Java Web page Paging technology

Query interface, query by name and car number, and then submit the query results to the servlet:

<%@ page language= "java" contenttype= "text/html; Charset=utf-8 "pageencoding= "Utf-8"%><! DOCTYPE HTML PUBLIC "-//w3c//dtd HTML 4.01 transitional//en" "Http://www.w3.org/TR/html4/loose.dtd" > PackageShouqisystem.user;Importjava.io.IOException;ImportJavax.servlet.RequestDispatcher;Importjavax.servlet.ServletException;ImportJavax.servlet.http.HttpServlet;Importjavax.servlet.http.HttpServletRequest;ImportJavax.servlet.http.HttpServletResponse;Importjavax.servlet.http.HttpSession;/*** Servlet Implementation class Serviceservlet*/ Public classServiceservletextendsHttpServlet {Private Static Final LongSerialversionuid = 1L; /**     * @seeHttpservlet#httpservlet ()*/     PublicServiceservlet () {Super(); //TODO auto-generated Constructor stub    }    /**     * @seeHttpservlet#doget (httpservletrequest request, httpservletresponse response)*/    protected voidDoget (HttpServletRequest request, httpservletresponse response)throwsservletexception, IOException {//TODO auto-generated Method StubString name=NewString (Request.getparameter ("name"). GetBytes ("Iso-8859-1"), "Utf-8"); String Carnum=NewString (Request.getparameter ("Carnum"). GetBytes ("Iso-8859-1"), "Utf-8"); String S1= "Beginqueryservice.jsp"; HttpSession Session=request.getsession (); Session.setattribute ("Name", name); Session.setattribute ("Carnum", Carnum); Response.setcontenttype ("Text/html;charset=utf-8"); String s=Response.encodeurl (S1); RequestDispatcher disp=NULL; Disp=Request.getrequestdispatcher (s);    Disp.forward (request, response); }    /**     * @seeHttpservlet#dopost (httpservletrequest request, httpservletresponse response)*/    protected voidDoPost (HttpServletRequest request, httpservletresponse response)throwsservletexception, IOException {//TODO auto-generated Method Stubdoget (request, response); }}

Pages.java Control Paging

 PackageShouqisystem.user;ImportJava.sql.ResultSet;Importjavax.servlet.http.HttpServletRequest; Public classPages {ResultSet Counttopicrs=NULL;//total number of records result setResultSet pagirs=NULL;//Query Result set         Public intintcounttopic=0;//Total Records         Public intIntpagesize;//show several records per page         Public intIntpagecount;//Total Pages         Public intintpage=1;//Current Page         PublicString Nowpage;  PublicString Httpfile;                UserInfo DB;  PublicPages () {intpagesize=2; DB=NewUserInfo (); }                 Public voidQuerysql (ResultSet counttopicrs,resultset pagirs,httpservletrequest request)throwsexception{Httpfile=Request.getrequesturi (); Nowpage=request.getparameter ("pages"); if(nowpage==NULL) {intpage=1; }Else{intpage=Integer.parseint (nowpage); if(intpage<1) Intpage=1; }                        //counttopicrs=db.queryiccarddatasum (name, carnum);            if(Counttopicrs.next ()) {Intcounttopic=counttopicrs.getint (1); } Intpagecount= (intcounttopic+intpagesize-1)/intpagesize; if(intpage>Intpagecount) {Intpage=Intpagecount;            } counttopicrs.close (); //Db.close_all (); //pagirs=db.queryiccarddata (name, carnum); //return pagirs;        }         Public intGetcounttopic () {returnIntcounttopic; }         Public intGetpagecount () {returnIntpagecount; }         Public intGetintpage () {returnintpage; }         Publicstring PageFooter () {string str=""; intNext,prev; Prev=intpage-1; Next=intpage+1;            System.out.println (); STR+ = "<font color=red> query to" +getcounttopic () + "records </font>" + "<font color=red> Total" +getpagecount () + "Page < /FONT> "; STR+ = "<font color=red> First" +getintpage () + "page </font>"; if(intpage>1) Str+ = "<font color=red><a href=" + Httpfile + "? Pages=1" + "> Home </a></font>"; ElseStr+ = "<font color=red> Home"; if(intpage>1) Str+ = "<font color=red><a href=" + Httpfile + "? pages=" +prev+ "> Previous </a></font>"; ElseStr+ = "<font color=red> prev </font>"; if(intpage<intpagecount) Str+ = "<font color=red><a href=" + Httpfile + "? pages=" +next+ "> Next </a></font>"; ElseStr+ = "<font color=red> next page </font>"; if(Intpagecount>1&&intpage! =intpagecount) Str+ = "<font color=red><a href=" + Httpfile + "? pages=" +intpagecount+ "> Last </a></font>"; ElseStr+ = "<font color=red> end </font>"; returnstr; }         Public voidClose_all ()throwsexception{Db.close_all (); }}

Query Results page:

<% @pageImport= "Java.sql.ResultSet"%><%@ page language= "java" contenttype= "text/html; Charset=utf-8 "pageencoding= "Utf-8"%><%@ pageImport= "java.io.*,java.util.*,java.sql.*,shouqisystem.user.*"%><jsp:usebean id= "userinfo" scope= "Request"class= "Shouqisystem.user.UserInfo"/><jsp:usebean id= "pages" scope= "page"class  = "Shouqisystem.user.Pages"/><! DOCTYPE HTML PUBLIC "-//w3c//dtd HTML 4.01 transitional//en" "Http://www.w3.org/TR/html4/loose.dtd" >String name= (String) session.getattribute ("name"); String Carnum= (String) session.getattribute ("Carnum"); ResultSet Counttopicrs=userinfo.querydynamicmonitorsum (name, carnum); ResultSet RS=userinfo.querydynamicmonitor (name, carnum);  Pages.querysql (counttopicrs,rs,request); String Footer=pages.  PageFooter (); if(pages.intpagecount>0){      intI=0;  while(Rs.next ()) {i++; if(I> (pages.intpage-1) *pages.intpagesize) && (i<=pages.intpage*pages.intpagesize)) {%> <tr> <td><input type= "checkbox" Name= "Pkey" size= "5" value= "<%=string.valueof (Rs.getint (" ID "))%>"/></td> <td><span style= "Color:white" ><%=rs.getstring ("name")%></span>      </td> <td><span style= "Color:white" ><%=rs.getstring ("Carnum")%></span></td> <td><span style= "Color:white" ><%=rs.getstring ("Speedtime")%></span></td> &LT;TD ><span style= "Color:white" ><%=rs.getstring ("Speedfourleveltimes")%></span></td> < Td><span style= "Color:white" ><%=rs.getstring ("Outgoingtime")%></span></td> <td> <span style= "Color:white" ><%=rs.getstring ("destination")%></span></td> <td>< Span style= "Color:white" ><%=rs.getstring ("Fatiguedrivingtime")%></span></td> <td>< Span style= "Color:white" ><%=rs.getstring ("DegreE ")%></span></td> <td><span style=" Color:white "><%=rs.getstring (" Times ")%></ Span></td> </tr> <%}}} out.println ("<tr><td colspan=2>" +footer+ "</td></tr>");  Rs.close ();   Pages.close_all (); %> <tr align= "right" > <td colspan= "2" > <input type= "Submit" name= "revise" value= "Modify" onclick= "form.action= ' revisedynamicmonitor.jsp '; Form.submit ();" > <input type= "Submit" name= "delete" value= "delete" onclick= "form.action= ' deletedynamicmonitor.jsp '; form.sub MIT (); " > </td> </tr> </table><br><br> </form> </center></body& Gt;
Java Web page Paging technology