【SSM】Spring + SpringMVC +MyBatis 框架整合

个人简介：Java领域新星创作者；阿里云技术博主、星级博主、专家博主；正在Java学习的路上摸爬滚打，记录学习的过程~
个人主页：.29.的博客
学习社区：进去逛一逛~

一、导入相关依赖

---

pom.xml配置文件：

• 打包方式：war

<?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.haojin.ssm</groupId><artifactId>ssm</artifactId><version>1.0-SNAPSHOT</version><packaging>war</packaging><properties><maven.compiler.source>8</maven.compiler.source><maven.compiler.target>8</maven.compiler.target><spring.version>5.3.1</spring.version></properties><dependencies><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-beans</artifactId><version>${spring.version}</version></dependency><!--springmvc--><dependency><groupId>org.springframework</groupId><artifactId>spring-web</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-aspects</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId><version>${spring.version}</version></dependency><!-- Mybatis核心 --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.5.7</version></dependency><!--mybatis和spring的整合包--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>2.0.6</version></dependency><!-- 连接池 --><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>1.0.9</version></dependency><!-- junit测试 --><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.12</version><scope>test</scope></dependency><!-- MySQL驱动 --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.31</version></dependency><!-- log4j日志 --><dependency><groupId>log4j</groupId><artifactId>log4j</artifactId><version>1.2.17</version></dependency><!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper --><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper</artifactId><version>5.2.0</version></dependency><!-- 日志 --><dependency><groupId>ch.qos.logback</groupId><artifactId>logback-classic</artifactId><version>1.2.3</version></dependency><!-- ServletAPI --><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>3.1.0</version><scope>provided</scope></dependency><dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-databind</artifactId><version>2.12.1</version></dependency><dependency><groupId>commons-fileupload</groupId><artifactId>commons-fileupload</artifactId><version>1.3.1</version></dependency><!-- Spring5和Thymeleaf整合包 --><dependency><groupId>org.thymeleaf</groupId><artifactId>thymeleaf-spring5</artifactId><version>3.0.12.RELEASE</version></dependency></dependencies></project>

二、配置web.xml文件

---

• web.xml文件所在目录：*\src\main\webapp\WEB-INF\web.xml

配置目录：
1.spring的编码过滤器；
2.处理请求方式的过滤器；
3.SpringMVC的前端控制器DispatcherServlet；
4.自定义springmvc配置文件的名称与位置；
5.将DispatcherServlet的初始化时间提前到服务器启动前；
6.spring监听器，在服务器启动时加载spring的配置文件；
7.自定义spring配置文件的名称与位置；

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"><!--配置spring的编码过滤器--><filter><filter-name>CharacterEncodingFilter</filter-name><filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class><init-param>  <!--配置encoding，设置请求的编码为utf-8--><param-name>encoding</param-name><param-value>utf-8</param-value></init-param><init-param> <!--forceEncoding设置为true，使得响应的编码也能配置--><param-name>forceEncoding</param-name><param-value>true</param-value></init-param></filter><filter-mapping><filter-name>CharacterEncodingFilter</filter-name><url-pattern>/*</url-pattern></filter-mapping><!--配置处理请求方式的过滤器--><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><!--配置SpringMVC的前端控制器DispatcherServlet--><servlet><servlet-name>SpringMVC</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><!--设置springmvc配置文件自定义的位置和名称--><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:springmvc.xml</param-value></init-param><!--将DispatcherServlet的初始化时间提前到服务器启动前--><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>SpringMVC</servlet-name><url-pattern>/</url-pattern></servlet-mapping><!--配置spring监听器，在服务器启动时加载spring的配置文件--><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><!--配置spring配置文件自定义的位置和名称--><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:spring.xml</param-value></context-param>
</web-app>

三、SpringMVC配置文件

---

• SpringMVC配置文件的位置：Maven工程下的resources目录

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 https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd"><!--配置扫描控制层的组件--><context:component-scan base-package="com.haojin.ssm.controller"/><!--配置Thymeleaf的视图解析器--><bean id="viewResolver" class="org.thymeleaf.spring5.view.ThymeleafViewResolver"><property name="order" value="1"/><property name="characterEncoding" value="UTF-8"/><property name="templateEngine"><bean class="org.thymeleaf.spring5.SpringTemplateEngine"><property name="templateResolver"><bean class="org.thymeleaf.spring5.templateresolver.SpringResourceTemplateResolver"><!-- 视图前缀 --><property name="prefix" value="/WEB-INF/templates/"/><!-- 视图后缀 --><property name="suffix" value=".html"/><property name="templateMode" value="HTML5"/><property name="characterEncoding" value="UTF-8" /></bean></property></bean></property></bean><!--配置默认的servlet处理静态资源--><mvc:default-servlet-handler /><!--开启mvc框架的注解驱动--><mvc:annotation-driven /><!--配置视图控制器--><mvc:view-controller path="/" view-name="index"></mvc:view-controller><!--配置文件上传解析器--><bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"/>
</beans>

