第一次博客

#技术栈
最近接触的到的技术栈mybatis-plus，lombok，swagger。
软件postman

安装的环境IDEA、MAVEN、Git、JDK，数据库采用mysql

先利用mybatis-plus实现CRUD功能，然后完成分页插件。

利用mybatis-plus实现CRUD功能
mybatis-plus实现了 User 表的 CRUD 功能，甚至连 XML 文件都不用编写。

1.maven依赖
    <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>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <scope>provided</scope>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
    </dependency>
</dependencies>

2.application.yml

# Tomcat

server:

tomcat:

uri-encoding: UTF-8
max-threads: 1000
min-spare-threads: 30

port: 8080

spring:

datasource:

driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/demo?useUnicode=true&zeroDateTimeBehavior=convertToNull&autoReconnect=true&characterEncoding=utf-8&useSSL=false&autoReconnect=true&failOverReadOnly=false&&serverTimezone=Asia/Shanghai
username: root
password: 123456789

logging:

level:

 com.graduation.panda.dao : debug

3.User.java

@Data

public class User {

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

利用了lombok插件 4.UserMapper.java public interface UserMapper extends BaseMapper { }

5.Test

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

UserMapper 中的 selectList() 方法的参数为 MP 内置的条件封装器 Wrapper，所以不填写就是无任何条件

6.附上数据库 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');