SSH（Spring+Struts+Hibernate）实现的简单CRUD案例

一、啥是SSH（Spring+Struts+Hibernate）

在这里就不多解释，直接百度了一下SSH的解释，此篇主要结合SSH来完成一个简单的CRUD项目。

百度一下：SSH在J2EE项目中表示了3种框架，即 Spring + Struts +Hibernate。 Struts对Model，View和Controller都提供了对应的组件。Spring是一个轻量级的控制反转(IoC)和面向切面(AOP)的容器框架，它由Rod Johnson创建。它是为了解决企业应用开发的复杂性而创建的。Spring使用基本的JavaBean来完成以前只可能由EJB完成的事情。 Hibernate是一个开放源代码的对象关系映射框架，它对JDBC进行了非常轻量级的对象封装，可以应用在任何使用JDBC的场合，可以在Servlet/JSP的Web应用中使用，也可以在应用EJB的J2EE架构中取代CMP，完成数据持久化的重任。

二、开始我们的项目

项目结构

2.1、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>com.hsl</groupId>
    <artifactId>springStrutsHibernate02</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>

    <dependencies>
        <!--spring相关依赖-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>5.0.2.RELEASE</version>
        </dependency>
        <!--struts2相关依赖-->
        <dependency>
            <groupId>org.apache.struts</groupId>
            <artifactId>struts2-core</artifactId>
            <version>2.5.14.1</version>
        </dependency>
        <dependency>
            <groupId>org.apache.struts</groupId>
            <artifactId>struts2-spring-plugin</artifactId>
            <version>2.5.14.1</version>
        </dependency>
        <!--hibernate相关依赖-->
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>5.2.12.Final</version>
        </dependency>
        <!--mysql依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.8-dmr</version>
        </dependency>
        <!--实现DataSource的接口-->
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.2</version>
        </dependency>
        <!--servlet依赖-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <artifactId>maven-war-plugin</artifactId>
                <version>2.2</version>
                <configuration>
                    <warSourceDirectory>web</warSourceDirectory>
                </configuration>
            </plugin>
        </plugins>
    </build>


</project>

2.2、web.xml

如果spring的配置文件名为applicationContext.xml则可以省略web.xml文件中的<context-param>

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
         version="3.1">
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:spring.xml</param-value>
    </context-param>
    <filter>
        <filter-name>struts2</filter-name>
        <filter-class>org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>struts2</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
</web-app>

2.3、Teacher.java

package entity;

public class Teacher {
    private int id;
    private String name;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

}

2.4、TeacherDao.java

package dao;

import entity.Teacher;

import java.util.List;

public interface TeacherDao {
    //添加
    void addTeacher(Teacher teacher);
    //查询全部
    List<Teacher> queryAll();
    //根据编号删除
    void delete(int id);
    //根据编号查询
    Teacher queryById(int id);
    //修改
    void update(Teacher teacher);
}

 2.5、TeacherDaoImpl.java

package dao;

import entity.Teacher;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

import java.util.List;

public class TeacherDaoImpl implements TeacherDao {
    private SessionFactory sessionFactory;

    public SessionFactory getSessionFactory() {
        return sessionFactory;
    }

    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }

    //增加数据
    public void addTeacher(Teacher teacher) {
        Session session = sessionFactory.openSession();
        Transaction transaction = session.beginTransaction();
        session.save(teacher);
        transaction.commit();
        session.close();
    }

    //查询全部数据
    public List<Teacher> queryAll() {
        Session session = sessionFactory.openSession();
        List<Teacher> teachers = session.createQuery("from Teacher ").list();
        session.close();
        return  teachers;
    }

    //根据编号删除
    public void delete(int id) {
        Session session = sessionFactory.openSession();
        Transaction transaction = session.beginTransaction();
        session.delete(session.get(Teacher.class,id));
        transaction.commit();
        session.close();
    }

    //根据编号查询
    public Teacher queryById(int id) {
        Session session = sessionFactory.openSession();
        Teacher teacher = session.get(Teacher.class,id);
        session.close();
        return teacher;
    }

    //修改
    public void update(Teacher teacher) {
        Session session = sessionFactory.openSession();
        Transaction transaction = session.beginTransaction();
        session.update(teacher);
        transaction.commit();
        session.close();
    }
}

2.6、TeacherService.java

package service;

import dao.TeacherDao;
import entity.Teacher;

import java.util.List;

public class TeacherService {
    private TeacherDao teacherDao;

    public TeacherDao getTeacherDao() {
        return teacherDao;
    }

    public void setTeacherDao(TeacherDao teacherDao) {
        this.teacherDao = teacherDao;
    }

    public void addTeacher(Teacher teacher){
        teacherDao.addTeacher(teacher);
    }

    public List<Teacher> queryAll(){
        return teacherDao.queryAll();
    }

    public void delete(int id){
        teacherDao.delete(id);
    }

    public Teacher queryById(int id){
        return teacherDao.queryById(id);
    }

    public void update(Teacher teacher){
        teacherDao.update(teacher);
    }

}

