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
# 添加日志
  configuration:
  • 6
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值