分页工具类JdbcUtil 对数据库表进行查询,StringBuffer sql = “select * from Table”等,查询得到数据很多(10000条),这个时候你需要采取后台分页的形式,将查询结果返回。调用JdbcUtil中的paginationSql()方法,将sql组合成sql级别的分页形式。 package com.jdbc.util; public class JdbcUtil { private static String PAGINATION_START = "SELECT BB.* FROM (SELECT AA.*,ROWNUM ROW_NUM FROM ("; private static String PAGINATION_END = ")AA)BB WHERE BB.ROW_NUM > ? AND BB.ROW_NUM <=?"; public static String paginationSql(String sql){ StringBuffer buffer = new StringBuffer(PAGINATION_START); buffer.append(sql); buffer.append(PAGINATION_END); return buffer.toString(); } }