【编程不良人】快速入门Spring学习笔记08---事务属性、Spring整合Structs2框架(SM)、Spring整合Mybatis+Struts2(SSM)、Spring注解、SSM注解式开发

约定不等于承诺〃 2023-10-09 14:01 78阅读 0赞

### 1. 事务属性 ###

#### 1.1 事务传播属性 ####

**配套视频：**[【编程不良人】快速入门Spring,SpringBoot、SpringCloud学不好完全是因为Spring没有掌握!\_哔哩哔哩\_bilibili][Spring_SpringBoot_SpringCloud_Spring_bilibili]

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16][]

# propagation: 传播   
        REQUIRED: 需要事务,如果外部存在事务，则融入当前事务； 【常用】
                          如果外部没有事务,则开启新的事务
                  使用：默认为REQUIRED，主要用于增删改方法)
                 
        SUPPORTS: 支持事务,如果外部存在事务，则融入当前事务； 【常用】
                          如果外部没有事务,不开启新的事务
                  使用：主要用于查询方法，一般查询方法都配置上SUPPORTS，保证事务的正常传播
                  
        REQUIRES_NEW: 每次开启新的事务,如果外部存在事务，外部事务挂起,自己开启新的事务运行,运行结束后恢复外部事务，外层事务继续执行（外层事务如果存在需要等待，内外相当于两个连接对象，互不影响，存在等待阻塞状态） 【常用，银行数据系统，交易记录】
        
        NOT_SUPPORTED: 不支持事务,如果外部存在事务，则外部事务挂起,自己以非事务方式运行，执行完成恢复外部事务运行 【常用】
        
        NEVER: 不支持事务,存在事务报错 【不常用】
        
        MANDATORY: 强制事务，没有事务报错 【不常用】
        
        NESTED: 嵌套事务,事务之间可以嵌套运行，部分数据库不支持，如MySQL、Oracle 【不常用】

#### 1.2 事务的隔离级别 ####

**配套视频：**[【编程不良人】快速入门Spring,SpringBoot、SpringCloud学不好完全是因为Spring没有掌握!\_哔哩哔哩\_bilibili][Spring_SpringBoot_SpringCloud_Spring_bilibili 1]

# isolation: 事务隔离级别
      以下由低到高：
        DEFAULT: 使用数据库默认的隔离级别  [推荐]
        
        READ_UNCOMMITTED: 读未提交  一个客户端读到了另一个客户端没有提交的数据  脏读现象
        
        READ_COMMITTED  : 读提交    一个客户端只能读到另一个客户端提交的数据   避免脏读现象 【oracle默认隔离级别，MySQL不会出现脏读现象】
        
        REPEATABLE_READ : 可重复读  主要是用来避免不可重复读现象出现(在一次事务中一方更新,导致两次查询结果不一致这种情况叫不可重复读)   行锁  【mysql默认隔离级别】
        
        SERIALIZABLE: 序列化读  主要是用来避免幻影读现象出现(在一次事务中一方插入,导致两次查询结果不一致这种情况叫幻影读)  表锁
        
        注意: 隔离级别越高,查询效率越低 一般推荐使用数据库默认隔离级别  MySQL>Oracle

#### 1.3 读写和异常性 ####

# read-only :事务读写性  true 只读 不能执行增删改操作(mysql支持 oralce不支持) 
                           false: 可读可写
      示例： `true:    本次事务只读
            `false:   本次事务非只读
            <tx:method name="save*" propagation="REQUIRES_NEW" read-only="true|false" isolation="SERIALIZABLE"/>
      
      # rollback-for: 出现什么类型异常回滚  默认出现RuntimeException及其子类异常回滚
      示例： rollback-for: 遇到什么类异常回滚
            no-rollback-for: 遇到什么类异常不回滚
          <tx:method name="save*" rollback-for="" no-rollback-for="" propagation="REQUIRES_NEW" read-only="true" isolation="SERIALIZABLE"/>
      
      # no-rollback-for: 出现什么类型异不回滚  java.lang.RuntimeException，也可自定义异常
      示例：
      
      # timeout:  事务超时性     当设置-1时表示永不超时【默认】
                                 当设置为>=0的正整数时，代表设置了超时时间，单位：秒
                                【设置=0时，表示不等待】

### 2. Struts2框架测试 ###

**配套视频：**[【编程不良人】快速入门Spring,SpringBoot、SpringCloud学不好完全是因为Spring没有掌握!\_哔哩哔哩\_bilibili][Spring_SpringBoot_SpringCloud_Spring_bilibili 2]

#### 2.1 新建maven-webapp项目 ####

**main目录下新建java、resources目录**

#### 2.2 pom.xml导入依赖 ####

<dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-beans</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aspects</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      
      
      <dependency>
        <groupId>org.apache.struts</groupId>
        <artifactId>struts2-core</artifactId>
        <version>2.3.16</version>
      </dependency>

#### 2.3 java目录下新建com.study.action.UserAction.java组件 ####

package com.study.action;
      
      import com.opensymphony.xwork2.Action;
      
      /**
       * @ClassName UserAction
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/13 9:43
       * @Version 1.0
       */
      public class UserAction {
          public String hello(){
              System.out.println("hello spring struts2");
              return Action.SUCCESS;
          }
      }

#### 2.4 resources下新建struts.xml，管理Action组件 ####

#### 2.5 在webapp/WEB-INF下的web.xml中添加filter ####

<!DOCTYPE web-app PUBLIC
       "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
       "http://java.sun.com/dtd/web-app_2_3.dtd" >
      
      <web-app>
        <display-name>Archetype Created Web Application</display-name>
      
        
        <filter>
          <filter-name>struts</filter-name>
          <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
        </filter>
      
        <filter-mapping>
          <filter-name>struts</filter-name>
          <url-pattern>/*</url-pattern>
        </filter-mapping>
      </web-app>

#### 2.6 部署Tomcat进行测试 ####

**Add Configuration...--> + -->Tomcat Server-->Local，配置相关参数（通过Artifact导入spring\_struts2:war exploded），注意自己的8080端口被占用，此处使用8888端口进行测试**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 1][]**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 2][]**

**启动服务进行测试，出现下面的提示表示项目启动成功：**

D:\Software_Development\IDEA_code\apache-tomcat-8.5.73-windows-x64\apache-tomcat-8.5.73\bin\catalina.bat run
      [2022-04-13 10:27:16,424] Artifact spring_struct2:war exploded: Waiting for server connection to start artifact deployment...
      Using CATALINA_BASE:   "C:\Users\cjn\AppData\Local\JetBrains\IntelliJIdea2020.1\tomcat\Unnamed_spring_struct2"
      Using CATALINA_HOME:   "D:\Software_Development\IDEA_code\apache-tomcat-8.5.73-windows-x64\apache-tomcat-8.5.73"
      Using CATALINA_TMPDIR: "D:\Software_Development\IDEA_code\apache-tomcat-8.5.73-windows-x64\apache-tomcat-8.5.73\temp"
      Using JRE_HOME:        "D:\Software_Development\JDK"
      Using CLASSPATH:       "D:\Software_Development\IDEA_code\apache-tomcat-8.5.73-windows-x64\apache-tomcat-8.5.73\bin\bootstrap.jar;D:\Software_Development\IDEA_code\apache-tomcat-8.5.73-windows-x64\apache-tomcat-8.5.73\bin\tomcat-juli.jar"
      Using CATALINA_OPTS:   ""
      ......
      Connected to server
      [2022-04-13 10:27:18,026] Artifact spring_struct2:war exploded: Artifact is being deployed, please wait...
      ......
      [2022-04-13 10:27:20,164] Artifact spring_struct2:war exploded: Artifact is deployed successfully
      [2022-04-13 10:27:20,164] Artifact spring_struct2:war exploded: Deploy took 2,138 milliseconds

**打开网址进行测试：[http://localhost:8888/spring\_struts2/user/hello][http_localhost_8888_spring_struts2_user_hello]**

**网页呈现效果：**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 3][]**

**控制台输出内容：**

hello spring struts2

**出现上述效果表示创建成功！**

### 3. Spring整合Struts2框架 ###

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 4][]

#### 3.1 引入依赖 ####

**pom.xml需要额外引入依赖：**

*  `struts2-spring-plugin` ：spring整合struts2
 *  `servlet-api`：引入监听器ContextLoaderListener

<dependency>
        <groupId>org.apache.struts</groupId>
        <artifactId>struts2-spring-plugin</artifactId>
        <version>2.3.16</version>
      </dependency>
      
      
      <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
      </dependency>

#### 3.2 resources下新建spring.xml，管理Action组件 ####

<?xml version="1.0" encoding="UTF-8"?>
      <beans xmlns="http://www.springframework.org/schema/beans"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
      
          
          <bean id="userAction" class="com.study.action.UserAction" scope="prototype"/>
      </beans>

#### 3.3 web.xml配置监听器和spring.xml文件位置 ####

<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>

#### 3.4 修改struts.xml中class对象名称为对象id ####

> `注意: 配置文件中书写的是工厂中管理的action的bean的id`

#### 3.5 部署项目测试 ####

**测试效果与2.6效果一致。**

#### 3.6 spring整合struts2编码步骤总结 ####

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 5][]

#### 附：自定义监听器MyListener ####

package com.study.listener;
      
      import org.springframework.context.support.ClassPathXmlApplicationContext;
      
      import javax.servlet.ServletContextEvent;
      import javax.servlet.ServletContextListener;
      
      public class MyListener implements ServletContextListener {
          private ClassPathXmlApplicationContext context ;
          
          @Override
          public void contextInitialized(ServletContextEvent sce) {
              String springConfig = sce.getServletContext().getInitParameter("springConfig");
              System.out.println(springConfig);
              System.out.println("服务器启动时初始化");
              this.context = new ClassPathXmlApplicationContext(springConfig);
          }
      
          @Override
          public void contextDestroyed(ServletContextEvent sce) {
              System.out.println("服务器关闭时销毁");
              context.close();
          }
      }

### 4. SSM整合编程 ###

#### 4.1 整合步骤 ####

**配套视频：**[【编程不良人】快速入门Spring,SpringBoot、SpringCloud学不好完全是因为Spring没有掌握!\_哔哩哔哩\_bilibili][Spring_SpringBoot_SpringCloud_Spring_bilibili 3]

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 6][]

#### 4.2 编码实现 ####

**配套视频：**[【编程不良人】快速入门Spring,SpringBoot、SpringCloud学不好完全是因为Spring没有掌握!\_哔哩哔哩\_bilibili][Spring_SpringBoot_SpringCloud_Spring_bilibili 4]

> **一、整合Spring+Mybatis**

**a. 新建Maven-webapp项目，main下新建java、resources目录，src下新建test目录，并在此路径下新建java、resources目录**

**b.在pom.xml引入依赖**

<dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
      </dependency>
      
      
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-beans</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aspects</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      
      
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.4</version>
      </dependency>
      
      
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>2.0.4</version>
      </dependency>
      
      
      <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.38</version>
      </dependency>
      
      
      <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.19</version>
      </dependency>
      
      
      <dependency>
        <groupId>org.apache.struts</groupId>
        <artifactId>struts2-core</artifactId>
        <version>2.3.16</version>
      </dependency>
      
      
      <dependency>
        <groupId>org.apache.struts</groupId>
        <artifactId>struts2-spring-plugin</artifactId>
        <version>2.3.16</version>
      </dependency>
      
      
      <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <scope>provided</scope>
      </dependency>
      
      
      <dependency>
        <groupId>jstl</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
      </dependency>
      
      
      <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>fastjson</artifactId>
        <version>1.2.62</version>
      </dependency>
      
      
      <dependency>
        <groupId>org.apache.logging.log4j</groupId>
        <artifactId>log4j-core</artifactId>
        <version>2.10.0</version>
      </dependency>
      <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>1.7.25</version>
      </dependency>

**c.新建实体类User**

package com.study.entity;
      
      import java.util.Date;
      
      /**
       * @ClassName User
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/14 12:33
       * @Version 1.0
       */
      public class User {
          private String id;
          private String name;
          private Integer age;
          private Date bir;
      
          public User() {
          }
          public User(String id, String name, Integer age, Date bir) {
              this.id = id;
              this.name = name;
              this.age = age;
              this.bir = bir;
          }
      
          @Override
          public String toString() {
              return "User{" +
                      "id='" + id + '\'' +
                      ", name='" + name + '\'' +
                      ", age=" + age +
                      ", bir=" + bir +
                      '}';
          }
      
          public String getId() {
              return id;
          }
      
          public void setId(String id) {
              this.id = id;
          }
      
          public String getName() {
              return name;
          }
      
          public void setName(String name) {
              this.name = name;
          }
      
          public Integer getAge() {
              return age;
          }
      
          public void setAge(Integer age) {
              this.age = age;
          }
      
          public Date getBir() {
              return bir;
          }
      
          public void setBir(Date bir) {
              this.bir = bir;
          }
      }

**d.新建DAO接口：UserDAO**

package com.study.dao;
      
      import com.study.entity.User;
      
      import java.util.List;
      
      /**
       * @ClassName UserDAO
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/14 12:36
       * @Version 1.0
       */
      public interface UserDAO {
          /**
           * @MethodName insert
           * @Description 插入用户数据
           * @param: user
           * @Author Jiangnan Cui
           * @Date 2022/4/14 12:37
           */
          void insert(User user);
      
          /**
           * @MethodName selectAll
           * @Description 查询用户所有数据
           * @return: java.util.List<com.study.entity.User>
           * @Author Jiangnan Cui
           * @Date 2022/4/14 12:37
           */
          List<User> selectAll();
      }

**e.新建Mapper配置文件：UserDAOMapper（resources/com/study/mapper目录下）**

<?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.study.dao.UserDAO">
          
          
          <insert id="insert" parameterType="User">
              insert into t_user values(#{id},#{name},#{age},#{bir})
          </insert>
      
          
          <select id="selectAll" resultType="User">
              select id,name,age,bir from t_user
          </select>
      
      </mapper>

**f.新建Service接口：UserService**

package com.study.service;
      
      import com.study.entity.User;
      
      import java.util.List;
      
      /**
       * @ClassName UserService
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/14 12:42
       * @Version 1.0
       */
      public interface UserService {
          /**
           * @MethodName insert
           * @Description 插入用户数据
           * @param: user
           * @Author Jiangnan Cui
           * @Date 2022/4/14 12:37
           */
          void insert(User user);
      
          /**
           * @MethodName selectAll
           * @Description 查询用户所有数据
           * @return: java.util.List<com.study.entity.User>
           * @Author Jiangnan Cui
           * @Date 2022/4/14 12:37
           */
          List<User> selectAll();
      }

**g.新建UserService接口实现类：UserServiceImpl，依赖UserDAO组件，需要注入**

package com.study.service;
      
      import com.study.dao.UserDAO;
      import com.study.entity.User;
      
      import java.util.List;
      import java.util.UUID;
      
      /**
       * @ClassName UserServiceImpl
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/14 12:42
       * @Version 1.0
       */
      public class UserServiceImpl implements UserService{
          //依赖UserDAO
          private UserDAO userDAO;
      
          public void setUserDAO(UserDAO userDAO) {
              this.userDAO = userDAO;
          }
      
          @Override
          public void insert(User user) {
              //处理业务
              user.setId(UUID.randomUUID().toString());
              userDAO.insert(user);
          }
      
          @Override
          public List<User> selectAll() {
              //处理业务
              return userDAO.selectAll();
          }
      }

**h.编写spring.xml配置文件（resources目录下）**

<?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:tx="http://www.springframework.org/schema/tx"
             xmlns:aop="http://www.springframework.org/schema/aop"
             xsi:schemaLocation="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.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
      
          
          <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/mybatis?
              useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false"/>
              <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="mapperLocations" value="classpath:com/study/mapper/*.xml"/>
              <property name="typeAliasesPackage" value="com.study.entity"/>
          </bean>
      
          
          <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
              <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
              <property name="basePackage" value="com.study.dao"/>
          </bean>
      
          
          <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
              <property name="dataSource" ref="dataSource"/>
          </bean>
      
          
          <tx:advice id="txAdvice" transaction-manager="transactionManager">
              <tx:attributes>
                  <tx:method name="insert*"/>
                  <tx:method name="select*" propagation="SUPPORTS"/>
              </tx:attributes>
          </tx:advice>
      
          
          <aop:config>
              <aop:pointcut id="pc" expression="within(com.study.service.*ServiceImpl)"/>
              <aop:advisor advice-ref="txAdvice" pointcut-ref="pc"/>
          </aop:config>
      
          
          <bean id="userService" class="com.study.service.UserServiceImpl">
              <property name="userDAO" ref="userDAO"/>
          </bean>
      </beans>

**i.在resources目录下新建log4j.properties记录日志信息**

## 根日志
      ## 日志级别
      log4j.rootLogger=ERROR,stdout
      ## 输出位置
      log4j.appender.stdout=org.apache.log4j.ConsoleAppender
      ## 布局
      log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
      ## 格式
      log4j.appender.stdout.layout.conversionPattern=[%p] %d{yyyy-MM-dd} %m%n
      •
      ## 子日志
      ## 日志级别
      log4j.logger.com.study.dao=DEBUG
      ## 监听spring框架的日志级别
      ## log4j.logger.org.springframework=ERROR

**j.测试Spring+Mybatis是否整合成功(src/test/java/com/study/test目录下）**

package com.study.test;
      
      import com.study.service.UserService;
      import org.springframework.context.ApplicationContext;
      import org.springframework.context.support.ClassPathXmlApplicationContext;
      
      /**
       * @ClassName TestUserService
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/14 13:07
       * @Version 1.0
       */
      public class TestUserService {
          public static void main(String[] args) {
              ApplicationContext context = new ClassPathXmlApplicationContext("spring.xml");
              UserService userService = (UserService) context.getBean("userService");
              userService.selectAll().forEach(user -> System.out.println("user = " + user));
          }
      }

**输出结果：**

[DEBUG] 2022-04-14 ==>  Preparing: select id,name,age,bir from t_user 
      [DEBUG] 2022-04-14 ==> Parameters: 
      [DEBUG] 2022-04-14 <==      Total: 14
      user = User{id='1', name='张三', age=10, bir=Fri Apr 01 00:00:00 CST 2022}
      user = User{id='2', name='李四', age=20, bir=Sat Apr 02 00:00:00 CST 2022}
      user = User{id='2f278828-6422-432d-ab1b-a727b33c23bc', name='小胖墩', age=3, bir=Mon Apr 11 21:43:57 CST 2022}
      user = User{id='3', name='王五', age=30, bir=Sun Apr 03 00:00:00 CST 2022}
      user = User{id='4', name='灰太狼', age=60, bir=Sun Apr 10 09:56:17 CST 2022}
      user = User{id='5', name='小超超', age=36, bir=Sun Apr 10 09:55:41 CST 2022}
      user = User{id='586a5f71-836c-4171-a038-4620fe0f9354', name='葫芦娃', age=5, bir=Tue Apr 12 09:45:17 CST 2022}
      user = User{id='6', name='小呆呆', age=60, bir=Sun Apr 10 09:55:43 CST 2022}
      user = User{id='7', name='小超超', age=36, bir=Sun Apr 10 09:55:44 CST 2022}
      user = User{id='8', name='胖嘟嘟', age=50, bir=Sun Apr 10 09:55:39 CST 2022}
      user = User{id='8a3e8ab8-5abc-44e1-9aec-31f3978d97f2', name='小胖墩', age=3, bir=Tue Apr 12 10:23:33 CST 2022}
      user = User{id='9', name='小崔', age=25, bir=Sun Apr 10 09:55:52 CST 2022}
      user = User{id='cd280176-68b2-4ceb-b781-ba2f5e1fbeff', name='小胖墩', age=3, bir=Tue Apr 12 10:21:18 CST 2022}
      user = User{id='e3863fd3-173c-46f4-a753-c72f7c92ad56', name='小猫咪', age=3, bir=Mon Apr 11 21:36:31 CST 2022}

> **二、整合Spring+Struts2**

**a. 配置web.xml(webapp/WEB-INF目录下）**

<!DOCTYPE web-app PUBLIC
       "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
       "http://java.sun.com/dtd/web-app_2_3.dtd" >
      
      <web-app>
        <display-name>Archetype Created Web Application</display-name>
        
        
        <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.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
        </filter>
        <filter-mapping>
          <filter-name>struts2</filter-name>
          <url-pattern>/*</url-pattern>
        </filter-mapping>
        
        
        <listener>
          <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
      </web-app>

**b.开发Action组件：UserAction，注入Service组件**

package com.study.action;
      
      import com.opensymphony.xwork2.Action;
      import com.study.entity.User;
      import com.study.service.UserService;
      
      import java.util.List;
      
      /**
       * @ClassName UserAction
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/14 13:57
       * @Version 1.0
       */
      public class UserAction {
          //依赖注入只需要SET方法
          private UserService userService;
      
          public void setUserService(UserService userService) {
              this.userService = userService;
          }
          //接收参数 数据传递 必须同时提供GET、SET方法
          private List<User> users;
          private User user;
      
          public List<User> getUsers() {
              return users;
          }
      
          public void setUsers(List<User> users) {
              this.users = users;
          }
      
          public User getUser() {
              return user;
          }
      
          public void setUser(User user) {
              this.user = user;
          }
      
          /**
           * @MethodName insert
           * @Description  插入用户信息
           * @return: java.lang.String
           * @Author Jiangnan Cui
           * @Date 2022/4/14 14:31
           */
          public String insert(){
              //1.接收参数
              //2.调用业务方法
              userService.insert(user);
              //3.处理响应
              return Action.SUCCESS;
          }
      
          /**
           * @MethodName selectAll
           * @Description 查询所有用户数据
           * @return: java.lang.String
           * @Author Jiangnan Cui
           * @Date 2022/4/14 14:34
           */
          public String selectAll(){
              //1.收集数据
              //2.调用业务
              //3.处理响应
              this.users = userService.selectAll();
              return Action.SUCCESS;
          }
      }

**c.spring.xml管理Action组件，注入Service组件**

<bean id="userAction" class="com.study.action.UserAction" scope="prototype">
          <property name="userService" ref="userService"/>
      </bean>

**d.resources目录下引入struts.xml**

<?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>
          <package name="user" extends="struts-default" namespace="/user">
              
              <action name="selectAll" class="userAction" method="selectAll">
                  <result name="success">/showAll.jsp</result>
              </action>
      
              
              <action name="insert" class="userAction" method="insert">
                  <result name="success" type="redirect">/user/selectAll</result>
              </action>
          </package>
      </struts>

**e.webapp路径下新建showAll.jsp**

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
      <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
      <%@page pageEncoding="UTF-8" contentType="text/html; UTF-8" isELIgnored="false" %>
      <!doctype html>
      <html lang="en">
      <head>
          <meta charset="UTF-8">
          <meta name="viewport"
                content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
          <meta http-equiv="X-UA-Compatible" content="ie=edge">
          <title>展示所有用户</title>
      </head>
      <body>
          <h1>用户列表</h1>
          <c:forEach items="${requestScope.users}" var="user">
              ${user.id}----${user.name}----${user.age}----<fmt:formatDate value="${user.bir}" pattern="yyyy-MM-dd"/> <br>
          </c:forEach>
      </body>
      </html>

**f.部署Tomcat进行测试**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 7][]**

**项目启动成功后自动访问页面：**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 8][]**

**控制台打印输出：**

D:\Software_Development\IDEA_code\apache-tomcat-8.5.78\bin\catalina.bat run
      [2022-04-14 02:45:51,794] Artifact ssm_struts2:war exploded: Waiting for server connection to start artifact deployment...
      Using CATALINA_BASE:   "C:\Users\cjn\AppData\Local\JetBrains\IntelliJIdea2020.1\tomcat\Unnamed_ssm_struts2"
      Using CATALINA_HOME:   "D:\Software_Development\IDEA_code\apache-tomcat-8.5.78"
      Using CATALINA_TMPDIR: "D:\Software_Development\IDEA_code\apache-tomcat-8.5.78\temp"
      Using JRE_HOME:        "D:\Software_Development\JDK"
      Using CLASSPATH:       "D:\Software_Development\IDEA_code\apache-tomcat-8.5.78\bin\bootstrap.jar;D:\Software_Development\IDEA_code\apache-tomcat-8.5.78\bin\tomcat-juli.jar"
      Using CATALINA_OPTS:   ""
      ......
      Connected to server
      [2022-04-14 02:45:53,392] Artifact ssm_struts2:war exploded: Artifact is being deployed, please wait...
      ......
      [2022-04-14 02:45:57,901] Artifact ssm_struts2:war exploded: Artifact is deployed successfully
      [2022-04-14 02:45:57,901] Artifact ssm_struts2:war exploded: Deploy took 4,509 milliseconds

**访问路径：[http://localhost:8888/ssm\_struts2/user/selectAll][http_localhost_8888_ssm_struts2_user_selectAll] 查询所有用户信息，显示效果如下：**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 9][]**

**访问路径：[http://localhost:8888/ssm\_struts2/user/insert?user.name=皮卡丘&&user.age=10&user.bir=2022-04-14][http_localhost_8888_ssm_struts2_user_insert_user.name_user.age_10_user.bir_2022-04-14] 插入用户信息，显示效果如下：**

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 10][]

**附：最终项目结构**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_11_color_FFFFFF_t_70_g_se_x_16][]**

### 5. Spring的注解式开发 ###

**配套视频：**[【编程不良人】快速入门Spring,SpringBoot、SpringCloud学不好完全是因为Spring没有掌握!\_哔哩哔哩\_bilibili][Spring_SpringBoot_SpringCloud_Spring_bilibili 5]

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 11][]

#### 5.1 常用注解总结 ####

> `Spring自2.5版本以后提供了一些注解用来在使用spring时进行快速开发`

### 实例化相关注解
      # 1. @Component(value="beanid")
          修饰范围:   用在类上
          注解作用:   通用的创建实例的注解,用来创建当前这个类的实例
          value属性: 用来指定创建的对象在工厂中的唯一标识   如果不指定默认创建对象在工厂中的标识为类名首字母小写
                      
      # 2. @Repository 
          修饰范围:    用在类上
          注解作用:    @component的子类注解专用于DAO组件的创建,通常加在DAO组件上
          value属性:  用来指定创建的对象在工厂中的唯一标识   如果不指定默认创建对象在工厂中的标识为类名首字母小写
      
      # 3. @Service
          修饰范围:    用在类上
          注解作用:    @component的子类注解专用于Service组件的创建,通常加在Service组件上
          value属性:   用来指定创建的对象在工厂中的唯一标识   如果不指定默认创建对象在工厂中的标识为类名首字母小写
      
      # 4. @Controller
          修饰范围:    用在类上
          注解作用:    @component的子类注解专用于Action组件的创建,通常加在Action组件上
          value属性:  用来指定创建的对象在工厂中的唯一标识   如果不指定默认创建对象在工厂中的标识为类名首字母小写
                      
      
      
      
      ### 控制对象的创建次数的注解
      # 1. @Scope(value="singleton|prototype")
          修饰范围:    用在类上
          注解作用:    用来控制这个实例在工厂中的创建次数
          value属性:  singleton为单例,prototype为多例   默认单例
      
      
      
      ### 注入相关的注解
      # 1. @Autowired(Spring提供)
          修饰范围:    用在成员变量或成员变量的GET/SET方法上
          注解作用:    用来给类中成员变量赋值
          注入原则:    默认根据类型自动注入
      
      # 2. @Resource(JAVAEE提供)
          修饰范围:    用在成员变量或成员变量的GET/SET方法上
          注解作用:    用来给类中成员变量赋值
          注入原则:    默认根据名称自动注入名称找不到根据类型自动注入
      
      
      
      ### 控制事务的相关注解
      # 1. @Transactional
          修饰范围:    用在类上主要用在业务层组件类上或者是方法上
          注解作用:    用来给类中方法加入事务,当类上和方法上同时存在该注解时局部优先
          注解属性:    
                      propagation  用来控制传播属性
                      Isolation    用来控制隔离级别
                      timeout      用来设置超时性
                      rollback-for 用来设置什么异常回滚
                      norollback-for 用来设置什么异常不会滚
                      readonly     用来设置事务读写性
      # 注意: 如果要使用事务注解在配置文件中必须开启事务注解生效加入如下配置:   
      <tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>

**具体实现：**

#### 5.2 新建Maven-webapp项目，添加java、resources目录 ####

#### 5.3 pom.xml导入依赖 ####

<dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
      </dependency>
      <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>compile</scope>
      </dependency>
      
      
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-beans</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aspects</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>4.3.2.RELEASE</version>
      </dependency>

#### 5.4 编写DAO接口及其实现类 ####

package com.study.dao;
      
      /**
       * @ClassName UserDAO
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/15 15:51
       * @Version 1.0
       */
      public interface UserDAO {
          void save(String name);
      }
      
      
      
      package com.study.dao;
      
      import org.springframework.stereotype.Component;
      import org.springframework.stereotype.Repository;
      
      
      /**
       * @ClassName UserDAOImpl
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/15 15:52
       * @Version 1.0
       */
      //1.通用注解
      //默认@Component(value="userDAOImpl")，即类名首字母小写，简写为@Component("userDAOImpl")，只有一个参数时才可以省略value
      //指定其他名称是，须通过value指定
      //@Component(value = "userDAO")
      
      //2.DAO层专用注解
      //默认@Repository(value="userDAOImpl")，即类名首字母小写，简写为@Repository("userDAOImpl")，只有一个参数时才可以省略value
      //指定其他名称是，须通过value指定
      @Repository(value = "userDAO")
      public class UserDAOImpl implements UserDAO{
          @Override
          public void save(String name) {
              System.out.println("UserDAO: " + name);
          }
      }

#### 5.5 编写Service接口及其实现类 ####

package com.study.service;
      
      /**
       * @ClassName UserService
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/15 15:53
       * @Version 1.0
       */
      public interface UserService {
          void save(String name);
      
          String find(String id);
      }
      
      
      
      package com.study.service;
      
      import com.study.dao.UserDAO;
      import org.springframework.beans.factory.annotation.Autowired;
      import org.springframework.context.annotation.Scope;
      import org.springframework.stereotype.Component;
      import org.springframework.stereotype.Service;
      import org.springframework.transaction.annotation.Isolation;
      import org.springframework.transaction.annotation.Propagation;
      import org.springframework.transaction.annotation.Transactional;
      
      /**
       * @ClassName UserServiceImpl
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/15 15:54
       * @Version 1.0
       */
      //1.通用注解
      //默认@Component(value="userServiceImpl")，即类名首字母小写，简写为@Component("userServiceImpl")，只有一个参数时才可以省略value
      //指定其他名称是，须通过value指定
      //@Component(value = "userService")
      
      //2.Service层专用注解
      //默认@Repository(value="userServiceImpl")，即类名首字母小写，简写为@Repository("userServiceImpl")，只有一个参数时才可以省略value
      //指定其他名称是，须通过value指定
      @Service(value = "userService")
      
      //Service层需要添加事务，默认属性，查询方法额外添加属性
      @Transactional
      
      // 默认单例，scope为多例
      @Scope(value = "prototype")
      public class UserServiceImpl implements UserService{
          //Service层需要调用DAO层
          @Autowired
          private UserDAO userDAO;
      
          @Override
          public void save(String name) {
              userDAO.save("UserDAO");
              System.out.println("UserService = " + name);
      
          }
      
          @Override
          //查询方法需要额外添加事务属性
          @Transactional(
                  propagation = Propagation.SUPPORTS,
                  isolation = Isolation.DEFAULT,
                  noRollbackFor = {},
                  rollbackFor = {},
                  readOnly = false,
                  timeout = -1
          )
          public String find(String id) {
              return id;
          }
      }

#### 5.6 编写spring.xml配置文件，开启注解扫描配置 ####

#### 5.7 测试 ####

package com.study.test;
      
      import com.study.dao.UserDAO;
      import com.study.service.UserService;
      import org.junit.Test;
      import org.springframework.context.ApplicationContext;
      import org.springframework.context.support.ClassPathXmlApplicationContext;
      
      /**
       * @ClassName TestSpring
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/15 15:57
       * @Version 1.0
       */
      public class TestSpring {
          /**
           * @MethodName TestUserDAO
           * @Description 测试DAO层注解
           * @Author Jiangnan Cui
           * @Date 2022/4/15 16:23
           */
          @Test
          public void TestUserDAO(){
              ApplicationContext context = new ClassPathXmlApplicationContext("spring.xml");
              UserDAO userDAO = (UserDAO) context.getBean("userDAO");
              System.out.println("userDAO = " + userDAO);
              userDAO.save("2022年4月15日15:59:50");
          }
      
          /**
           * @MethodName TestUserService
           * @Description 测试Service层注解
           * @Author Jiangnan Cui
           * @Date 2022/4/15 16:23
           */
          @Test
          public void TestUserService(){
              ApplicationContext context = new ClassPathXmlApplicationContext("spring.xml");
              UserService userService = (UserService) context.getBean("userService");
              System.out.println("userService = " + userService);
              System.out.println(userService.find("1"));
              UserService userService1 = (UserService) context.getBean("userService");
              System.out.println("userService1 = " + userService1);
              System.out.println(userService1.find("2"));
              System.out.println(userService==userService1);
      
              userService.save("UserService");
          }
      }

**输出结果：**

userService = com.study.service.UserServiceImpl@19d37183
      1
      userService1 = com.study.service.UserServiceImpl@1a0dcaa
      2
      false
      UserDAO: UserDAO
      UserService = UserService

### 6.ssm整合注解式开发 ###

#### 6.1 编码步骤 ####

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 12][]

####  ####

#### 6.2 代码实现 ####

**配套视频：**[【编程不良人】快速入门Spring,SpringBoot、SpringCloud学不好完全是因为Spring没有掌握!\_哔哩哔哩\_bilibili][Spring_SpringBoot_SpringCloud_Spring_bilibili 6]

> **一、整合Spring+Mybatis**

**a. 新建Maven-webapp项目，main下新建java、resources目录，src下新建test目录，并在此路径下新建java、resources目录**

**b.在pom.xml引入依赖**

**c.新建实体类User**

package com.study.entity;
      
      import java.util.Date;
      
      /**
       * @ClassName User
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/14 12:33
       * @Version 1.0
       */
      public class User {
          private String id;
          private String name;
          private Integer age;
          private Date bir;
      
          public User() {
          }
        
          public User(String id, String name, Integer age, Date bir) {
              this.id = id;
              this.name = name;
              this.age = age;
              this.bir = bir;
          }
      
          @Override
          public String toString() {
              return "User{" +
                      "id='" + id + '\'' +
                      ", name='" + name + '\'' +
                      ", age=" + age +
                      ", bir=" + bir +
                      '}';
          }
      
          public String getId() {
              return id;
          }
      
          public void setId(String id) {
              this.id = id;
          }
      
          public String getName() {
              return name;
          }
      
          public void setName(String name) {
              this.name = name;
          }
      
          public Integer getAge() {
              return age;
          }
      
          public void setAge(Integer age) {
              this.age = age;
          }
      
          public Date getBir() {
              return bir;
          }
      
          public void setBir(Date bir) {
              this.bir = bir;
          }
      }

**d.新建DAO接口：UserDAO**

**e.新建Mapper配置文件：UserDAOMapper（resources/com/study/mapper目录下）**

**f.新建Service接口：UserService**

**g.新建UserService接口实现类：UserServiceImpl，依赖UserDAO组件，需要注入**

package com.study.service;
      
      import com.study.dao.UserDAO;
      import com.study.entity.User;
      
      import java.util.List;
      import java.util.UUID;
      
      /**
       * @ClassName UserServiceImpl
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/14 12:42
       * @Version 1.0
       */
      @Service("userService")
      @Transational
      public class UserServiceImpl implements UserService{
          //依赖UserDAO
          @Autowired
          private UserDAO userDAO;
      
          @Override
          public void insert(User user) {
              //处理业务
              user.setId(UUID.randomUUID().toString());
              userDAO.insert(user);
          }
      
          @Override
          @Transactional(propagation = Propagation.SUPPORTS)
          public List<User> selectAll() {
              //处理业务
              return userDAO.selectAll();
          }
      }

**h.编写spring.xml配置文件（resources目录下）**

<?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.study"/>
        
          
          <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/mybatis?
              useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false"/>
              <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="mapperLocations" value="classpath:com/study/mapper/*.xml"/>
              <property name="typeAliasesPackage" value="com.study.entity"/>
          </bean>
      
          
          <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
              <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
              <property name="basePackage" value="com.study.dao"/>
          </bean>
      
          
          <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
              <property name="dataSource" ref="dataSource"/>
          </bean>
          
          
          <tx:annotation-driven transaction-manager="transactionManager"/>
          
      </beans>

