使用sp_cursoropen和sp_cursorfetch分页

最新推荐文章于 2024-09-14 18:42:05 发布

chen_jiangtao

最新推荐文章于 2024-09-14 18:42:05 发布

阅读量4.4k

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/evane1890/article/details/1559475

版权

<code>
cstmt = con.prepareCall("{?=call sp_cursoropen(?, ?, ?, ?, ?)}",
     1004, 1008);
   cstmt.registerOutParameter(1, Types.INTEGER);
   cstmt.registerOutParameter(2, Types.INTEGER);
   log.info(sql);
   cstmt.setString(3, sql);
   cstmt.setInt(4, 1);
   cstmt.registerOutParameter(4, Types.INTEGER);
   cstmt.setInt(5, 1);
   cstmt.registerOutParameter(5, Types.INTEGER);
   cstmt.registerOutParameter(6, Types.INTEGER);
   rs = cstmt.executeQuery();

   log.info(rs.getMetaData().getColumnCount());
   log.info(rs.next());
   log.info(cstmt.getInt(1));
   int cursor = cstmt.getInt(2);
   log.info(cursor);
   log.info(cstmt.getInt(4));
   log.info(cstmt.getInt(5));
   log.info(cstmt.getInt(6));
   countSize = cstmt.getInt(6);
   countPage = (int) Math.ceil(1.0 * countSize / pageSize);
   cstmt.close();
   rs.close();
   cstmt = con.prepareCall("{?=call sp_cursorfetch(?, ?, ?, ?)}");
   cstmt.registerOutParameter(1, Types.INTEGER);
   cstmt.setInt(2, cursor);
   cstmt.setInt(3, 16);
   cstmt.setInt(4, (page-1)*pageSize+1);
   log.info("page:"+page);
   cstmt.setInt(5, pageSize);
   log.info("pageSize:"+pageSize);
   rs = cstmt.executeQuery();
</code>