利用Struts2+Hibernate+maven进行分页查询

偏执的太偏执、 2022-01-11 04:05 247阅读 0赞

### 利用Struts2+Hibernate+maven进行分页查询 ###

*  项目介绍
 *   *  环境配置
     *  文件结构
     *  文件说明
     *  资源下载
     *  参考博客
 *  源代码
 *   *  Companyinfo实体类
     *  pageBean分页信息实体类
     *  CompanyinfoDao操作层
     *  Hibernate的工厂类HibernateSessionFactory
     *  Struts2 Action类：page
     *  Companyinfo的配置信息:Companyinfo.hbm.xml
     *  hibernate配置:hibernate.cfg.xml
     *  Struts2的配置：struts.xml
     *  前台显示show.jsp
     *  maven配置文件：pom.xml
 *  运行截图

# 项目介绍 #

## 环境配置 ##

IDE:eclipse
    jdk-version:1.8
    maven的webapp应用

## 文件结构 ##

![文件结构][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70]

## 文件说明 ##

Companyinfo：是一个JavaBean类，需要显示的内容
    pageBean：描述分页信息的内容
    CompanyinfoDao：Companyinfo的Dao层用来数据库访问的一个接口
    HibernateSessionFactory：封装一些Hibernate一些操作
    page：action与前台进行交换，在运行该项目的时候在浏览器的的地址栏访问
    http://localhost:8080/a/page
    show.jsp：用来显示从数据库获取的记录，并可以进行上下页进行查看

## 资源下载 ##

[利用Struts2+Hibernate+maven进行分页查询][Struts2_Hibernate_maven]

## 参考博客 ##

[利用servlet+jsp+javabean进行分页查询][servlet_jsp_javabean]  
[s标签显示后台数据的基本用法以及iterator遍历用法][s_iterator]  
[Hibernate HQL详解][Hibernate HQL]

# 源代码 #

## Companyinfo实体类 ##

package org.hb.bean;
    
    import java.io.Serializable;
    
    @SuppressWarnings("serial")
    public class Companyinfo implements Serializable{ 
    	private Integer c_id;
    	private String c_name;
    	private String c_email;
    	private String c_password;
    	private String c_brief;
    	private String c_serve;
    	public Companyinfo(Integer c_id, String c_name, String c_email, String c_password, String c_brief, String c_serve) { 
    		super();
    		this.c_id = c_id;
    		this.c_name = c_name;
    		this.c_email = c_email;
    		this.c_password = c_password;
    		this.c_brief = c_brief;
    		this.c_serve = c_serve;
    	}
    	public Companyinfo() { 
    		super();
    	}
    	@Override
    	public String toString() { 
    		return "Companyinfo [c_id=" + c_id + ", c_name=" + c_name + ", c_email=" + c_email + ", c_password="
    				+ c_password + ", c_brief=" + c_brief + ", c_serve=" + c_serve + "]";
    	}
    	public Integer getC_id() { 
    		return c_id;
    	}
    	public void setC_id(Integer c_id) { 
    		this.c_id = c_id;
    	}
    	public String getC_name() { 
    		return c_name;
    	}
    	public void setC_name(String c_name) { 
    		this.c_name = c_name;
    	}
    	public String getC_email() { 
    		return c_email;
    	}
    	public void setC_email(String c_email) { 
    		this.c_email = c_email;
    	}
    	public String getC_password() { 
    		return c_password;
    	}
    	public void setC_password(String c_password) { 
    		this.c_password = c_password;
    	}
    	public String getC_brief() { 
    		return c_brief;
    	}
    	public void setC_brief(String c_brief) { 
    		this.c_brief = c_brief;
    	}
    	public String getC_serve() { 
    		return c_serve;
    	}
    	public void setC_serve(String c_serve) { 
    		this.c_serve = c_serve;
    	}
    	
    }

## pageBean分页信息实体类 ##

