Shulou(Shulou.com)06/02 Report--

This article mainly introduces the relevant knowledge of "what is the method of springboot integrating mybatis plus and dynamic-datasource". The editor shows you the operation process through an actual case, and the operation method is simple, fast and practical. I hope this article "what is the method of springboot integrating mybatis plus and dynamic-datasource" can help you solve the problem.

Springboot integrates mybatis plus and dynamic-datasource considerations environment

Spring-boot-starter-parent 1.5.2.RELEASE

Mybatis-plus-boot-starter 2.x

Dynamic-datasource-spring-boot-starter 2.5.0

Druid-spring-boot-starter 1.1.10

Note @ SpringBootApplication (exclude = DruidDataSourceAutoConfigure.class)

Stat and wall filters are enabled by default in all versions of dynamic (batch execution of sql is not supported by default, and some lower versions cannot be customized)

The method of enabling batch execution of sql

# method 1: upgrade version, such as 2.5.0spring: datasource: dynamic: druid: wall: noneBaseStatementAllow: true multiStatementAllow: true# method 2: remove wall filter spring: datasource: dynamic: druid: filters: stat

When integrating mybatis plus into an existing project, you should specify another enumeration package, otherwise there will be problems.

Mybatis-plus: type-enums-package: com.zxkj.demo.enums.mpspringboot mybatis plus Multi-data Source configuration Integration dynamic-datasourcepro file introduces dependency mysql mysql-connector-java runtime com.alibaba druid-spring-boot-starter 1.2.6 Com.baomidou mybatis-plus-boot-starter 3.1.2 com.baomidou dynamic-datasource-spring-boot-starter 2.5.6 org.projectlombok lombok 1.18.20 application.yml configuration spring: datasource: Dynamic: primary: master # sets the default data source or data source group Master default value (data source name can be named at will, no fixed value, eg:db1,db2) strict: false # sets strict mode, default false does not start. After startup, an exception is thrown when the specified data source is not matched. If it is not started, the default data source will be used. Datasource: master: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://192.168.3.220:3306/mchouse_test1?useUnicode=true&characterEncoding=utf-8 username: * password: * slave_1: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc: Mysql://112.30.184.149:3306/net_trans_sup_hefei_edi?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai username: * password: * slave_2: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://120.55.168.100:33066/net_trans_sup_hefei_edi?useUnicode=true& CharacterEncoding=utf-8&serverTimezone=Asia/Shanghai username: * password: * mybatis-plus:# configuration:# log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # org.apache.ibatis.logging.slf4j.Slf4jImpl mapper-locations: classpath:mapper/*.xml # configure mybatis.xml file Root path global-config: # logical deletion configuration db-config: # After deletion logic-delete-value: 1 # before deletion logic-not-delete-value: 0 modify the Application startup class @ SpringBootApplication (exclude = {DruidDataSourceAutoConfigure.class})

DruidDataSourceAutoConfigure should be excluded here, because DruidDataSourceAutoConfigure will inject a DataSourceWrapper, which will look for url,username,password and so on under the native spring.datasource. The configuration path of our dynamic data source is variable.

Create MybatisPlusConfig@Configuration@EnableTransactionManagement@MapperScan ("com.example.md5_demo.com.db.**.mapper") public class MyBatisPlusConfig {/ * SQL performance analysis plug-in * for use in the development environment, which is not recommended online. MaxTime refers to the maximum sql execution time * / @ Bean @ Profile ({"dev", "test"}) / / set the dev test environment to enable public PerformanceInterceptor performanceInterceptor () {PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor (); performanceInterceptor.setMaxTime (100000); / / ms. If the ms set here exceeds, sql does not execute performanceInterceptor.setFormat (true); return performanceInterceptor } / * Logic delete plug-in * / @ Bean public ISqlInjector sqlInjector () {return new LogicSqlInjector ();} / * paging plug-in * / @ Bean public PaginationInterceptor paginationInterceptor () {return new PaginationInterceptor ();}} create mapper interface @ Mapperpublic interface DemoMapper extends BaseMapper {List getAllList (); @ DS ("slave_2") List getShopList () } SpringBootTestclass Md5DemoApplicationTests {@ Autowired private DemoMapper demoMapper; @ Test void contextLoads () {List list=demoMapper.getAllList (); System.out.println (list); System.out.println ("*"); List shopList=demoMapper.getShopList (); System.out.println (shopList);}}

@ DS priority: method > class

@ DS can be annotated on both methods and classes. At the same time, method annotations take precedence over class annotations. Either mapper or service can be added. It is recommended to add them on only one method.

This is the end of the introduction to "what is the method for springboot to integrate mybatis plus and dynamic-datasource". Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.