Question

hibernate调用mysql存储过程

String hql="{CALL simpleproc2 (?,?)}";
SQLQuery query=getSession().createSQLQuery(hql);
query.setInteger(0,1005);
query.setInteger(1,Types.INTEGER);
接着该怎么获得二个参数，即存储过程的out参数

Answer 1

Query q=session.createSQLQuery("{call proc2(?,?)}");
CallableStatement cs = session.connection().prepareCall("{proc2(?,?)}");
cs.setString(1,"23");
cs.registerOutParameter(2, Types.INTEGER);