2.7、TeacherController.java

package controller;

import entity.Teacher;
import org.apache.struts2.ServletActionContext;
import service.TeacherService;

import javax.servlet.http.HttpServletRequest;
import java.util.List;

public class TeacherController {
    private TeacherService teacherService;

    public void setTeacherService(TeacherService teacherService) {
        this.teacherService = teacherService;
    }

    private String name;

    private  int id;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    private Teacher teacher;

    public void setTeacher(Teacher teacher) {
        this.teacher = teacher;
    }

    public String add(){
        teacher.setName(name);
        teacherService.addTeacher(teacher);
        return "success";
    }

    public String queryAll(){
        List<Teacher> teachers = teacherService.queryAll();
        HttpServletRequest httpServletRequest = ServletActionContext.getRequest();
        httpServletRequest.setAttribute("teachers",teachers);
        return "success";
    }

    public String delete(){
        teacherService.delete(id);
        return "success";
    }

    public String queryById(){
        Teacher teacher = teacherService.queryById(id);
        HttpServletRequest httpServletRequest = ServletActionContext.getRequest();
        httpServletRequest.setAttribute("teacher",teacher);
        return "success";
    }

    public String update(){
        teacher.setId(id);
        teacher.setName(name);
        teacherService.update(teacher);
        return "success";
    }

}

 2.8、spring.xml

其中<props>中的hibernate.dialect得注意放置的位置，理应上是需要放第一个<prop>中，否则可能会出现找不到sessionFactory的问题。

<?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:p="http://www.springframework.org/schema/p"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

    <!--<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"-->也可以是这个
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
          p:driverClass="com.mysql.jdbc.Driver"
          p:jdbcUrl="jdbc:mysql://localhost:3306/student?serverTimezone=UTC"
          p:user="root"
          p:password="123456"
    />

    <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>　　//注意位置！！多次入坑
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.format_sql">true</prop>
            </props>
        </property>
        <property name="mappingLocations">
            <list>
                <value>classpath:Teacher.hbm.xml</value>
            </list>
        </property>
    </bean>

    <bean id="teacherDao" class="dao.TeacherDaoImpl">
        <property name="sessionFactory" ref="sessionFactory"/>
    </bean>
    <bean id="teacherService" class="service.TeacherService">
        <property name="teacherDao" ref="teacherDao"/>
    </bean>
    <bean id="teacher" class="entity.Teacher"/>
    <bean id="teacherController" class="controller.TeacherController" scope="prototype">
        <property name="teacher" ref="teacher"/>
        <property name="teacherService" ref="teacherService"/>
    </bean>

</beans>

2.9、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="ssh" extends="struts-default">
        <action name="add" class="teacherController" method="add">
            <result name="success" type="redirectAction">queryAll</result>
        </action>
        <action name="queryAll" class="teacherController" method="queryAll">
            <result name="success" type="dispatcher">index.jsp</result>
        </action>
        <action name="delete" class="teacherController" method="delete">
            <result name="success" type="redirectAction">queryAll</result>
        </action>
        <action name="queryById" class="teacherController" method="queryById">
            <result name="success" type="dispatcher">update.jsp</result>
        </action>
        <action name="update" class="teacherController" method="update">
            <result name="success" type="redirectAction">queryAll</result>
        </action>
    </package>
</struts>

2.10、index.jsp

<%@ page import="entity.Teacher" %>
<%@ page import="java.util.List" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>老师信息</title>
  </head>
  <body>
  <table border="1">
    <tr>
      <th>编号</th>
      <th>姓名</th>
      <th>操作</th>
    </tr>
    <%
      for(Teacher teacher:(List<Teacher>) request.getAttribute("teachers")){
    %>
    <tr>
      <td><%= teacher.getId()%></td>
      <td><%= teacher.getName()%></td>
      <td>
        <a href="delete.action?id=<%= teacher.getId()%>">删除</a> |
        <a href="queryById.action?id=<%= teacher.getId()%>">修改</a>
      </td>
    </tr>
    <%
      }
    %>
  </table>
  <a href="add.jsp">添加</a>
  </body>
</html>

2.11、add.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>添加</title>
  </head>
  <body>
  <h1>添加</h1>
  <form action="add.action" method="post">
    <p>
      <label>姓名：</label>
      <input type="text" name="name" id="name"/>
    </p>
    <p>
      <input type="submit" value="添加">
    </p>
  </form>
  </body>
</html>

2.12、update.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
  <head>
    <title>修改</title>
  </head>
  <body>
  <h1>修改</h1>
  <form action="update.action" method="post">
    <%
      Teacher teacher = (Teacher) request.getAttribute("teacher");
    %>
    <p>
      <label>姓名：</label>
      <input type="text" name="name" value="<%= teacher.getName()%>" id="name"/>
    </p>
    <p>
      <input type="hidden" name="id" value="<%= teacher.getId()%>" id="id"/>
      <input type="submit" value="修改">
    </p>
  </form>
  </body>
</html>

运行结果：

刚刚入门sprig，如果错误请评论指正！！

完...