struts2.3+spring4.2+hibernate4.3整合带分页例子-CSDN博客

本文链接：https://blog.csdn.net/lu1099936765/article/details/52799809

学习SSH已经有一段时间了，在网上找一个容易理解的SSH有点难，这里给大家提供一个较简单的SSH例子，供广大初学者学习。先上图，后面再细说（第一次写博客，可能有很多不完善的地方）。

项目构造图

web.xml的配置

spring的配置

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns:aop="http://www.springframework.org/schema/aop"
   xmlns:context="http://www.springframework.org/schema/context"
   xmlns:mvc="http://www.springframework.org/schema/mvc"
   xmlns:tx="http://www.springframework.org/schema/tx"
   xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
       http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
       http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
       http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd">

   
   <bean id="personAction" class="com.lq.action.PersonAction" scope="prototype">
       <property name="personService" ref="personService"/>
       <property name="page" ref="page"/>
   </bean>

   
   <bean id="personService" class="com.lq.service.PersonService">
       <property name="personDAO" ref="personDAO"/>
   </bean>

   
   <bean id="personDAO" class="com.lq.dao.vo.PersonDAO">
       <property name="sessionFactory" ref="sessionFactory"/>
   </bean>

   
   <bean id="page" class="util.PageBean">
   </bean>


   
   <context:property-placeholder location="classpath:db.properties"/>

   <bean id="ds" class="org.apache.commons.dbcp.BasicDataSource"
       destroy-method="close">
       <property name="driverClassName" value="${jdbc.driver}" />
       <property name="url" value="${jdbc.url}" />
       <property name="username" value="${jdbc.name}" />
       <property name="password" value="${jdbc.pass}" />
   </bean>

   <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
       <property name="dataSource" ref="ds"/>
       <property name="hibernateProperties">
           <props>
               <prop key="hibernate.dialect">
                   org.hibernate.dialect.MySQLDialect
               </prop>
               <prop key="hibernate.hbm2ddl.auto">update</prop>
               <prop key="hibernate.show_sql">true</prop>
               <prop key="hibernate.format_sql">true</prop>
               <prop key="hibernate.format_sql">true</prop>

               <prop key="hibernate.connection.pool_size">10</prop>
               
               <prop key="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>

           </props>
       </property>

       <property name="mappingResources">
           <list>
               <value>com/lq/dao/vo/Person.hbm.xml</value>
           </list>
       </property>
   </bean>
   <bean id="tm"
       class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
       <property name="dataSource" ref="ds" />
   </bean>

   <tx:annotation-driven transaction-manager="tm" />

</beans>

Struts的配置

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
   "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
   "http://struts.apache.org/dtds/struts-2.3.dtd">

<struts>
   <constant name="struts.devMode" value="true"/>

   
    <package name="default" namespace="/"   extends="struts-default">

    <action name="addPerson" class="personAction" method="add">
       <result name="list" type="chain">listPerson</result>
       <result name="faile">error.jsp</result>
    </action>

    <action name="listPerson" class="personAction" method="list">
       <result name="list">list.jsp</result>
       <result name="faile">error.jsp</result>
    </action>

     <action name="delPerson" class="personAction" method="del">
       <result name="list" type="chain">listPerson</result>
       <result name="faile">error.jsp</result>
    </action>

     <action name="toUpdatePerson" class="personAction" method="toUpdate">
       <result name="update">update.jsp</result>
       <result name="faile">error.jsp</result>
    </action>

     <action name="updatePerson" class="personAction" method="update">
       <result name="list" type="chain">listPerson</result>
       <result name="faile">error.jsp</result>
    </action>

    </package>
</struts>

vo类（模式层）

package com.lq.dao.vo;

public class Person {
   private int id;
   private String account;
   private String name;
   public int getId() {
       return id;
   }
   public void setId(int id) {
       this.id = id;
   }
   public String getAccount() {
       return account;
   }
   public void setAccount(String account) {
       this.account = account;
   }
   public String getName() {
       return name;
   }
   public void setName(String name) {
       this.name = name;
   }
}

dao类

package com.lq.dao.vo;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;

import util.PageBean;

public class PersonDAO{
   private SessionFactory sessionFactory;
   private Session session;

   public SessionFactory getSessionFactory() {
       return sessionFactory;
   }
   public void setSessionFactory(SessionFactory sessionFactory) {
       this.sessionFactory = sessionFactory;
   }
   public Session getSession() {
       return session!=null?session:sessionFactory.getCurrentSession();
   }

   public void add(Person p){
       getSession().save(p);
   }

   public Person selectById(Person p)
   {
       return (Person) getSession().get(Person.class,p.getId());
   }

   @SuppressWarnings("unchecked")
   public List<Person> selectAll()
   {
       String hql = "from Person";
       Query q = getSession().createQuery(hql);
       List<Person> plist=q.list();
       return plist;
   }

   public void del(Person p){
       getSession().delete(p);
   }

   public void update(Person p){
       getSession().update(p);
   }

   public long count(){
       String hql = "select count(*) from Person";
       Query q = getSession().createQuery(hql);
       return ((Long)q.uniqueResult()).longValue();
   }

   @SuppressWarnings("unchecked")
   public List<Person> selectForPage(PageBean <Person> page)
   {
       String hql = "from Person order by id";
       Query q = getSession().createQuery(hql);
       q.setFirstResult((page.getPageNo()-1)*page.getPageSize());//设置起始行
       q.setMaxResults(page.getPageSize()); // 每页条数

       List<Person> plist=q.list();
       return plist;
   }
}

