SpringBoot,整合Mybatis和Druid

 一.依赖

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.0.1</version>
        </dependency>       

        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
        </dependency>

        <!--druid-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.17</version>
        </dependency>
         <dependency>
            <groupId>javax.persistence</groupId>
            <artifactId>persistence-api</artifactId>
            <version>1.0.2</version>
        </dependency>

二. application.yml配置

注意： mapper-locations: 中写 Mapper.xml的路径 ，此处为 resource下创建的 mapper文件夹

            type-aliases-package: 中填写 数据库对应实体类的包路径

spring:
  profiles:
    active: dev
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.cj.jdbc.Driver
    filters: stat
    maxActive: 20
    initialSize: 1
    maxWait: 60000
    minIdle: 1
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true
    maxOpenPreparedStatements: 20

mybatis:
  # classpath 路径下，
  mapper-locations: classpath:mapper/*Mapper.xml
  type-aliases-package: com.xiaojukeji.gamis.server.model.entity.*.entity
#  返回数据下划线转驼峰
  configuration:
    map-underscore-to-camel-case: true

 此处，把其他数据库连接信息，放入 application-dev.yml中，方便环境切换

spring:
  datasource:
    url: jdbc:mysql://112.74.166.222:3306/ttms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowMultiQueries=true
    username: root
    password: 22222

三.实体类

@Getter
@Setter
@AllArgsConstructor
@NoArgsConstructor
public class BlackList {

    @Id
    @GeneratedValue
    private Long id;


    private String cityId;

    private String cityName;
}

四. Mapper

创建mapper类

@Mapper
@Component
public interface BlackListMapper {
    List<BlackWhiteList> getBlackWhiteList();
}

创建相应的 mapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >

<mapper namespace="com.server.mapper.BlackWhiteListMapper">
    
    <select id="getBlackList" resultType="com.server.model.entity.BlackList">
        SELECT
            *
            FROM black_list;
    </select>
</mapper>

五.在启动类添加注解，扫描 mapper接口

  如图，添加 @MapperScan("com.server.mapper") 

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