SpringBoot集成MyBatis-Plus

小知识，大挑战！本文正在参与“程序员必备小知识”创作活动。

前言

MyBatis-Plus (opens new window)（简称 MP）是一个 MyBatis (opens new window)的增强工具，在 MyBatis 的基础上只做增强不做改变，为简化开发、提高效率而生。

确实MyBatis-Plus用起来比较爽的，没有了之前繁琐的xml文件的配置，和现在倡导的DDD领域驱动设计和单表操作，可以说是完美契合。

参考学习指南

官方文档：mp.baomidou.com/guide/

GITHUB地址： Gitee (opens new window) | Github(opens new window)

使用入门

POM依赖

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter</artifactId>
    </dependency>

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>

    <!-- mybaits plus 插件 -->
    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>3.0.5</version>
    </dependency>

    <!-- 阿里数据库连接池 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid-spring-boot-starter</artifactId>
        <version>1.1.10</version>
    </dependency>

    <!-- lombok简化代码 -->
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
    </dependency>
</dependencies>

数据库配置

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/smp?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true
    username: root
    password: 1qaz!QAZ
  jackson:
    date-format: yyyy-MM-dd HH:mm:ss
    time-zone: GMT+8
    serialization:
      write-dates-as-timestamps: false

代码分层样例

DownLinkRecordMapper

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sharding.jdbc.demo.entity.DownLinkRecord;

public interface DownLinkRecordMapper extends BaseMapper<DownLinkRecord> {
}

DownLinkRecord

@Data
@TableName("smp_down_link_record")
public class DownLinkRecord {

    @TableId(type = IdType.AUTO)
    private Integer id;

    private Integer merchantId;

    private Integer massTaskId;

    private String massTaskName;

    private String phone;

    private Integer status;

    private String errorCode;

    private Date createTime;
}

DownLinkRecordDAO

@Repository
public class DownLinkRecordDAO extends ServiceImpl<DownLinkRecordMapper, DownLinkRecord> {
}