int pageSize=3; int pageNow=1;//默认显示第一页 int rowCount=0;//该值从数据库中查询 int pageCount=0;//该值是通过pageSize和rowCount //接受用户希望显示的页数(pageNow) String s_pageNow=request.getParameter("pageNow"); if(s_pageNow!=null){ //接收到了pageNow pageNow=Integer.parseInt(s_pageNow); }
String pagecount="select count(*) from tb_reply where RTID='"+request.getParameter("id")+"'";
ResultSet rsc=connection.executeQuery(pagecount);
while(rsc.next()){
rowCount=rsc.getInt(1);
}//得到总条数
int f=(pageNow-1)*3;
String sqlReyle="select tb_reply.*,tb_user.* from tb_reply inner join tb_user on tb_reply.RUID= tb_user.UID where tb_reply.RTID='"+request.getParameter("id")+"' limit "+f+",3";
下面就是有记录就循环,下面是部分代码:
ResultSet rsReyle=connection.executeQuery(sqlReyle);
try{
while(rsReyle.next()){
//reSign=rsReyle.getString("sign");
//get title
String sqlRet="select TTopic from tb_topics where TID='"+request.getParameter("id")+"'";
//ResultSet rsRet=connection.executeQuery(sqlReyle);
ResultSet rsRet=connection.executeQuery(sqlRet);
try{
while(rsRet.next()){
//reSign=rsReyle.getString("sign");
reTitle=rsRet.getString("TTopic");
}}catch(Exception e){}
//end get title
reContent=rsReyle.getString("RContent");
reAccount=rsReyle.getString("UName");
recreatime=rsReyle.getString("RTime");
reSex=rsReyle.getInt("USex");
replyid=rsReyle.getInt("RID");
%>。。。。。。。下面表格啥的。