JSP分页实现 代码
来源:互联网 发布:淘宝官网网址 编辑:程序博客网 时间:2024/06/09 00:13
- <%@ page contentType="text/html" pageEncoding="GB2312" language="java"%>
- <%@ page import="java.sql.*"%>
- <html>
- <head>
- <title>hello</title>
- </head>
- <body>
- <table border="1" spacing="2">
- <%!
- public static final String DRIVER = "com.mysql.jdbc.Driver";
- public static final String USER = "root";
- public static final String PASS = "12345";
- public static final String URL = "jdbc:mysql://localhost:3306/MLDN";
- public static final int PAGESIZE = 5;
- int pageCount;
- int curPage = 1;
- %>
- <%
- //一页放5个
- String user = null;
- String pass = null;
- try{
- Class.forName(DRIVER);
- Connection con = DriverManager.getConnection(URL,USER,PASS);
- String sql = "SELECT empno,ename,job,hiredate,sal,comm FROM emp";
- PreparedStatement stat = con.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);
- ResultSet rs = stat.executeQuery();
- rs.last();
- int size = rs.getRow();
- pageCount = (size%PAGESIZE==0)?(size/PAGESIZE):(size/PAGESIZE+1);
- String tmp = request.getParameter("curPage");
- if(tmp==null){
- tmp="1";
- }
- curPage = Integer.parseInt(tmp);
- if(curPage>=pageCount) curPage = pageCount;
- boolean flag = rs.absolute((curPage-1)*PAGESIZE+1);
- out.println(curPage);
- int count = 0;
- do{
- if(count>=PAGESIZE)break;
- int empno = rs.getInt(1);
- String ename = rs.getString(2);
- String job = rs.getString(3);
- Date hiredate = rs.getDate(4);
- float sal = rs.getFloat(5);
- int comm = rs.getInt(6);
- count++;
- %>
- <tr>
- <td><%=empno%></td>
- <td><%=ename%></td>
- <td><%=job%></td>
- <td><%=hiredate%></td>
- <td><%=sal%></td>
- <td><%=comm%></td>
- </tr>
- <%
- }while(rs.next());
- con.close();
- }
- catch(Exception e){
- }
- %>
- </table>
- <a href = "multipage.jsp?curPage=1" >首页</a>
- <a href = "multipage.jsp?curPage=<%=curPage-1%>" >上一页</a>
- <a href = "multipage.jsp?curPage=<%=curPage+1%>" >下一页</a>
- <a href = "multipage.jsp?curPage=<%=pageCount%>" >尾页</a>
- 第<%=curPage%>页/共<%=pageCount%>页
- </body>
- </html>
0 0
- JSP分页实现 代码
- Jsp分页显示代码实现 (
- JSP分页技术实现 (附代码)
- JSP中较长文件分页的实现代码
- jsp 页面分页超链接代码实现
- jsp分页显示Java代码实现
- jsp实现分页的步骤及代码
- jsp分页显示的实现代码
- Jsp分页模板代码,实现页面内套用分页逻辑
- 在jsp中嵌入java代码实现分页代码
- JSP分页代码实例
- JSP分页代码
- JSP分页代码...
- JSP分页代码实例
- JSP分页代码...
- 分页代码 (jsp)
- Hibernate + JSP 分页代码
- Jsp分页实例代码
- 查询当前数据库是否存在阻塞的情况
- FTP库BlackRaccoon问题解决方案
- javascript基本知识
- Ucloud发布《2015公有云安全年度报告》
- 12306系统架构优化
- JSP分页实现 代码
- java堆与栈(转载)
- wordpress网站从本地上传到阿里云服务器
- bzoj4378 Logistyka 树状数组
- 阻塞队列BlockingQueue
- struts、hibernate、spring实现驾校管理系统
- 基于微信的自动问答系统研究
- odoo教程---在odoo8中创建自定义的reports
- linux配置LAMP环境