Springboot + Mybatis-plus 增删改查

最新推荐文章于 2025-05-28 23:11:34 发布

有一个码农，他叫封子

最新推荐文章于 2025-05-28 23:11:34 发布

阅读量6.9k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： Mybatis-plus 文章标签： Mybatis-plus

本文链接：https://blog.youkuaiyun.com/qq_27991405/article/details/94291501

Mybatis-plus 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了如何使用Springboot结合Mybatis-plus进行数据库的增删改查操作。从建表开始，然后创建Springboot工程，添加相关依赖，配置数据库连接，接着编写entity和mapper，最后进行测试并展示数据库查询结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

最近公司用Mybatis-plus进行开发，虽然已经上手了，但是还没好好系统的学习。

建表

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 '邮箱',
     addr VARCHAR(250) NULL DEFAULT NULL COMMENT '地址',
     remark VARCHAR(250) NULL DEFAULT NULL COMMENT '备注',
     PRIMARY KEY (id)
)

创建工程

使用Springboot Initializr快速创建工程。

添加依赖

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

<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-devtools</artifactId>
	<scope>runtime</scope>
	<optional>true</optional>
</dependency>
<dependency>
	<groupId>com.h2database</groupId>
	<artifactId>h2</artifactId>
	<scope>runtime</scope>
</dependency>
<dependency>
	<groupId>org.projectlombok</groupId>
	<artifactId>lombok</artifactId>
	<optional>true</optional>
</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.1.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>8.0.16</version>
</dependency>

配置数据库链接

连接的是MySQL8.0版本的数据库

#DataSourcespring:
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mybatis_plus?userSSL=true&useUnicode=true&characterEncoding=UTF8&serverTimezone=GMT
    username: your_user_name
    password: your_password

Coding

entity

package com.fengling.demomybatisplus.entity;

import lombok.Data;

@Data
public class User {
    private Long id;
    private String name;
    private int age;
    private String email;
    private String addr;
    private String remark;
}

mapper

package com.fengling.demomybatisplus.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fengling.demomybatisplus.entity.User;

public interface UserMapper extends BaseMapper<User> {
}

测试

package com.fengling.demomybatisplus;

import com.fengling.demomybatisplus.entity.User;
import com.fengling.demomybatisplus.mapper.UserMapper;
import org.junit.Assert;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import javax.annotation.Resource;

@RunWith(SpringRunner.class)
@SpringBootTest
public class UserTests {

    @Resource
    private UserMapper userMapper;


    @Test
    public void testInsert() {
        User user = new User();
        user.setName("fengling319");
        user.setAge(18);
        user.setEmail("fengling319@xxx.com");
        user.setAddr("广东深圳龙岗");
        user.setRemark("喝酱油的");

        int insert = userMapper.insert(user);
        Assert.assertEquals(insert , 1);

    }

    @Test
    public void testSelect(){
        List<User> users = userMapper.selectList(null);
        users.forEach(System.out::println);
        Assert.assertEquals(2, users.size());
    }

}

数据库查询结果

    @Test
    public void testQuery() {
        QueryWrapper<User> ew = new QueryWrapper<>();
        ew.like("name" , "318");
        List<User> users = userMapper.selectList(ew);
        users.forEach(System.out::println);
    }

 @Test
    public void testUpdate() {
        QueryWrapper<User> ew = new QueryWrapper<>();
        ew.like("name" , "318");
        User user = userMapper.selectOne(ew);
        user.setRemark("大王叫我来巡山！！！");

        int i = userMapper.updateById(user);
        Assert.assertEquals(i , 1);

    }