vo的映射文件

<?xml version="1.0"?>
<!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.lq.dao.vo.Person" table="person">
        <id name="id" type="int">
            <column name="id" />
            <generator class="native" />
        </id>
        <property name="account" type="string" length="30">
           <column name="account" />
        </property>
         <property name="name" type="string" length="30">
           <column name="name" />
        </property>
    </class>
</hibernate-mapping>

服务层

package com.lq.service;

import java.util.List;

import org.springframework.transaction.annotation.Transactional;

import util.PageBean;

import com.lq.dao.vo.Person;
import com.lq.dao.vo.PersonDAO;

public class PersonService {
   private PersonDAO personDAO;
   public PersonDAO getPersonDAO() {
       return personDAO;
   }
   public void setPersonDAO(PersonDAO personDAO) {
       this.personDAO = personDAO;
   }

   @Transactional
   public void add(Person p){
       personDAO.add(p);
   }

   @Transactional
   public Person selectById(Person p)
   {
       return personDAO.selectById(p);
   }

   @Transactional
   public List<Person> selectAll()
   {
       return personDAO.selectAll();
   }

   @Transactional
   public void del(Person p){
       personDAO.del(p);
   }

   @Transactional
   public void update(Person p){
       personDAO.update(p);
   }

   @Transactional
   public long count(){
       return personDAO.count();
   }

   @Transactional
   public List<Person> selectForPage(PageBean <Person> page)
   {
       return personDAO.selectForPage(page);
   }
}

控制层

package com.lq.action;

import util.PageBean;

import com.lq.dao.vo.Person;
import com.lq.service.PersonService;
import com.opensymphony.xwork2.ActionSupport;

@SuppressWarnings("serial")
public class PersonAction extends ActionSupport{//值栈 request
   private Person p;
   private PageBean<Person> page;
   private PersonService personService;

   public Person getP() {
       return p;
   }
   public void setP(Person p) {
       this.p = p;
   }
   public PersonService getPersonService() {
       return personService;
   }
   public void setPersonService(PersonService personService) {
       this.personService = personService;
   }

   public PageBean<Person> getPage() {
       return page;
   }
   public void setPage(PageBean<Person> page) {
       this.page = page;
   }

   public String add() {
       personService.add(p);
       return "list";
   }

   public String list() {
       //page.setList(personService.selectAll());查询全部结果
       long count = personService.count();
       double n = count*1.0/page.getPageSize();
       int total = (int) Math.ceil(n);

       page.setList(personService.selectForPage(page));
       page.setTotal(total);
       page.setUrl("listPerson");

       return "list";
   }

   public String del() {
       personService.del(p);
       return "list";
   }

   public String toUpdate() {
       p=personService.selectById(p);
       return "update";
   }

   public String update() {
       personService.update(p);
       return "list";
   }
}

列表页面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<style type="text/css">
   .content{
           width:800px;
           height: auto;
           margin: 0 auto;
           border: solid #0198E7 2px;
           font-size: 18px;
   }
   th,td{
       width:200px;text-align: center; color: #666; BACKGROUND-COLOR: #F4FAFF; font-weight: "bold";
   }
   a{color:#666;}
   .page2{
   color:#fff;
   margin-right: 30px;
   border-radius: 5px;
   font-size:16px;
   padding-left:5px;
   padding-right:5px;
   background: #8E83C6;
   line-height: 36px;
   font-weight: bold;
   }
   .page a{
   color:#fff;
   margin-right: 30px;
   border-radius: 5px;
   font-size:16px;
   padding-left:5px;
   padding-right:5px;
   background: #8E83C6;
   line-height: 36px;
   font-weight: bold;
   }
</style>
</head>
<body>
<div class="content">
   <table>
       <tr>
           <td><a href="add.jsp">添加新的信息</a></td>
           <td></td>
           <td></td>
           <td></td>
       </tr>
       <tr>
           <th>编号</th>
           <th>账号</th>
           <th>姓名</th>
           <th>操作</th>
       </tr>
       <c:forEach var="p" items="${page.list}">
           <tr>
               <td>${p.id}</td>
               <td>${p.account}</td>
               <td>${p.name}</td>
               <td>
                   <a href="delPerson?p.id=${p.id}">删除</a>
                   <a href="toUpdatePerson?p.id=${p.id}">修改</a>
               </td>
           </tr>
       </c:forEach>
       <tr>
           <td>
               <c:if test="${page.pageNo!=1}">
                   <span class="page"><a href="${page.url}?&page.pageNo=1">首页</a></span>
                       <span class="page"><a href="${page.url}?&page.pageNo=${page.pageNo-1}">上一页</a></span>
               </c:if>
           </td>
           <td>
               <span class="page2">${page.pageNo}/${page.total}</span>
           </td>
           <td>
               <c:if test="${page.pageNo<page.total}">
                       <span class="page"><a href="${page.url}?&page.pageNo=${page.pageNo+1}">下一页</a></span>
                       <span class="page"><a href="${page.url}?&page.pageNo=${page.total}">尾页</a></span>
               </c:if>
           </td>
           <td>
           </td>
       </tr>
   </table>
</div>
</body>
</html>