//分页查询
1.规定每一页的大小 pageSize=5
2.总页数 pagrCount select count(*) form admin_info;
3当前页: pageNo select * from admin_info limit pageSize-1,5;
4总记录数: recordCount
主要代码:
public ArrayList queryByPage(int pageNo){
ArrayList user=new ArrayList();
Connection coon= Userutil.getcoon();
String sql=“select *from admin_info limit ?,?”;
String name=null;
String pwd=null;
Statement st=null;
try {
pt=coon.prepareStatement(sql);
pt.setInt(1,(pageNo-1)*pageSize );
pt.setInt(2,pageSize);
rs=pt.executeQuery();
while(rs.next()) {
name=rs.getString(2);
pwd=rs.getString(3);
User d=new User(name,pwd);
user.add(d);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Userutil.close(coon, pt);
return user;
}
public int getRecordCount() {
int recordCount=0;
Connection coon= Userutil.getcoon();
String sql=“select count(*) from admin_info”;
try {
pt = coon.prepareStatement(sql);
rs=pt.executeQuery();
if(rs.next()) {
recordCount=rs.getInt(1);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Userutil.close(coon, pt);
return recordCount;
}
public int getpagrCount() {
int pagrCount=0;
int recordCount=getRecordCount();
pagrCount=(recordCount+pageSize-1)/pageSize;
return pagrCount;
}
}