ssm整合

• ①使用idea创建maven项目如图：

  

  接着按提示选择项目路径后点击finish即可。

• ②在src/main下新建分别java包（源代码路径）、resources包（资源路径）和test包（测试代码路径），并在File–>Project Structure–>Modules下分别进行设置，如图：

  

• ③在pom.xml导入支持ssm的相关依赖：

  <?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.ssm</groupId>
    <artifactId>demo</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>
  
    <name>demo Maven Webapp</name>
    <!-- FIXME change it to the project's website -->
    <url>http://www.example.com</url>
  
    <properties>
      <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
      <maven.compiler.source>1.7</maven.compiler.source>
      <maven.compiler.target>1.7</maven.compiler.target>
  
      <!--spring 版本号-->
      <spring.version>5.2.11.RELEASE</spring.version>
      <!--jackson 版本号-->
      <jackson.version>2.11.3</jackson.version>
    </properties>
  
    <dependencies>
      <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.11</version>
        <scope>test</scope>
      </dependency>
  
      <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
      </dependency>
  
      <!--spring 核心包-->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
      </dependency>
  
      <!-- Spring JDBC -->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${spring.version}</version>
      </dependency>
  
      <!-- Spring MVC -->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
      </dependency>
  
      <!-- 提供 Servlet 编译环境 -->
      <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>javax.servlet-api</artifactId>
        <version>4.0.1</version>
        <scope>provided</scope>
      </dependency>
  
      <!-- 提供 JSP 支持环境（自定义标签) -->
      <dependency>
        <groupId>javax.servlet.jsp</groupId>
        <artifactId>javax.servlet.jsp-api</artifactId>
        <version>2.3.1</version>
        <scope>provided</scope>
      </dependency>
  
      <!-- 提供 JSTL 支持 -->
      <dependency>
        <groupId>javax.servlet</groupId>
        <artifactId>jstl</artifactId>
        <version>1.2</version>
      </dependency>
  
      <!--Spring MVC 对 JSON 的支持需要依赖 jackson -->
      <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-annotations</artifactId>
        <version>${jackson.version}</version>
      </dependency>
  
      <dependency>
        <groupId>com.fasterxml.jackson.core</groupId>
        <artifactId>jackson-databind</artifactId>
        <version>${jackson.version}</version>
      </dependency>
  
      <!-- 启用校验支持 -->
      <dependency>
        <groupId>org.hibernate.validator</groupId>
        <artifactId>hibernate-validator</artifactId>
        <version>6.1.6.Final</version>
      </dependency>
  
      <!--lombok-->
      <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.12</version>
        <scope>provided</scope>
      </dependency>
  
      <!--mysql-->
      <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>6.0.6</version>
      </dependency>
  
      <!--阿里数据库连接池-->
      <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.21</version>
      </dependency>
  
      <!--mybatis-->
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.3</version>
      </dependency>
  
      <!--spring和mybatis的整合-->
      <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>2.0.5</version>
      </dependency>
  
      <!--AspectJ-->
      <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aspects</artifactId>
        <version>${spring.version}</version>
      </dependency>
  
    </dependencies>
  </project>