**i.在resources目录下新建log4j.properties记录日志信息**

## 根日志
      ## 日志级别
      log4j.rootLogger=ERROR,stdout
      ## 输出位置
      log4j.appender.stdout=org.apache.log4j.ConsoleAppender
      ## 布局
      log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
      ## 格式
      log4j.appender.stdout.layout.conversionPattern=[%p] %d{yyyy-MM-dd} %m%n
      
      ## 子日志
      ## 日志级别
      log4j.logger.com.study.dao=DEBUG
      ## 监听spring框架的日志级别
      ## log4j.logger.org.springframework=ERROR

**j.测试Spring+Mybatis是否整合成功(src/test/java/com/study/test目录下）**

**输出结果：**

[DEBUG] 2022-04-15 ==>  Preparing: select id,name,age,bir from t_user 
      [DEBUG] 2022-04-15 ==> Parameters: 
      [DEBUG] 2022-04-15 <==      Total: 17
      user = User{id='1', name='张三', age=10, bir=Fri Apr 01 00:00:00 CST 2022}
      user = User{id='2', name='李四', age=20, bir=Sat Apr 02 00:00:00 CST 2022}
      user = User{id='2d237778-835d-477b-9721-fe6f575064b9', name='波比', age=18, bir=Sun Feb 02 00:00:00 CST 2020}
      user = User{id='2f278828-6422-432d-ab1b-a727b33c23bc', name='小胖墩', age=3, bir=Mon Apr 11 21:43:57 CST 2022}
      user = User{id='3', name='王五', age=30, bir=Sun Apr 03 00:00:00 CST 2022}
      user = User{id='4', name='灰太狼', age=60, bir=Sun Apr 10 09:56:17 CST 2022}
      user = User{id='5', name='小超超', age=36, bir=Sun Apr 10 09:55:41 CST 2022}
      user = User{id='586a5f71-836c-4171-a038-4620fe0f9354', name='葫芦娃', age=5, bir=Tue Apr 12 09:45:17 CST 2022}
      user = User{id='6', name='小呆呆', age=60, bir=Sun Apr 10 09:55:43 CST 2022}
      user = User{id='7', name='小超超', age=36, bir=Sun Apr 10 09:55:44 CST 2022}
      user = User{id='8', name='胖嘟嘟', age=50, bir=Sun Apr 10 09:55:39 CST 2022}
      user = User{id='8a3e8ab8-5abc-44e1-9aec-31f3978d97f2', name='小胖墩', age=3, bir=Tue Apr 12 10:23:33 CST 2022}
      user = User{id='9', name='小崔', age=25, bir=Sun Apr 10 09:55:52 CST 2022}
      user = User{id='985cd035-dedc-4e84-973a-a5fdaa2b8475', name='喜洋洋', age=8, bir=Tue Oct 10 00:00:00 CST 2000}
      user = User{id='a6be9263-f05f-415f-855e-33843b22e71d', name='皮卡丘', age=10, bir=Thu Apr 14 00:00:00 CST 2022}
      user = User{id='cd280176-68b2-4ceb-b781-ba2f5e1fbeff', name='小胖墩', age=3, bir=Tue Apr 12 10:21:18 CST 2022}
      user = User{id='e3863fd3-173c-46f4-a753-c72f7c92ad56', name='小猫咪', age=3, bir=Mon Apr 11 21:36:31 CST 2022}

> **二、整合Spring+Struts2**

**a. 配置web.xml(webapp/WEB-INF目录下）**

<!DOCTYPE web-app PUBLIC
       "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
       "http://java.sun.com/dtd/web-app_2_3.dtd" >
      
      <web-app>
        <display-name>Archetype Created Web Application</display-name>
        
        
        <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.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
        </filter>
        <filter-mapping>
          <filter-name>struts2</filter-name>
          <url-pattern>/*</url-pattern>
        </filter-mapping>
        
        
        <listener>
          <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
      </web-app>

**b.开发Action组件：UserAction，注入Service组件**

package com.study.action;
      
      import com.opensymphony.xwork2.Action;
      import com.study.entity.User;
      import com.study.service.UserService;
      
      import java.util.List;
      
      /**
       * @ClassName UserAction
       * @Description TODO
       * @Author Jiangnan Cui
       * @Date 2022/4/14 13:57
       * @Version 1.0
       */
      @Controller
      @Scope("prototype")
      public class UserAction {
          //依赖注入
          @Autowired
          private UserService userService;
      
          //接收参数 数据传递 必须同时提供GET、SET方法
          private List<User> users;//struts2传值机制：成员变量替换request的作用域
          private User user;
      
          public List<User> getUsers() {
              return users;
          }
      
          public void setUsers(List<User> users) {
              this.users = users;
          }
      
          public User getUser() {
              return user;
          }
      
          public void setUser(User user) {
              this.user = user;
          }
      
          /**
           * @MethodName insert
           * @Description  插入用户信息
           * @return: java.lang.String
           * @Author Jiangnan Cui
           * @Date 2022/4/14 14:31
           */
          public String insert(){
              //1.接收参数
              //2.调用业务方法
              userService.insert(user);
              //3.处理响应
              return Action.SUCCESS;
          }
      
          /**
           * @MethodName selectAll
           * @Description 查询所有用户数据
           * @return: java.lang.String
           * @Author Jiangnan Cui
           * @Date 2022/4/14 14:34
           */
          public String selectAll(){
              //1.收集数据
              //2.调用业务
              //3.处理响应
              this.users = userService.selectAll();
              return Action.SUCCESS;
          }
      }

**c.resources目录下引入struts.xml**

<?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>
          <package name="user" extends="struts-default" namespace="/user">
              
              <action name="selectAll" class="userAction" method="selectAll">
                  <result name="success">/showAll.jsp</result>
              </action>
      
              
              <action name="insert" class="userAction" method="insert">
                  <result name="success" type="redirect">/user/selectAll</result>
              </action>
          </package>
      </struts>

**d.webapp路径下新建showAll.jsp**

**d.部署Tomcat进行测试**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 13][]**

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 14][] **项目启动成功后自动访问页面：**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 15][]**

