基于p6sy、druid 封装的springboot mysql starter，包含多数据源支持、日志打印开关、事务支持等功能，零配置，简单易用。
<dependency>
<groupId>com.github.imaginary11</groupId>
<artifactId>sqlx-spring-boot-starter</artifactId>
<version>1.0.0-RELEASE</version>
</dependency>
# 启用开关
sqlx.primary.enabled=true
# mybatis 配置文件位置
sqlx.primary.mybatis.config-location = classpath:mybatis-config.xml
# mybatis sql xml 路径 {db_name} 替换为你的目录名称
sqlx.primary.mybatis.mapper-locations = classpath:mapper/{db_name}/*.xml
# 对应 model 包
sqlx.primary.mybatis.type-aliases-package = com.example.demostarter.model
# druid 驱动
sqlx.primary.db.type = com.alibaba.druid.pool.DruidDataSource
# mysql 配置
sqlx.primary.db.url = jdbc:p6spy:mysql://{ip}:{port}/itsm_account?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&socketTimeout=300000
sqlx.primary.db.driverClassName = com.p6spy.engine.spy.P6SpyDriver
sqlx.primary.db.username = {username}
sqlx.primary.db.password = {password}
sqlx.primary.db.druid-initial-size = 10
sqlx.primary.db.druid-max-active = 10
sqlx.primary.db.v-query = select 1 from dual
# sql 日志打印级别
logging.level.p6spy = info
@SpringBootApplication(exclude = {DataSourceAutoConfiguration.class, MybatisAutoConfiguration.class})
@MapperScan(basePackages = "com.example.demostarter.dao", sqlSessionTemplateRef = "primarySqlSessionTemplate")
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<setting name="mapUnderscoreToCamelCase" value="false"/>
<setting name="cacheEnabled" value="true"/>
<setting name="lazyLoadingEnabled" value="false"/>
<setting name="defaultExecutorType" value="REUSE"/>
<setting name="defaultStatementTimeout" value="300"/>
</settings>
</configuration>
application.properties
sqlx.primary.enabled=true
sqlx.primary.mybatis.config-location = classpath:mybatis-config.xml
sqlx.primary.mybatis.mapper-locations = classpath:mapper/itsm_account/*.xml
sqlx.primary.mybatis.type-aliases-package = com.example.demostarter.model
sqlx.primary.db.type = com.alibaba.druid.pool.DruidDataSource
sqlx.primary.db.url = jdbc:p6spy:mysql://xxx:3306/itsm_account?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&socketTimeout=300000
sqlx.primary.db.driverClassName = com.p6spy.engine.spy.P6SpyDriver
sqlx.primary.db.username = xxx
sqlx.primary.db.password = xxx
sqlx.primary.db.druid-initial-size = 10
sqlx.primary.db.druid-max-active = 10
sqlx.primary.db.v-query = select 1 from dual
logging.level.p6spy = info