package org.hb.bean;
    
    public class pageBean { 
    	private int everyPage; // 每页显示记录数
    	private int totalCount; // 总记录数
    	private int totalPage; // 总页数
        private int currentPage; //当前页
        private int beginIndex;			//查询起始点
    	public pageBean(int everyPage, int totalCount ,int currentPage) { 
    		super();
    		this.everyPage = everyPage;
    		this.totalCount = totalCount;
    		this.currentPage = currentPage;
    		if(totalCount != 0 &&totalCount % everyPage == 0) { 
    			totalPage = totalCount / everyPage;
    		} else { 
    			totalPage = totalCount / everyPage + 1;
    		}
    	}
    	public int getCurrentPage() { 
    		return currentPage;
    	}
    	public void setCurrentPage(int currentPage) { 
    		if(currentPage<1)currentPage=1;
    		this.currentPage = currentPage;
    		
    	}
    	public int getEveryPage() { 
    		return everyPage;
    	}
    	public void setEveryPage(int everyPage) { 
    		this.everyPage = everyPage;
    	}
    	public int getTotalCount() { 
    		return totalCount;
    	}
    	public void setTotalCount(int totalCount) { 
    		this.totalCount = totalCount;
    	}
    	
    	public int getTotalPage() { 
    		return totalPage;
    	}
    	public void setTotalPage(int totalPage) { 
    		this.totalPage = totalPage;
    	}
    	public int getBeginIndex() { 
    		setBeginIndex();
    		return beginIndex;
    	}
    	public void setBeginIndex() { 
    		this.beginIndex =(currentPage - 1) * everyPage;
    	}
    
    }

## CompanyinfoDao操作层 ##

package org.hb.dao;
    
    import java.util.List;
    
    import org.hibernate.Session;
    import org.hibernate.query.Query;
    import org.hb.bean.Companyinfo;
    import org.hb.bean.pageBean;;
    
    public class CompanyinfoDao { 
    	
    	public int getCount(String hql) { 
    		Session session = HibernateSessionFactory.getSession();
    		return new Long((Long)session.createQuery(hql).uniqueResult()).intValue();
    	}
    		
    	public List<Companyinfo> getAll(String hql,pageBean pBean) { 
    		// TODO Auto-generated method stub
    		Session session = HibernateSessionFactory.getSession();
    		List<Companyinfo> list = null;
    		try { 
    			Query<Companyinfo> query = session.createQuery(hql,Companyinfo.class);
    			query.setFirstResult(pBean.getBeginIndex());
    			query.setMaxResults(pBean.getEveryPage());
    			list= query.list();
    		} catch (Exception e) { 
    			// TODO: handle exception
    			e.printStackTrace();
    		}finally { 
    			HibernateSessionFactory.closeSession();
    		}
    		return list;
    	}
    }

## Hibernate的工厂类HibernateSessionFactory ##

package org.hb.dao;
    
    import org.hibernate.HibernateException;
    import org.hibernate.Session;
    import org.hibernate.cfg.Configuration;
    
    public class HibernateSessionFactory { 
    	private static String CONFIG_FILE_LOCATION = "/hibernate.cfg.xml"; // 指定配置文件路径
    	private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>(); // 定义ThreadLocal对象
    	private static Configuration configuration = new Configuration(); // 定义Configuration对象
    	private static org.hibernate.SessionFactory sessionFactory;// 定义SessionFactory对象
    	private static String configFile = CONFIG_FILE_LOCATION;
    	static { 
    		try { 
    			configuration.configure(configFile);// 读取配置文件
    			sessionFactory = configuration.buildSessionFactory();// 根据配置文件创建SessionFactory对象
    		} catch (Exception e) { 
    			e.printStackTrace();
    		}
    	}
    
    	private HibernateSessionFactory() { 
    	}
    
    	public static Session getSession() throws HibernateException { 
    		Session session = (Session) threadLocal.get();// 从ThreadLocal对象中获得Session对象
    		if (session == null || !session.isOpen()) { // 判断获得的Session对象是否为空或者未打开
    			if (sessionFactory == null) { // 如果没有创建SessionFactory对象，则首先创建
    				rebuildSessionFactory();
    			}
    			// 如果SessionFactory对象不为空，则调用其openSession方法创建Session对象
    			session = (sessionFactory != null) ? sessionFactory.openSession() : null;
    			threadLocal.set(session);// 在ThreadLocal对象中保存该Session对象
    		}
    		return session;
    	}
    
    	public static void rebuildSessionFactory() { 
    		try { 
    			configuration.configure(configFile);// 读取配置文件
    			sessionFactory = configuration.buildSessionFactory();// 根据配置文件创建sessionFactory对象
    		} catch (Exception e) { 
    			e.printStackTrace();
    		}
    	}
    
    	public static void closeSession() throws HibernateException { 
    		Session session = (Session) threadLocal.get();// 从ThreadLocal对象中获得Session对象
    		threadLocal.set(null);// 将当前线程Session对象从ThreadLocal对象中移除
    		if (session != null) { 
    			session.close();
    		}
    	}
    
    	public static org.hibernate.SessionFactory getSessionFactory() { // 取得SessionFactory对象
    		return sessionFactory;
    	}
    
    	public static void setConfigFile(String configFile) { // 设置新的配置文件
    		HibernateSessionFactory.configFile = configFile;
    		sessionFactory = null;
    	}
    
    	public static Configuration getConfiguration() { // 获得Configuration对象
    		return configuration;
    	}
    }

