Spring整合Mybatis（狂神）

Dear 丶 2023-10-04 22:31 45阅读 0赞

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

*  步骤
 *   *  导入相关jar包
 *  回忆mybatis
 *   *  1、编写pojo实体类
     *  2、编写实现mybatis的配置文件
     *  3、编写UserMapper接口
     *  4、编写UserMapper.xml文件
     *  5、测试
 *  Mybatis-Spring
 *   *  整合实现一：
     *   *  1、引入Spring配置文件spring-dao.xml
         *  2、配置数据源替换mybaits的数据源
         *  3、配置SqlSessionFactory，关联MyBatis
         *  4、注册sqlSessionTemplate，关联sqlSessionFactory
         *  5、需要UserMapper接口的UserMapperImpl 实现类，私有化sqlSessionTemplate
         *  6、将自己写的实现类，注入到Spring配置文件中。
         *  7、测试使用即可！
     *  整合实现二：

## 步骤 ##

### 导入相关jar包 ###

*  junit
 *  mybatis
 *  mysql数据库
 *  spring相关
 *  aop织入器
 *  mybatis-spring整合包【重点】在此还导入了lombok包。
 *  配置Maven静态资源过滤问题！

<dependencies>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.5.6</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.47</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>5.2.0.RELEASE</version>
            </dependency>
            
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>5.2.0.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.8.13</version>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>2.0.2</version>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.18.10</version>
            </dependency>
        </dependencies>
    
        <build>
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>true</filtering>
                </resource>
        </build>

2、编写配置文件  
3、测试

## 回忆mybatis ##

### 1、编写pojo实体类 ###

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

### 2、编写实现mybatis的配置文件 ###

<?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="com.kuang.pojo"/>
       </typeAliases>
    
       <environments default="development">
           <environment id="development">
               <transactionManager type="JDBC"/>
               <dataSource type="POOLED">
                   <property name="driver" value="com.mysql.jdbc.Driver"/>
                   <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=utf8"/>
                   <property name="username" value="root"/>
                   <property name="password" value="123456"/>
               </dataSource>
           </environment>
       </environments>
    
       <mappers>
           <package name="com.kuang.dao"/>
       </mappers>
    </configuration>

### 3、编写UserMapper接口 ###

public interface UserMapper {
        
        public List<User> selectUser();
    }

### 4、编写UserMapper.xml文件 ###

<?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="com.kuang.mapper.UserMapper">
    
        
        <select id="selectUser" resultType="user">
            select * from mybatis.user
        </select>
    </mapper>

### 5、测试 ###

@Test
    public void selectUser() throws IOException {
        
    
       String resource = "mybatis-config.xml";
       InputStream inputStream = Resources.getResourceAsStream(resource);
       SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
       SqlSession sqlSession = sqlSessionFactory.openSession();
    
       UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    
       List<User> userList = mapper.selectUser();
       for (User user: userList){
        
           System.out.println(user);
      }
    
       sqlSession.close();
    }

## Mybatis-Spring ##

**什么是MyBatis-Spring？**

MyBatis-Spring 会帮助你将 MyBatis 代码无缝地整合到 Spring 中。

文档链接：[http://mybatis.org/spring/zh/index.html][http_mybatis.org_spring_zh_index.html]

如果使用 Maven 作为构建工具，仅需要在 pom.xml 中加入以下代码即可：

<dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>2.0.2</version>
            </dependency>

### 整合实现一： ###

#### 1、引入Spring配置文件spring-dao.xml ####

<?xml version="1.0" encoding="GBK"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
            https://www.springframework.org/schema/beans/spring-beans.xsd
    
    </beans>

#### 2、配置数据源替换mybaits的数据源 ####

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8"/>
            <property name="username" value="root"/>
            <property name="password" value="123456"/>
        </bean>

#### 3、配置SqlSessionFactory，关联MyBatis ####

<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/kuang/mapper/*.xml"/>
        </bean>

#### 4、注册sqlSessionTemplate，关联sqlSessionFactory ####

<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
            
            <constructor-arg index="0" ref="sqlSessionFactory" />
        </bean>

#### 5、需要UserMapper接口的UserMapperImpl 实现类，私有化sqlSessionTemplate ####

public class UserMapperImpl implements UserMapper {
        
    
        //我们的所有操作，都使用sqlSession来执行，在原来，现在都使用SqlsessionTemplate
        private SqlSessionTemplate sqlSession;
    
        public void setSqlSession(SqlSessionTemplate sqlSession) {
        
            this.sqlSession = sqlSession;
        }
    
        public List<User> selectUser() {
        
            UserMapper mapper = sqlSession.getMapper(UserMapper.class);
            return mapper.selectUser();
        }
    }

#### 6、将自己写的实现类，注入到Spring配置文件中。 ####

#### 7、测试使用即可！ ####

@Test
        public void test () throws IOException {
        
    
            ApplicationContext context = new ClassPathXmlApplicationContext("spring-dao.xml");
            
            UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
            for (User user : userMapper.selectUser()) {
        
                System.out.println(user);
            }
        }

结果成功输出！现在我们的Mybatis配置文件的状态！发现都可以被Spring整合！

<?xml version="1.0" encoding="GBK" ?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    
    <configuration>
        
        <typeAliases>
            <package name="com.kuang.pojo"/>
        </typeAliases>
    </configuration>

### 整合实现二： ###

mybatis-spring1.2.3版以上的才有这个，官方文档截图：

dao继承Support类 , 直接利用 getSqlSession() 获得 , 然后直接注入SqlSessionFactory . 比起整合方式一 , 不需要管理SqlSessionTemplate , 而且对事务的支持更加友好 . 可跟踪源码查看。  
![在这里插入图片描述][10b6d169d6a74c0588e88adfd1b6fe1e.png]  
测试：

1、将我们上面写的UserMapperImpl修改一下

public class UserMapperImpl extends SqlSessionDaoSupport implements UserMapper {
        
    
        public List<User> selectUser() {
        
            
            return getSqlSession().getMapper(UserMapper.class).selectUser();
        }
    }

2、注入到Spring配置文件中。

3、测试

[http_mybatis.org_spring_zh_index.html]: http://mybatis.org/spring/zh/index.html
[10b6d169d6a74c0588e88adfd1b6fe1e.png]: https://img-blog.csdnimg.cn/10b6d169d6a74c0588e88adfd1b6fe1e.png