JSP实现的简单分页示例
本文实例讲述了JSP实现的简单分页示例。分享给大家供大家参考,具体如下:
<%@pagelanguage="java"import="java.util.*"contentType="text/html;charset=gbk"%> <%@pageimport="com.yx.page.db.*"%> <%@pageimport="java.sql.*"%> <html> <head> <title>MyJSP'page01.jsp'startingpage</title> </head> <body> <center> <%! finalStringjspURL="page04.jsp"; %> <% //定义如下分页变量 //1、定义每页要显示的记录数 intlineSize=10; //2、定义一个当前是第几页 intcurrentPage=1; //接受传过来的当前页 %> <% try{ currentPage=Integer.parseInt(request.getParameter("cp")); }catch(Exceptione){ e.printStackTrace(); } %> <% Connectionconn=null; PreparedStatementpStmt=null; ResultSetrs=null; GetConnectiongetConnection=newGetConnection();//自定义数据库连接操作DAO %> <scriptlanguage="javascript"> functionopenPage(curpage){ document.form1.cp.value=curpage; document.form1.submit(); } </script> <formaction="<%=jspURL%>"method="post"name="form1"> <inputname="button1"type="button"value="首页"onClick="openPage(1)"> <inputname="button2"type="button"value="上一页"onClick="openPage(<%=currentPage-1%>)"> <inputname="button3"type="button"value="下一页"onClick="openPage(<%=currentPage+1%>)"> <inputname="button4"type="button"value="尾页"> <inputname="cp"type="hidden"value=""/> </form> <tablewidth="80%"border="1"> <% try{ StringstrSql="select*fromperson"; pStmt=getConnection.getPreStatement(strSql); rs=pStmt.executeQuery(); %> <tr> <tdalign="center">编号</td> <tdalign="center">登陆名称</td> <tdalign="center">姓名</td> <tdalign="center">密码</td> <tdcolspan="2"align="center">操作</td> </tr> <% for(intx=0;x<(currentPage-1)*lineSize;x++){ rs.next(); } for(intx=0;x<lineSize;x++){ if(rs.next()){ intid=rs.getInt(1); Stringuid=rs.getString(2); Stringname=rs.getString(3); Stringpass=rs.getString(4); %> <tr> <td><%=id%></td> <td><%=uid%></td> <td><%=name%></td> <td><%=pass%></td> <td>更改</td> <td>删除</td> </tr> <% } } }catch(Exceptione){ %> <h4>系统有错误</h4> <% e.printStackTrace(); }finally{ getConnection.getAllClose(conn,pStmt,rs); } %> </table> </center> </body> </html>
希望本文所述对大家JSP程序设计有所帮助。