【Java从0到架构师】Spring - 整合 MyBatis

末蓝、 2022-09-02 14:43 175阅读 0赞

### 整合 MyBatis ###

*  整合 MyBatis - 依赖
 *  整合 MyBatis - 数据源
 *  整合 MyBatis - SqlSessionFactoryBean
 *  整合 MyBatis - MapperScannerConfigurer
 *  完整配置文件

> Java 从 0 到架构师目录：[【Java从0到架构师】学习记录][Java_0]

> 学习 Spring 搭配这门课效果更好：[《孙哥说Spring5》学习笔记][Spring5]

Gitee 代码：[https://gitee.com/szluyu99/mj\_java\_frame/tree/master/02\_Spring/][https_gitee.com_szluyu99_mj_java_frame_tree_master_02_Spring]

> [【Spring 持久层】Spring 与 MyBatis 整合][Spring _Spring _ MyBatis]

# 整合 MyBatis - 依赖 #

Spring 整合 MyBatis 所需依赖：spring-jdbc、**mybatis-spring**

<dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>5.2.8.RELEASE</version>
    </dependency>
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>2.0.5</version>
    </dependency>

其他依赖：

*  必要：spring-context、mysql-connector-java、mybatis
 *  可选：logback-classic、druid

# 整合 MyBatis - 数据源 #

<context:property-placeholder location="db.properties"/>
    
    
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    	<property name="driverClassName" value="${jdbc.driverClass}"/>
    	<property name="url" value="${jdbc.url}"/>
    	<property name="username" value="${jdbc.username}"/>
    	<property name="password" value="${jdbc.password}"/>
    </bean>

数据源也可以使用：

*  Spring 的 DriverManagerDataSource
 *  MyBatis 的 PooledDataSource

这里配置的连接池，默认会自动提交事务

# 整合 MyBatis - SqlSessionFactoryBean #

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        
        <property name="dataSource" ref="dataSource"/>
        
        <property name="typeAliasesPackage" value="com.mj.domain"/>
        
        <property name="mapperLocations">
            <array>
                <value>mappers/*.xml</value>
            </array>
        </property>
    </bean>

# 整合 MyBatis - MapperScannerConfigurer #

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
        
        <property name="basePackage" value="com.mj.dao"/>
    </bean>

配置完后可以通过 getBean 方法获取 dao 的代理对象，bean 的 id 是 dao 类名的小驼峰形式

*  比如 com.mj.dao.SkillDao 的 id 是 skillDao

SkillDao dao = ctx.getBean("skillDao", SkillDao.class);

# 完整配置文件 #

[applicationContext.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" 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">
    
        
        <context:property-placeholder location="db.properties"/>
    
        
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="${jdbc.driverClass}"/>
            <property name="url" value="${jdbc.url}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
            
            <property name="typeAliasesPackage" value="com.mj.domain"/>
            
            <property name="mapperLocations">
                <array>
                    <value>mappers/*.xml</value>
                </array>
            </property>
        </bean>
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
            
            <property name="basePackage" value="com.mj.dao"/>
        </bean>
    
    </beans>

[Java_0]: https://blog.csdn.net/weixin_43734095/article/details/119067034
[Spring5]: https://blog.csdn.net/weixin_43734095/article/details/106309373
[https_gitee.com_szluyu99_mj_java_frame_tree_master_02_Spring]: https://gitee.com/szluyu99/mj_java_frame/tree/master/02_Spring/
[Spring _Spring _ MyBatis]: https://blog.csdn.net/weixin_43734095/article/details/106483350
[applicationContext.xml]: https://gitee.com/szluyu99/mj_java_frame/blob/master/02_Spring/13_Spring06_%E6%95%B4%E5%90%88MyBatis/src/main/resources/applicationContext.xml