1. 背景

  • 需求
    • 利用 SSM(SpringMVC+Spring+Mybatis) 框架实现 account表 的“查询所有用户”和“保存用户”功能；
  • 环境
    • jdb 版本：jdk1.8.0_131；
    • IDE 工具：IntelliJ IDEA 2019.3 community；
    • Tomcat：apache-tomcat-9.0.21，利用插件 Smart Tomcat 与 IDE 的集成（社区版限制）；
    • Maven：apache-maven-3.6.1；
  • 思路：
    • 先撘 spring，然后撘 springmvc 并整合 spring + springmvc，再撘 mybatis 并整合 spring + mybatis，最终进行集成测试；

  • jar 包准备（配置 pom.xml）

    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    3. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    4. <modelVersion>4.0.0</modelVersion>
    6. <groupId>cn.tjufe</groupId>
    7. <artifactId>springmvc_1</artifactId>
    8. <version>1.0-SNAPSHOT</version>
    9. <packaging>war</packaging>
    11. <name>springmvc_1 Maven Webapp</name>
    12. <!-- FIXME change it to the project's website -->
    13. <url>http://www.example.com</url>
    15. <!--版本锁定-->
    16. <properties>
    17.   <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    18.   <maven.compiler.source>1.8</maven.compiler.source>
    19.   <maven.compiler.target>1.8</maven.compiler.target>
    20.   <spring.version>5.0.2.RELEASE</spring.version>
    21.   <slf4j.version>1.6.6</slf4j.version>
    22.   <log4j.version>1.2.12</log4j.version>
    23.   <mysql.version>5.1.6</mysql.version>
    24.   <mybatis.version>3.4.5</mybatis.version>
    25. </properties>
    27. <dependencies>
    28.   <!--1. spring相关的依赖包-->
    29.   <dependency>
    30.     <groupId>org.aspectj</groupId>
    31.     <artifactId>aspectjweaver</artifactId>
    32.     <version>1.6.8</version>
    33.   </dependency>
    34.   <dependency>
    35.     <groupId>org.springframework</groupId>
    36.     <artifactId>spring-aop</artifactId><!--spring切面-->
    37.     <version>${spring.version}</version>
    38.   </dependency>
    39.   <dependency>
    40.     <groupId>org.springframework</groupId>
    41.     <artifactId>spring-context</artifactId><!--spring上下文-->
    42.     <version>${spring.version}</version>
    43.   </dependency>
    44.   <dependency>
    45.     <groupId>org.springframework</groupId>
    46.     <artifactId>spring-web</artifactId><!--提供contextLoaderListener类实现spring+springmvc-->
    47.     <version>${spring.version}</version>
    48.   </dependency>
    49.   <dependency>
    50.     <groupId>org.springframework</groupId>
    51.     <artifactId>spring-webmvc</artifactId>
    52.     <version>${spring.version}</version>
    53.   </dependency>
    54.   <dependency>
    55.     <groupId>org.springframework</groupId>
    56.     <artifactId>spring-tx</artifactId><!--spring事务管理-->
    57.     <version>${spring.version}</version>
    58.   </dependency>
    59.   <dependency>
    60.     <groupId>org.springframework</groupId>
    61.     <artifactId>spring-jdbc</artifactId><!--spring操作数据库-->
    62.     <version>${spring.version}</version>
    63.   </dependency>
    64.   </dependency>
    65.   <!--2. springmvc相关依赖包-->
    66.   <dependency>
    67.     <groupId>javax.servlet</groupId>
    68.     <artifactId>servlet-api</artifactId>
    69.     <version>2.5</version>
    70.     <scope>provided</scope>
    71.   </dependency>
    72.   <dependency>
    73.     <groupId>javax.servlet.jsp</groupId>
    74.     <artifactId>jsp-api</artifactId>
    75.     <version>2.0</version>
    76.     <scope>provided</scope>
    77.   </dependency>
    78.   <dependency>
    79.     <groupId>jstl</groupId>
    80.     <artifactId>jstl</artifactId><!--JSP标准标签库-->
    81.     <version>1.2</version>
    82.   </dependency>
    83.   <!--3. mybatis相关的依赖包-->
    84.   <dependency>
    85.     <groupId>org.mybatis</groupId>
    86.     <artifactId>mybatis</artifactId>
    87.     <version>${mybatis.version}</version>
    88.   </dependency>
    89.   <dependency>
    90.     <groupId>org.mybatis</groupId>
    91.     <artifactId>mybatis-spring</artifactId><!--支持spring与mybatis集成-->
    92.     <version>1.3.0</version>
    93.   </dependency>
    94.   <dependency>
    95.     <groupId>c3p0</groupId>
    96.     <artifactId>c3p0</artifactId><!--数据连接池-->
    97.     <version>0.9.1.2</version>
    98.     <type>jar</type>
    99.     <scope>compile</scope>
    100.   </dependency>    
    101.   <!--4. spring单元测试-->
    102.   <dependency>
    103.     <groupId>org.springframework</groupId>
    104.     <artifactId>spring-test</artifactId>
    105.     <version>${spring.version}</version>
    106.     <scope>compile</scope>
    107.   </dependency>    
    108.   <dependency>
    109.     <groupId>junit</groupId>
    110.     <artifactId>junit</artifactId>
    111.     <version>4.12</version>
    112.     <scope>compile</scope>
    113.   </dependency>
    114.   <dependency>
    115.     <groupId>mysql</groupId>
    116.     <artifactId>mysql-connector-java</artifactId>
    117.     <version>${mysql.version}</version>
    118.   </dependency>
    119.   <!--5. 打印log-->
    120.   <dependency>
    121.     <groupId>log4j</groupId>
    122.     <artifactId>log4j</artifactId>
    123.     <version>${log4j.version}</version>
    124.   </dependency>
    125.   <dependency>
    126.     <groupId>org.slf4j</groupId>
    127.     <artifactId>slf4j-api</artifactId>
    128.     <version>${slf4j.version}</version>
    129.   </dependency>
    130.   <dependency>
    131.     <groupId>org.slf4j</groupId>
    132.     <artifactId>slf4j-log4j12</artifactId>
    133.     <version>${slf4j.version}</version>
    134.   </dependency>
    135.   <!--6. json解析-->
    136.   <dependency>
    137.     <groupId>com.fasterxml.jackson.core</groupId>
    138.     <artifactId>jackson-databind</artifactId>
    139.     <version>2.9.0</version>
    140.   </dependency>
    141.   <dependency>
    142.     <groupId>com.fasterxml.jackson.core</groupId>
    143.     <artifactId>jackson-core</artifactId>
    144.     <version>2.9.0</version>
    145.   </dependency>
    146.   <dependency>
    147.     <groupId>com.fasterxml.jackson.core</groupId>
    148.     <artifactId>jackson-annotations</artifactId>
    149.     <version>2.9.0</version>
    150.   </dependency>
    151. </dependencies>
    153. <build>
    154.   <finalName>springmvc_day01_01_start</finalName>
    155.   <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
    156.     <plugins>
    157.       <plugin>
    158.         <artifactId>maven-clean-plugin</artifactId>
    159.         <version>3.0.0</version>
    160.       </plugin>
    161.       <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
    162.       <plugin>
    163.         <artifactId>maven-resources-plugin</artifactId>
    164.         <version>3.0.2</version>
    165.       </plugin>
    166.       <plugin>
    167.         <artifactId>maven-compiler-plugin</artifactId>
    168.         <version>3.7.0</version>
    169.       </plugin>
    170.       <plugin>
    171.         <artifactId>maven-surefire-plugin</artifactId>
    172.         <version>2.20.1</version>
    173.       </plugin>
    174.       <plugin>
    175.         <artifactId>maven-war-plugin</artifactId>
    176.         <version>3.2.0</version>
    177.       </plugin>
    178.       <plugin>
    179.         <artifactId>maven-install-plugin</artifactId>
    180.         <version>2.5.2</version>
    181.       </plugin>
    182.       <plugin>
    183.         <artifactId>maven-deploy-plugin</artifactId>
    184.         <version>2.8.2</version>
    185.       </plugin>
    186.     </plugins>
    187.   </pluginManagement>
    188. </build>
    189. </project>

    2. 实现

  • 目录安排

