springboot集成druid和通用mapper

---

springboot整合druid,并使用generator-mybatis插件逆向生成通用mapper

使用springboot集成druid和通用mapper,利用mybatis-generator插件快速搭建数据层

导入Maven依赖

<!-注意版本不要太低-->
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid-spring-boot-starter</artifactId>
	<version>1.1.10</version>
</dependency>
<dependency>
	<groupId>tk.mybatis</groupId>
	<artifactId>mapper</artifactId>
	<version>3.4.2</version>
</dependency>
<dependency>
	<groupId>tk.mybatis</groupId>
	<artifactId>mapper-spring-boot-starter</artifactId>
	<version>1.1.3</version>
</dependency>

导入generator-mybatis插件

<plugin>
	<groupId>org.mybatis.generator</groupId>
	<artifactId>mybatis-generator-maven-plugin</artifactId>
	<version>1.3.6</version>
	<configuration>
		<configurationFile>src/main/resources/mybatis-generator.xml</configurationFile>
		<!--允许移动生成的文件 -->
		<verbose>true</verbose>
		<!-- 是否覆盖，true表示会替换生成的JAVA文件，false则不覆盖 -->
		<overwrite>true</overwrite>
	</configuration>
	<dependencies>
		<!--下面这两个依赖不引入是不会逆向生成的-->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.46</version>
		</dependency>
		<dependency>
			<groupId>tk.mybatis</groupId>
			<artifactId>mapper</artifactId>
			<version>3.4.2</version>
		</dependency>
	</dependencies>
</plugin>

编写MyMapper继承tk.mybatis中的通用模板

public interface MyMapper<T> extends Mapper<T>, MySqlMapper<T> {

}

编写mybatis-generator.xml文件

注意context里面的标签顺序，写错了会出现异常

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
        PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

<generatorConfiguration>
    <!--指定数据库jdbc驱动jar包的位置-->
    <classPathEntry location="E:\mavenRepository\mysql\mysql-connector-java\5.1.4\mysql-connector-java-5.1.4.jar"/>

    <context id="MysqlContext" targetRuntime="MyBatis3Simple" defaultModelType="flat">
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>

        <plugin type="tk.mybatis.mapper.generator.MapperPlugin">
            <property name="mappers" value="com.yang.tkmapper.utils.MyMapper"/>
        </plugin>

        <commentGenerator>
            <!-- 是否去除自动生成的注释,true：是,false:否 -->
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>

        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/video?characterEncoding=UTF-8"
                        userId="root"
                        password="root">
        </jdbcConnection>

        <!-- 对应生成的pojo所在包 -->
        <javaModelGenerator targetPackage="com.yang.tkmapper.pojo" targetProject="src/main/java"/>

		<!-- 对应生成的mapper所在目录 -->
        <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"/>

		<!-- 配置mapper对应的java映射 -->
        <javaClientGenerator targetPackage="com.yang.tkmapper.mapper" targetProject="src/main/java"
                             type="XMLMAPPER"/>

        <table tableName="bgm"/>
    </context>
</generatorConfiguration>

使用插件逆向生成mapper

逆向生成的mapper示例

public interface BgmMapper extends MyMapper<Bgm> {
    
}

在application.yaml中配置druid数据源（如果druid-starter依赖版本过低，此处属性注入会失败）

spring:
  #  数据源配置
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      username: root
      password: root
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://127.0.0.1:3306/video?characterEncoding=UTF-8&serverTimezone=UTC&useUnicode=true
      initialSize: 5
      minIdle: 5
      maxActive: 20
      # 最大等待连接时间
      maxWait: 60000
      timeBetweenEvictionRunsMillis: 60000
      minEvictableIdleTimeMillis: 300000
      validationQuery: select 1 from dual
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false
      poolPreparedStatements: true
      #    配置监控统计拦截的filters，stat:监控统计、log4j：日志记录、wall：防御sql注入
      #    如果允许时报错  java.lang.ClassNotFoundException: org.apache.log4j.Priority
      #    则导入 log4j 依赖即可，Maven 地址： https://mvnrepository.com/artifact/log4j/log4j
      filters: stat,wall,log4j
      maxOpenPreparedStatements: 20
      useGlobalDataSourceStat: true
      connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

如果开启了filters则还需要添加log4j依赖

<dependency>
	<groupId>log4j</groupId>
	<artifactId>log4j</artifactId>
	<version>1.2.17</version>
</dependency>

测试生成的mapper

扫描mapper

@SpringBootApplication
@MapperScan("com.yang.tkmapper.mapper")
public class TkmapperApplication {
    public static void main(String[] args) {
        SpringApplication.run(TkmapperApplication.class, args);
    }
}

编写测试

@Service
public class BgmServer {
    @Autowired
    BgmMapper bgmMapper;
    public void select(){
        Example example = new Example(Bgm.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("author","于文文");
        criteria.andEqualTo("name","体面");
        List<Bgm> bgms = bgmMapper.selectByExample(example);
        System.out.println(bgms);
    }
}

测试成功

[Bgm(id=18052674D26HH33P, author=于文文, name=体面, path=\bgm\music.mp3)]