结合JDBC和Oracle ROWNUM实现分页查询

liyeho

package org.cmcc.dao;　　
import java.sql.Connection;
　　
import java.sql.ResultSet;
　　
import java.sql.SQLException;
　　
import java.sql.Statement;
　　
import java.util.ArrayList;
　　
import java.util.List;
　　
import org.apache.log4j.Logger;
　　
import org.cmcc.entity.DGwap201208;
　　
import org.cmcc.util.DBUtil;
　　
/**
　　* @Desc        数据库操作类
　　* @Author      Administrator
　　* @Datetime    2012-9-24下午05:50:37
　　* @Version     1.0
　　*/

　　
public>　　private static Logger logger = Logger.getLogger(DGWapDAO.class);
　　private Connection conn = null;
　　private Statement stm = null;
　　private ResultSet rs = null;
　　/**
　　* 分页获得数据
　　* @param pageNum   页码
　　* @param pageSize      每页多少行
　　 * @return
　　*/
　　public List getGdWapByPage(int pageNum, int pageSize) {
　　List results = new ArrayList();;
　　DGwap201208 wap = null;
　　int start = pageSize * pageNum;
　　int end = pageSize * (pageNum + 1);
　　//分页查询语句：利用ROWNUM
　　String sql = "SELECT * FROM (SELECT ROWNUM AS rn, T.MSISDN as msisdn,T.USER_AGENT as userAgent," +
　　"T.URL as url,T.USE_TIME as useTime,T.STATUS_CODE as statusCode," +
　　"T.DOWN_TRAFFIC as downTraffic,T.UP_TRAFFIC as upTraffic," +
　　"T.GETWAY_DELAY as getwayDelay,T.SP_DELAY as spDelay " +
　　"FROM DG_WAP_201208 T) WHERE rn>=" + start + " AND rn