mvc1.png

2.1 配置一：springmvc 与 spring 整合

  • 需要配置 springmvc.xml、applicationContext.xml 和 web.xml，并在 web.xml 配置 springmvc.xml 和 applicationContext.xml 的匹配路径；

  • 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-4.1.xsd
     http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd">

  <!-- 包扫描 -->
  <context:component-scan base-package="cn.tjufe">
      <!--只扫描 controller 下的包-->
      <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  </context:component-scan>

  <!-- 视图解析器对象-->
  <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
      <property name="prefix" value="/WEB-INF/pages/"></property>
      <property name="suffix" value=".jsp"></property>
  </bean>

  <!--设置静态资源过滤器，哪些静态资源不拦截-->
  <mvc:resources mapping="/js/**" location="/js/"/>
  <mvc:resources mapping="/css/**" location="/css/"/>
  <mvc:resources mapping="/images/**" location="/images/"/>

  <!--开启 SpringMVC 框架注解的支持-->
  <mvc:annotation-driven/>
</beans>

  • applicationContext.xml（后续与 mybatis 的再补充）

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

  <!--开启注解的扫描,只处理 dao 和 service，controller 交给 springmvc.xml-->
  <context:component-scan base-package="cn.tjufe">
      <!--配置哪些注解不扫描-->
      <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  </context:component-scan>

  <!--spring整合mybatis框架在2.2有补充-->
