用Spring的JdbcTemplate实现分页功能 - 编程入门网
作者 佚名技术
来源 NET编程
浏览
发布时间 2012-06-20
| paginationSQL.append(" ) WHERE num > " + startIndex); //装入结果集 setResultList(getJdbcTemplate().queryForList(paginationSQL.toString())); } /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub } public int getCurrentPage() { return currentPage; } public void setCurrentPage(int currentPage) { this.currentPage = currentPage; } public int getNumPerPage() { return numPerPage; } public void setNumPerPage(int numPerPage) { this.numPerPage = numPerPage; } public List getResultList() { return resultList; } public void setResultList(List resultList) { this.resultList = resultList; } public int getTotalPages() { return totalPages; } //计算总页数 public void setTotalPages() { if(totalRows % numPerPage == 0){ this.totalPages = totalRows / numPerPage; }else{ this.totalPages = (totalRows / numPerPage) + 1; } } public int getTotalRows() { return totalRows; } public void setTotalRows(int totalRows) { this.totalRows = totalRows; } public int getStartIndex() { return startIndex; } public void setStartIndex() { this.startIndex = (currentPage - 1) * numPerPage; } public int getLastIndex() { return lastIndex; } public JdbcTemplate getJTemplate() { return jTemplate; } public void setJTemplate(JdbcTemplate template) { jTemplate = template; } //计算结束时候的索引 public void setLastIndex() { System.out.println("totalRows="+totalRows);/////////// System.out.println("numPerPage="+numPerPage);/////////// if( totalRows < numPerPage){ this.lastIndex = totalRows; }else if((totalRows % numPerPage == 0) || (totalRows % numPerPage != 0 && currentPage < totalPages)){ this.lastIndex = currentPage * numPerPage; }else if(totalRows % numPerPage != 0 && currentPage == totalPages){//最后一页 this.lastIndex = totalRows ; } }}在我的业务逻辑代码中： /** * find season ranking list from DC * @param areaId 选手区域id * @param rankDate 赛季 * @param category 类别 * @param characterName 角色名 * @return List */ public List findSeasonRankingList(Long areaId, int rankYear,int rankMonth, Long categoryId,String characterName) { //SQL语句 StringBuffer sql = new StringBuffer(" SELECT C.USERID userid,D.POSNAME posname,C.GAMEID gameid,C.AMOUNT amount,C.RANK rank FROM "); //表 sql.append(" (SELECT B.USERID USERID,"); sql.append(" B.POSID POSID,"); sql.append(" A.DISTRICT_CODE DISTRICTCODE,"); sql.append(" A.GAMEID GAMEID,"); sql.append(" AMOUNT AMOUNT,"); sql.append(" RANK RANK "); sql.append(" FROM TB_FS_RANK A "); sql.append(" LEFT JOIN TB_CHARACTER_INFO B "); sql.append(" ON A.DISTRICT_CODE = B.DISTRICT_CODE "); sql.append(" AND A.GAMEID = B.GAMEID "); //附加条件 if(areaId != null && areaId.intValue() != 0){ sql.append(" and A.DISTRICT_CODE = " + areaId.intValue()); } if( rankYear > 1970 && rankMonth > 0){ //hql.append(&qu |
凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢! |
你可能对下面的文章感兴趣
关于用Spring的JdbcTemplate实现分页功能 - 编程入门网的所有评论
