Web——SSH框架整合

墨蓝 2024-03-17 09:26 50阅读 0赞

> 工程目录结构如下：

![在这里插入图片描述][8fc8d61223704868bad24fae84e73828.png_pic_center]

### 1、导入jar包 ###

<dependencies>
        
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>5.2.10.Final</version>
        </dependency>
        
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.12</version>
        </dependency>
        
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>1.6.1</version>
        </dependency>
        
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>4.3.11.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.3.11.RELEASE</version>
        </dependency>
        
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aspects</artifactId>
            <version>4.3.11.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>4.3.11.RELEASE</version>
        </dependency>
        
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
        </dependency>
        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
    </dependencies>
    <build>
        <finalName>ssh-test01</finalName>
        
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.xml</include>
                    <include>**/*.properties</include>
                </includes>
            </resource>
        </resources>
    </build>

### Dao和实体类 ###

> Dao和实体类是hibernate相关的部分  
> 实体类Dept

package com.ssh.pojo;
    public class Dept {
        
        private Integer id;
        private String name;
        //getter/setter方法略
    }

> 映射文件Dept.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.ssh.pojo.Dept" table="DEPT">
            <id name="id" type="java.lang.Integer">
                <column name="ID" precision="10" scale="0"/>
                <generator class="identity"/>
            </id>
            <property name="name" type="java.lang.String">
                <column name="NAME" length="20"/>
            </property>
        </class>
    </hibernate-mapping>

> 实体类Employee

package com.ssh.pojo;
    
    public class Employee {
        
        private Integer id;
        private String name;
        private Dept dept;
        //getter/setter方法略
    }

> 映射文件Employee.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.ssh.pojo.Employee" table="EMPLOYEE">
            <id name="id" type="java.lang.Integer">
                <column name="ID" precision="10" scale="0"/>
                <generator class="identity"/>
            </id>
            <property name="name" type="java.lang.String">
                <column name="NAME" length="20"/>
            </property>
            
            <many-to-one name="dept" class="com.ssh.pojo.Dept">
                <column name="DEPT_ID"/>
            </many-to-one>
        </class>
    </hibernate-mapping>

> EmployeeDAO

package com.ssh.dao;
    
    import com.ssh.pojo.Employee;
    import org.hibernate.criterion.DetachedCriteria;
    import org.springframework.orm.hibernate5.support.HibernateDaoSupport;
    
    import java.util.List;
    
    //HibernateDaoSupport是Spring提供的类，对Hibernate的Session进行了封装
    public class EmployeeDAO extends HibernateDaoSupport {
        
        //添加
        public void addEmployee(Employee emp) {
        
            super.getHibernateTemplate().save(emp);
        }
    
        //条件查询
        public List<Employee> getEmpByCriteria(DetachedCriteria criteria) {
        
            return (List<Employee>)super.getHibernateTemplate().findByCriteria(criteria);
        }
    }

> DeptDAO

package com.ssh.dao;
    
    import com.ssh.pojo.Dept;
    import org.springframework.orm.hibernate5.support.HibernateDaoSupport;
    
    import java.util.List;
    
    public class DeptDAO extends HibernateDaoSupport {
        
    
        public List<Dept> getDeptList() {
        
            return (List<Dept>) super.getHibernateTemplate().find("from Dept", null);
        }
    }

### 3、 Hibernate和Spring的整合 ###

> Hibernate和Spring整合的时候，Spring主要负责管理Hibernate的Session和事务  
> 在spring-config.xml中进行配置：

<?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:tx="http://www.springframework.org/schema/tx"
           xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-4.2.xsd
           http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd">
    
        
        <context:property-placeholder location="classpath:jdbc.properties" ignore-unresolvable="true"/>
        <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="${jdbc.driver}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
        </bean>
    
        
        <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.MySQLDialect</prop>
                    <prop key="hibernate.show_sql">true</prop>
                    <prop key="hibernate.format_sql">true</prop>
                </props>
            </property>
            
            
            
            
            
            <property name="mappingResources">
                <list>
                    <value>com/ssh/pojo/Employee.hbm.xml</value>
                    <value>com/ssh/pojo/Dept.hbm.xml</value>
                </list>
            </property>
        </bean>
        
        <bean id="transactionManager"
              class="org.springframework.orm.hibernate5.HibernateTransactionManager">
            <property name="sessionFactory" ref="sessionFactory"/>
        </bean>
        
        <tx:advice id="txAdvice" transaction-manager="transactionManager">
            <tx:attributes>
                
                <tx:method name="add*" rollback-for="Exception"/>
                <tx:method name="delete*" rollback-for="Exception"/>
                <tx:method name="update*" rollback-for="Exception"/>
                <tx:method name="get*" propagation="SUPPORTS" read-only="true"/>
                <tx:method name="do*" rollback-for="Exception"/>
            </tx:attributes>
        </tx:advice>
        
        <aop:config>
            <aop:pointcut id="serviceMethod"
                          expression="execution(* com.ssh.service..*(..))"/>
            <aop:advisor pointcut-ref="serviceMethod" advice-ref="txAdvice"/>
        </aop:config>
    
        <bean id="employeeDAO" class="com.ssh.dao.EmployeeDAO">
            <property name="sessionFactory" ref="sessionFactory"/>
        </bean>
        <bean id="deptDAO" class="com.ssh.dao.DeptDAO">
            <property name="sessionFactory" ref="sessionFactory"/>
        </bean>
    </beans>

> 数据库配置文件jdbc.properties：

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/数据库?characterEncoding=utf-8
    jdbc.username=用户名
    jdbc.password=密码
    日志文件log4j.properties
    log4j.rootLogger=DEBUG, stdout, 
    
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n

### 4、Service ###

> EmployeeService

package com.ssh.service;
    
    import com.ssh.dao.EmployeeDAO;
    import com.ssh.pojo.Employee;
    import org.hibernate.criterion.DetachedCriteria;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    @Service
    public class EmployeeService {
        
        @Autowired
        private EmployeeDAO employeeDAO;
    
        public void addEmployee(Employee emp) {
        
            employeeDAO.addEmployee(emp);
        }
    
        public List<Employee> getEmpByCriteria(DetachedCriteria criteria) {
        
            return employeeDAO.getEmpByCriteria(criteria);
        }
    }

> DeptService

package com.ssh.service;
    
    import com.ssh.dao.DeptDAO;
    import com.ssh.pojo.Dept;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    @Service
    public class DeptService {
        
        @Autowired
        private DeptDAO deptDAO;
    
        public List<Dept> getDeptList(){
        
            return deptDAO.getDeptList();
        }
    }

> 在spring-config.xml中配置对Service的扫描：

<context:component-scan base-package="com.ssh.service">
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Service"/>
    </context:component-scan>

### 5、Controller ###

> Controller就是SpringMVC的部分了：

package com.ssh.controller;
    
    import com.ssh.pojo.Dept;
    import com.ssh.pojo.Employee;
    import com.ssh.service.DeptService;
    import com.ssh.service.EmployeeService;
    import org.hibernate.criterion.DetachedCriteria;
    import org.hibernate.criterion.Restrictions;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.servlet.ModelAndView;
    
    import java.util.List;
    
    @Controller
    @RequestMapping("/emp")
    public class EmpController {
        
        @Autowired
        private EmployeeService employeeService;
        @Autowired
        private DeptService deptService;
    
        @RequestMapping("/list.html")
        public String list(Employee employee, Model model) {
        
            //封装查询条件
            DetachedCriteria criteria=DetachedCriteria.forClass(Employee.class);
            if(employee.getName()!=null&&employee.getName().trim().length()>0){
        
                criteria.add(Restrictions.like("name","%"+employee.getName()+"%"));
            }
            model.addAttribute("employeeList", employeeService.getEmpByCriteria(criteria));
            return "/emp_list.jsp";
        }
    
        //去添加员工的页面
        @RequestMapping("/go_add.html")
        public ModelAndView goAdd() {
        
            List<Dept> deptList = deptService.getDeptList();
            return new ModelAndView("/emp_add.jsp", "deptList", deptList);
        }
    
        @RequestMapping("/add.html")
        public String add(Employee employee) {
        
            employeeService.addEmployee(employee);
            //添加成功后跳转到列表页
            return "redirect:/emp/list.html";
        }
    
    }

> SpringMVC-servlet.xml

> web.xml

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns="http://java.sun.com/xml/ns/javaee"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
              http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
             version="3.0">
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-config.xml</param-value>
        </context-param>
        
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
    
    <filter>
        <filter-name>CharacterEncodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
        <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
        
        <filter>
            <filter-name>openSessionInView</filter-name>
            <filter-class>org.springframework.orm.hibernate5.support.OpenSessionInViewFilter</filter-class>
        </filter>
        <filter-mapping>
            <filter-name>openSessionInView</filter-name>
            <url-pattern>*.html</url-pattern>
        </filter-mapping>
        
        <servlet>
            <servlet-name>springMVC</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        </servlet>
        <servlet-mapping>
            <servlet-name>springMVC</servlet-name>
            <url-pattern>*.html</url-pattern>
        </servlet-mapping>
    </web-app>

### 6、页面 ###

> emp\_add.jsp

> 运行结果  
> ![在这里插入图片描述][8976d8dbd9864a07a6a025be2b4f2eb8.png_pic_center]

> emp\_list.jsp

> 运行结果  
> ![在这里插入图片描述][419f966b15c947128c6e3014bcfd070c.png_pic_center]

[8fc8d61223704868bad24fae84e73828.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/17/645dba0e1d5a46a68c0c475615f8b528.png
[8976d8dbd9864a07a6a025be2b4f2eb8.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/17/4f59961234e9443da21d8d573d053569.png
[419f966b15c947128c6e3014bcfd070c.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/17/ccc48240fd6144eb997595ac2cb77953.png