SSH实现数据分页显示功能

「爱情、让人受尽委屈。」 2022-06-07 05:21 292阅读 0赞

之前使用许多技术做过数据的分页显示功能,像pager-taglib分页框架,还有许多前端技术自带的分页.但很少使用框架自己尝试写分页,剖析分页的原理.现在自己实现一个数据分页的功能.

工程结构:

![Center][]

代码:

\#数据模型层

User.java

package com.sunline.entity;
    
    /**
     * User entity. @author MyEclipse Persistence Tools
     */
    
    public class User  implements java.io.Serializable {
    
        // Fields    
    
         private Integer userId;
         private String userName;
         private String userPassword;
         private String userKind;
         private Double userBalance;
         private String userStatus;
    
    
        // Constructors
    
        /** default constructor */
        public User() {
        }
    
    	/** minimal constructor */
        public User(String userName, String userPassword, String userKind, Double userBalance) {
            this.userName = userName;
            this.userPassword = userPassword;
            this.userKind = userKind;
            this.userBalance = userBalance;
        }
        
        /** full constructor */
        public User(String userName, String userPassword, String userKind, Double userBalance, String userStatus) {
            this.userName = userName;
            this.userPassword = userPassword;
            this.userKind = userKind;
            this.userBalance = userBalance;
            this.userStatus = userStatus;
        }
    
       
        // Property accessors
    
        public Integer getUserId() {
            return this.userId;
        }
        
        public void setUserId(Integer userId) {
            this.userId = userId;
        }
    
        public String getUserName() {
            return this.userName;
        }
        
        public void setUserName(String userName) {
            this.userName = userName;
        }
    
        public String getUserPassword() {
            return this.userPassword;
        }
        
        public void setUserPassword(String userPassword) {
            this.userPassword = userPassword;
        }
    
        public String getUserKind() {
            return this.userKind;
        }
        
        public void setUserKind(String userKind) {
            this.userKind = userKind;
        }
    
        public Double getUserBalance() {
            return this.userBalance;
        }
        
        public void setUserBalance(Double userBalance) {
            this.userBalance = userBalance;
        }
    
        public String getUserStatus() {
            return this.userStatus;
        }
        
        public void setUserStatus(String userStatus) {
            this.userStatus = userStatus;
        }
    
    }

User.hbm.xml

<?xml version="1.0" encoding="utf-8"?>
    <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
    
    <hibernate-mapping>
        <class name="com.sunline.entity.User" table="user" catalog="bank">
            <id name="userId" type="java.lang.Integer">
                <column name="user_id" />
                <generator class="native"></generator>
            </id>
            <property name="userName" type="java.lang.String">
                <column name="user_name" length="50" not-null="true" />
            </property>
            <property name="userPassword" type="java.lang.String">
                <column name="user_password" length="50" not-null="true" />
            </property>
            <property name="userKind" type="java.lang.String">
                <column name="user_kind" length="50" not-null="true" />
            </property>
            <property name="userBalance" type="java.lang.Double">
                <column name="user_balance" precision="15" not-null="true" />
            </property>
            <property name="userStatus" type="java.lang.String">
                <column name="user_status" length="4" />
            </property>
        </class>
    </hibernate-mapping>

\#数据访问层

package com.sunline.dao;
    
    import java.util.List;
    
    import javax.annotation.Resource;
    
    import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
    
    import com.sunline.entity.User;
    
    @Resource(name="UserDao")
    public class UserDao extends HibernateDaoSupport{
    	/*
    	 * 获取所有用户信息
    	 */
    	@SuppressWarnings("unchecked")
    	public List<User> findAll(){
    		String sql="from User";
    		List<User> list=this.getHibernateTemplate().find(sql);
    		return list;
    	}
    }

\#业务逻辑层

package com.sunline.biz;
    
    import java.util.List;
    
    import org.springframework.stereotype.Service;
    
    import com.sunline.dao.UserDao;
    import com.sunline.entity.User;
    
    @Service(value="UserBiz")
    public class UserBiz {
       UserDao userDao;
    
       public void setUserDao(UserDao userDao) {
    	  this.userDao = userDao;
       }
    	/*
    	 * 获取所有用户信息
    	 */
    	@SuppressWarnings("unchecked")
    	public List<User> findAll(){
    		return userDao.findAll();
    	}
       
    }

