SpringBoot多数据源的配置(SpringBoot+MyBatis)

最新推荐文章于 2024-08-09 18:07:53 发布
最新推荐文章于 2024-08-09 18:07:53 发布
阅读量1.3w 收藏 7
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zhe1110/article/details/54138500
版权
遇到的问题
1,@Primary注解是必要的,不然会出现异常. 
    
    
  1. org.springframework.beans.factory.NoUniqueBeanDefinitionException: No qualifying bean of type [javax.sql.DataSource] is defined: expected single matching bean but found 2: test1DataSource,test2DataSource
2,因为存在多个DataSource,SqlSessionFactory,PlatformTransactionManager,SqlSessionTemplate所以要使用"name"来区分.
3,SqlSessionTemplate如果不配置,在访问主数据源的数据没有问题,但是访问另一个数据源就会出现异常. 
    
    
  1. org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): cn.zz.mapper1.UserMapper1.findAll
4,MyBatis@Configuration上需要加注解
@MapperScan(basePackages = "cn.zz.mapper1", sqlSessionTemplateRef  = "test2SqlSessionTemplate")



结构



数据源 
   
   
  1. package cn.zz.config;
  3. import org.apache.ibatis.session.SqlSessionFactory;
  4. import org.mybatis.spring.SqlSessionFactoryBean;
  5. import org.mybatis.spring.SqlSessionTemplate;
  6. import org.mybatis.spring.annotation.MapperScan;
  7. import org.springframework.beans.factory.annotation.Qualifier;
  8. import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
  9. import org.springframework.boot.context.properties.ConfigurationProperties;
  10. import org.springframework.context.annotation.Bean;
  11. import org.springframework.context.annotation.Configuration;
  12. import org.springframework.context.annotation.Primary;
  13. import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
  14. import org.springframework.jdbc.datasource.DataSourceTransactionManager;
  15. import org.springframework.transaction.PlatformTransactionManager;
  17. import javax.sql.DataSource;
  20. @Configuration
  21. @MapperScan(basePackages = "cn.zz.mapper", sqlSessionTemplateRef  = "test1SqlSessionTemplate")
  22. public class DataSource1 {
  24.     @Bean(name = "test1DataSource")
  25.     @ConfigurationProperties(prefix = "spring.datasource.primary")
  26.     @Primary
  27.     public DataSource testDataSource() {
  28.         return DataSourceBuilder.create().build();
  29.     }
  31.     @Bean(name = "test1SqlSessionFactory")
  32.     @Primary
  33.     public SqlSessionFactory testSqlSessionFactory(@Qualifier("test1DataSource") DataSource dataSource) throws Exception {
  34.         SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
  35.         bean.setDataSource(dataSource);
  36.         bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/*.xml"));
  37.         return bean.getObject();
  38.     }
  40.     @Bean(name = "test1TransactionManager")
  41.     @Primary
  42.     public PlatformTransactionManager testTransactionManager(@Qualifier("test1DataSource") DataSource dataSource) {
  43.         return new DataSourceTransactionManager(dataSource);
  44.     }
  46.     @Bean(name = "test1SqlSessionTemplate")
  47.     @Primary
  48.     public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("test1SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
  49.         return new SqlSessionTemplate(sqlSessionFactory);
  50.     }
  51. }

    
    
  1. package cn.zz.config;
  3. import org.apache.ibatis.session.SqlSessionFactory;
  4. import org.mybatis.spring.SqlSessionFactoryBean;
  5. import org.mybatis.spring.SqlSessionTemplate;
  6. import org.mybatis.spring.annotation.MapperScan;
  7. import org.springframework.beans.factory.annotation.Qualifier;
  8. import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
  9. import org.springframework.boot.context.properties.ConfigurationProperties;
  10. import org.springframework.context.annotation.Bean;
  11. import org.springframework.context.annotation.Configuration;
  12. import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
  13. import org.springframework.jdbc.datasource.DataSourceTransactionManager;
  14. import org.springframework.transaction.PlatformTransactionManager;
  16. import javax.sql.DataSource;
  19. @Configuration
  20. @MapperScan(basePackages = "cn.zz.mapper1", sqlSessionTemplateRef  = "test2SqlSessionTemplate")
  21. public class DataSource2 {
  23.     @Bean(name = "test2DataSource")
  24.     @ConfigurationProperties(prefix = "spring.datasource.secondary")
  25.     public DataSource testDataSource() {
  26.         return DataSourceBuilder.create().build();
  27.     }
  29.     @Bean(name = "test2SqlSessionFactory")
  30.     public SqlSessionFactory testSqlSessionFactory(@Qualifier("test2DataSource") DataSource dataSource) throws Exception {
  31.         SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
  32.         bean.setDataSource(dataSource);
  33.         bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mybatis1/*.xml"));
  34.         return bean.getObject();
  35.     }
  37.     @Bean(name = "test2TransactionManager")
  38.     public PlatformTransactionManager testTransactionManager(@Qualifier("test2DataSource") DataSource dataSource) {
  39.         return new DataSourceTransactionManager(dataSource);
  40.     }
  42.     @Bean(name = "test2SqlSessionTemplate")
  43.     public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("test2SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
  44.         return new SqlSessionTemplate(sqlSessionFactory);
  45.     }
  48. }

Controller 
     
     
  1. package cn.zz.controller;
  3. import cn.zz.model.User;
  4. import cn.zz.service.UserService;
  5. import cn.zz.service1.UserService1;
  6. import org.apache.log4j.Logger;
  7. import org.springframework.beans.factory.annotation.Autowired;
  8. import org.springframework.stereotype.Controller;
  9. import org.springframework.web.bind.annotation.RequestMapping;
  10. import org.springframework.web.bind.annotation.ResponseBody;
  12. import java.util.List;
  14. 

  15. @Controller
  16. public class UserController {
  18.     private Logger logger = Logger.getLogger(UserController.class);
  20.     @Autowired
  21.     private UserService userService;
  23.     @Autowired
  24.     private UserService1 userService1;
  26.     @RequestMapping("/save")
  27.     @ResponseBody
  28.     public User save() {
  29.         User user = userService.save("zz",27,"72");
  30.         return user;
  31.     }
  33.     @RequestMapping("/save1")
  34.     @ResponseBody
  35.     public String save1() {
  36.         userService.save1("zz",27,"72");
  37.         return "ok";
  38.     }
  40.     @RequestMapping("/getUserInfo")
  41.     @ResponseBody
  42.     public User getUserInfo() {
  43.         User user = userService.getUserInfo();
  44.         if(user!=null){
  45.             System.out.println("user.getName():"+user.getName());
  46.             logger.info("user.getAge():"+user.getAge());
  47.         }
  48.         return user;
  49.     }
  51.     @RequestMapping("/findAll")
  52.     @ResponseBody
  53.     public List<User> findAll() {
  54.         List<User> user = userService.findAll();
  55.         return user;
  56.     }
  58.     @RequestMapping("/findAll1")
  59.     @ResponseBody
  60.     public List<User> findAll1() {
  61.         List<User> user = userService1.findAll1();
  62.         return user;
  63.     }
  64. }

Service 
      
      
  1. package cn.zz.service;
  3. import cn.zz.mapper.UserMapper;
  4. import cn.zz.model.User;
  5. import org.springframework.beans.factory.annotation.Autowired;
  6. import org.springframework.stereotype.Service;
  7. import org.springframework.transaction.annotation.Transactional;
  9. import java.util.List;
  11. @Service

  12. @Transactional
  13. public class UserService {
  14.     @Autowired
  15.     private UserMapper userMapper;
  17.     public User getUserInfo(){
  18.         User user=userMapper.findUserInfo();
  19.         //User user=null;
  20.         return user;
  21.     }
  23.     public User save(String name, Integer age, String password) {
  24.         User user=new User();
  25.         user.setName(name);
  26.         user.setAge(age);
  27.         user.setPassword(password);
  28.         userMapper.save(user);
  29.         return user;
  30.     }
  32.     public List<User> findAll() {
  33.         List<User> user=userMapper.findAll();
  34.         //User user=null;
  35.         return user;
  36.     }
  39.     public void save1(String zz, int i, String s) {
  40.         User user=new User();
  41.         user.setName(zz);
  42.         user.setAge(i);
  43.         user.setPassword(s);
  44.         userMapper.save1(user);
  45.     }
  46. }

      
      
  1. package cn.zz.service1;
  3. import cn.zz.mapper1.UserMapper1;
  4. import cn.zz.model.User;
  5. import org.springframework.beans.factory.annotation.Autowired;
  6. import org.springframework.stereotype.Service;
  7. import org.springframework.transaction.annotation.Transactional;
  9. import java.util.List;
  12. @Service
  13. @Transactional
  14. public class UserService1 {
  15.     @Autowired
  16.     private UserMapper1 userMapper1;
  19.     public List<User> findAll1() {
  20.         List<User> user = userMapper1.findAll();
  21.         //User user=null;
  22.         return user;
  23.     }
  25. }

Mapper 
       
       
  1. package cn.zz.mapper;
  3. import cn.zz.model.User;
  5. import java.util.List;
  7. /**
  8.  * Created by zl on 2015/8/27.
  9.  */
  10. //@Repository(value = "sqlSessionFactoryBean1")
  11. public interface UserMapper {
  12.     public User findUserInfo();
  14.     void save(User user);
  16.     List<User> findAll();
  18.     void save1(User user);
  19. }

        
        
  1. package cn.zz.mapper1;
  3. import cn.zz.model.User;
  5. import java.util.List;
  7. public interface UserMapper1 {
  8.     public User findUserInfo();
  10.     void save(User user);
  12.     List<User> findAll();
  14.     void save1(User user);
  15. }

Mapper.xml 
         
         
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="cn.zz.mapper.UserMapper">
  5.     <select id="findUserInfo" resultType="cn.zz.model.User">
  6.     select id,name,age,password from user;
  7.   </select>
  11.     <select id="findAll" resultType="cn.zz.model.User">
  12.         select id,name,age,password from user;
  13.     </select>
  16.     <insert id="save"
  17.             keyProperty="id" keyColumn="id" useGeneratedKeys="true">
  18.         INSERT INTO user(name,age,password) VALUES(#{name}, #{age}, #{password});
  19.     </insert>
  21.     <insert id="save1">
  22.         INSERT INTO user(name,age,password) VALUES(#{name}, #{age}, #{password});
  23.     </insert>
  26. </mapper>

          
          
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="cn.zz.mapper1.UserMapper1">
  5.     <select id="findUserInfo" resultType="cn.zz.model.User">
  6.     select id,name,age,password from user;
  7.   </select>
  10.     <select id="findAll" resultType="cn.zz.model.User">
  11.         select id,name,age,password from user;
  12.     </select>
  15.     <insert id="save"
  16.             keyProperty="id" keyColumn="id" useGeneratedKeys="true">
  17.         INSERT INTO user(name,age,password) VALUES(#{name}, #{age}, #{password});
  18.     </insert>
  20.     <insert id="save1">
  21.         INSERT INTO user(name,age,password) VALUES(#{name}, #{age}, #{password});
  22.     </insert>
  25. </mapper>

实体类 
           
           
  1. package cn.zz.model;
  3. public class User {
  4.     private Integer id;
  5.     private String name;
  6.     private Integer age;
  7.     private String password;
  9.     public Integer getId() {
  10.         return id;
  11.     }
  13.     public void setId(Integer id) {
  14.         this.id = id;
  15.     }
  17.     public String getName() {
  18.         return name;
  19.     }
  21.     public void setName(String name) {
  22.         this.name = name;
  23.     }
  25.     public Integer getAge() {
  26.         return age;
  27.     }
  29.     public void setAge(Integer age) {
  30.         this.age = age;
  31.     }
  33.     public String getPassword() {
  34.         return password;
  35.     }
  37.     public void setPassword(String password) {
  38.         this.password = password;
  39.     }
  40. }


application.properties 
            
            
  1. spring.datasource.primary.url=jdbc:mysql://127.0.0.1:3306/zz?useUnicode=true&characterEncoding=gbk&zeroDateTimeBehavior=convertToNull
  2. spring.datasource.primary.username=root
  3. spring.datasource.primary.password=123456
  4. spring.datasource.primary.driver-class-name=com.mysql.jdbc.Driver
  6. spring.datasource.secondary.url=jdbc:mysql://127.0.0.1:3306/zz1?useUnicode=true&characterEncoding=gbk&zeroDateTimeBehavior=convertToNull
  7. spring.datasource.secondary.username=root
  8. spring.datasource.secondary.password=123456
  9. spring.datasource.secondary.driver-class-name=com.mysql.jdbc.Driver

Application 
             
             
  1. package cn.zz;
  3. import org.apache.log4j.Logger;
  4. import org.springframework.boot.SpringApplication;
  5. import org.springframework.boot.autoconfigure.SpringBootApplication;
  7. //@EnableAutoConfiguration
  8. @SpringBootApplication
  9. //@ComponentScan
  10. //@MapperScan("cn.no7player.mapper")
  11. public class Application {
  12.     private static Logger logger = Logger.getLogger(Application.class);
  14.     /**
  15.      * Start
  16.      */
  17.     public static void main(String[] args) {
  18.         SpringApplication.run(Application.class, args);
  19.         logger.info("SpringBoot Start Success");
  20.     }
  21. }


pom.xml 
           
           
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3. 	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  4. 	<modelVersion>4.0.0</modelVersion>
  6. 	<groupId>com.unioncast</groupId>
  7. 	<artifactId>unioncast-db-service</artifactId>
  8. 	<version>0.0.1-SNAPSHOT</version>
  9. 	<packaging>war</packaging>
  11. 	<name>unioncast-db-service</name>
  12. 	<description>Demo project for Spring Boot</description>
  14. 	<parent>
  15. 		<groupId>org.springframework.boot</groupId>
  16. 		<artifactId>spring-boot-starter-parent</artifactId>
  17. 		<version>1.4.1.RELEASE</version>
  18. 		<relativePath /> <!-- lookup parent from repository -->
  19. 	</parent>
  21. 	<repositories>
  22. 		<repository>
  23. 			<id>nexus</id>
  24. 			<name>nexus</name>
  25. 			<url>http://192.168.101.23:8081/nexus/content/groups/public/</url>
  26. 			<releases>
  27. 				<enabled>true</enabled>
  28. 			</releases>
  29. 			<snapshots>
  30. 				<enabled>true</enabled>
  31. 			</snapshots>
  32. 		</repository>
  33. 	</repositories>
  35. 	<properties>
  36. 		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  37. 		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  38. 		<java.version>1.8</java.version>
  39. 	</properties>
  41. 	<dependencies>
  42. 		<!-- 自己的公共库依赖 -->
  43. 		<dependency>
  44. 			<groupId>com.unioncast</groupId>
  45. 			<artifactId>unioncast-common</artifactId>
  46. 			<version>0.0.1-SNAPSHOT</version>
  47. 			<exclusions>
  48. 				<exclusion>
  49. 					<groupId>javax.servlet</groupId>
  50. 					<artifactId>servlet-api</artifactId>
  51. 				</exclusion>
  52. 			</exclusions>
  53. 		</dependency>
  54. 		<dependency>
  55. 			<groupId>org.springframework.boot</groupId>
  56. 			<artifactId>spring-boot-starter-actuator</artifactId>
  57. 			<exclusions>
  58. 				<exclusion>
  59. 					<groupId>org.springframework.boot</groupId>
  60. 					<artifactId>spring-boot-starter-logging</artifactId>
  61. 				</exclusion>
  62. 			</exclusions>
  63. 		</dependency>
  64. 		
  65. 		<dependency>
  66. 			<groupId>org.springframework.boot</groupId>
  67. 			<artifactId>spring-boot-starter-aop</artifactId>
  68. 		</dependency>
  69. 		
  70. 		<dependency>
  71. 			<groupId>org.springframework.boot</groupId>
  72. 			<artifactId>spring-boot-actuator-docs</artifactId>
  73. 		</dependency>
  74. 		<dependency>
  75. 			<groupId>org.springframework.boot</groupId>
  76. 			<artifactId>spring-boot-starter-cache</artifactId>
  77. 		</dependency>
  78. 		<!-- <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> 
  79. 			</dependency> -->
  80. 		<dependency>
  81. 			<groupId>org.springframework.boot</groupId>
  82. 			<artifactId>spring-boot-starter-data-rest</artifactId>
  83. 		</dependency>
  84. 		<dependency>
  85. 			<groupId>org.springframework.data</groupId>
  86. 			<artifactId>spring-data-rest-hal-browser</artifactId>
  87. 		</dependency>
  88. 		<dependency>
  89. 			<groupId>org.springframework.boot</groupId>
  90. 			<artifactId>spring-boot-devtools</artifactId>
  91. 		</dependency>
  92. 		<dependency>
  93. 			<groupId>org.springframework.boot</groupId>
  94. 			<artifactId>spring-boot-starter-jdbc</artifactId>
  95. 		</dependency>
  96. 		<!-- <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-security</artifactId> 
  97. 			</dependency> -->
  98. 		<dependency>
  99. 			<groupId>org.springframework.boot</groupId>
  100. 			<artifactId>spring-boot-starter-thymeleaf</artifactId>
  101. 		</dependency>
  102. 		<dependency>
  103. 			<groupId>org.springframework.boot</groupId>
  104. 			<artifactId>spring-boot-starter-web</artifactId>
  105. 		</dependency>
  107. 		<dependency>
  108. 			<groupId>com.h2database</groupId>
  109. 			<artifactId>h2</artifactId>
  110. 			<scope>runtime</scope>
  111. 		</dependency>
  112. 		<dependency>
  113. 			<groupId>mysql</groupId>
  114. 			<artifactId>mysql-connector-java</artifactId>
  115. 			<scope>runtime</scope>
  116. 		</dependency>
  117. 		<dependency>
  118. 			<groupId>org.springframework.boot</groupId>
  119. 			<artifactId>spring-boot-starter-tomcat</artifactId>
  120. 			<!--<scope>provided</scope>-->
  121. 		</dependency>
  122. 		<dependency>
  123. 			<groupId>org.springframework.boot</groupId>
  124. 			<artifactId>spring-boot-starter-test</artifactId>
  125. 			<scope>test</scope>
  126. 		</dependency>
  127. 		<dependency>
  128. 			<groupId>org.springframework.restdocs</groupId>
  129. 			<artifactId>spring-restdocs-mockmvc</artifactId>
  130. 			<scope>test</scope>
  131. 		</dependency>
  132. 		<dependency>
  133. 			<groupId>org.springframework.boot</groupId>
  134. 			<artifactId>spring-boot-configuration-processor</artifactId>
  135. 			<optional>true</optional>
  136. 		</dependency>
  137. 		<!-- redis相关 -->
  138. 		<dependency>
  139. 			<groupId>org.springframework.boot</groupId>
  140. 			<artifactId>spring-boot-starter-redis</artifactId>
  141. 		</dependency>
  142. 		<!-- c3p0连接池 -->
  143. 		<dependency>
  144. 			<groupId>com.mchange</groupId>
  145. 			<artifactId>c3p0</artifactId>
  146. 			<version>0.9.5.2</version>
  147. 		</dependency>
  149. 		<dependency>
  150. 			<groupId>org.springframework.boot</groupId>
  151. 			<artifactId>spring-boot-starter-log4j2</artifactId>
  152. 		</dependency>
  153. 		<dependency>
  154. 			<groupId>org.scala-lang</groupId>
  155. 			<artifactId>scala-library</artifactId>
  156. 			<version>2.11.0</version>
  157. 		</dependency>
  158. 		<dependency>
  159. 			<groupId>org.springframework.boot</groupId>
  160. 			<artifactId>spring-boot-starter-data-elasticsearch</artifactId>
  161. 		</dependency>
  162. 		<dependency>
  163. 			<groupId>com.sun.jna</groupId>
  164. 			<artifactId>jna</artifactId>
  165. 			<version>3.0.9</version>
  166. 		</dependency>
  168. 		<!-- Swagger -->
  169. 		<dependency>
  170. 			<groupId>io.springfox</groupId>
  171. 			<artifactId>springfox-swagger-ui</artifactId>
  172. 			<version>2.2.2</version>
  173. 		</dependency>
  174. 		<dependency>
  175. 			<groupId>io.springfox</groupId>
  176. 			<artifactId>springfox-swagger2</artifactId>
  177. 			<version>2.2.2</version>
  178. 		</dependency>
  179. 		<!-- END Swagger -->
  181. 	</dependencies>
  183. 	<build>
  184. 		<plugins>
  186. 			<plugin>
  187. 				<groupId>org.springframework.boot</groupId>
  188. 				<artifactId>spring-boot-maven-plugin</artifactId>
  189. 			</plugin>
  191. 			<plugin>
  192. 				<artifactId>maven-surefire-plugin</artifactId>
  193. 				<configuration>
  194. 					<skipTests>true</skipTests>
  195. 				</configuration>
  196. 			</plugin>
  198. 			<plugin>
  199. 				<groupId>org.apache.maven.plugins</groupId>
  200. 				<artifactId>maven-compiler-plugin</artifactId>
  201. 				<configuration>
  202. 					<source>1.8</source>
  203. 					<target>1.8</target>
  204. 					<encoding>UTF-8</encoding>
  205. 					<compilerArgument>-Xlint:unchecked</compilerArgument>
  206. 				</configuration>
  207. 			</plugin>
  210. 		</plugins>
  211. 	</build>
  214. </project>










 



zhe1110
关注
SpringBoot多数据源
大老杨的博客
04-11 5882
很多业务场景都需要使用到多数据库，本文介绍springboot对多数据源的使用。 这次先说一下application.properties文件，分别连接了2个数据库test和test1。完整代码如下： ##端口号 server.port=8888 ##数据库url spring.datasource.test.url=jdbc:mysql://localhost:3306/test?c...
Spring Boot 集成Mybatis实现多数据源
热门推荐
maoyeqiu的专栏
06-30 4万+
项目提交测试，趁着中当间的这个空档期，把springboot的多数据源配置学习一下，总体来说多数据源配置有两种方式，一种是静态的，一种是动态的。 静态的方式 我们以两套配置方式为例，在项目中有两套配置文件，两套mapper，两套SqlSessionFactory，各自处理各自的业务，这个两套mapper都可以进行增删改查的操作，在这两个主MYSQL后也可以各自配置自己的slave，实现数据的备
Java框架—SpringBoot+MyBatis实现多数据源配置
最新发布
weixin_41624547的博客
08-09 1403
spring:druid:master:slave:DruidDataSourceAutoConfigure会注入一个DataSourceWrapper，其会在原生的spring.datasource下找 url, username, password 等。动态数据源 URL 等配置是在 druid下，因此需要排除，否则会报错。
Springboot 之 Mybatis 多数据源实现
天行健，君子以自强不息；地势坤，君子以厚德载物。
09-11 832
简介上篇讲解了 JPA 多数据源实现；这篇讲解一下 Mybatis 多数据源实现 。主要采用将不同数据库的 Mapper 接口分别存放到不同的 package，Spring 去扫描不同的包，注入不同的数据源来实现多数据源。原理跟 JPA 多数据源实现基本一致。创建 mybatis-multip-datasource 项目数据库脚本参考： Springboot 之 JPA 多数据源实...
SpringBoot配置多个数据库
终
06-13 587
Java项目配置多个数据库
Springboot+mybatis+druid多数据源配置（oracle+mybatis）
07-29
总结，Spring Boot结合Mybatis和Druid实现多数据源配置的过程包括：配置数据源、配置Mybatis、创建数据源切换器、以及针对不同数据库的测试。这一过程涉及了Spring Boot的自动配置、依赖注入、配置属性绑定等多个...
springboot + mybatis-plus + oracle + 多数据源 + redis + hutool
04-06
springboot + mybatis-plus + database+ 多数据源 + redis + hutool 框架干净，没有其他冗余的成分； 配置了MP的代码生成器，意见生成代码，节省开发时间！ 可用于各种定时任务处理，各种夸库操作， 多数据源支持...
详解springboot+mybatis多数据源最简解决方案
08-30
SpringBoot+MyBatis多数据源解决方案 SpringBoot框架中，使用MyBatis框架来实现多数据源解决方案是非常常见的场景。本篇文章将详细介绍如何使用SpringBoot框架来实现多数据源解决方案，并提供了一个简单的解决方案...
SpringBoot+layui+Thymeleaf+Mybatis+Shiro后台管理系统脚手架
08-05
标题中的"SpringBoot+layui+Thymeleaf+Mybatis+Shiro后台管理系统脚手架"代表了一个基于SpringBoot框架的后台管理系统，该系统利用了一系列技术来构建高效、易用的管理界面。以下是对这些技术及其在系统中的作用的...
springboot +mybatis+oracle 配置多个数据源,配置两个数据库信息
12-25
本配置示例将详细介绍如何在Spring Boot中整合MyBatis与Oracle数据库，并配置两个不同的数据源。 首先，我们需要理解数据源（DataSource）的概念。数据源是Java应用程序与数据库之间的桥梁，它负责管理数据库连接，...
SpringBoot 多数据源
07-03
springboot 多数据源 MySQL 分库分表策略。 springboot 多数据源 MySQL 分库分表策略。
SpringBoot多数据源项目
02-14
基于springboot，多数据源，用druid整合，SpringAop进行数据源切换，包括实现事务切换，内有功能备注
springboot+mybatis实现多数据源
Curtisjia的博客
02-09 4152
目录前言准备环境建表语句代码项目结构依赖配置dao测试 前言 在一个项目体量不断增大的情况下，数据量随之增大，那么为了分散数据库的压力，可能会通过分库分表来进行减缓操作。这就与我们单一的数据源就不一样了，而是要配置多数据源了，本文就通过简单的示例，来示范多数据源实现的过程 准备环境 jdk8，idea2020.1.1，mysql8.0，maven3，springboot2.5.0 建表语句 这两张表要建在不同的数据库下 CREATE TABLE `job_test` ( `id` int(11) NOT
springboot 配置多数据源
ba5189tsl的专栏
08-04 4万+
1.首先在创建应用对象时引入autoConfig @ComponentScan @EnableAutoConfiguration public class Application extends SpringBootServletInitializer { public static void main(String[] args) { SpringApplication ap
Spring Boot整合MyBatis配置多数据源
null
03-03 2355
多数据源即动态数据源，随着项目开发逐渐扩大，单个数据源、单一数据源已经无法满足需求项目的支撑需求。或是单一数据库无法承载大数据量的访问，需使用多个数据库进行数据的读写分离；或是某些特殊业务需求，需操作不同的数据库。在文章中，展示了Spring Boot整合MyBatis连接数据库的方法，基于此，Spring Boot 整合MyBatis 配置多数据源。
SpringBoot+Mybatis+Druid动态数据源配置实战
"通过springboot+mybatis+druid配置动态数据源" 在现代企业级应用中，经常需要处理多个数据库，比如分离读写操作、分布式系统或是多租户环境。在这种情况下，动态数据源的配置变得至关重要。本教程将详细讲解如何在...
评论 3
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值