目录

• 什么是MyBatisPlus
• 特性
• 快速入门
  • 创建数据库和表
  • 初始化工程
  • 导入依赖
    • 注意：导入mybatis-plus后就不要导入mybatis，因为mybatis-plus中包含mybatis，可能和导入的mybatis版本冲突
  • 配置
  • 编写代码
  • 测试
• 日志配置

https://baomidou.com/


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

创建数据库和表

DROP TABLE IF EXISTS user;

CREATE TABLE user
(
    id BIGINT(20) NOT NULL COMMENT '主键ID',
    name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名',
    age INT(11) NULL DEFAULT NULL COMMENT '年龄',
    email VARCHAR(50) NULL DEFAULT NULL COMMENT '邮箱',
    PRIMARY KEY (id)
);

DELETE FROM user;

INSERT INTO user (id, name, age, email) VALUES
(1, 'Jone', 18, 'test1@baomidou.com'),
(2, 'Jack', 20, 'test2@baomidou.com'),
(3, 'Tom', 28, 'test3@baomidou.com'),
(4, 'Sandy', 21, 'test4@baomidou.com'),
(5, 'Billie', 24, 'test5@baomidou.com');

初始化工程

导入依赖

    com.baomidou
    mybatis-plus-boot-starter
    3.0.5

<?xml version="1.0" encoding="UTF-8"?>

    4.0.0
    
        org.springframework.boot
        spring-boot-starter-parent
        2.6.3
         
    
    com.qing
    mybatis_plus
    0.0.1-SNAPSHOT
    mybatis_plus
    mybatis_plus
    
        1.8
    
    
        
            org.springframework.boot
            spring-boot-starter-web
        

        
            org.springframework.boot
            spring-boot-starter-test
            test
        

        
        
            mysql
            mysql-connector-java
        
        
            org.projectlombok
            lombok
        
        
            com.baomidou
            mybatis-plus-boot-starter
            3.0.5
        
    

    
        
            
                org.springframework.boot
                spring-boot-maven-plugin
            
        
    

注意：导入mybatis-plus后就不要导入mybatis，因为mybatis-plus中包含mybatis，可能和导入的mybatis版本冲突

配置

spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus?serverTimezone=Asia/Shanghai&useSSL=false&useUnicode=true&characterEncoding=utf8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

编写代码

package com.qing.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private Long id;
    private String name;
    private Integer age;
    private String email;
}

package com.qing.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.qing.pojo.User;
import org.springframework.stereotype.Repository;

// 继承BaseMapper，传入对应的实体类
@Repository
public interface UserMapper extends BaseMapper {
}

@MapperScan("com.qing.mapper") // 扫描mapper包

package com.qing;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@MapperScan("com.qing.mapper") // 扫描mapper包
@SpringBootApplication
public class MybatisPlusApplication {

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

}

测试

package com.qing;

import com.qing.mapper.UserMapper;
import com.qing.pojo.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest
class MybatisPlusApplicationTests {

    @Autowired
    private UserMapper userMapper;

    @Test
    void contextLoads() {
        List userList = userMapper.selectList(null);
        userList.forEach(l -> System.out.println(l));
    }

}

日志配置

# 数据库连接配置
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus?serverTimezone=Asia/Shanghai&useSSL=false&useUnicode=true&characterEncoding=utf8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

# 日志配置
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl