springboot+mybatisplus实现基本的增删改查以及分页查询。这里使用的是Restful风格包括简单描述Restful是什么

    先实现springboot+mybatisplus的增删改查接口使用postman测试：

第一步创建项目导入依赖：

直接给大家了：

<?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 https://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.6.6</version>

    </parent>

    <groupId>com.okchan</groupId>

    <artifactId>springboot_07_ssmp</artifactId>

    <version>0.0.1-SNAPSHOT</version>

    <properties>

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

    </properties>

    <dependencies>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-web</artifactId>

        </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>

            <version>3.4.3.4</version>

        </dependency>

        <dependency>

            <groupId>com.alibaba</groupId>

            <artifactId>druid-spring-boot-starter</artifactId>

            <version>1.2.6</version>

        </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>

然后用yml配置，修改端口（也可以不做）。

然后给一下SQL：

Drop TABLE  if exists tb_book;

CREATE TABLE tb_book (

    `id` INT(10) NOT NULL AUTO_INCREMENT,

        `type` VARCHAR(20),

        `name` VARCHAR(50),

        `description` VARCHAR(255),

        PRIMARY KEY(`id`)

)ENGINE=INNODB DEFAULT CHARSET=utf8mb4;

INSERT INTO  `tb_book` (type,name,description)

VALUES ('计算机相关','springboot','入门' );

INSERT INTO  `tb_book` (type,name,description)

VALUES ('计算机相关','spring','入门到放弃' );

INSERT INTO  `tb_book` (type,name,description)

VALUES ('计算机相关','java核心技术','入门到精通' );

INSERT INTO  `tb_book` (type,name,description)

VALUES ('计算机相关','mysql','入门到精通' );

INSERT INTO  `tb_book` (type,name,description)

VALUES ('市场营销','市场营销书3','入门' );

INSERT INTO  `tb_book` (type,name,description)

VALUES ('市场营销','市场营销书2','入门' );

INSERT INTO  `tb_book` (type,name,description)

VALUES ('市场营销','市场营销书1','入门' );

然后导入lombok简化代码开发。（也可以直接写对应的get，set，toString方法都可以看个人喜好）

<!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->

<dependency>

    <groupId>org.projectlombok</groupId>

    <artifactId>lombok</artifactId>

    <version>1.18.20</version>

    <scope>provided</scope>

</dependency>

pom文件配置：

server:

  port: 80

spring:

  datasource:

    druid:

      driver-class-name: com.mysql.cj.jdbc.Driver

      url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC

      username: root

      password: 123456

#id-type: auto 设置为数据库的id自增策略

mybatis-plus:

  global-config:

    db-config:

      table-prefix: tb_

      id-type: auto