JdbcTemplate 的oracle分页

最新推荐文章于 2023-08-08 10:46:33 发布

weixin_30426879

最新推荐文章于 2023-08-08 10:46:33 发布

阅读量1k

点赞数

文章标签：数据库 java 测试

原文链接：http://www.cnblogs.com/qinyios/p/11217569.html

版权

@Autowired
private JdbcTemplate jd;

		int ps1=Integer.valueOf(pageSize);
		int cp1=Integer.valueOf(currPage);

			StringBuffer stringBuffer = new StringBuffer();
			stringBuffer.append("SELECT * FROM (SELECT ROWNUM AS rowno, t.* FROM fhcb_08_tbl_ext_attributes t WHERE ROWNUM <="+cp1*ps1+" ) table_alias WHERE table_alias.rowno >= "+((cp1-1)*ps1+1));
			List<Map<String, Object>> countList = jd
					.queryForList("SELECT COUNT(1) AS count FROM fhcb_08_tbl_ext_attributes");
			count = Integer.parseInt(String.valueOf(countList.get(0).get("count")));
			pageCount = (count % psize) == 0 ? count / psize : count / psize + 1;
			queryForList = jd.queryForList(stringBuffer.toString());

转载于:https://www.cnblogs.com/qinyios/p/11217569.html