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);