【SSM进阶学习系列丨整合篇】Spring+SpringMVC+MyBatis 框架配置详解

￡神魔★判官ぃ 2024-05-09 16:21 79阅读 0赞

![在这里插入图片描述][4299adc638f54354be9886fc1c6ffa82.png_pic_center]

#### 文章目录 ####

*  一、环境准备
 *   *  1.1、创建数据库和表
     *  1.2、导入框架依赖的jar包
     *  1.3、修改Maven的编译版本
     *  1.4、完善Maven目录
     *  1.5、编写项目需要的包
     *  1.6、编写实体、Mapper、Service
 *  二、配置MyBatis环境
 *   *  2.1、配置mybatis的主配置文件
     *  2.2、编写映射文件
     *  2.3、测试环境是否正确
 *  三、配置Spring环境
 *   *  3.1、编写主配置文件
     *  3.2、测试Spring环境是否正确
 *  四、Spring整合MyBaits框架
 *   *  4.1、定义数据库配置
     *  4.2、主配置文件中引入properties配置文件
     *  4.3、注册数据源
     *  4.4、定义事务管理器
     *  4.5、开启事务的注解驱动支持
     *  4.6、配置SqlSessionFactoryBean
     *  4.7、配置自动扫描所有 Mapper 接口和文件
     *  4.8、测试
 *  五、配置SpringMVC环境
 *   *  5.1、主配置文件
     *  5.2、web.xml配置前端控制器
 *  六、Spring集成SpringMVC环境

![在这里插入图片描述][8eef2f980a154a09b859a9596f337547.png]

## 一、环境准备 ##

### 1.1、创建数据库和表 ###

create database ssm;
    
    use ssm;
    
    create table t_account(
    	id int primary key auto_increment,
      	name varchar(30),
      	age int,
      	balance int
    );
    
    insert into t_account values(default,'HelloWorld',23,100);

### 1.2、导入框架依赖的jar包 ###

由于我们整合的是SpringMVC、Spring和MyBatis，所以需要将这三个框架所需要的jar包导入到项目中。注意：由于要连接数据库，所以仍需要数据库驱动包。

**注意：MyBatis框架和Spring框架整合需要一个mybatis-spring的jar包，该jar包的作用是两个框架的转换包。**

<dependencies>
       
       <dependency>
           <groupId>org.mybatis</groupId>
           <artifactId>mybatis</artifactId>
           <version>3.5.3</version>
       </dependency>
    
       
       <dependency>
          	<groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
       </dependency>
      
      	
        <dependency>
           	<groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.2.1.RELEASE</version>
        </dependency>
    
        
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.4</version>
        </dependency>
    
        
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.2.1.RELEASE</version>
        </dependency>
      
       	
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-jdbc</artifactId>
          <version>5.2.1.RELEASE</version>
        </dependency>
      
      	
      	<dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-web</artifactId>
          <version>5.2.1.RELEASE</version>
        </dependency>
    
        
        <dependency>
          <groupId>org.springframework</groupId>
          <artifactId>spring-webmvc</artifactId>
          <version>5.2.1.RELEASE</version>
        </dependency>
      	
      	
        <dependency>
          <groupId>com.fasterxml.jackson.core</groupId>
          <artifactId>jackson-core</artifactId>
          <version>2.9.5</version>
        </dependency>
        <dependency>
          <groupId>com.fasterxml.jackson.core</groupId>
          <artifactId>jackson-annotations</artifactId>
          <version>2.9.5</version>
        </dependency>
        <dependency>
          <groupId>com.fasterxml.jackson.core</groupId>
          <artifactId>jackson-databind</artifactId>
          <version>2.9.5</version>
        </dependency>
      
      	
        <dependency>
              <groupId>javax.servlet</groupId>
              <artifactId>javax.servlet-api</artifactId>
              <version>3.1.0</version>
              <scope>provided</scope>
        </dependency>
      
      	
      	<dependency>
          <groupId>javax.servlet</groupId>
          <artifactId>jstl</artifactId>
          <version>1.2</version>
        </dependency>
      
      	
        <dependency>
          <groupId>commons-fileupload</groupId>
          <artifactId>commons-fileupload</artifactId>
          <version>1.3.1</version>
        </dependency>
        <dependency>
          <groupId>commons-io</groupId>
          <artifactId>commons-io</artifactId>
          <version>2.4</version>
      	</dependency>
    	
      	 
         <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
         </dependency>
      
      	
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.2.1.RELEASE</version>
            <scope>test</scope>
        </dependency>
      
      	
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
      
    	
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.3</version>
        </dependency>
      
      	
      	<dependency>
          <groupId>com.alibaba</groupId>
          <artifactId>druid</artifactId>
          <version>1.1.21</version>
        </dependency>
    </dependencies>

### 1.3、修改Maven的编译版本 ###

### 1.4、完善Maven目录 ###

![在这里插入图片描述][bb150a11e0304d528e8ad0c0bf373252.png]

### 1.5、编写项目需要的包 ###

cn.bdqn.domain
    cn.bdqn.mapper
    cn.bdqn.service
    cn.bdqn.controller
    cn.bdqn.utils
    cn.bdqn.exception

### 1.6、编写实体、Mapper、Service ###

public class Account {
                
                                  
        private int id;           
                                  
        private String name;      
                                  
        private Integer age;      
                                  
        private Integer balance; 
    
    	// 生成get和set方法、toString方法
    }

public interface AccountMapper {
        
        
        // 查询所有的账号
        public List<Account> selectAll();
     
        // 保存账号
        public void insert(Account account);
    }

public interface AccountService {
        
    
        // 查询所有账号
        public List<Account> queryAll();
    
        // 保存账号
        public void save(Account account);
    }

public class AccountServiceImpl implements AccountService {
        
    
        // 查询全部账号
        public List<Account> queryAll() {
        
    
            System.out.println("查询全部账号");
            return null;
        }
    
        // 保存账号
        public void save(Account account) {
        
            System.out.println("保存账号");
        }
    }

## 二、配置MyBatis环境 ##

### 2.1、配置mybatis的主配置文件 ###

主配置文件：mybaits-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>
        <typeAliases>
            
            <package name="cn.bdqn.domain"/>
        </typeAliases>
    
        
        <environments default="mysql">
            
            <environment id="mysql">
                
                <transactionManager type="JDBC"></transactionManager>
                
                <dataSource type="POOLED">
                    
                    <property name="driver" value="com.mysql.jdbc.Driver"/>
                    <property name="url" value="jdbc:mysql:///ssm?allowMultiQueries=true"/>
                    <property name="username" value="root"/>
                    <property name="password" value="1234567"/>
                </dataSource>
            </environment>
        </environments>
    
        <mappers>
            <package name="cn.bdqn.mapper"/>
        </mappers>
    
    </configuration>

### 2.2、编写映射文件 ###

