分页程序

 
分页程序
package text;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
 
public class PageQuery {
public List executeQuery(String sql, int pageNumber, int pageSize)
throws SQLException {
List resultSetDatum = new ArrayList();
Connection conn = DBConn.getConnection();
Statement stmt = conn.createStatement(
        ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int colCount = rsmd.getColumnCount();
if (rs.absolute((pageNumber - 1) * pageSize + 1)) {
int counter = 0;
do {
        Object[] row = new Object[colCount];
        for (int i = 0; i < colCount; i++) {
               row[i] = rs.getObject(i + 1);
        }
        resultSetDatum.add(row);
        counter++;
} while (rs.next() && counter < pageSize);
}
return resultSetDatum;
}
public static void main(String[] args) {
PageQuery queryUtil = new PageQuery();
String sql = "select * from emp";
try {
List resultSet = queryUtil.executeQuery(sql, 1, 5);   //（查询段，第N页，每页M行）    
for(int i = 0; i < resultSet.size(); i++){
        Object[] row = (Object[])resultSet.get(i);           
        for(int j = 0; j < row.length; j++){
               System.out.print(row[j] + " | ");
        }
        System.out.println();
}    
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println("end.");
}
}