MyBatis-Plus 多库部署方式；spring mvc 多库部署方式

1、实现mybatis-plus的多个数据库的切换方式

     源码地址：https://github.com/baomidou/mybatisplus-spring-mvc

2、因为其文档都是相互依赖的，所以修改配置，就是在已有的配置中修改

     这里配置多数据源采用定义不同的profile方式修改启动时连接的数据库

     原版

       配置文件位置：https://github.com/baomidou/mybatisplus-spring-mvc/tree/master/src/main/resources/spring

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <beans xmlns="http://www.springframework.org/schema/beans"
 3        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 4        xmlns:context="http://www.springframework.org/schema/context" xmlns:util="http://www.springframework.org/schema/util"
 5        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/util http://www.springframework.org/schema/util/spring-util.xsd">
 6 
 7     
 8     <context:property-placeholder location="classpath:config.properties"/>
 9 
10     
11     <context:component-scan base-package="com.baomidou.springmvc.service"/>
12 
13     <import resource="classpath:spring/spring-mybatis.xml"/>
14 beans>

      修改后配置

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <beans xmlns="http://www.springframework.org/schema/beans"
 3        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 4        xmlns:context="http://www.springframework.org/schema/context"
 5        xmlns:util="http://www.springframework.org/schema/util"
 6        xsi:schemaLocation="http://www.springframework.org/schema/beans
 7        http://www.springframework.org/schema/beans/spring-beans.xsd
 8        http://www.springframework.org/schema/context
 9        http://www.springframework.org/schema/context/spring-context.xsd
10        http://www.springframework.org/schema/util
11        http://www.springframework.org/schema/util/spring-util.xsd" profile="development">
12 
13     
14     
15     
16 
17 
18     <beans profile="development">
19         <context:property-placeholder
20                 location="classpath*:common/*.properties,classpath*:development/*.properties"/>
21         
22         
23         <context:component-scan base-package="com.rent.springmvc.service"/>
24         
25         <import resource="classpath:spring/spring-mybatis.xml"/>
26     beans>
27 
28 
29     
30     <beans profile="test">
31         <context:property-placeholder
32                 location="classpath*:common/*.properties,classpath*:test/*.properties"/>
33 
34         
35         
36         <context:component-scan base-package="com.rent.springmvc.service"/>
37         
38         <import resource="classpath:spring/spring-mybatis.xml"/>
39     beans>
40 
41     
42     <beans profile="production">
43         <context:property-placeholder
44                 location="classpath*:common/*.properties,classpath*:production/*.properties"/>
45 
46         
47         
48         <context:component-scan base-package="com.rent.springmvc.service"/>
49         
50         <import resource="classpath:spring/spring-mybatis.xml"/>
51     beans>
52 
53 beans>

      项目路径截图

    development中写修改的

1 validationQuery=SELECT 1
2 ###############本地数据库
3 jdbc_url=jdbc\:mysql\://localhost\:3306/renttest?characterEncoding\=UTF-8
4 ##jdbc_url=jdbc\:mysql\://192.168.31.255\:3306/test?characterEncoding\=UTF-8
5 jdbc_username=root
6 jdbc_password=123456

      3、beans可以嵌套beans，这是核心配置

                location="classpath*:common/*.properties,classpath*:development/*.properties"/>
    
    
    
    
    

     import引入其他配置，这是一份拼接的配置文件