Spring5 整合篇

刺骨的言语ヽ痛彻心扉 2023-01-07 03:54 99阅读 0赞

### 目录 ###

*  第一章 SSJ整合
 *   *  1.1、整合介绍
     *  1.2、创建工程
     *  1.3、导入依赖
     *  1.4、配置项目
     *  1.5、创建实体
     *  1.6、增删改查
     *  1.7、异常处理
 *  第二章 SSH整合
 *   *  2.1、整合介绍
     *  2.2、创建工程
     *  2.3、导入依赖
     *  2.4、配置项目
     *  2.5、创建实体
     *  2.6、增删改查
     *  2.7、异常处理
 *  第三章 SSM整合
 *   *  3.1、整合介绍
     *  3.2、创建工程
     *  3.3、导入依赖
     *  3.4、配置项目
     *  3.5、创建实体
     *  3.6、增删改查
     *  3.7、异常处理
 *  第四章 SSMP整合
 *   *  4.1、整合介绍
     *  4.2、创建工程
     *  4.3、导入依赖
     *  4.4、配置项目
     *  4.5、创建实体
     *  4.6、增删改查
     *  4.7、异常处理

--------------------

**配套资料，免费下载**  
链接：https://pan.baidu.com/s/14AOFoYKdu-QDAFf\_3GvwqQ  
提取码：7hqi  
复制这段内容后打开百度网盘手机App，操作更方便哦

> 注意：以下所有整合均共用此数据表中的数据：

DROP DATABASE IF EXISTS `test`;
    
    CREATE DATABASE `test`;
    
    USE `test`;
    
    DROP TABLE IF EXISTS `t_user`;
    
    CREATE TABLE `t_user` (
      `uid` INT(11) NOT NULL AUTO_INCREMENT,
      `uname` VARCHAR(20) NOT NULL,
      `ugender` VARCHAR(20) NOT NULL,
      `uage` INT(11) NOT NULL,
      PRIMARY KEY (`uid`)
    ) ENGINE=INNODB DEFAULT CHARSET=utf8;
    
    INSERT INTO `test`.`t_user` (`uname`, `ugender`, `uage`) VALUES ('张三', '男', '18'); 
    INSERT INTO `test`.`t_user` (`uname`, `ugender`, `uage`) VALUES ('李四', '女', '19'); 
    INSERT INTO `test`.`t_user` (`uname`, `ugender`, `uage`) VALUES ('王五', '男', '20');

# 第一章 SSJ整合 #

## 1.1、整合介绍 ##

**技术要点：** Spring MVC 5.3.2 + Spring 5.3.2 + JdbcTemplate 5.3.2

**其他方面：** 数据库连接池、注解事务管理、常用增删改查、全局异常处理、解决跨域问题、统一使用VO.Result对象封装数据

**项目名称：** ssj-demo，完整代码，请参考配套资料

## 1.2、创建工程 ##

![image-20201228202836047][]

![image-20201229114847040][]

![image-20201228203032366][]

![18][]

## 1.3、导入依赖 ##