**控制台打印输出：**

D:\Software_Development\IDEA_code\apache-tomcat-8.5.78\bin\catalina.bat run
      [2022-04-15 08:15:02,252] Artifact ssm_struts2_annotation:war exploded: Waiting for server connection to start artifact deployment...
      Using CATALINA_BASE:   "C:\Users\cjn\AppData\Local\JetBrains\IntelliJIdea2020.1\tomcat\Unnamed_ssm_struts2_annotation"
      Using CATALINA_HOME:   "D:\Software_Development\IDEA_code\apache-tomcat-8.5.78"
      Using CATALINA_TMPDIR: "D:\Software_Development\IDEA_code\apache-tomcat-8.5.78\temp"
      Using JRE_HOME:        "D:\Software_Development\JDK"
      Using CLASSPATH:       "D:\Software_Development\IDEA_code\apache-tomcat-8.5.78\bin\bootstrap.jar;D:\Software_Development\IDEA_code\apache-tomcat-8.5.78\bin\tomcat-juli.jar"
      Using CATALINA_OPTS:   ""
      ......
      Connected to server
      [2022-04-15 08:15:04,464] Artifact ssm_struts2_annotation:war exploded: Artifact is being deployed, please wait...
      ......
      [2022-04-15 08:15:21,685] Artifact ssm_struts2_annotation:war exploded: Artifact is deployed successfully
      [2022-04-15 08:15:21,686] Artifact ssm_struts2_annotation:war exploded: Deploy took 17,222 milliseconds

**访问路径：[http://localhost:8888/ssm\_struts2\_annotation/user/selectAll][http_localhost_8888_ssm_struts2_annotation_user_selectAll] 查询所有用户信息，显示效果如下：**

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 16][]

**访问路径：[http://localhost:8888/ssm\_struts2\_annotation/user/insert?user.name=][http_localhost_8888_ssm_struts2_annotation_user_insert_user.name]唐三&&user.age=20&user.bir=2022-04-15 插入用户信息，显示效果如下：**

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 17][]

**附：最终项目结构**

**![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_12_color_FFFFFF_t_70_g_se_x_16][]**

### 【完结】 ###

[Spring_SpringBoot_SpringCloud_Spring_bilibili]: https://www.bilibili.com/video/BV12k4y167jK?p=23
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/c1bfa6a125e44e37bfbc4d90d7d5fa71.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[Spring_SpringBoot_SpringCloud_Spring_bilibili 1]: https://www.bilibili.com/video/BV12k4y167jK?p=24
[Spring_SpringBoot_SpringCloud_Spring_bilibili 2]: https://www.bilibili.com/video/BV12k4y167jK?p=25
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/85e0dad000fb42448d739370cc14a493.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/c52111871a0545c19fb6eac721b1b516.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[http_localhost_8888_spring_struts2_user_hello]: http://localhost:8888/spring_struts2/user/hello
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 3]: https://img-blog.csdnimg.cn/801b2522153243e9baedd51d0d84b642.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 4]: https://img-blog.csdnimg.cn/6ca871ccc51b40beb8d39b46506b0388.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 5]: https://img-blog.csdnimg.cn/06e15d0ef9a8478390bb8b3d9d7f629c.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[Spring_SpringBoot_SpringCloud_Spring_bilibili 3]: https://www.bilibili.com/video/BV12k4y167jK?p=26
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 6]: https://img-blog.csdnimg.cn/a8629e14f7ab4104a332302114d83b8c.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[Spring_SpringBoot_SpringCloud_Spring_bilibili 4]: https://www.bilibili.com/video/BV12k4y167jK?p=27
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 7]: https://img-blog.csdnimg.cn/8840e9413f9f42848d4915b73af18a2b.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 8]: https://img-blog.csdnimg.cn/1cb5f7c106ef49efa5e50df90ac3b8db.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[http_localhost_8888_ssm_struts2_user_selectAll]: http://localhost:8888/ssm_struts2/user/selectAll
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 9]: https://img-blog.csdnimg.cn/b5abe5e30dd141beb2ae6552a707a4e7.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[http_localhost_8888_ssm_struts2_user_insert_user.name_user.age_10_user.bir_2022-04-14]: http://localhost:8888/ssm_struts2/user/insert?user.name=%E7%9A%AE%E5%8D%A1%E4%B8%98&&user.age=10&user.bir=2022-04-14
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 10]: https://img-blog.csdnimg.cn/1451ea4617a9433c99b41975e0af78b7.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_11_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/cadfc1f66a934eab88fadf3eba3fd123.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_11,color_FFFFFF,t_70,g_se,x_16
[Spring_SpringBoot_SpringCloud_Spring_bilibili 5]: https://www.bilibili.com/video/BV12k4y167jK?p=28
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 11]: https://img-blog.csdnimg.cn/a04a134edb8e4773a3ce9122fdea0cf0.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 12]: https://img-blog.csdnimg.cn/58373390244a478fa1346399b8c4f95c.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[Spring_SpringBoot_SpringCloud_Spring_bilibili 6]: https://www.bilibili.com/video/BV12k4y167jK?p=29
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 13]: https://img-blog.csdnimg.cn/26a26c94dc964430b2d945d2a615e691.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 14]: https://img-blog.csdnimg.cn/a6a3b2cf9b29400aadcdb56e1f8564b1.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 15]: https://img-blog.csdnimg.cn/d7d9515de49a4170bb8975c81782e348.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[http_localhost_8888_ssm_struts2_annotation_user_selectAll]: http://localhost:8888/ssm_struts2_annotation/user/selectAll
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 16]: https://img-blog.csdnimg.cn/676cb6b8abfb4e0eb3ab59ab84672e33.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[http_localhost_8888_ssm_struts2_annotation_user_insert_user.name]: http://localhost:8888/ssm_struts2_annotation/user/insert?user.name=
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_20_color_FFFFFF_t_70_g_se_x_16 17]: https://img-blog.csdnimg.cn/594ce57aa2be4fcaa1b04e524cc46501.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBAQ29kZXJfQ3Vp_size_12_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/ccefa2c0366d4c3b995ef26ce0418aaf.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ29kZXJfQ3Vp,size_12,color_FFFFFF,t_70,g_se,x_16