public Page getNameByEndate() {
Object[] objects = new Object[] {};
String sql = "select a.name from 1ARCHIVES a where a.remove_id='1' and a.position='1' order by a.enddate desc";
return this.unpayNameDao.queryForPage(sql, 1, 16, objects);
}
return this.unpayNameDao.queryForPage(sql, Integer.valueOf(pageNo), 108, objects);
public Page queryForPage(String sql, int pageNo, int pageCount,Object[] args) {
String strSql = "";
int startNo = Page.getStartOfPage(pageNo, pageCount);
int endNo = startNo + pageCount;
int argsCount = args.length;
//获取总数
int totleCount = queryForCount(sql, args);
Object[] new_args;
if (startNo == 0) {
strSql = "select * from (" + sql + ") where rownum <= ?";
new_args = new Object[argsCount + 1];
} else {
strSql = "select * from (select row_.*,rownum rownum_ from (" + sql
+ ") row_ where rownum <= ?) where rownum_>?";
new_args = new Object[argsCount + 2];
new_args[argsCount + 1] = new Integer(startNo);
}
for (int i = 0; i < argsCount; i++) {
new_args[i] = args[i];
}
new_args[argsCount] = new Integer(endNo);
List list = jdbcTemplateRsdl.queryForList(strSql, new_args);
return new Page(startNo, totleCount, pageCount, list);
}
private int queryForCount(String sql, Object[] args) {
String strSql = "select count(rowid) from ( " + sql + ")";
return jdbcTemplateRsdl.queryForInt(strSql, args);
}
jdbcTemplate分页
最新推荐文章于 2022-10-08 14:18:30 发布