📄 page.jsp
字号:
<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><%//变量声明java.sql.Connection sqlCon; //数据库连接对象java.sql.Statement sqlStmt; //SQL语句对象java.sql.ResultSet sqlRst; //结果集对象java.lang.String strCon; //数据库连接字符串java.lang.String strSQL; //SQL语句int intPageSize; //一页显示的记录数int intRowCount; //记录总数int intPageCount; //总页数int intPage; //待显示页码int layer;int idlayer;idlayer=1;java.lang.String outtext;outtext="";java.lang.String strPage;int j;int i;//设置一页显示的记录数intPageSize = 2;//取得待显示页码strPage = request.getParameter("page");if(strPage==null){//表明在QueryString中没有page这一个参数，此时显示第一页数据 intPage = 1;}else{//将字符串转换成整型 intPage = java.lang.Integer.parseInt(strPage); if(intPage<1) intPage = 1;}//装载JDBC驱动程序Class.forName("org.gjt.mm.mysql.Driver").newInstance();//连接数据库sqlCon = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/sample","root","javaee");//创建语句对象sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);//执行SQL语句并获取结果集sqlRst = sqlStmt.executeQuery("SELECT customerid,phone FROM customer");//获取记录总数sqlRst.last();intRowCount = sqlRst.getRow();//记算总页数intPageCount = (intRowCount+intPageSize-1) / intPageSize;//调整待显示的页码if(intPage>intPageCount) intPage = intPageCount;%><html><head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head><body topmargin="0" leftmargin="0" ><table width="100%"><tr><td >页次：<%=intPage%>/<%=intPageCount%>页 <%=intPageSize%>条/页 </td></tr></table><table width="100%"><tr><td width＝50%>ID</td><td width＝50%>电话</td></tr><%if(intPageCount>0){sqlRst.absolute((intPage-1) * intPageSize + 1);i = 0;while(i<intPageSize && !sqlRst.isAfterLast()){String id = sqlRst.getString(1);String phone = sqlRst.getString(2);%><trwidth><td width＝50%><%=id%></td><td width＝50%><%=phone%></td><tr><%sqlRst.next();i++;}}%></table><%if(intPage>1){%><a href="page.jsp?page=<%=intPage-1%>">上一页</a><%}%><%if(intPage<intPageCount){%><a href="page.jsp?page=<%=intPage+1%>">下一页</a><%}%></body></html><%//关闭结果集sqlRst.close();//关闭SQL语句对象sqlStmt.close();//关闭数据库sqlCon.close();%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -