SpringMVC和SpringBoot整合mybatis以及多数据源配置

桃扇骨 2023-06-25 02:23 39阅读 0赞

# 1.SpringMVC整合MyBatis及多数据源配置 #

## 1.1pom.xml文件引入mybatis配置 ##

<dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>${mysql.version}</version>
        </dependency>
    
        
    
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>${mybatis-version}</version>
        </dependency>
    
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis-spring</artifactId>
          <version>${mybatis-spring-version}</version>
        </dependency>
    
    
        <dependency>
          <groupId>com.mchange</groupId>
          <artifactId>c3p0</artifactId>
          <version>${c3p0.version}</version>
        </dependency>

## 1.2 /resources目录添加mybatis-config.xml配置文件以及mybatis目录 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeXV4NDg2OQ_size_16_color_FFFFFF_t_70][]

这个工程我配置了两个数据源，所以mybatis目录下的Mapper文件根据不同数据源分别放在不同目录下，这样编译扫描Mapper文件。

mybatis-config.xml内容如下：

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD SQL Map Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    
    <configuration>
        
        <settings>
            
            <setting name="cacheEnabled" value="true"/>
            
            <setting name="lazyLoadingEnabled" value="true"/>
            <setting name="multipleResultSetsEnabled" value="true"/>
            <setting name="useColumnLabel" value="true"/>
            <setting name="defaultExecutorType" value="REUSE"/>
            <setting name="defaultStatementTimeout" value="25000"/>
        </settings>
    
    </configuration>

Mapper.xml文件和Dao类要一一对应

Mapper.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.test.dao.second.ChannelDao">
        
    
        <resultMap type="com.test.domain.ProductChannel" id="ChannelResult">
            <result column="channel" property="channel"/>
            <result column="name" property="name"/>
        </resultMap>
    
        <select id="getChannelList" resultMap="ChannelResult">
            select channel,name from tb_channel where deleted = 0 and length(name) > 0 and p_id = 91
            ORDER BY id
        </select>
    
    
    
    </mapper>

namespace要指定对应的Dao类。Dao类内容如下：

package com.test.dao.second;
    
    import com.test.domain.ProductChannel;
    import org.apache.ibatis.annotations.Mapper;
    
    import java.util.List;
    
    /**
     * Created by on 2017/12/27.
     */
    @Mapper
    public interface ChannelDao {
    
        List<ProductChannel> getChannelList();
    }

## 1.3 spring-context.xml配置数据源 ##

SpringMVC工程当中数据源的配置是写在spring-context.xml文件当中的。

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.xxxx.xxx.dao.first"/>
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory1"/>
        </bean>
    
    
        <bean id="sqlSessionFactory1" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="adminDataSource"/>
            <property name="configLocation" value="classpath:mybatis-config.xml"/>
            <property name="mapperLocations" value="classpath:/mybatis/first/*Mapper.xml"/>
        </bean>
    
        <bean id="sqlSessionTemplate1" class="org.mybatis.spring.SqlSessionTemplate">
            <constructor-arg index="0" ref="sqlSessionFactory1"/>
            <constructor-arg index="1" value="BATCH"/>
        </bean>
    
    
        <bean id="transactionManager1" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="adminDataSource"></property>
        </bean>
    
        <bean id="adminDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
              destroy-method="close">
            <property name="driverClass" value="${admin-jdbc.driverClassName}" />
            <property name="jdbcUrl" value="${admin-jdbc.url}" />
            <property name="user" value="${admin-jdbc.user}" />
            <property name="password" value="${admin-jdbc.pass}" />
            
            <property name="minPoolSize" value="${c3p0.minPoolSize}" />
            
            <property name="maxPoolSize" value="${c3p0.maxPoolSize}" />
            
            <property name="maxIdleTime" value="${c3p0.maxIdleTime}" />
            
            <property name="acquireIncrement" value="${c3p0.acquireIncrement}" />
            <property name="initialPoolSize" value="${c3p0.initialPoolSize}" />
            
            <property name="idleConnectionTestPeriod" value="${c3p0.idleConnectionTestPeriod}" />
            
            <property name="acquireRetryAttempts" value="${c3p0.acquireRetryAttempts}" />
            <property name="testConnectionOnCheckout" value="${c3p0.testConnectionOnCheckout}" />
        </bean>
    
    
        <tx:advice id="adminTxAdvice" transaction-manager="transactionManager1">
            <tx:attributes>
                
                
                <tx:method name="create*" propagation="REQUIRED"/>
                <tx:method name="save*" propagation="REQUIRED"/>
                <tx:method name="add*" propagation="REQUIRED"/>
                <tx:method name="update*" propagation="REQUIRED"/>
                <tx:method name="remove*" propagation="REQUIRED"/>
                <tx:method name="del*" propagation="REQUIRED"/>
                <tx:method name="import*" propagation="REQUIRED"/>
                <tx:method name="modify*" propagation="REQUIRED"/>
                <tx:method name="finish*" propagation="REQUIRED"/>
                <tx:method name="freeze*" propagation="REQUIRED"/>
                <tx:method name="edit*" propagation="REQUIRED"/>
                <tx:method name="up*" propagation="REQUIRED"/>
                <tx:method name="down*" propagation="REQUIRED"/>
                <tx:method name="select*" propagation="REQUIRED"/>
                <tx:method name="unselect*" propagation="REQUIRED"/>
    
                
                
                
                <tx:method name="*" read-only="false"/>
            </tx:attributes>
        </tx:advice>

其中$\{admin-jdbc.url\}这些参数是从jdbc.properties配置文件中读取的，具体的配置在我的文章《SpringMVC和SpringBoot开发环境、生产环境的多环境配置》中有详细介绍。

SpringMVC的多数据源配置很简单，只要按照上面的方式再创建一组bean就行了，如下所示：

# 2.SpringBoot整合Mybatis及多数据源配置 #

SpringBoot对各种常用软件的整合做了很多很好的封装，SpringBoot整合MyBatis网上有很多教程，这里只介绍一下多数据源的SpringBoot配置。

## 2.1 application.properties配置不同数据源的连接配置 ##

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeXV4NDg2OQ_size_16_color_FFFFFF_t_70 1][]

Mapper文件和Dao类同样根据数据源进行分组

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeXV4NDg2OQ_size_16_color_FFFFFF_t_70 2][]

## 2.2 创建数据源配置类 ##

不同数据源创建不同的配置类，如下

![20191224170806523.png][]

配置类内容如下:

package com.xxxx.xxx.datasource;
    
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.mybatis.spring.SqlSessionTemplate;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.beans.factory.annotation.Qualifier;
    import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
    import org.springframework.boot.context.properties.ConfigurationProperties;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.context.annotation.Primary;
    import org.springframework.context.annotation.PropertySource;
    import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
    import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    
    import javax.sql.DataSource;
    
    /**
     * Created by on 17/7/17.
     */
    @Configuration
    @MapperScan(basePackages = "com.xxxx.xxx.dao.source", sqlSessionTemplateRef  = "fromSqlSessionTemplate")
    @PropertySource("classpath:application.properties")
    public class SourceDataSourceConfig {
    
        @Bean(name = "fromDataSource")
        @ConfigurationProperties(prefix = "jdbcFrom")
        @Primary
        public DataSource fromDataSource() {
    
            return DataSourceBuilder.create().build();
        }
    
        @Bean(name = "fromSqlSessionFactory")
        @Primary
        public SqlSessionFactory fromSqlSessionFactory(@Qualifier("fromDataSource") DataSource dataSource) throws Exception {
            SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
            bean.setDataSource(dataSource);
            bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/source/*Mapper.xml"));
            return bean.getObject();
        }
    
        @Bean(name = "fromTransactionManager")
        @Primary
        public DataSourceTransactionManager fromTransactionManager(@Qualifier("fromDataSource") DataSource dataSource) {
            return new DataSourceTransactionManager(dataSource);
        }
    
        @Bean(name = "fromSqlSessionTemplate")
        @Primary
        public SqlSessionTemplate fromSqlSessionTemplate(@Qualifier("fromSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
            return new SqlSessionTemplate(sqlSessionFactory);
        }
    }

第二个数据源的配置类同上，只是bean的名称要取不一样的。

SpringMVC和SpringBoot整合mybatis以及多数据源配置就讲解到这里，更多精彩文章敬请期待。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeXV4NDg2OQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191224164819307.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeXV4NDg2OQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeXV4NDg2OQ_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191224170553281.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeXV4NDg2OQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeXV4NDg2OQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191224170638774.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xpeXV4NDg2OQ==,size_16,color_FFFFFF,t_70
[20191224170806523.png]: https://img-blog.csdnimg.cn/20191224170806523.png