分页查询能解决数据库记录的显示方式:
分页查询的基本原理
con = getConnection();
stmt = con.prepareStatement(sql);
int start = rowsPerPage*(page -1) + 1;
int end = start + rowsPerPage;
stmt.setInt(1,end);
stmt.setInt(2,start);
ResultSet rs = stmt.executeQuery();
List<Service> list = new ArrayList<Service>();
while(rs.next()){
list.add(toService(rs));
}
. 每次只像数据库要求一页的数据量
. 频繁访问数据库
. 内存压力小适合大数据量
Oracle分页查询SQL语句
select ID,ACCOUNT_ID,HOST,USER_NAME,LOGIN_PASSWD,STATUS,CREATE_DATE,
PAUSE_DATE,CLOSE_DATE,COST_ID from (select ID,ACCOUNT_ID,HOST,USER_NAME,
LOGIN_PASSWD,STATUS,CREATE_DATE,PAUSE_DATE,CLOSE_DATE,COST_ID,ROWNUM r
from SERVICE where ROWNUMBER < ?) where r > =?