SpringBoot配置Mybatis

Springboot添加Mybatis

1.添加Pom.xml依赖

        <!-- mybatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <!--<version>1.3.1</version>-->
            <version>1.3.2</version>
        </dependency>
        <!--Mybatis-Plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus</artifactId>
            <version>3.2.0</version>
        </dependency>
        <!-- tk.mybatis -->
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <!--<version>1.1.5</version>-->
            <version>2.1.5</version>
        </dependency>

        <!--pageHelper-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <!--<version>1.2.5</version>-->
            <version>1.2.12</version>
            <exclusions>
                <exclusion>
                    <groupId>com.github.jsqlparser</groupId>
                    <artifactId>jsqlparser</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

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

        <!-- druid -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>

2.添加yaml文件

#用户配置
my-database-coonfig:
  ip: 127.0.0.1
  port: 3306
  dbname: testdb
  uname: root
  passwd: 123


#标准配置
spring:
  datasource:
    druid:
      # 数据库访问配置, 使用druid数据源
      type: com.alibaba.druid.pool.DruidDataSource
      driverClassName: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://${my-database-coonfig.ip}:${my-database-coonfig.port}/${dmy-database-coonfig.dbname}?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai
      username: ${my-database-coonfig.uname}
      password: ${my-database-coonfig.passwd}

3.添加dao和model文件

最好在同一个包下，方便扫描

• 数据库

• Record

@Accessors(chain = true)
@Data
@Table(name = "tmp_record_data")
public class Record {

    @Id
    @Column(name = "id")
    private String id;

    @Column(name = "content")
    private String content;
}

• BaseDAO

import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.MySqlMapper;

public interface BaseDAO<T> extends Mapper<T>, MySqlMapper<T> {
}

• RecordDAO

public interface RecordDAO extends BaseDAO<Record> {
}

3.添加@MapperScan注解

@SpringBootApplication
@MapperScan(basePackages = {"com.example.demo.repository.mysql.dao"})
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }

}

然后就可以愉快的开始使用啦~