Spring整合MyBatis的原理及实现

我会带着你远行 2024-04-18 23:05 73阅读 0赞

# 1、整合原理 #

1.  我们要将MyBatis配置整合到Spring的配置文件中；
2.  MyBatis配置文件中配置了： **数据源**、**别名**、**mapper映射文件**，**延迟加载**
3.  此时要将（数据源、别名、mapper映射文件）配置写入到Spring的配置文件中，所以mybatis配置文件中只写类的延时加载。
4.  Spring配置文件中新配置**sqlSessionFactory**对象，以及**UserMapper**对象（两种方式）
5.  整合完成

# 2、整合代码 #

#### 1、Spring配置文件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"
           xmlns:aop="http://www.springframework.org/schema/aop" 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 http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
    
    
        
        
        <context:property-placeholder location="classpath:db.properties" system-properties-mode="NEVER"/>
    
        <bean id="datasource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="driverClassName" value="${driver}"/>
            <property name="url" value="${url}"/>
            <property name="username" value="${username}"/>
            <property name="password" value="${password}"/>
        </bean>
    
       
        <bean id="SqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="datasource"/>
            
            <property name="typeAliasesPackage" value="com.project.SSM.user4crud"/>
            
            <property name="mapperLocations" value="classpath:com/project/SSM/user4crud/mapper/*.xml"/>
            
            <property name="configLocation" value="classpath:mybatis.xml"/>
        </bean>
    
    
        
        
        
    
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.project.SSM.user4crud.mapper"/>
            
        </bean>
    
    
    </beans>

数据源配置，此处使用的是阿里的**druid连接池**

driver=com.mysql.jdbc.Driver
    url=jdbc:mysql:///xxxxx?useUnicode=true&characterEncoding=UTF-8
    username=root
    password=xxxx

#### 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>
        
        
        
        <settings>
            <setting name="lazyLoadingEnabled" value="true"/>
            <setting name="aggressiveLazyLoading" value="false"/>
            <setting name="lazyLoadTriggerMethods" value=""/>
        </settings>
    </configuration>