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> <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