mybatisplus-sts-直接使用基础接口实现CRUD操作

最新推荐文章于 2025-10-13 14:53:50 发布

原创最新推荐文章于 2025-10-13 14:53:50 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

springboot 专栏收录该内容

46 篇文章

订阅专栏

本文详细介绍了如何在SpringBoot项目中整合MyBatisPlus，包括项目创建、配置、实体类定义、Mapper接口编写、单元测试等内容，旨在帮助开发者快速上手。

0 参考文献

官方参考

1 创建项目

file,new,spring starter project

2 配置pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.4.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.zfh</groupId>
	<artifactId>springboot-zfh07-mybatisplus-3</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>springboot-zfh07-mybatisplus-3</name>
	<description>Demo project for Spring Boot</description>

	<properties>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
	    <!-- 实体简洁化工具lombok -->   
		<dependency>
	        <groupId>org.projectlombok</groupId>
	        <artifactId>lombok</artifactId>
	        <optional>true</optional>
	    </dependency>
	    <!-- mybatis plus -->
	    <dependency>
	        <groupId>com.baomidou</groupId>
	        <artifactId>mybatis-plus-boot-starter</artifactId>
	        <version>3.1.0</version>
	    </dependency>
	    <!-- 内存数据库h2 -->
	    <dependency>
	        <groupId>com.h2database</groupId>
	        <artifactId>h2</artifactId>
	        <scope>runtime</scope>
	    </dependency>
	
		<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>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>

3 写数据库配置文件和测试数据

在这里插入图片描述
schema-h2.sql

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

data-h2.sql

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

4 写项目配置文件

在这里插入图片描述
application.yml

# DataSource Config
spring:
  datasource:
    driver-class-name: org.h2.Driver
    schema: classpath:db/schema-h2.sql
    data: classpath:db/data-h2.sql
    url: jdbc:h2:mem:test
    username: root
    password: test

5 编写实体类

在这里插入图片描述
User.java

package com.zfh.demo.entity;

import lombok.Data;

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

6 编写mapper接口

在这里插入图片描述
UserMapper.java

package com.zfh.demo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zfh.demo.entity.User;

public interface UserMapper extends BaseMapper<User> {

}

注意，在接口中，要继承基础接口
在这里插入图片描述

7 添加mapper扫描

在这里插入图片描述

package com.zfh.demo;

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

@SpringBootApplication
**@MapperScan("com.zfh.demo.mapper")**
public class SpringbootZfh07Mybatisplus3Application {

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

}

8 进行单元测试

在这里插入图片描述

package com.zfh.demo;

import java.util.List;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import com.zfh.demo.entity.User;
import com.zfh.demo.mapper.UserMapper;

import junit.framework.Assert;

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

	@Autowired
    private UserMapper userMapper;

    @Test
    public void testSelect() {
        System.out.println(("----- selectAll method test ------"));
        List<User> userList = userMapper.selectList(null);
        Assert.assertEquals(5, userList.size());
        userList.forEach(System.out::println);
    }
    
    
    @Test
    public void testInsert() {
    	System.out.println(("----- Insert one record test ------"));
    	User user = new User();
    	user.setId(6l);
    	user.setName("Peter");
    	user.setAge(30);
    	user.setEmail("test6@qq.com");
    	
    	int result = userMapper.insert(user);
    	Assert.assertEquals(1,result);
    	System.out.println("insert 1 user");
    	System.out.println(user.toString());
    	
    	System.out.println(("----- selectAll method test ------"));
        List<User> userList = userMapper.selectList(null);
        Assert.assertEquals(6, userList.size());
        userList.forEach(System.out::println);
    }
    
    @Test
    public void testUpdate() {
    	System.out.println(("----- Insert one record test ------"));
    	User user = new User();
    	user.setId(6l);
    	user.setName("Peter");
    	user.setAge(30);
    	user.setEmail("test6@qq.com");
    	
    	int result = userMapper.insert(user);
    	Assert.assertEquals(1,result);
    	System.out.println("insert 1 user");
    	System.out.println(user.toString());
    	
    	System.out.println(("----- selectAll method test ------"));
        List<User> userList = userMapper.selectList(null);
        Assert.assertEquals(6, userList.size());
        userList.forEach(System.out::println);
        
    	user.setId(6l);
    	user.setName("Peter Zheng");
    	user.setAge(31);
    	user.setEmail("test6666@qq.com");
        
    	result = userMapper.updateById(user);
    	Assert.assertEquals(1,result);
    	System.out.println("update 1 user");
    	System.out.println(user.toString());
    	
    	System.out.println(("----- selectAll method test ------"));
        userList = userMapper.selectList(null);
        Assert.assertEquals(6, userList.size());
        userList.forEach(System.out::println);
    }
    
    @Test
    public void testDelete() {
    	System.out.println(("----- Insert one record test ------"));
    	User user = new User();
    	user.setId(6l);
    	user.setName("Peter");
    	user.setAge(30);
    	user.setEmail("test6@qq.com");
    	
    	int result = userMapper.insert(user);
    	Assert.assertEquals(1,result);
    	System.out.println("insert 1 user");
    	System.out.println(user.toString());
    	
    	System.out.println(("----- selectAll method test ------"));
        List<User> userList = userMapper.selectList(null);
        Assert.assertEquals(6, userList.size());
        userList.forEach(System.out::println);
        
    	user.setId(5l);
    	user = userMapper.selectById(user.getId());
        
    	result = userMapper.deleteById(user.getId());
    	Assert.assertEquals(1,result);
    	System.out.println("delete 1 user");
    	System.out.println(user.toString());
    	
    	System.out.println(("----- selectAll method test ------"));
        userList = userMapper.selectList(null);
        Assert.assertEquals(5, userList.size());
        userList.forEach(System.out::println);
    }
    
    @Test
    public void testOther() {
    	String projectPath = System.getProperty("user.dir");
    	projectPath += "\\src\\main\\java";
    	System.out.println(projectPath);
    }
	
	@Test
	public void contextLoads() {
	}

}

9 单元测试注意事项

每一次测试动作，都是基础当场配置出来的H2内存数据库和库里的数据进行的，所以数据不会持久化到库中
本次没有使用自动生成代码的方式，但mybatisPlus提供了更加方便和规范的操作方式，如果这些方式不足提供给业务，就应该进一步引入mybatis进行自行的库操作；或是用jdbcTemplate等工具来做库操作；或是退化到更原始的jdbc上的操作
有时候因为网络的问题，相应的jar包没有下载全面，影响测试和运行