## Struts2 Action类：page ##

package org.mystruts.action;
    
    import java.util.List;
    
    import javax.servlet.http.HttpSession;
    
    import org.apache.struts2.ServletActionContext;
    import org.hb.bean.Companyinfo;
    import org.hb.bean.pageBean;
    import org.hb.dao.CompanyinfoDao;
    
    import com.opensymphony.xwork2.ActionSupport;
    
    @SuppressWarnings("serial")
    public class page extends ActionSupport { 
    	private Integer currentPage;
    	private List<Companyinfo> list;
    	
    	
    	public List<Companyinfo> getList() { 
    		return list;
    	}
    
    
    
    	public void setList(List<Companyinfo> list) { 
    		this.list = list;
    	}
    
    
    
    	public Integer getCurrentPage() { 
    		return currentPage;
    	}
    
    
    
    	public void setCurrentPage(Integer currentPage) { 
    		this.currentPage = currentPage;
    		
    	}
    	
    	public CompanyinfoDao companyinfoDao = new CompanyinfoDao();
    
    
    	public String execute() throws Exception { 
    		HttpSession session = ServletActionContext.getRequest().getSession();
    		pageBean pBean = (pageBean)session.getAttribute("page");
    		if(pBean==null) { 
    			String hql = "select count(*) from Companyinfo ";
    			int count = companyinfoDao.getCount(hql);
    			pBean= new pageBean(3, count, 1);
    		}
    		if(currentPage==null)currentPage=1;
    		pBean.setCurrentPage(currentPage);
    		String hql = " from Companyinfo ";
    		list = companyinfoDao.getAll(hql, pBean);
    		session.setAttribute("page", pBean);
    		return ActionSupport.SUCCESS;
    	}
    }

## Companyinfo的配置信息:Companyinfo.hbm.xml ##

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
    
    <hibernate-mapping package="org.hb.bean">
    	<class name="Companyinfo" table="companyinfo">
    		<id name="c_id">
    			<generator class="native" />
    		</id>
    		<property name="c_name" type="string" column="c_name" />
    		<property name="c_email" type="string" column="c_email" />
    		<property name="c_password" type="string" column="c_password" />
    		<property name="c_brief" type="string" column="c_brief" />
    		<property name="c_serve" type="string" column="c_serve" />
    	</class>
    </hibernate-mapping>

## hibernate配置:hibernate.cfg.xml ##

<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
    <hibernate-configuration>
        <session-factory>
            <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
            <property name="hibernate.connection.url">jdbc:mysql://127.0.0.1:3306/job?useSSL=false</property>
            <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
            <property name="connection.username">root</property>
            
            <property name="connection.password"></property>
    
            
            <property name="show_sql">false</property>
            <property name="format_sql">false</property>
    
            
            <mapping resource="org/hb/bean/Companyinfo.hbm.xml" />
        </session-factory>
    </hibernate-configuration>

## Struts2的配置：struts.xml ##

<?xml version="1.0" encoding="UTF-8"?>
    
    <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.5//EN" "http://struts.apache.org/dtds/struts-2.5.dtd">
    
    <struts>
        <package name="page" namespace="/" extends="struts-default">
            <action name="page" class="org.mystruts.action.page">
                <result name="success">/show.jsp</result>
            </action>
        </package>
    </struts>