修改 **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.caochenlei</groupId>
        <artifactId>ssj-demo</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
            
            <spring.version>5.3.2</spring.version>
            <jackson.version>2.12.0</jackson.version>
            <log4j.version>2.14.0</log4j.version>
        </properties>
    
        <dependencies>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aop</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aspects</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-tx</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-core</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-annotations</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>3.1.0</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>javax.servlet.jsp-api</artifactId>
                <version>2.3.3</version>
                <scope>provided</scope>
            </dependency>
            
            <dependency>
                <groupId>taglibs</groupId>
                <artifactId>standard</artifactId>
                <version>1.1.2</version>
            </dependency>
            <dependency>
                <groupId>jstl</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
            
            <dependency>
                <groupId>commons-fileupload</groupId>
                <artifactId>commons-fileupload</artifactId>
                <version>1.4</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.49</version>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.2.4</version>
            </dependency>
            
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-core</artifactId>
                <version>${log4j.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-api</artifactId>
                <version>${log4j.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-slf4j-impl</artifactId>
                <version>${log4j.version}</version>
            </dependency>
        </dependencies>
    
        <build>
            
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                        <include>**/*.conf</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                        <include>**/*.conf</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>
    </project>

## 1.4、配置项目 ##

src\\main\\webapp\\WEB-INF\\error.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html>
    <head>
        <title>error page</title>
    </head>
    <body>
    <p><strong>错误描述：</strong>${msg}</p>
    <p><strong>错误提示：</strong>${ex.message}</p>
    </body>
    </html>

src\\main\\resources\\log4j2.xml

<?xml version="1.0" encoding="UTF-8"?>
    
    <Configuration status="info">
        <Appenders>
            <Console name="Console" target="SYSTEM_OUT">
                <PatternLayout pattern="%d{yyyy-MM-dd HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n"/>
            </Console>
        </Appenders>
        <Loggers>
            <Root level="info">
                <AppenderRef ref="Console"/>
            </Root>
        </Loggers>
    </Configuration>

修改 web.xml

<?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_4_0.xsd" version="4.0">
        
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
        <context-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-ioc.xml</param-value>
        </context-param>
    
        
        <servlet>
            <servlet-name>DispatcherServlet</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            <init-param>
                <param-name>contextConfigLocation</param-name>
                <param-value>classpath:spring-mvc.xml</param-value>
            </init-param>
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>DispatcherServlet</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>
    
        
        <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>forceRequestEncoding</param-name>
                <param-value>true</param-value>
            </init-param>
            
            <init-param>
                <param-name>forceResponseEncoding</param-name>
                <param-value>true</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>characterEncodingFilter</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    </web-app>

src\\main\\resources\\spring-mvc.xml

src\\main\\resources\\spring-ioc.xml

## 1.5、创建实体 ##

com.caochenlei.vo.Result

public class Result implements Serializable { 
        private static final long serialVersionUID = 6785657555819824255L;
    
        private Boolean success;
        private Object data;
        private String message;
    
        public Result() { 
            super();
        }
    
        public Result(Boolean success, Object data, String message) { 
            this.success = success;
            this.data = data;
            this.message = message;
        }
    
        public Boolean getSuccess() { 
            return success;
        }
    
        public void setSuccess(Boolean success) { 
            this.success = success;
        }
    
        public Object getData() { 
            return data;
        }
    
        public void setData(Object data) { 
            this.data = data;
        }
    
        public String getMessage() { 
            return message;
        }
    
        public void setMessage(String message) { 
            this.message = message;
        }
    }

com.caochenlei.entity.User

public class User implements Serializable { 
        private static final long serialVersionUID = -445352327778902151L;
    
        private Integer uid;
        private String uname;
        private String ugender;
        private Integer uage;
    
        public User() { 
        }
    
        public User(Integer uid, String uname, String ugender, Integer uage) { 
            this.uid = uid;
            this.uname = uname;
            this.ugender = ugender;
            this.uage = uage;
        }
    
        public Integer getUid() { 
            return uid;
        }
    
        public void setUid(Integer uid) { 
            this.uid = uid;
        }
    
        public String getUname() { 
            return uname;
        }
    
        public void setUname(String uname) { 
            this.uname = uname;
        }
    
        public String getUgender() { 
            return ugender;
        }
    
        public void setUgender(String ugender) { 
            this.ugender = ugender;
        }
    
        public Integer getUage() { 
            return uage;
        }
    
        public void setUage(Integer uage) { 
            this.uage = uage;
        }
    }

## 1.6、增删改查 ##

com.caochenlei.dao.UserDao

public interface UserDao { 
        //查找一个用户
        public User findOne(Integer id);
    
        //查找所有用户
        public List<User> findAll();
    
        //添加一个用户
        public Integer save(User user);
    
        //删除一个用户
        public Integer delete(Integer id);
    
        //修改一个用户
        public Integer update(User user);
    }

com.caochenlei.dao.impl.UserDaoImpl

@Repository
    public class UserDaoImpl implements UserDao { 
        @Autowired
        private JdbcTemplate jdbcTemplate;
    
        @Override
        public User findOne(Integer id) { 
            String sql = "select * from t_user where uid = ?";
            return jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), id);
        }
    
        @Override
        public List<User> findAll() { 
            String sql = "select * from t_user";
            return jdbcTemplate.query(sql, new BeanPropertyRowMapper<User>(User.class));
        }
    
        @Override
        public Integer save(User user) { 
            String sql = "insert into t_user values(?,?,?,?)";
            return jdbcTemplate.update(sql, null, user.getUname(), user.getUgender(), user.getUage());
        }
    
        @Override
        public Integer delete(Integer id) { 
            String sql = "delete from t_user where uid=?";
            return jdbcTemplate.update(sql, id);
        }
    
        @Override
        public Integer update(User user) { 
            String sql = "update t_user set uname=?,ugender=?,uage=? where uid=?";
            return jdbcTemplate.update(sql, user.getUname(), user.getUgender(), user.getUage(), user.getUid());
        }
    }

