java web jdbc oracle 分页_JdbcTemplate 的oracle分页

@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> 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());

JdbcTemplate 的oracle分页

标签：row   ==   where   query   ringbuf   str   template   psi   from

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/qinyios/p/11217569.html