springboot工程集成mybatis-plus---快速入门

一.创建数据库

1.创建数据库 mybatis_plus
2.创建user表

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');

二.创建springboot工程

1.导入依赖 mybatis-plus和lombok(小插件）

 <!-- 数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!-- mybatis-plus -->
        <!-- mybatis-plus 是自己开发，并非官方的！ -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.0.5</version>
        </dependency>

2.配置数据库信息

开启日志
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost:3307/mybatis_plus?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

3.创建User实体类

package com.jmu.czx.entity;

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

@Data//lombok插件注解,自动生成getter,setter,tostring等方法
@AllArgsConstructor//自动生成有参构造方法
@NoArgsConstructor//自动生成有无参构造方法
public class User {


    private Long id;
    private String name;
    private Integer age;
    private String email;


}

4.创建mapper接口

mapper接口要继承BaseMapper接口，T为你需要的对象类型
可以看其源码就知道有哪些CURD的操作

package com.jmu.czx.Mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jmu.czx.entity.User;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserMapper extends BaseMapper<User> {
    // 所有的CRUD操作都已经编写完成了
    // 你不需要像以前的配置一大堆文件了！
}

5.编写测试类

封装好CURD测试

package com.jmu.czx;

import com.jmu.czx.Mapper.UserMapper;
import com.jmu.czx.entity.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;


import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@SpringBootTest
class CzxApplicationTests {
    @Autowired
    private UserMapper userMapper;

    @Test
    void contextLoads() {
        List<User> users = userMapper.selectList(null);  //查询所有用户
        users.forEach(System.out::println);
    }

    @Test
    void test() {
        User user = new User();
        user.setId(6L);
        user.setAge(18);
        user.setName("czx");
        user.setEmail("773980670@qq.com");
        int insert = userMapper.insert(user);   //insert操作
        System.out.println(insert);

    }

    @Test
    void test1() {

        int i = userMapper.deleteById(3l); //根号id删除
        System.out.println(6);

    }
    @Test
    void test2() {

        int i = userMapper.deleteBatchIds(Arrays.asList(1l,2l)); //根号id批量删除
        System.out.println(6);

    }
    @Test
    void test3() {
        Map<String,Object> map=new HashMap<>();
        map.put("name","czx");
        int i = userMapper.deleteByMap(map); // 通过map删除
        System.out.println(6);

    }

}

总结

以上为mybatis-plus快速入门，扩展内容后面会更新