• ④编辑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">
  
    <!--字符编码过滤器:一定要在其它过滤器之前-->
    <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>
  
    <!--指定Spring容器的配置文件位置-->
    <context-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
  
    <!-- spring监听器 -->
    <listener>
      <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
  
    <!--指定SpringMVC容器的配置文件位置-->
    <!--配置前端控制器能拦截所有请求，并智能派发-->
    <!--这个前端控制器是一个servlet，应该在web.xml中配置这个servlet来拦截所有请求-->
    <servlet>
      <servlet-name>springMVC</servlet-name>
      <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
      <init-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:springMVC.xml</param-value>
      </init-param>
      <!--servlet启动加载，servlet原本是第一次访问就创建对象-->
      <!--load-on-startup表示服务器启动的时候创建对象，值越小优先级越高，越先创建对象-->
      <load-on-startup>1</load-on-startup>
    </servlet>
  
    <servlet-mapping>
      <servlet-name>springMVC</servlet-name>
      <!--/和/*都是拦截所有请求，但/*的范围更大，还会拦截到*.jsp这些请求，一旦拦截页面就无法显示-->
      <url-pattern>/</url-pattern>
    </servlet-mapping>
  
    <!-- 支持REST风格的过滤器：可以将POST请求转换为PUT或DELETE请求 -->
    <filter>
      <filter-name>HiddenHttpMethodFilter</filter-name>
      <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
    </filter>
    <filter-mapping>
      <filter-name>HiddenHttpMethodFilter</filter-name>
      <url-pattern>/*</url-pattern>
    </filter-mapping>
  </web-app>

  并按照其中的相关配置在resources文件夹下新建applicationContext.xml（Spring容器的配置文件）和springMVC.xml（springMVC的配置文件）。

• ⑤编辑springMVC.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:mvc="http://www.springframework.org/schema/mvc"
  
         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/mvc
         http://www.springframework.org/schema/mvc/spring-mvc.xsd
  ">
  
      <!--SpringMVC只扫描controller-->
      <context:component-scan base-package="com.ssm" use-default-filters="false">
          <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
          <context:include-filter type="annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice"/>
      </context:component-scan>
  
      <!--扫描静态资源-->
      <mvc:default-servlet-handler/>
      <!--扫描动态资源-->
      <mvc:annotation-driven/>
  
      <!--配置视图解析器-->
      <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
          <property name="prefix" value="/WEB-INF/pages/"/>
          <property name="suffix" value=".jsp"/>
      </bean>
  </beans>

• ⑥编辑applicationContext.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:p="http://www.springframework.org/schema/p"
         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">
  
      <!--Spring容器扫描除了控制器之外的所有组件-->
      <context:component-scan base-package="com.ssm">
          <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
      </context:component-scan>
  
      <!-- 读取类路径下的属性文件-->
      <!--spring整合mybatis-->
      <context:property-placeholder location="classpath:jdbc.properties"/>
  
      <!-- 使用 阿里提供的 Druid 组件来管理数据库连接 -->
      <!--配置连接池-->
      <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">
          <!-- 数据库基本信息配置 -->
          <property name="url" value="${jdbc.url}" />
          <property name="username" value="${jdbc.user}" />
          <property name="password" value="${jdbc.password}" />
          <property name="driverClassName" value="${jdbc.driver}" />
          <property name="filters" value="${druid.filters}" />
          <!-- 最大并发连接数 -->
          <property name="maxActive" value="${druid.maxActive}" />
          <!-- 初始化连接数量 -->
          <property name="initialSize" value="${druid.initialSize}" />
          <!-- 配置获取连接等待超时的时间 -->
          <property name="maxWait" value="${druid.maxWait}" />
          <!-- 最小空闲连接数 -->
          <property name="minIdle" value="${druid.minIdle}" />
          <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
          <property name="timeBetweenEvictionRunsMillis" value="${druid.timeBetweenEvictionRunsMillis}" />
          <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
          <property name="minEvictableIdleTimeMillis" value="${druid.minEvictableIdleTimeMillis}" />
          <property name="validationQuery" value="${druid.validationQuery}" />
          <property name="testWhileIdle" value="${druid.testWhileIdle}" />
          <property name="testOnBorrow" value="${druid.testOnBorrow}" />
          <property name="testOnReturn" value="${druid.testOnReturn}" />
          <property name="maxOpenPreparedStatements" value="${druid.maxOpenPreparedStatements}" />
          <!-- 1800 秒，也就是 30 分钟 -->
          <property name="removeAbandonedTimeout" value="${druid.removeAbandonedTimeout}" />
          <!-- 关闭 abanded 连接时输出错误日志 -->
          <property name="logAbandoned" value="${druid.logAbandoned}" />
      </bean>
  
      <!--配置spring框架声明式事务管理-->
      <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
          <property name="dataSource" ref="dataSource" />
      </bean>
  
      <!-- 为注解提供 事务管理器 支持-->
      <tx:annotation-driven transaction-manager="transactionManager"/>
  
      <!--配置使用mybatis来操作数据库-->
      <!-- 提供 SqlSessionFactoryBean 配置用来创建 SqlSessionFactory 对象  -->
      <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
          <!-- 指定Mybatis全局配置文件位置 -->
          <property name="configLocation" value="classpath:mybatis-config.xml"/>
          <!-- 注入数据库连接池 -->
          <property name="dataSource" ref="dataSource" />
          <!-- 执行xml映射文件位置 -->
          <property name="mapperLocations" value="classpath:mapper/*.xml" />
  
      </bean>
  
      <!-- 扫描Mapper接口所在的包(为相应的接口动态创建相应的实现类),即把接口的实现加入到ioc容器中 -->
      <bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
          <!-- 为 MapperScannerConfigurer 注入 sqlSessionFactory  -->
          <property name="sqlSessionFactoryBeanName" value="sessionFactory" />
          <!-- 扫描dao接口所在的包-->
          <property name="basePackage" value="com.ssm.dao" />
      </bean>
  </beans>

  在resources下新建数据源的配置文件jdbc.properties：

  jdbc.url =jdbc:mysql://127.0.0.1:3306/User?useUnicode=true&characterEncoding=UTF8&useSSL=true
  jdbc.driver = com.mysql.jdbc.Driver
  jdbc.user = root
  jdbc.password =<密码>
  
  druid.filters = stat
  druid.maxActive =20
  druid.initialSize = 1
  druid.maxWait = 60000
  druid.minIdle = 10
  druid.maxIdle = 15
  druid.timeBetweenEvictionRunsMillis = 60000
  druid.minEvictableIdleTimeMillis = 300000
  druid.validationQuery = SELECT 'x'
  druid.testWhileIdle = true
  druid.testOnBorrow = false
  druid.testOnReturn = false
  druid.maxOpenPreparedStatements = 20
  druid.removeAbandoned = true  
  druid.removeAbandonedTimeout = 1800
  druid.logAbandoned = true

• ⑦在resources下新建mybatis-config.xml并编辑：

  <?xml version="1.0" encoding="UTF-8" ?>
  <!DOCTYPE configuration
          PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
          "http://mybatis.org/dtd/mybatis-3-config.dtd">
  <configuration>
  
      <settings>
          <!--开启驼峰命名-->
          <setting name="mapUnderscoreToCamelCase" value="true"/>
      </settings>
  
  </configuration>

• ⑧整合测试，新建相关业务逻辑代码：

  

  User数据库的User表信息：

  

  相关业务逻辑代码信息：

  @Data
  @AllArgsConstructor
  @NoArgsConstructor
  public class User {
      private Integer id ;
      private String userName ;
      private String password ;
  }
  
  @Repository
  public interface UserDao {
      User getUserById(int id);
  }
  
  @Service
  public class UserService {
      @Autowired
      UserDao userDao;
  
      public User getUserById(Integer id){
          return userDao.getUserById(id);
      }
  }
  
  @RestController
  public class UserController {
  
      @Autowired
      UserService userService;
  
      @RequestMapping("/ssm")
      public User ssm(@RequestParam("id")Integer id){
          return userService.getUserById(id);
      }
  }

  resources/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">
  
  <!-- namespace 必须跟 UserMapper 接口的全限定名称一致 -->
  <mapper namespace="com.ssm.dao.UserDao">
  
      <!--User getUserById(int id);-->
      <select id="getUserById" resultType="com.ssm.bean.User" >
          SELECT * FROM t_users where id = #{id};
      </select>
  
  </mapper>

  紧接着配置tomcat：

  

启动项目后访问http://localhost:8080/ssm_war_exploded/ssm?id=1成功得到结果：