method1: 原生jdbc 调用存储过程
public void callStrored(){
try {
String sql = "{call updateStudentInfo(?,?,?,?,?)}"; //前四个是in参数,第五个是输出参数
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@hostname:port:servicename", "username", "password");
CallableStatement prepareCall = conn.prepareCall(sql);
prepareCall.setString(1,"18");
prepareCall.setString(2,"21002");
prepareCall.setString(3,"702");
prepareCall.setString(4,"857");
prepareCall.registerOutParameter(5,Types.VARCHAR);
prepareCall.execute();
String resultOut = prepareCall.getString(5);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}