具体代码:
//查询department表中所有的数据 并且通过ResultSet 实现逻辑分页
public void selectDeptPage(int currentPage,int PageRows){ //currentPage 当前页 PageRows 每页显示条数
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
try {
connection = jdbcUtil.getConnection();
statement = connection.createStatement();
String sql = "select * from departments";
resultSet = statement.executeQuery(sql);
//定义开始位置和结束位置
int begin =(currentPage-1)*currentPage;
int end = currentPage * PageRows;
//添加位置计数器
int currentNum = 0;
while (resultSet.next()){
if (currentNum>= begin && currentNum< end ){
System.out.println(resultSet.getInt("department_id")+""+resultSet.getString("department_name"));
//结束操作ResuletSet边界条件
if (currentNum == end-1){
break;
}
currentNum++;
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
jdbcUtil.closeResult(resultSet,statement,connection);
}
}
如果您发现该资源为电子书等存在侵权的资源或对该资源描述不正确等,可点击“私信”按钮向作者进行反馈;如作者无回复可进行平台仲裁,我们会在第一时间进行处理!