mysql jsp分页

int pg=1;
if(request.getParameter("pg")!=null){
pg=Integer.parseInt(request.getParameter("pg"));
}



int size=20;//每页显示条数
ResultSet rs=db.executeQuery("select * from p_web where Title like'%"+keyword+"%' and State='finished' order by SortID limit "+(pg-1)*size+","+size);
   
// 计算总的记录条数
    ResultSet rs3 = db.executeQuery("select count(*) from p_web where Title like'%"+keyword+"%' and State='finished' order by SortID");   
    int total =0;
if (rs3.next()) {
     total = rs3.getInt(1);    
}
// out.print(total+"<br>");
//总页数
int pgsize=0;
pgsize=(total/size)+((total%size)>0?1:0);
// out.print(pgsize);


%><br>
<%if(pg!=1){ %>
<A href="websearchresult.jsp?KeyWord=<%=keyword %>&pg=1">首页</A>
  <A href="websearchresult.jsp?KeyWord=<%=keyword %>&pg=<%=pg>1?pg-1:1%>">上页</A>
  <%}else{out.print("首页 上页");} %>
  <%if(pg!=pgsize){ %>
   <A href="websearchresult.jsp?KeyWord=<%=keyword %>&pg=<%=pg<pgsize?pg+1:pgsize%>">下页</A>
   <A href="websearchresult.jsp?KeyWord=<%=keyword %>&pg=<%=pgsize%>">尾页</A>
    <%}else{out.print("下页 尾页");} %>
    第<%=pg%>页/共<%=pgsize%>页</A>