Session session = HibernateUtil.getSession();
while(rs.next()){
GridNode gn = new GridNode();
gn.setId(new Long(rs.getInt("VS_ID")));
gn.setTitle(rs.getString("VS_title"));
gn.setOptions(rs.getString("optionsnum"));
gn.setParticipants(rs.getString("peonum"));
gridNodeList.add(gn);
String sql = "{call getPageshowOptionNumPNum (?,?,?) }";
/**
这里其实我有点小问题,就是session.connection() 已被舍弃,
替代方法SessionFactoryUtils.getDataSource(getSessionFactory()).getConnection()
来自类org.springframework.orm.hibernate3.SessionFactoryUtils
但是我无法找到这个类,知道的网友帮忙告知一下
*/
CallableStatement call = session.connection().prepareCall(sql)
call.setInt(1,page.getCurrPageNo());call.setInt(2,page.getPageSize());
//带返回值得参数需要设定数据类型
call.registerOutParameter("totalDataSize", Type.INT);
while(rs.next()){
GridNode gn = new GridNode();
gn.setId(new Long(rs.getInt("VS_ID")));
gn.setTitle(rs.getString("VS_title"));
gn.setOptions(rs.getString("optionsnum"));
gn.setParticipants(rs.getString("peonum"));
gridNodeList.add(gn);
}
//查询完了以后才赋值
int a = call.getInt("totalDataSize");