在resources目录下新建与mapper接口同名的目录。即：cn/bdqn/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="cn.bdqn.mapper.AccountMapper">
    
        
        <select id="selectAll" resultType="cn.bdqn.domain.Account">
            select
                id,name,age,balance
            from
                t_account
        </select>
        
        
        <insert id="insert">
            insert into t_account(name,age,balance) values (#{name},#{age},#{balance})
        </insert>
        
    </mapper>

### 2.3、测试环境是否正确 ###

@Test
        public void testMyBatis() throws Exception{
        
            InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
    
            SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(is);
    
            SqlSession session = ssf.openSession();
    
            AccountMapper accountMapper = session.getMapper(AccountMapper.class);
            List<Account> accounts = accountMapper.selectAll();
            System.out.println(accounts);
    
            is.close();
            session.close();
        }

## 三、配置Spring环境 ##

### 3.1、编写主配置文件 ###

注意：由于是SSM项目整合，在Spring主配置文件中配置扫描包的时候仅仅针对Service业务层、Mapper持久化层等注解的扫描，对于Web层，交由SpringMVC框架去处理。

### 3.2、测试Spring环境是否正确 ###

@Test
        public void testSpring() throws Exception{
        
    
            ApplicationContext ac = new ClassPathXmlApplicationContext("beans.xml");
    
            AccountService accountService = (AccountService) ac.getBean("accountService");
    
            System.out.println(accountService);
        }

## 四、Spring整合MyBaits框架 ##

注意：我们在配置MyBaits环境的时候，数据源配置在了MyBatis上，现在由于Spring整合MyBaits，则对于在MyBatis中配置的数据源要交给Spring去管理。在这里，我们用的阿里巴巴的数据源。

[官网][Link 1]

### 4.1、定义数据库配置 ###

定义db.properties数据库配置文件

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql:///ssm?allowMultiQueries=true
    jdbc.username=root
    jdbc.password=1234567

### 4.2、主配置文件中引入properties配置文件 ###

<context:property-placeholder location="classpath:db.properties"/>

### 4.3、注册数据源 ###

### 4.4、定义事务管理器 ###

### 4.5、开启事务的注解驱动支持 ###

<tx:annotation-driven transaction-manager="transactionManager"/>

### 4.6、配置SqlSessionFactoryBean ###

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
      	<property name="dataSource" ref="dataSource" />
    </bean>

### 4.7、配置自动扫描所有 Mapper 接口和文件 ###

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="cn.bdqn.mapper"/>
    </bean>

### 4.8、测试 ###

@Test
        public void testSpringAndMyBatis() throws Exception{
        
            ApplicationContext ac =  new ClassPathXmlApplicationContext("beans.xml");
    
            AccountService accountService = (AccountService) ac.getBean("accountService");
    
            List<Account> accounts = accountService.queryAll();
    
            System.out.println(accounts);
        }

## 五、配置SpringMVC环境 ##

### 5.1、主配置文件 ###

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:mvc="http://www.springframework.org/schema/mvc"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mv="http://www.springframework.org/schema/mvc"
           xsi:schemaLocation="
            http://www.springframework.org/schema/beans
            https://www.springframework.org/schema/beans/spring-beans.xsd
            http://www.springframework.org/schema/mvc
            https://www.springframework.org/schema/mvc/spring-mvc.xsd
            http://www.springframework.org/schema/context
            https://www.springframework.org/schema/context/spring-context.xsd">
    
        
        <context:component-scan base-package="cn.bdqn" use-default-filters="false">
            <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
    
        
        <bean id="viewResolver"
              class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            <property name="prefix" value="/WEB-INF/jsp/"/>
            <property name="suffix" value=".jsp"/>
        </bean>
    
        <mvc:annotation-driven/>
    </beans>

### 5.2、web.xml配置前端控制器 ###

<?xml version="1.0" encoding="utf-8"?>
    <web-app xmlns="http://java.sun.com/xml/ns/javaee"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
                          http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
             version="3.0">
    
      <servlet>
        <servlet-name>frontDispatcherServlet</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>frontDispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
      </servlet-mapping>
    </web-app>

## 六、Spring集成SpringMVC环境 ##

在web.xml文件中配置。

<listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    
    
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:beans.xml</param-value>
    </context-param>

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

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

[4299adc638f54354be9886fc1c6ffa82.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/09/fdbc46ef2d55402cadc15fb11509e751.png
[8eef2f980a154a09b859a9596f337547.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/09/c900142d7fbe42aaa3d43b175f9538cd.png
[bb150a11e0304d528e8ad0c0bf373252.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/09/fb8b27128a6b4036b99f22f54c0911e5.png
[Link 1]: http://mybatis.org/spring/zh/index.html
[c90d48c8a3714dfcaa96f382b15394ba.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/09/bc67569f84f54cbc945cf6440806e69c.png