Question

jsp+ mysql实现分页显示，jsp网页查询mysql数据库中一个学生的多科成绩显示出来，谢谢！

Answer 1

ConnDB cd = new ConnDB();

ct=cd.getConnDB();

ps=ct.prepareStatement("select count(*) from usertable");

rs = ps.executeQuery();

//得到pageCount的值

if(rs.next()){

rowCount = rs.getInt(1);
// pw.println(""+rowCount);测试
}

if(rowCount%pageSize==0){

pageCount = rowCount/pageSize;
}else{

pageCount = rowCount/pageSize +1;
}

ps=ct.prepareStatement("select * from usertable user_id limit "+pageSize*(pageNow-1)+","+pageSize+";");

rs=ps.executeQuery();

追问

哦