create or replace procedure province_test(pro_name in varchar,pro_count out int) is
begin
select count(id) into pro_count from s_city where pid=(select id from s_province where name=pro_name);
end;
try {
Connection conn = SessionFactoryUtils.getDataSource(this.getSessionFactory()).getConnection();//得到jdbc Connection
CallableStatement cstmt = conn.prepareCall("{call province_test(?,?)}");//调用存储过程
cstmt.setString(1, pname);//in参数
cstmt.registerOutParameter(2, Types.INTEGER);//out参数
cstmt.execute();
return cstmt.getInt(2);//得到2位置的out值
} catch (SQLException e) {
e.printStackTrace();
return 0;
}
参考链接:https://docs.oracle.com/cd/B28359_01/java.111/b31224/getsta.htm#i1014127