com.caochenlei.service.UserService

public interface UserService { 
        //查找一个用户
        public User findOne(Integer id);
    
        //查找所有用户
        public List<User> findAll();
    
        //添加一个用户
        public Integer save(User user);
    
        //删除一个用户
        public Integer delete(Integer id);
    
        //修改一个用户
        public Integer update(User user);
    }

com.caochenlei.service.impl.UserServiceImpl

@Service
    @Transactional
    public class UserServiceImpl implements UserService { 
        @Autowired
        private UserDao userDao;
    
        @Override
        public User findOne(Integer id) { 
            return userDao.findOne(id);
        }
    
        @Override
        public List<User> findAll() { 
            return userDao.findAll();
        }
    
        @Override
        public Integer save(User user) { 
            return userDao.save(user);
        }
    
        @Override
        public Integer delete(Integer id) { 
            return userDao.delete(id);
        }
    
        @Override
        public Integer update(User user) { 
            return userDao.update(user);
        }
    }

com.caochenlei.controller.UserController

@CrossOrigin
    @RestController
    @RequestMapping("/user")
    public class UserController { 
        @Autowired
        private UserService userService;
    
        //查找一个用户
        @GetMapping("/findOne/{id}")
        public Result findOne(@PathVariable Integer id) { 
            User user = userService.findOne(id);
            return new Result(true, user, "操作成功");
        }
    
        //查找所有用户
        @GetMapping("/findAll")
        public Result findAll() { 
            List<User> users = userService.findAll();
            return new Result(true, users, "操作成功");
        }
    
        //添加一个用户
        @PostMapping("/save")
        public Result save(@RequestBody User user) { 
            Integer rows = userService.save(user);
            if (rows > 0) { 
                return new Result(true, rows, "操作成功");
            } else { 
                return new Result(false, rows, "操作失败");
            }
        }
    
        //删除一个用户
        @PostMapping("/delete/{id}")
        public Result delete(@PathVariable Integer id) { 
            Integer rows = userService.delete(id);
            if (rows > 0) { 
                return new Result(true, rows, "操作成功");
            } else { 
                return new Result(false, rows, "操作失败");
            }
        }
    
        //修改一个用户
        @PostMapping("/update")
        public Result update(@RequestBody User user) { 
            Integer rows = userService.update(user);
            if (rows > 0) { 
                return new Result(true, rows, "操作成功");
            } else { 
                return new Result(false, rows, "操作失败");
            }
        }
    }

## 1.7、异常处理 ##

com.caochenlei.handler.GlobalExceptionHandler

@ControllerAdvice
    public class GlobalExceptionHandler { 
        //处理系统未知异常
        @ExceptionHandler
        public ModelAndView doOtherException(Exception exception) { 
            ModelAndView mv = new ModelAndView();
            mv.addObject("msg", "系统发生错误，请通知管理员！");
            mv.addObject("ex", exception);
            mv.setViewName("error");
            return mv;
        }
    }

# 第二章 SSH整合 #

## 2.1、整合介绍 ##

**技术要点：** Spring MVC 5.3.2 + Spring 5.3.2 + Hibernate 5.4.27.Final

**其他方面：** 数据库连接池、注解事务管理、常用增删改查、全局异常处理、解决跨域问题、统一使用VO.Result对象封装数据

**项目名称：** ssh-demo，完整代码，请参考配套资料

## 2.2、创建工程 ##

![image-20201228202836047][]

![image-20201229115126626][]

