如何Spring整合mybatis？（实例）

今天药忘吃喽~ 2021-09-09 05:50 304阅读 0赞

Spring差不多过了一遍，现在尝试如何把spring和mybatis整合起来，下面实例演示一下：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDEwNzE0MA_size_16_color_FFFFFF_t_70][]

用到的数据库表：

![20210730133421801.png][]

>  先在项目的pom.xml下添加相关的依赖

<?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">
        <parent>
            <artifactId>spring-study</artifactId>
            <groupId>com.ys</groupId>
            <version>1.0-SNAPSHOT</version>
        </parent>
        <modelVersion>4.0.0</modelVersion>
    
        <artifactId>spring-11-mybatis2</artifactId>
    
        <dependencies>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.5.6</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.17</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>5.2.12.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>5.0.9.RELEASE</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.9.7</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>2.0.6</version>
            </dependency>
    
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.18.20</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.13.2</version>
                <scope>test</scope>
            </dependency>
        </dependencies>
    
        <build>
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties </include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>
    
    
    </project>

>  写pojo包下的实体类：

@Data
    public class Animal {
        private int id;
        private String name;
    }

>  写dao包下的接口：

public interface AnimalDao {
        List<Animal> getAnimals();
    }

>  写接口对应的mapper.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.ys.dao.AnimalDao">
        <select id="getAnimals" resultType="com.ys.pojo.Animal">
            select * from animal;
        </select>
    
    </mapper>

> 写resources下的总配置文件spring-dao.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:aop="http://www.springframework.org/schema/aop"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
            https://www.springframework.org/schema/beans/spring-beans.xsd">
    
        
        <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
            <property name="url"
                      value="jdbc:mysql://localhost:3306/ems?useSSL=FALSE&serverTimezone=Asia/Shanghai"/>
            <property name="username" value="root"/>
            <property name="password" value="root"/>
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"/>
            
            <property name="configLocation" value="classpath:mybatis-config.xml"/>
            
            <property name="mapperLocations" value="classpath:com/ys/dao/*.xml"/>
        </bean>
    
        
        <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
            
            <constructor-arg index="0" ref="sqlSessionFactory"/>
        </bean>
    
        <bean id="animaldao" class="com.ys.dao.AnimalDaoIImpl">
            <property name="sqlSession" ref="sqlSession"/>
        </bean>
    </beans>

由于我们已经把mybatis的配置都写到spring配置文件中了，所以mybatis-config.xml里面就暂时没有什么内容了，可以暂时不要它

> 写接口的实现类

package com.ys.dao;
    
    import com.ys.pojo.Animal;
    import org.mybatis.spring.SqlSessionTemplate;
    
    import java.util.List;
    
    public class AnimalDaoIImpl implements AnimalDao {
        private SqlSessionTemplate sqlSession;
    
        public void setSqlSession(SqlSessionTemplate sqlSession) {
            this.sqlSession = sqlSession;
        }
        @Override
        public List<Animal> getAnimals() {
            AnimalDao mapper = sqlSession.getMapper(AnimalDao.class);
            return mapper.getAnimals();
        }
    }

>  测试

@org.junit.Test
        public void test1() {
            ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("spring-dao.xml");
            AnimalDaoIImpl animaldao = context.getBean("animaldao", AnimalDaoIImpl.class);
            for (Animal animal : animaldao.getAnimals()) {
                System.out.println(animal);
            }
        }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDEwNzE0MA_size_16_color_FFFFFF_t_70 1][]

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

**整合方式2**

> 再写一个上面接口对应的实现类

//继承SqlSessionDaoSupport类，直接可以获得SqlSession对象
    public class AnimalDaoImpl2 extends SqlSessionDaoSupport implements AnimalDao {
        @Override
        public List<Animal> getAnimals() {
            SqlSession sqlSession = getSqlSession();
            AnimalDao mapper = sqlSession.getMapper(AnimalDao.class);
            return mapper.getAnimals();
        }
    }

> 给上面的实现类注册bean

> 测试

@org.junit.Test
        public void test1() {
            ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("spring-dao.xml");
            AnimalDaoImpl2 animaldao2 = context.getBean("animaldao2", AnimalDaoImpl2.class);
            for (Animal animal : animaldao2.getAnimals()) {
                System.out.println(animal);
            }
        }

结果同上！

> **总结：**
> 
> **spring-mybatis整合步骤：**
> 
> 1.  编写数据源配置
> 2.  sqlSessionFactory
> 3.  sqlSessionTemplate
> 4.  给接口写实现类
> 5.  将接口的实现类注册到spring中
> 6.  运行调试

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDEwNzE0MA_size_16_color_FFFFFF_t_70]: /images/20210813/40276abaac80492295c166099abea122.png
[20210730133421801.png]: /images/20210813/555eadf4327544288735d6b6efbae056.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDEwNzE0MA_size_16_color_FFFFFF_t_70 1]: /images/20210813/5693fbc45b1648bd84c2a2c32b80b4da.png