快速开始

tb_user 数据表

tb_address数据表

初始化一个Spring Boot工程，添加mybatis-plus依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>最新版本</version>
</dependency>

配置

spring:
  datasource:
    url: jdbc:mysql://localhost/mybatis-plus-db
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: root

在Spring Boot启动类中添加@MapperScan注解，扫描Mapper文件夹：

@SpringBootApplication
@MapperScan("cn.coderlzw.mybatisplusdemo.mapper")
public class MybatisPlusDemoApplication {
    public static void main(String[] args) {
        SpringApplication.run(MybatisPlusDemoApplication.class, args);
    }
}

编码

@Data
public class User {
    private Integer id;
    private String name;
    private String username;
    private String email;
    private String mobile;
    private Integer age;
    private String email;
    private String gender;
}

编写Mapper包下的UserMapper接口：

public interface UserMapper extends BaseMapper<User> {
}

开始使用

@SpringBootTest
public class SampleTest {
​
    @Autowired
    private UserMapper userMapper;
​
    @Test
    public void testSelect() {
        System.out.println(("----- 查询用户列表测试 ------"));
        List<User> userList = userMapper.selectList(null);
        userList.forEach(System.out::println);
    }
}