分页程序
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.");
}
}
分页程序
最新推荐文章于 2024-08-01 13:39:52 发布