\#数据分页的处理

Page.java

package com.sunline.entity;
    
    import java.util.ArrayList;
    import java.util.List;
    
    public class Page {
    	private List<User> bigList;//分页数据集
    	private List<User> smallList;//返回实际的数据集
    	private int currentPage;//当前页
    	private int pageRow;//每页行数
    	private int pageTotal;//总页数
    	private int nextPage;//下一页
    	private int upPage;//上一页
    	private boolean isFirstPage;//是否为首页
    	private boolean isLastPage;//是否尾页
    	private int totalRow;//查询到的总记录数
    	public boolean getIsFirstPage() {
    		if(currentPage==1){
    			isFirstPage=true;
    		}
    		return isFirstPage;
    	}
    	public boolean getIsLastPage() {
    		this.getPageTotal();
    		if(currentPage==pageTotal){
    			isLastPage=true;
    		}
    		return isLastPage;
    	}
    	public int getNextPage() {
    		this.nextPage=currentPage+1;
    		return nextPage;
    	}
    	public int getUpPage() {
    		this.upPage=currentPage-1;
    		return upPage;
    	}
    	public int getPageTotal() {
    		this.pageTotal=bigList.size()/pageRow;
    		if(bigList.size()%pageRow!=0){
    			this.pageTotal++;
    		}
    		return pageTotal;
    	}
    	public List<User> getSmallList() {
    		smallList=new ArrayList();
    		for (int i=(currentPage-1)*pageRow;i<=currentPage*pageRow-1&&i<bigList.size();i++) {
    			smallList.add(bigList.get(i));
    		}
    		return smallList;
    	}
    	public void setBigList(List<User> bigList) {
    		this.bigList = bigList;
    	}
    	public void setCurrentPage(int currentPage) {
    		this.currentPage = currentPage;
    	}
    	public void setPageRow(int pageRow) {
    		this.pageRow = pageRow;
    	}
    	public int getTotalRow() {
    		return this.bigList.size();
    	}
    	public int getPageRow() {
    		return pageRow;
    	}
    	public int getCurrentPage() {
    		return currentPage;
    	}
    	
    }

\#控制层

UserAction.java

package com.sunline.action;
    
    import java.util.List;
    import java.util.Map;
    
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import com.opensymphony.xwork2.ActionContext;
    import com.opensymphony.xwork2.ActionSupport;
    import com.sunline.biz.UserBiz;
    import com.sunline.entity.Page;
    import com.sunline.entity.User;
    
    public class UserAction extends ActionSupport {
    	private static final long serialVersionUID = -3661658944790352760L;
    	//获取配置文件
        ApplicationContext context=new ClassPathXmlApplicationContext("applicationContext.xml"); 
        //获取配置中的实例  
        UserBiz userBiz = (UserBiz) context.getBean("UserBiz");
    	ActionContext contextq = ActionContext.getContext();
    	Map<String, Object> session = contextq.getSession();
    	private String currentPage;                  //前端传来的当前页码
    	public String getCurrentPage() {
    		return currentPage;
    	}
    
    	public void setCurrentPage(String currentPage) {
    		this.currentPage = currentPage;
    	}
    
    	public String execute() throws Exception {
    		// TODO Auto-generated method stub
    		List<User> list = (List<User>) userBiz.findAll();
    		//得到当前页
    		String currentPage = this.currentPage;
    		if(currentPage==null){
    			currentPage="1";
    		}
    		int pageNum=Integer.parseInt(currentPage);
    		Page page = new Page();
    		page.setBigList(list);//设置要分页的集合
    		page.setCurrentPage(pageNum);//设置当前页
    		page.setPageRow(5);//设置每页数量
    		session.put("page", page);
    		return SUCCESS;
    	}
    	
    
    }

\#前端视图层

page.jsp

