MybatisPlus入门案例

目录

一：创建user表，并添加数据

二：创建SpringBoot工程

2.1: pom中引入 Spring Boot Starter 父工程 和相关依赖：

2.2：在application.properties 配置文件中添加 MySQL 数据库的相关配置：

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

2.4: 实体类：

2.5: mapper

三：测试

---

一：创建user表，并添加数据

CREATE TABLE `user` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `name` varchar(20) DEFAULT NULL COMMENT '姓名',
  `age` int(12) DEFAULT NULL COMMENT '年龄',
  `hobby` varchar(50) DEFAULT NULL COMMENT '爱好',
  PRIMARY KEY (`id`)
) ;


INSERT INTO `user`(`name`, `age`, `hobby`) VALUES ('张三', 18, '看电影');
INSERT INTO `user`(`name`, `age`, `hobby`) VALUES ('李四', 20, '玩LOL');
INSERT INTO `user`(`name`, `age`, `hobby`) VALUES ('王五', 22, '健身');

二：创建SpringBoot工程

2.1: pom中引入 Spring Boot Starter 父工程 和相关依赖：

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.6.3</version>
        <relativePath/>
    </parent>      

  
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>
        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
    </dependencies>

2.2：在application.properties 配置文件中添加 MySQL 数据库的相关配置：

这里要配置你自己的数据库

#mysql数据库连接
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/demo?serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=123456

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

package com.mrwen;

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

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

2.4: 实体类：

package com.mrwen.pojo;

import lombok.Data;

@Data
public class User {
    private int id;
    private String name;
    private int age;
    private String hobby;
}

2.5: mapper

package com.mrwen.mapper;

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

@Repository
public interface UserMapper extends BaseMapper<User> {
}

三：测试

package com.mrwen;

import com.mrwen.mapper.UserMapper;
import com.mrwen.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
public class TestDemo {
    @Autowired
    private UserMapper userMapper;

    @Test
    public void test01() {
        List<User> userList = userMapper.selectList(null);
        userList.forEach(System.out::println);
    }
}

输出结果：

 更多CRUD接口 参照：Mybatis-Plus 官方文档https://baomidou.com/pages/49cc81/#service-crud-%E6%8E%A5%E5%8F%A3