</beans>

  • web.xml（配置 springmvc.xml 和 applicationContext.xml）

    <?xml version="1.0" encoding="UTF-8"?>
<web-app>
<display-name>Archetype Created Web Application</display-name>
<!--配置解决中文乱码的过滤器-->
<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>
</filter>
<filter-mapping>
  <filter-name>characterEncodingFilter</filter-name>
  <url-pattern>/*</url-pattern>
</filter-mapping>

<!--1. 配置 spring 的监听器实现spring与springmvc整合，注意：默认加载路径为WEB-INF 下的 applicationContext.xml-->
<listener>
  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<context-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>classpath:applicationContext.xml</param-value><!--配置监听器的文件路径在系统路径下-->
</context-param>
<!--2. 配置dispatcherServlet并说明springmvc.xml的配置路径-->
<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:springmvc.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>
</web-app>

    2.2 配置二：mybatis 与 spring 整合

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

  <!--开启注解的扫描,只处理 dao 和 service，controller 交给 springmvc.xml-->
  <context:component-scan base-package="cn.tjufe">
      <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  </context:component-scan>

  <!--spring整合mybatis框架，实际上此部分有 SqlMapConfig.xml 和 MyTest.testMybatis 的东西整合而成-->
  <!--配置连接池，注意！！！！ property 的 name 不能修改，否则会使容器创建不成功-->
  <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
      <property name="driverClass" value="com.mysql.jdbc.Driver"/>
      <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/test_jdbc"/>
      <property name="user" value="root"/>
      <property name="password" value="1234"/>
  </bean>
  <!--配置SqlSessionFactory-->
  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
      <property name="dataSource" ref="dataSource"/>
  </bean>
  <!--配置AccountDao接口所在包-->
  <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
      <property name="basePackage" value="cn.tjufe.dao"/>
  </bean>

  <!--配置spring框架声明式事务管理-->
  <!--配置事务管理器-->
  <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="find" read-only="true"/>
          <tx:method name="*" isolation="DEFAULT"/>
      </tx:attributes>
  </tx:advice>
  <!--配置AOP增强-->
  <aop:config>
      <aop:advisor advice-ref="txAdvice" pointcut="execution(* cn.tjufe.Service.impl.*ServiceImpl.*(..))"/>
  </aop:config>
</beans>

    2.3 代码

    2.3.1 springmvc 相关代码

  • 示意图

mvc1.png

  • controller 代码
    • 注意：saveAccount 由于返回值为 void，所以需进行转发或重定向，否则会报错 ```java package cn.tjufe.controller;

import cn.tjufe.Service.IAccountService; import cn.tjufe.domain.Account2; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping;

import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.util.List;

@Controller @RequestMapping(“/account/“) public class AccountController {

@Autowired
private IAccountService accountService;//实现 service 的注入

@RequestMapping("findAllAccount")
public String findAllAccount(Model model){
    System.out.println("表现层：查询所有账户信息...");
    List<Account2> accounts = accountService.findAllAccount();
    model.addAttribute("accountList",accounts);
    return "success";
}

@RequestMapping("saveAccount")
public void saveAccount(Account2 account, HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    System.out.println("表现层：保存账户信息...");
    accountService.saveAccount(account);
    response.sendRedirect(request.getContextPath()+"/account/findAllAccount");
    return;
}

}


- union.jsp
```java
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
    <a href="account/findAllAccount">查询所有账户</a>
    <br/>
    <h3>保存账户</h3>
    <form action="account/saveAccount" method="post">
        用户ID: <input type="text" name="id"/><br/>
        姓名: <input type="text" name="name"/><br/>
        金额: <input type="text" name="money"/><br/>
        <input type="submit" value="保存"/>
    </form>
</body>
</html>

  • success.jsp

    <%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
  <title>Title</title>
</head>
<body>
  <h3>SSM 整合练习</h3>
  <h4>获取到所有账户信息</h4>
  <c:forEach items="${accountList}" var="account">
      ${account.name}
  </c:forEach>
</body>
</html>

    2.3.2 spring 代码+ mybatis 注解

  • 示意图

mvc1.png

  • service 层代码 ```java // service 接口 package cn.tjufe.Service;

import cn.tjufe.domain.Account2; import java.util.List;

public interface IAccountService {

public List<Account2> findAllAccount();
public void saveAccount(Account2 account);

} // serviceImpl package cn.tjufe.Service.impl;

import cn.tjufe.Service.IAccountService; import cn.tjufe.dao.AccountDao; import cn.tjufe.domain.Account2; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;

import java.util.List;

@Service(“accountService”) public class AccountServiceImpl implements IAccountService { @Autowired private AccountDao accountDao;//实现spring和mybatis整合之后，可将dao对象注入

@Override
public List<Account2> findAllAccount() {
    System.out.println("业务层: 查询所有账户信息...");
    return accountDao.findAllAccount();
}

@Override
public void saveAccount(Account2 account) {
    System.out.println("业务层: 保存账户信息...");
    accountDao.saveAccount(account);
}

}


- dao 层代码
```java
package cn.tjufe.dao;

import cn.tjufe.domain.Account2;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository("accountDao")
public interface AccountDao {
    /**
     * 查询所有账户
     */
    @Select("select * from account")
    public List<Account2> findAllAccount();

    /**
     * 保存账户信息
     */
    @Insert("insert into account(id,name,balance) values(#{id}, #{name}, #{balance})")
    public void saveAccount(Account2 account);
}

2.3 补充-其他配置内容

  • log.properties 的简单配置 ```java

    Set root category priority to INFO and its only appender to CONSOLE.

    log4j.rootCategory=INFO, CONSOLE debug info warn error fatal

    log4j.rootCategory=debug, CONSOLE, LOGFILE

Set the enterprise logger category to FATAL and its only appender to CONSOLE.

log4j.logger.org.apache.axis.enterprise=FATAL, CONSOLE

CONSOLE is set to be a ConsoleAppender using a PatternLayout.

log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout log4j.appender.CONSOLE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n

LOGFILE is set to be a File appender using a PatternLayout.

log4j.appender.LOGFILE=org.apache.log4j.FileAppender log4j.appender.LOGFILE.File=d:\axis.log log4j.appender.LOGFILE.Append=true log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout log4j.appender.LOGFILE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n ```

2.4 结果

  • 查询所有用户

mvc1.png

  • 保存用户

mvc1.png

2.5 异常记录

  • applicationContext.xml 中

mvc1.png
image.png

2.6 待优化

  • applicationContext.xml 中有关数据库的配置信息可单独写一个 properties 出来

image.png

3. 总结

  • 所谓的整合就是容器嵌套
  • 实现容器整合之后，才能实现bean的注入