<%@page import="com.sunline.entity.User"%>
    <%@page import="com.sunline.entity.Page"%>
    <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
    <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> 
    <%
    String path = request.getContextPath();
    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
    %>
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html>
      <head>
        <base href="<%=basePath%>">
        
        <title>分页显示数据</title>
        
    	<meta http-equiv="pragma" content="no-cache">
    	<meta http-equiv="cache-control" content="no-cache">
    	<meta http-equiv="expires" content="0">    
    	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    	<meta http-equiv="description" content="This is my page">
    	
      <link rel="stylesheet" href="bootstrap-3.3.7/css/bootstrap.min.css">  
      <script src="js/jquery-3.2.1.min.js"></script>    
      <script src="js/bootstrap.min.js"></script>  
      <script type="text/javascript">
    function check(){
    	var currentPage = document.getElementById("currentPages").value;
    	var PageTotal = document.getElementById("PageTotal").value;
    	if(currentPage==""){  
    		alert("请输入要跳转的页数！");
    		return false;
    	}
    	if(currentPage>PageTotal){   
    	    alert("对不起,没有你要查找的数据!");
    	    return false;
    	}
    	window.location.href="${pageContext.request.contextPath}/Page?currentPage="+currentPage;
    }
    </script>
      </head>
      
    <body>
    <div class="container-fluid row form-group">
      <div class="panel panel-info"> 
         <div class="panel-heading">
              <strong class="glyphicon glyphicon-home" style="text-align: left;">数据分页</strong>
         </div>
         <div class="panel-body">
          <table class="table table-hover" border="1">
            <tr style="height: 40px;" class="success">
               <td>用户ID</td>
               <td>用户姓名</td>
               <td>用户密码</td>
               <td>账户类型</td>
               <td>账户余额</td>
               <td>账户状态</td>
            </tr>
         <%
             Page pages = (Page)request.getSession().getAttribute("page");
             System.out.println("你的页面数据为 : " + pages.getCurrentPage());
             List<User> list = (List<User>) pages.getSmallList();
             for(User user : list){		 
          %>
          <tr>
             <td><%=user.getUserId() %></td>
             <td><%=user.getUserName() %></td>
             <td><%=user.getUserPassword() %></td>
             <td><%=user.getUserKind() %></td>
             <td><%=user.getUserBalance() %></td>
             <td><%=user.getUserStatus() %></td>
          </tr>
          
          <%
            }
           %>
         </table>
         <div style="float: right;">
           	共 <font color="red"><%=pages.getTotalRow() %></font> 条数据   
      		当前第 <font color="red"><%=pages.getCurrentPage() %></font> 页  
      		共 <font color="red"><%=pages.getPageTotal() %></font> 页  
      		<%
      		   int yeshu = pages.getPageTotal();
      		   int currentPage = pages.getCurrentPage();
      		 %>
             <a href="${pageContext.request.contextPath }/Page?currentPage=1">首页</a>
             <%
                if(currentPage!=1){
              %>
              <a href="${pageContext.request.contextPath }/Page?currentPage=<%=currentPage-1%>">上一页</a>
              <%
                 }
               %>
             <%
                 if(currentPage<pages.getPageTotal()){
              %>
             <a href="${pageContext.request.contextPath }/Page?currentPage=<%=currentPage+1%>">下一页</a>
             <%
                 }
              %>
              <label>跳转到</label>
              <input type="text" name="currentPages" id="currentPages" style="width: 40px;"/>
              <input type="hidden" name="PageTotal" id="PageTotal" value="<%=pages.getPageTotal()%>">
              <label>页</label>
              <input type="button" value="跳转" class="btn btn-success" οnclick="check()"/>
          </div>
        </div>
      </div>
    </div>
    </body>
    </html>

\#截图

![Center 1][]

![Center 2][]

工程源码,需要参考可以下载使用,有使用教程,点击----->[下载源码][Link 1][  
][Link 1]

[Center]: /images/20220607/84494e29b8a24e7188b5afc20013d561.png
[Center 1]: /images/20220607/51b7c27193da48fb939c8a77ae15c4f3.png
[Center 2]: /images/20220607/076189c073394670b3b7e9905214494d.png
[Link 1]: http://download.csdn.net/download/linhaiyun_ytdx/10016677