java中怎么调用function

2025-03-01 19:21:36
推荐回答(1个)
回答1:

JDBC中使用CallableStatement来调用Procedure
String sql = "{call getSessionID(?, ?)}";
CallableStatement statement = connection.prepareCall(sql);
// 输入参数
statement.setString(1, "/Catalina/localhost/JavaEE_Web");
// 注册输出参数
statement.registerOutParameter(2, java.sql.Types.VARCHAR);
statement.execute();

String sessionID = statement.getString(2);