Hibernate调用存储过程例子

        Session session = this.getHibernateTemplate().getSessionFactory().openSession();
		Connection conn = session.connection();
		try {
			String sql = "{call test_pro(?,?)}";
			CallableStatement call = conn.prepareCall(sql);
			call.setInt(1, htbaId);//设置第一个参数
			call.registerOutParameter(2, OracleType.STYLE_INT);//注册输出的参数
			call.execute();
			int re = call.getInt(2);
			if (re == 1) {
				flag= true;
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (conn != null) {
				try {
					conn.close();
					session.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}