📄 page.jsp
字号:
<%-- Document : page Created on : 2009-4-13, 19:58:23 Author : Administrator--%><%@page contentType="text/html;charset=GBK"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><%//变量声明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/student","root","root");//创建语句对象sqlStmt=sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);//执行SQL语句并获取结果集sqlRst=sqlStmt.executeQuery("SELECT SNO,SNA,PHONE FROM ff");//获取记录总数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="2" leftmargin="0" bgcolor="black" text="red"> <hr align="center" width="600" size="1" color="#0000FF"> <center><h1><marquee direction="left" behavior="alternate">数据库数据显示如下：</marquee></h1></center> <hr align="center" width="600" size="1" color="#0000FF"> <table align="center" border="1" width="80%" bordercolorlight="#0000FF" cellpadding="2" bordercolordark="FFFFFF" cellspacing="0"> <tr> <td align="center"> 页次：<%=intPage%>/<%=intPageCount%>页 <%=intPageSize%>条/页 </td> </tr> </table> <table align="center" border="1" width="80%" bordercolorlight="#0000FF" cellpadding="2" bordercolordark="FFFFFF" cellspacing="0"> <tr> <td width="33.3%" align="center">学号</td> <td width="33.3%" align="center">姓名</td> <td width="33.3%" align="center">电话</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);String phone1=sqlRst.getString(3);%> <tr> <td width="33.3%" align="center"><%=id%></td> <td width="33.3%" align="center"><%=phone%></td> <td width="33.3%" align="center"><%=phone1%></td> </tr><%sqlRst.next();i++;}}%></table><% if(intPage>1){ %> <a href="page.jsp?page=<%=intPage-1%>"><center>上一页</center></a> <%}%> <% if(intPage<intPageCount) {%> <a href="page.jsp?page=<%=intPage+1%>"><center>下一页</center></a> <%}%> </body></html><%//关闭结果集sqlRst.close();//关闭数据库sqlCon.close();%><center><a href="index.jsp">继续向数据库录数据</a></center>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -