81,092
社区成员
发帖
与我相关
我的任务
分享
this.size = 5;//设定页面显示数据大小
int pageLine=10;
int totalRec=0;
int intPage=1;
int i;
if (request.getParameter("page")!=null)
intPage=Integer.parseInt(request.getParameter("page"));
try{
ResultSet countrs=null;
countrs=db1.executeQuery("select count(*)as cnt from czc_info where cnums like '"+"%"+qcnums+"%"+"' and ct like '"+"%"+qct+"%"+"' and jwnums in (select jwnums from jsy_info where tname like '"+"%"+qtname+"%"+"' ) ");
if(countrs.next())
totalRec=countrs.getInt("cnt");
countrs.close();
db1.closeStmt();
}
catch(Exception e){
e.printStackTrace();
}
int intPageCount=0;
intPageCount=(totalRec+pageLine-1)/pageLine;
我通常是用这种方式进行分页