hibernate+struts2实现数据分页

短命女 2022-05-23 10:26 175阅读 0赞

#### 1.创建实体类 ####

package com.mxl.models;
    import java.util.Date;
    public class User {
    	private Integer id;
    	private String username;
    	private String password;
    	private String name;
    	private String sex;
    	private Date birthday;
    	private String email;
    	private String phone;		
    	public Integer getId() {
    		return id;
    	}
    	public void setId(Integer id) {
    		this.id = id;
    	}
    	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 String getName() {
    		return name;
    	}
    	public void setName(String name) {
    		this.name = name;
    	}
    	public String getSex() {
    		return sex;
    	}
    	public void setSex(String sex) {
    		this.sex = sex;
    	}
    	public Date getBirthday() {
    		return birthday;
    	}
    	public void setBirthday(Date birthday) {
    		this.birthday = birthday;
    	}
    	public String getEmail() {
    		return email;
    	}
    	public void setEmail(String email) {
    		this.email = email;
    	}
    	public String getPhone() {
    		return phone;
    	}
    	public void setPhone(String phone) {
    		this.phone = phone;
    	}
    }

#### 2.创建实体类映射 ####

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
    <hibernate-mapping>
    	<class name="com.mxl.models.User" table="user">
    		<id name="id" column="id"><generator class="native"></generator></id>
    		<property name="username"></property>
    		<property name="password"></property>
    		<property name="name"></property>
    		<property name="sex"></property>
    		<property name="birthday"></property>
    		<property name="email"></property>
    		<property name="phone"></property>
    	</class>
    </hibernate-mapping>

#### 3.创建action ####

package com.mxl.actions;
    import java.util.List;
    import javax.servlet.http.HttpServletRequest;
    import org.apache.struts2.ServletActionContext;
    import com.mxl.dao.UserDao;
    import com.mxl.models.User;
    import com.opensymphony.xwork2.ActionContext;
    import com.opensymphony.xwork2.ActionSupport;
    public class UserManager extends ActionSupport {
    	private User user;	
    	private List<User>users;
    	private UserDao userDao=new UserDao();
    	private int pageNo=1;
    	private int pageSize=8;
    	private int pageCount;
    	public String user_getAll(){
    		pageCount=userDao.getPageCount(pageSize);
    		if(pageNo<1){
    			pageNo=1;
    		}else if(pageNo>pageCount){
    			pageNo=pageCount;
    		}
    		users=userDao.selectAllList(pageNo,pageSize);
    		return "userList";
    	}
    	public void setUsers(List<User> users) {
    		this.users = users;
    	}	
    	public User getUser() {
    		return user;
    	}
    	public void setUser(User user) {
    		this.user = user;
    	}
    	public int getPageNo() {
    		return pageNo;
    	}
    	public void setPageNo(int pageNo) {
    		this.pageNo = pageNo;
    	}
    	public int getPageSize() {
    		return pageSize;
    	}
    	public void setPageSize(int pageSize) {
    		this.pageSize = pageSize;
    	}
    	public int getPageCount() {
    		return pageCount;
    	}
    	public void setPageCount(int pageCount) {
    		this.pageCount = pageCount;
    	}
    }

#### 4.创建UserDao ####

package com.mxl.dao;
    import java.util.List;
    import org.hibernate.Query;
    import org.hibernate.Session;
    import org.hibernate.Transaction;
    import com.mxl.connect.HibernateSessionFactory;
    import com.mxl.models.User;
    public class UserDao {
    	private  Session session=null;
    	private Transaction tx=null;
    	public List<User> selectAllList(int pageNo,int pageSize){//分页查询
    		List<User>list=null;
    		try{
    			session=HibernateSessionFactory.getSession();
    			String hql="from User";
    			Query query=session.createQuery(hql);
    			query.setFirstResult((pageNo-1)*pageSize);
    			query.setMaxResults(pageSize);
    			list=query.list();
    		}catch(Exception ex){
    			ex.printStackTrace();
    		}finally{
    			HibernateSessionFactory.closeSession();
    		}
    		return list;
    	}
    	public int getPageCount(int pageSize){//获得总页数
    		String hql="select count(id) from User";
    		int count=0;
    		int pageCount=0;
    		try{
    			session=HibernateSessionFactory.getSession();
    			Query query=session.createQuery(hql);
    			long temp=(Long)query.uniqueResult();
    			count=(int)temp;
    		}catch(Exception e){
    			e.printStackTrace();
    		}finally{
    			HibernateSessionFactory.closeSession();
    		}
    		if(count%pageSize==0){
    			pageCount=count/pageSize;
    		}else{
    			pageCount=count/pageSize+1;
    		}
    		return pageCount;
    	}
    }

#### 5.创建显示页面(关键代码) ####

#### 6.运行效果 ####

![20180607101512125][]

[20180607101512125]: /images/20220523/3efaf8dc65eb43ea9a52d5f96890ebb3.png