• 配置文件中配置了扫描的包：com.haojin.ssm.controller

• 配置文件中视图控制器所配置的视图：index.html

四、搭建MyBatis环境

---

⚪属性文件jdbc.properties

属性文件jdbc.properties中存放的是用于连接数据库的相关属性：

jdbc.username=root
jdbc.password=abc123
jdbc.url=jdbc:mysql://localhost:3306/ssm?serverTimezone=UTC
jdbc.driver=com.mysql.cj.jdbc.Driver

---

⚪MyBatis核心配置文件

• MyBatis的核心配置文件通常命名为：mybatis-config.xml:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration><!--引入外部文件：jdbc.properties--><properties resource="jdbc.properties"/><!--设置mybatis全局配置--><settings><!-- mapUnderscoreToCamelCase(默认为false) 下划线自动映射为驼峰 —— t_emp映射为tEmp --><setting name="mapUnderscoreToCamelCase" value="true"/><!--lazyLoadingEnabled：开启延迟加载--><setting name="lazyLoadingEnabled" value="true"/><!----></settings><!--设置类型别名--><typeAliases><package name="com.haojin.mybatis.pojo"/></typeAliases><plugins><!--配置分页插件--><plugin interceptor="com.github.pagehelper.PageInterceptor" ></plugin></plugins><!--配置连接数据库的相关环境--><environments default="development"><environment id="development"><transactionManager type="JDBC"/><dataSource type="POOLED"><property name="driver" value="${jdbc.driver}"/><property name="url" value="${jdbc.url}"/><property name="username" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/></dataSource></environment></environments><!--配置映射文件--><mappers><package name="com.haojin.mybatis.mapper"/></mappers></configuration>

---

⚪创建Mapper接口 + Mapper映射文件

注意：

1. 映射文件的属性 namespace 要和mapper接口的 全类名 保持一致
2. 映射文件中，SQL语句的 id 与mapper接口中的 方法名 保持一致

Mapper接口 EmployeeMapper:

/*** @author .29.* @create 2023-03-15 15:49*/
public interface EmployeeMapper {List<Employee> getEmployeeList();
}

Mapper映射文件 EmployeeMapper.xml：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namespace属性与mapper接口全类名保持一致-->
<mapper namespace="com.haojin.ssm.mapper.EmployeeMapper"><!--SQL语句的id与mapper接口中的方法名保持一致--><!--查询功能的标签，必须设置 resultType 或 resultMap- resultType： 设置默认的映射关系- resultMap： 设置自定义的映射关系--><!--List<Employee> getEmployeeList();--><select id="getEmployeeList" resultType="Employee">select * from t_emp;</select></mapper>

---

⚪日志文件log4j.xml

在导入依赖时，我们导入了Log4j日志框架，所以需要配置其核心配置文件：log4j.xml。

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"><log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"><appender name="STDOUT" class="org.apache.log4j.ConsoleAppender"><param name="Encoding" value="UTF-8"/><layout class="org.apache.log4j.PatternLayout"><param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS}
%m (%F:%L) \n"/></layout></appender><logger name="java.sql"><level value="debug"/></logger><logger name="org.apache.ibatis"><level value="info"/></logger><root><level value="debug"/><appender-ref ref="STDOUT"/></root>
</log4j:configuration>

五、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: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 https://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.haojin.ssm"><context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/></context:component-scan><!--引入外部配置文件jdbc.properties--><context:property-placeholder location="classpath:jdbc.properties"/><!--配置数据源--><bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"><property name="url" value="${jdbc.url}"></property><property name="username" value="${jdbc.username}"></property><property name="password" value="${jdbc.password}"></property><property name="driverClassName" value="${jdbc.driver}"></property></bean><!--配置事务管理器--><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><!--引用数据源--><property name="dataSource" ref="dataSource"></property></bean><!--开启事务注解驱动:将使用@Transactional表示的方法或类中的所有方法进行事务管理--><tx:annotation-driven transaction-manager="transactionManager"/><!--配置SqlSessionFactoryBean,可以直接从Spring的IOC容器中获取SqlSessionFactory对象--><bean class="org.mybatis.spring.SqlSessionFactoryBean"><!--配置MyBatis核心配置文件的路径--><property name="configLocation" value="classpath:mybatis-config.xml"></property><!--设置数据源，这里通过spring设置，mybatis-config.xml中的相关配置可删除--><property name="dataSource" ref="dataSource"></property><!--设置类型别名类似的包--><property name="typeAliasesPackage" value="com.haojin.ssm.pojo"></property><!--设置映射文件路径，只有映射文件的包和mapper接口的包不一致时需要设置--><!--<property name="mapperLocations" value="classpath:mappers/*.xml"></property>--></bean><!--配置mapper接口扫描，通过SqlSession创建基础包中所有mapper接口的代理实现类对象并交给IOC管理--><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!--设置基础包--><property name="basePackage" value="com.haojin.ssm.mapper"></property></bean></beans>

---