import java.util.List; public class Pager { /** * 总共页数 */ private int totalPages; /** * 总共记录数 */ private int totalRecords; /** * 每页显示数量 */ private int pageSize; /** * 当前页 */ private int pageIndex; /** * 当前页数据集合 */ private List datas; public void setTotalPages(int totalPages) { this.totalPages = totalPages; } public void setTotalRecords(int totalRecords) { this.totalRecords = totalRecords; } public void setPageSize(int pageSize) { this.pageSize = pageSize; } public void setPageIndex(int pageIndex) { this.pageIndex = pageIndex; } public void setDatas(List datas) { this.datas = datas; } public int getTotalPages() { return totalPages; } public int getTotalRecords() { return totalRecords; } public int getPageSize() { return pageSize; } public int getPageIndex() { return pageIndex; } public List getDatas() { return datas; } }

 import java.sql.Timestamp; public class User { private int userId;//用户id private String username;//用户名 private String password;//密码 private Timestamp regdate;//注册时间 public int getUserId() { return userId; } public void setUserId(int userId) { this.userId = userId; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public Timestamp getRegdate() { return regdate; } public void setRegdate(Timestamp regdate) { this.regdate = regdate; } }

 public void GetUsers(String name,int pagesize,int pageIndex)

 public class SystemContext { //页大小 private static ThreadLocal pageSize = new ThreadLocal<>(); //当前页 private static ThreadLocal pageIndex = new ThreadLocal<>(); public static Integer getPageSize() { return pageSize.get(); } public static void removePageSize(){ pageSize.remove(); } public static void setPageSize(int _pageSize) { pageSize.set(_pageSize); } public Integer getPageIndex() { return pageIndex.get(); } public void setPageIndex(int _pageIndex) { pageIndex.set(_pageIndex); } public static void removePageIndex(){ pageIndex.remove(); } }

 import com.dao.SystemContext; import javax.servlet.*; import java.io.IOException; public class SystemFilter implements Filter{ int pageSize; int pageIndex = 1; @Override public void init(FilterConfig filterConfig) throws ServletException { try { pageSize = Integer.parseInt(filterConfig.getInitParameter("pagesize")); } catch (NumberFormatException e) { pageSize = 15; } } @Override public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException { try { pageIndex = Integer.parseInt(servletRequest.getParameter("pageindex")); }catch (NumberFormatException e){ //什么也不做,pageindex=1 } try { //开始请求的时候配置参数 SystemContext.setPageSize(pageSize); SystemContext.setPageIndex(pageIndex); filterChain.doFilter(servletRequest,servletResponse); }finally { //请求返回的时候移除参数 SystemContext.removePageIndex(); SystemContext.removePageSize(); } } @Override public void destroy() { } }

SystemFiltercom.filter.SystemFilterpagesize15SystemFilter/index.jsp

 import com.util.Pager; import com.util.User; import java.sql.*; import java.util.ArrayList; import java.util.List; public class UserDAO { private Connection conn = null; private ResultSet rs = null; private PreparedStatement ps = null; // public static void main(String[] args) { // UserDAO dao = new UserDAO(); // dao.GetUsers("",15,1); // dao.close(); // } public UserDAO() { String driverName = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/fenyedemo"; String user = "root";String password = "123456"; try { Class.forName(driverName); conn = DriverManager.getConnection(url,user,password); } catch (ClassNotFoundException e) { System.out.println("没有发现驱动"); e.printStackTrace(); } catch (SQLException e) { System.out.println("获取连接失败"); e.printStackTrace(); } } /** * 具体分页实现代码 * @param name 查询条件 * @return */ public Pager GetUsers(String name){ //获取分页参数 int pagesize = SystemContext.getPageSize(); int pageIndex = SystemContext.getPageIndex(); //分页具体sql语句 String sql = "select * from user "; String sqlCount = "select count(*) from user "; if (name!=null && !name.trim().equals("")){ sql += "where username LIKE %"+name+"%"; sqlCount += "where username LIKE %"+name+"%"; } sql += " LIMIT ?,?"; //存放当前页的集合 List datas = new ArrayList<>(); //存放当前分页的集合 Pager pages = new Pager<>(); User userTemp = null; try { ps = conn.prepareStatement(sql); if(pageIndex<=0) pageIndex=1; //设置参数 ps.setInt(1,(pageIndex-1)*pagesize); ps.setInt(2,pagesize); rs = ps.executeQuery(); //循环取出,添加到datas中 while (rs.next()){ userTemp = new User(); userTemp.setUserId(rs.getString("id")); userTemp.setUsername(rs.getString("username")); userTemp.setPassword(rs.getString("password")); userTemp.setRegdate(rs.getTimestamp("regdate")); datas.add(userTemp); } //最后设置pages pages.setPageIndex(pageIndex); pages.setPageSize(pagesize); ps = conn.prepareStatement(sqlCount); rs = ps.executeQuery(); while(rs.next()){ pages.setTotalRecords(rs.getInt(1)); pages.setTotalPages((rs.getInt(1)-1)/pagesize+1); } pages.setDatas(datas); } catch (SQLException e) { System.out.println("获取出错"); e.printStackTrace(); } return pages; } public void close(){ try { if (rs!=null) rs.close(); rs = null; if (ps!=null) ps.close(); ps = null; if (conn!=null) conn.close(); conn = null; } catch (SQLException e) { System.out.println("关闭失败"); e.printStackTrace(); } } }

<%@ page import="com.dao.UserDAO" %><%@ page import="com.util.Pager" %><%@ page import="com.util.User" %><%@ page import="java.util.Iterator" %><%@ page contentType="text/html;charset=UTF-8" language="java" %><% String condition = request.getParameter("condition"); UserDAO userDAO = new UserDAO(); Pager pages = null; if (condition!=null && !condition.trim().equals("")){ pages = userDAO.GetUsers(condition); }else { pages = userDAO.GetUsers(null); } userDAO.close(); %>
分页测试
<% for (Iterator it = pages.getDatas().iterator(); it.hasNext() ; ) { User userTemp = (User) it.next(); %><% }%>
ID
USERNAME
PASSWORD
DATA
<%=userTemp.getUserId()%>
<%=userTemp.getUsername()%>
<%=userTemp.getPassword()%>
<%=userTemp.getRegdate()%>

<%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="utf-8" %><% int items = Integer.parseInt(request.getParameter("items")); int maxPageItems = Integer.parseInt(request.getParameter("maxPageItems")); int maxIndexPages = Integer.parseInt(request.getParameter("maxIndexPages")); String params = request.getParameter("params"); %><%--引入分页框架--%><%@taglib prefix="pg" uri="http://jsptags.co
                
提示：
                    本文由神整理自网络，如有侵权请联系本站删除！
                    

                    本站声明： 

                    1、本站所有资源均来源于互联网，不保证100%完整、不提供任何技术支持； 

                    2、本站所发布的文章以及附件仅限用于学习和研究目的;不得将用于商业或者非法用途；否则由此产生的法律后果，本站概不负责！
                
                

                

                                            
上一篇：JSP入门之HelloWorld程序实例_JSP编程_
                                                                
下一篇：JSP自定义标签简单入门教程_JSP编程_