前言:
小伙伴说能不能用springboot整合一下mybatis多数据源不使用JPA进行数据库连接操作。那么说干就干
1 创建一个springboot项目
流程就不介绍了,按图操作即可
项目创建成功了,那么开始说下整合mybatis
首先在我们的resources目录下存在一个application.properties文件,这是一个全局配置文件,先将两个数据源配置添加到这个文件中(如果你分环境了可以将数据源配置放在不同的目录下)
//数据源1 spring.datasource.druid.crmtest.driver-class-name=com.mysql.jdbc.Driver spring.datasource.druid.crmtest.url=jdbc:mysql://xxxxx:3306/crm spring.datasource.druid.crmtest.username=xxx spring.datasource.druid.crmtest.password=xxx spring.datasource.druid.crmtest.initial-size=2 spring.datasource.druid.crmtest.max-active=10 spring.datasource.druid.crmtest.min-idle=2 spring.datasource.druid.crmtest.max-wait=30000 spring.datasource.druid.crmtest.validation-query=SELECT 1 spring.datasource.druid.crmtest.validation-query-timeout=30000 spring.datasource.druid.crmtest.min-evictable-idle-time-millis=300000 spring.datasource.druid.crmtest.pool-prepared-statements=true spring.datasource.druid.crmtest.max-pool-prepared-statement-per-connection-size=20 spring.datasource.druid.crmtest.test-on-borrow=false spring.datasource.druid.crmtest.test-on-return=false spring.datasource.druid.crmtest.test-while-idle=true spring.datasource.druid.crmtest.time-between-eviction-runs-millis=60000 spring.datasource.druid.crmtest.filters=stat,wall spring.datasource.druid.crmtest.connection-properties=druid.stat.slowSqlMillis=5000 spring.datasource.druid.crmtest.connection-init-sqls=set names utf8mb4; #数据源2 spring.datasource.druid.paytest.driver-class-name=com.mysql.jdbc.Driver spring.datasource.druid.paytest.url=jdbc:mysql://xxxxxxx:3306/pay spring.datasource.druid.paytest.username=xxxx spring.datasource.druid.paytest.password=xxxxxx spring.datasource.druid.paytest.initial-size=2 spring.datasource.druid.paytest.max-active=10 spring.datasource.druid.paytest.min-idle=2 spring.datasource.druid.paytest.max-wait=30000 spring.datasource.druid.paytest.validation-query=SELECT 1 spring.datasource.druid.paytest.validation-query-timeout=30000 spring.datasource.druid.paytest.min-evictable-idle-time-millis=300000 spring.datasource.druid.paytest.pool-prepared-statements=true spring.da<span>本文来源gaodai#ma#com搞*!代#%^码网5</span>tasource.druid.paytest.max-pool-prepared-statement-per-connection-size=20 spring.datasource.druid.paytest.test-on-borrow=false spring.datasource.druid.paytest.test-on-return=false spring.datasource.druid.paytest.test-while-idle=true spring.datasource.druid.paytest.time-between-eviction-runs-millis=60000 spring.datasource.druid.paytest.filters=stat,wall spring.datasource.druid.paytest.connection-properties=druid.stat.slowSqlMillis=5000 spring.datasource.druid.paytest.connection-init-sqls=set names utf8mb4;