## 前台显示show.jsp ##

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
    <%@page import="org.hb.bean.*"%>
     <%@ taglib prefix="s" uri="/struts-tags"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html lang="en">
    <head>
    	<meta charset="UTF-8">
    	<title>Document</title>
    </head>
    <style type="text/css"> table { border-collapse: collapse; border:2px solid black; } th,td { padding: .5em .75em; } th { border:1px solid grey; } td { border:1px dotted grey; } </style>
     <body>
            <table>
                <caption>彩排安排</caption>
                <thead>
                    
                    <tr>
                        <th scope="rowgroup">公司名称</th>
                        <th scope="col">公司email</th>
                        <th scope="col">公司服务</th>
                    </tr>
                </thead>
                <tbody>
                    
                   <s:iterator value="list" >
                   	<tr>
                   		<td><s:property value="c_name" /></td>
                   		<td><s:property value="c_email" /></td>
                   		<td><s:property value="c_serve"/></td>
                   </tr>
                  </s:iterator>
                </tbody>
            </table>
            <a href="page?currentPage=1">首页</a>  
             <s:if test="#session.page.currentPage!=1">
            	 <a href="page?currentPage=<s:property value="%{#session.page.currentPage-1}"/>">上一页</a>  
             </s:if>
             <s:if test="#session.page.currentPage!=#session.page.totalPage">
            	 <a href="page?currentPage=<s:property value="%{#session.page.currentPage+1}"/>">下一页</a>  
             </s:if>       
              <a href="page?currentPage=<s:property value="#session.page.totalPage"/>">尾页</a>
        </body>
    </html>

## maven配置文件：pom.xml ##

<?xml version="1.0" encoding="UTF-8"?>
    
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
      <modelVersion>4.0.0</modelVersion>
    
      <groupId>a</groupId>
      <artifactId>a</artifactId>
      <version>0.0.1-SNAPSHOT</version>
      <packaging>war</packaging>
    
      <name>a Maven Webapp</name>
      
      <url>http://www.example.com</url>
    
      <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <maven.compiler.source>1.7</maven.compiler.source>
        <maven.compiler.target>1.7</maven.compiler.target>
      </properties>
    
      
     <dependencies>
     
       <dependency>
        <groupId>org.apache.struts</groupId>
        <artifactId>struts2-core</artifactId>
        <version>2.5.20</version>
      </dependency>
      
      <dependency>
      		<groupId>mysql</groupId>
      		<artifactId>mysql-connector-java</artifactId>
      		<version>5.1.41</version>
      	</dependency>
      
      	<dependency>
      		<groupId>org.hibernate</groupId>
      		<artifactId>hibernate-core</artifactId>
      		<version>5.4.2.Final</version>
      	</dependency>
      	
        <dependency>
          <groupId>junit</groupId>
          <artifactId>junit</artifactId>
          <version>4.11</version>
          <scope>test</scope>
        </dependency>
      </dependencies>
    
      <build>
        <finalName>a</finalName>
        <pluginManagement>
          <plugins>
            <plugin>
              <artifactId>maven-clean-plugin</artifactId>
              <version>3.1.0</version>
            </plugin>
            
            <plugin>
              <artifactId>maven-resources-plugin</artifactId>
              <version>3.0.2</version>
            </plugin>
            <plugin>
              <artifactId>maven-compiler-plugin</artifactId>
              <version>3.8.0</version>
            </plugin>
            <plugin>
              <artifactId>maven-surefire-plugin</artifactId>
              <version>2.22.1</version>
            </plugin>
            <plugin>
              <artifactId>maven-war-plugin</artifactId>
              <version>3.2.2</version>
            </plugin>
            <plugin>
              <artifactId>maven-install-plugin</artifactId>
              <version>2.5.2</version>
            </plugin>
            <plugin>
              <artifactId>maven-deploy-plugin</artifactId>
              <version>2.8.2</version>
            </plugin>
          </plugins>
        </pluginManagement>
      </build>
    </project>

# 运行截图 #

![运行截图1][1]![运行截图2][2]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw_size_16_color_FFFFFF_t_70]: /images/20220111/d1449afe309b4c63862e732e1abe72c0.png
[Struts2_Hibernate_maven]: https://download.csdn.net/download/qq_41146650/11248756
[servlet_jsp_javabean]: https://blog.csdn.net/qq_41146650/article/details/92799234
[s_iterator]: https://blog.csdn.net/zzq900503/article/details/43969545
[Hibernate HQL]: https://www.cnblogs.com/caoyc/p/5606444.html
[1]: https://img-blog.csdnimg.cn/20190618200451967.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMTQ2NjUw,size_16,color_FFFFFF,t_70
[2]: /images/20220111/48e077bc8d4842e1b36c72025979ffcb.png