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

灰太狼 2023-10-08 20:12 65阅读 0赞

![在这里插入图片描述][8d8e0d8a542946af858489a536162608.gif_pic_center]

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

#### SSM框架整合 ####

*  一、导入相关依赖
 *  二、配置web.xml文件
 *  三、SpringMVC配置文件
 *  四、搭建MyBatis环境
 *   *  ⚪属性文件jdbc.properties
     *  ⚪MyBatis核心配置文件
     *  ⚪创建Mapper接口 + Mapper映射文件
     *  ⚪日志文件log4j.xml
 *  五、Spring配置文件

## 一、导入相关依赖 ##

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

`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>
            
            <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>
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.5.7</version>
            </dependency>
            
            <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>
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.31</version>
            </dependency>
            
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
            
            <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>
            
            <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>
            
            <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`

> ![在这里插入图片描述][af41b84cab054824a578173fc3d2fb31.png_pic_center]

**配置目录：**  
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">
    
        
        <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>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>
    
        
        <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>
            
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>SpringMVC</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>
    
        
        <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>
    </web-app>

## 三、SpringMVC配置文件 ##

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

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

> ![在这里插入图片描述][fe65f5bef459463198dfb4d287af844f.png_pic_center]

`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"/>
    
        
        <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>
    
        
        <mvc:default-servlet-handler />
    
        
        <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`

> ![在这里插入图片描述][5182425034624bb593ddae2c8d809a85.png_pic_center]

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

> ![在这里插入图片描述][96744f3f77504c5085ccd2cdf9632d19.png_pic_center]

## 四、搭建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 configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "https://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        
        
        <properties resource="jdbc.properties"/>
    
    
        
        <settings>
            
            <setting name="mapUnderscoreToCamelCase" value="true"/>
            
            <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 mapper
            PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
            "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
    
    <mapper namespace="com.haojin.ssm.mapper.EmployeeMapper">
    
        
    
        
    
        
        <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>
    
        
        <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>
        
        <tx:annotation-driven transaction-manager="transactionManager"/>
    
    
        
        <bean class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="configLocation" value="classpath:mybatis-config.xml"></property>
            
            <property name="dataSource" ref="dataSource"></property>
            
            <property name="typeAliasesPackage" value="com.haojin.ssm.pojo"></property>
            
            
        </bean>
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="basePackage" value="com.haojin.ssm.mapper"></property>
        </bean>
    
        
    </beans>

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

> ![在这里插入图片描述][78f6f44548ba41ceb2ef20d79e679db0.png_pic_center]
> 
> ![在这里插入图片描述][1d89257f1c0448f3a2090ed278ee0b0f.png_pic_center]
> 
> ![在这里插入图片描述][e834d8606f214a509c11654855bb3fb4.png_pic_center]

[![在这里插入图片描述][20a7f1b58dfb4660b75d7f021c157d57.png_pic_center]][20a7f1b58dfb4660b75d7f021c157d57.png_pic_center 1]

[8d8e0d8a542946af858489a536162608.gif_pic_center]: https://img-blog.csdnimg.cn/8d8e0d8a542946af858489a536162608.gif#pic_center
[.29.]: https://blog.csdn.net/ebb29bbe?spm=1018.2226.3001.5343
[Link 1]: https://bbs.csdn.net/forums/185241f773fb401b8ca7994dc3d02333?joinKey=cyru4ex9o7wq-mz6v1koj5x-1-add3ae8dc3827dbbd4360c79af92bbbe
[af41b84cab054824a578173fc3d2fb31.png_pic_center]: https://img-blog.csdnimg.cn/af41b84cab054824a578173fc3d2fb31.png#pic_center
[fe65f5bef459463198dfb4d287af844f.png_pic_center]: https://img-blog.csdnimg.cn/fe65f5bef459463198dfb4d287af844f.png#pic_center
[5182425034624bb593ddae2c8d809a85.png_pic_center]: https://img-blog.csdnimg.cn/5182425034624bb593ddae2c8d809a85.png#pic_center
[96744f3f77504c5085ccd2cdf9632d19.png_pic_center]: https://img-blog.csdnimg.cn/96744f3f77504c5085ccd2cdf9632d19.png#pic_center
[78f6f44548ba41ceb2ef20d79e679db0.png_pic_center]: https://img-blog.csdnimg.cn/78f6f44548ba41ceb2ef20d79e679db0.png#pic_center
[1d89257f1c0448f3a2090ed278ee0b0f.png_pic_center]: https://img-blog.csdnimg.cn/1d89257f1c0448f3a2090ed278ee0b0f.png#pic_center
[e834d8606f214a509c11654855bb3fb4.png_pic_center]: https://img-blog.csdnimg.cn/e834d8606f214a509c11654855bb3fb4.png#pic_center
[20a7f1b58dfb4660b75d7f021c157d57.png_pic_center]: https://img-blog.csdnimg.cn/20a7f1b58dfb4660b75d7f021c157d57.png#pic_center
[20a7f1b58dfb4660b75d7f021c157d57.png_pic_center 1]: https://blog.csdn.net/ebb29bbe?type=blog