![image-20201229115143242][]

![19][]

## 2.3、导入依赖 ##

修改 **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.caochenlei</groupId>
        <artifactId>ssh-demo</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
            
            <spring.version>5.3.2</spring.version>
            <jackson.version>2.12.0</jackson.version>
            <hibernate.version>5.4.27.Final</hibernate.version>
            <log4j.version>2.14.0</log4j.version>
        </properties>
    
        <dependencies>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aop</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aspects</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-tx</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-core</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-annotations</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>3.1.0</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>javax.servlet.jsp-api</artifactId>
                <version>2.3.3</version>
                <scope>provided</scope>
            </dependency>
            
            <dependency>
                <groupId>taglibs</groupId>
                <artifactId>standard</artifactId>
                <version>1.1.2</version>
            </dependency>
            <dependency>
                <groupId>jstl</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
            
            <dependency>
                <groupId>commons-fileupload</groupId>
                <artifactId>commons-fileupload</artifactId>
                <version>1.4</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.hibernate</groupId>
                <artifactId>hibernate-core</artifactId>
                <version>${hibernate.version}</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.49</version>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.2.4</version>
            </dependency>
            
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-core</artifactId>
                <version>${log4j.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-api</artifactId>
                <version>${log4j.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-slf4j-impl</artifactId>
                <version>${log4j.version}</version>
            </dependency>
        </dependencies>
    
        <build>
            
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                        <include>**/*.conf</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                        <include>**/*.conf</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>
    </project>

## 2.4、配置项目 ##

src\\main\\webapp\\WEB-INF\\error.jsp

src\\main\\resources\\log4j2.xml

修改 web.xml

src\\main\\resources\\spring-mvc.xml

src\\main\\resources\\spring-ioc.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: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.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
        
        <context:component-scan base-package="com.caochenlei">
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
            <context:exclude-filter type="annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice"/>
        </context:component-scan>
    
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://localhost:3306/test"/>
            <property name="username" value="root"/>
            <property name="password" value="123456"/>
        </bean>
    
        
        <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
            
            <property name="hibernateProperties">
                <props>
                    <prop key="hibernate.show_sql">true</prop>
                    <prop key="hibernate.format_sql">true</prop>
                    <prop key="hibernate.hbm2ddl.auto">update</prop>
                    <prop key="hibernate.dialect">org.hibernate.dialect.MySQL55Dialect</prop>
                </props>
            </property>
            
            <property name="mappingLocations">
                <list>
                    <value>classpath:com/caochenlei/entity/*.hbm.xml</value>
                </list>
            </property>
        </bean>
    
        
        <bean id="hibernateTemplate" class="org.springframework.orm.hibernate5.HibernateTemplate">
            <property name="sessionFactory" ref="sessionFactory"/>
        </bean>
    
        
        <bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
            <property name="sessionFactory" ref="sessionFactory"/>
        </bean>
    
        
        <tx:annotation-driven transaction-manager="transactionManager"/>
    </beans>

## 2.5、创建实体 ##

com.caochenlei.vo.Result

com.caochenlei.entity.User

## 2.6、增删改查 ##

src\\main\\resources\\com\\caochenlei\\entity\\User.hbm.xml

<?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.caochenlei.entity.User" table="t_user">
            
            <id name="uid" column="uid">
                <generator class="native"/>
            </id>
            
            <property name="uname" column="uname"/>
            <property name="ugender" column="ugender"/>
            <property name="uage" column="uage"/>
        </class>
    </hibernate-mapping>

com.caochenlei.dao.UserDao

com.caochenlei.dao.impl.UserDaoImpl

@Repository
    public class UserDaoImpl implements UserDao { 
        @Autowired
        private HibernateTemplate hibernateTemplate;
    
        @Override
        public User findOne(Integer id) { 
            return hibernateTemplate.load(User.class, id);
        }
    
        @Override
        public List<User> findAll() { 
            return hibernateTemplate.loadAll(User.class);
        }
    
        @Override
        public Integer save(User user) { 
            hibernateTemplate.save(user);
            return 1;
        }
    
        @Override
        public Integer delete(Integer id) { 
            User user = hibernateTemplate.get(User.class, id);
            hibernateTemplate.delete(user);
            return 1;
        }
    
        @Override
        public Integer update(User user) { 
            hibernateTemplate.update(user);
            return 1;
        }
    }

com.caochenlei.service.UserService

com.caochenlei.service.impl.UserServiceImpl

com.caochenlei.controller.UserController

## 2.7、异常处理 ##

com.caochenlei.handler.GlobalExceptionHandler

# 第三章 SSM整合 #

## 3.1、整合介绍 ##

**技术要点：** Spring MVC 5.3.2 + Spring 5.3.2 + MyBatis 3.5.6

**其他方面：** 数据库连接池、注解事务管理、常用增删改查、全局异常处理、解决跨域问题、统一使用VO.Result对象封装数据

**项目名称：** ssm-demo，完整代码，请参考配套资料

## 3.2、创建工程 ##

![image-20201228202836047][]

![34734b9c04415af5a2c3724b42465d65.png][]

![image-20201229131725953][]

![20][]

## 3.3、导入依赖 ##

修改 **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.caochenlei</groupId>
        <artifactId>ssm-demo</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
            
            <spring.version>5.3.2</spring.version>
            <jackson.version>2.12.0</jackson.version>
            <mybatis.version>3.5.6</mybatis.version>
            <mybatis.spring.version>2.0.6</mybatis.spring.version>
            <log4j.version>2.14.0</log4j.version>
        </properties>
    
        <dependencies>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aop</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aspects</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-tx</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-core</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-annotations</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>3.1.0</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>javax.servlet.jsp-api</artifactId>
                <version>2.3.3</version>
                <scope>provided</scope>
            </dependency>
            
            <dependency>
                <groupId>taglibs</groupId>
                <artifactId>standard</artifactId>
                <version>1.1.2</version>
            </dependency>
            <dependency>
                <groupId>jstl</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
            
            <dependency>
                <groupId>commons-fileupload</groupId>
                <artifactId>commons-fileupload</artifactId>
                <version>1.4</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>${mybatis.version}</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>${mybatis.spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.49</version>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.2.4</version>
            </dependency>
            
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-core</artifactId>
                <version>${log4j.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-api</artifactId>
                <version>${log4j.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-slf4j-impl</artifactId>
                <version>${log4j.version}</version>
            </dependency>
        </dependencies>
    
        <build>
            
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                        <include>**/*.conf</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                        <include>**/*.conf</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>
    </project>

## 3.4、配置项目 ##

src\\main\\webapp\\WEB-INF\\error.jsp

src\\main\\resources\\log4j2.xml

修改 web.xml

src\\main\\resources\\spring-mvc.xml

src\\main\\resources\\spring-ioc.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: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.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
        
        <context:component-scan base-package="com.caochenlei">
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
            <context:exclude-filter type="annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice"/>
        </context:component-scan>
    
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://localhost:3306/test"/>
            <property name="username" value="root"/>
            <property name="password" value="123456"/>
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
            
            <property name="typeAliasesPackage" value="com.caochenlei.entity"/>
            
            <property name="mapperLocations" value="classpath:com/caochenlei/mapper/*.xml"/>
        </bean>
    
        
        <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.caochenlei.mapper"/>
        </bean>
    
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"/>
        </bean>
    
        
        <tx:annotation-driven transaction-manager="transactionManager"/>
    </beans>

## 3.5、创建实体 ##

com.caochenlei.vo.Result

com.caochenlei.entity.User

## 3.6、增删改查 ##

src\\main\\resources\\com\\caochenlei\\mapper\\UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.caochenlei.mapper.UserMapper">
        
        <select id="findOne" resultType="user">
            select * from t_user where uid=#{id}
        </select>
    
        
        <select id="findAll" resultType="user">
            select * from t_user
        </select>
    
        
        <insert id="save" useGeneratedKeys="true" keyProperty="uid">
            insert into t_user(uname,ugender,uage)
            values(#{uname},#{ugender},#{uage})
        </insert>
    
        
        <delete id="delete">
            delete from t_user where uid=#{id}
        </delete>
    
        
        <update id="update">
            update t_user
            set uname=#{uname},ugender=#{ugender},uage=#{uage}
            where uid=#{uid}
        </update>
    </mapper>

com.caochenlei.mapper.UserMapper

public interface UserMapper { 
        //查找一个用户
        public User findOne(Integer id);
    
        //查找所有用户
        public List<User> findAll();
    
        //添加一个用户
        public Integer save(User user);
    
        //删除一个用户
        public Integer delete(Integer id);
    
        //修改一个用户
        public Integer update(User user);
    }

com.caochenlei.service.UserService

com.caochenlei.service.impl.UserServiceImpl

@Service
    @Transactional
    public class UserServiceImpl implements UserService { 
        @Autowired(required = false)
        private UserMapper userMapper;
    
        @Override
        public User findOne(Integer id) { 
            return userMapper.findOne(id);
        }
    
        @Override
        public List<User> findAll() { 
            return userMapper.findAll();
        }
    
        @Override
        public Integer save(User user) { 
            return userMapper.save(user);
        }
    
        @Override
        public Integer delete(Integer id) { 
            return userMapper.delete(id);
        }
    
        @Override
        public Integer update(User user) { 
            return userMapper.update(user);
        }
    }

com.caochenlei.controller.UserController

## 3.7、异常处理 ##

com.caochenlei.handler.GlobalExceptionHandler

# 第四章 SSMP整合 #

## 4.1、整合介绍 ##

**技术要点：** Spring MVC 5.3.2 + Spring 5.3.2 + MyBatis-Plus 3.4.1

**其他方面：** 数据库连接池、注解事务管理、常用增删改查、全局异常处理、解决跨域问题、统一使用VO.Result对象封装数据

**项目名称：** ssmp-demo，完整代码，请参考配套资料

## 4.2、创建工程 ##

![image-20201228202836047][]

![image-20201231202719291][]

![image-20201231202738969][]

![20][20 1]

## 4.3、导入依赖 ##

修改 **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.caochenlei</groupId>
        <artifactId>ssmp-demo</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
            
            <spring.version>5.3.2</spring.version>
            <jackson.version>2.12.0</jackson.version>
            <mybatis-plus.version>3.4.1</mybatis-plus.version>
            <log4j.version>2.14.0</log4j.version>
        </properties>
    
        <dependencies>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aop</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aspects</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-tx</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>${spring.version}</version>
            </dependency>
            
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-core</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-annotations</artifactId>
                <version>${jackson.version}</version>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>3.1.0</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>javax.servlet.jsp-api</artifactId>
                <version>2.3.3</version>
                <scope>provided</scope>
            </dependency>
            
            <dependency>
                <groupId>taglibs</groupId>
                <artifactId>standard</artifactId>
                <version>1.1.2</version>
            </dependency>
            <dependency>
                <groupId>jstl</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
            
            <dependency>
                <groupId>commons-fileupload</groupId>
                <artifactId>commons-fileupload</artifactId>
                <version>1.4</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus</artifactId>
                <version>${mybatis-plus.version}</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.49</version>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.2.4</version>
            </dependency>
            
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-core</artifactId>
                <version>${log4j.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-api</artifactId>
                <version>${log4j.version}</version>
            </dependency>
            <dependency>
                <groupId>org.apache.logging.log4j</groupId>
                <artifactId>log4j-slf4j-impl</artifactId>
                <version>${log4j.version}</version>
            </dependency>
        </dependencies>
    
        <build>
            
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                        <include>**/*.conf</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                        <include>**/*.conf</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>
    </project>

## 4.4、配置项目 ##

src\\main\\webapp\\WEB-INF\\error.jsp

src\\main\\resources\\log4j2.xml

修改 web.xml

src\\main\\resources\\spring-mvc.xml

src\\main\\resources\\spring-ioc.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: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.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
        
        <context:component-scan base-package="com.caochenlei">
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
            <context:exclude-filter type="annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice"/>
        </context:component-scan>
    
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://localhost:3306/test"/>
            <property name="username" value="root"/>
            <property name="password" value="123456"/>
        </bean>
    
        
        <bean id="sqlSessionFactory" class="com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
            
            <property name="typeAliasesPackage" value="com.caochenlei.entity"/>
            
            <property name="mapperLocations" value="classpath:com/caochenlei/mapper/*.xml"/>
        </bean>
    
        
        <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.caochenlei.mapper"/>
        </bean>
    
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"/>
        </bean>
    
        
        <tx:annotation-driven transaction-manager="transactionManager"/>
    </beans>

## 4.5、创建实体 ##

com.caochenlei.vo.Result

com.caochenlei.entity.User

@TableName("t_user")
    public class User implements Serializable { 
        private static final long serialVersionUID = -445352327778902151L;
    
        @TableId(type = IdType.AUTO)
        private Integer uid;
        private String uname;
        private String ugender;
        private Integer uage;
    
        public User() { 
        }
    
        public User(Integer uid, String uname, String ugender, Integer uage) { 
            this.uid = uid;
            this.uname = uname;
            this.ugender = ugender;
            this.uage = uage;
        }
    
        public Integer getUid() { 
            return uid;
        }
    
        public void setUid(Integer uid) { 
            this.uid = uid;
        }
    
        public String getUname() { 
            return uname;
        }
    
        public void setUname(String uname) { 
            this.uname = uname;
        }
    
        public String getUgender() { 
            return ugender;
        }
    
        public void setUgender(String ugender) { 
            this.ugender = ugender;
        }
    
        public Integer getUage() { 
            return uage;
        }
    
        public void setUage(Integer uage) { 
            this.uage = uage;
        }
    }

## 4.6、增删改查 ##

src\\main\\resources\\com\\caochenlei\\mapper\\UserMapper.xml

com.caochenlei.mapper.UserMapper

public interface UserMapper extends BaseMapper<User> { 
    
    }

com.caochenlei.service.UserService

com.caochenlei.service.impl.UserServiceImpl

@Service
    @Transactional
    public class UserServiceImpl implements UserService { 
        @Autowired(required = false)
        private UserMapper userMapper;
    
        @Override
        public User findOne(Integer id) { 
            return userMapper.selectById(id);
        }
    
        @Override
        public List<User> findAll() { 
            return userMapper.selectList(null);
        }
    
        @Override
        public Integer save(User user) { 
            return userMapper.insert(user);
        }
    
        @Override
        public Integer delete(Integer id) { 
            return userMapper.deleteById(id);
        }
    
        @Override
        public Integer update(User user) { 
            return userMapper.updateById(user);
        }
    }

com.caochenlei.controller.UserController

## 4.7、异常处理 ##

com.caochenlei.handler.GlobalExceptionHandler

[image-20201228202836047]: /images/20221119/9efa7aff127c4403b291708eb14e45ed.png
[image-20201229114847040]: /images/20221119/68bf0e9ed7654aa3a1063cec11252cc1.png
[image-20201228203032366]: /images/20221119/673ae40bc46a46198826d7773c37fa3e.png
[18]: https://img-blog.csdnimg.cn/img_convert/547e2a5c070860ceea0d71321395c6f3.gif
[image-20201229115126626]: https://img-blog.csdnimg.cn/img_convert/586aa0a09b85c1681bd9bf9238c7da9e.png
[image-20201229115143242]: https://img-blog.csdnimg.cn/img_convert/4aed8c7644b3cf684e9388cb373694b3.png
[19]: https://img-blog.csdnimg.cn/img_convert/a195af34f57afd23b8429beb8ea5454b.gif
[34734b9c04415af5a2c3724b42465d65.png]: https://img-blog.csdnimg.cn/img_convert/34734b9c04415af5a2c3724b42465d65.png
[image-20201229131725953]: https://img-blog.csdnimg.cn/img_convert/6151fa807fbd6e802784fc7cc62288ea.png
[20]: https://img-blog.csdnimg.cn/img_convert/5500e10106d04efe51b7d3926bc344ed.gif
[image-20201231202719291]: https://img-blog.csdnimg.cn/img_convert/20cdb7fba71af8b3cc29dfa78ad14c13.png
[image-20201231202738969]: https://img-blog.csdnimg.cn/img_convert/5a5b4c9cbdc5e406353744d391468106.png
[20 1]: https://img-blog.csdnimg.cn/img_convert/edebb27857935d89d69cd1395bd7de53.gif