返回首页 | 金赞娱乐场

合作共赢、快速高效、优质的网站建设提供商

更多精品源码-尽在织梦模板-www.moke8.com

网站开发jsp实现页面分页功能代码

时间:2017-07-28 编辑:admin

%@ page contentType="text/html" pageEncoding="GB2312" language="php"% %@ page import="php.sql.*"% html head title hello /title /head body table border="1" spacing="2" public static final String DRIVER = "com..jdbc.Driver"; public static final String USER = "root"; public static final String PASS = ""; public static final String URL = "jdbc:://localhost:3306/teachinfo"; 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 * FROM department"; 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; if(count =PAGESIZE)break; int departmentid = rs.getInt(1); String departmentname = rs.getString(2); count++; td %=departmentid% /td td %=departmentname% /td /tr }while(rs.next()); con.close(); catch(Exception e){ /table a href = "fenye.phpp curPage=1" 首页 /a a href = "fenye.phpp curPage= %=curPage-1% " 上一页 /a a href = "fenye.phpp curPage= %=curPage+1% " 下一页 /a a href = "fenye.phpp curPage= %=pageCount% " 尾页 /a 第 %=curPage% 页/共 %=pageCount% 页 /body /html

本篇代码希望各位朋友喜欢!


浏览:

网站建设

流程

    网站建设流程