springboot mapper sql 分页 增删改查遇到的一些问题

       springboot mapper sql  分页  增删改查遇到的一些问题

第一步建表 ORD_GOODS：

/*
 Navicat Premium Data Transfer

 Source Server         : javachen
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : cdb-4nug2mq6.cd.tencentcdb.com:10152
 Source Schema         : mkk

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : 65001

 Date: 11/04/2021 15:39:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ORD_GOODS
-- ----------------------------
DROP TABLE IF EXISTS `ORD_GOODS`;
CREATE TABLE `ORD_GOODS`  (
  `GOODS_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '商品id',
  `GOODS_NAME` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `GOODS_ART` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品艺术名称',
  `GOODS_PRICE` decimal(32, 8) NULL DEFAULT NULL COMMENT '商品真实价格',
  `GOODS_MARKET_PRICE` decimal(32, 8) NULL DEFAULT NULL COMMENT '商品市场价格',
  `GOODS_HISTORY_PRICE` decimal(32, 8) NULL DEFAULT NULL COMMENT '商品历史价格',
  `GOODS_DESC` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品介绍',
  `GOODS_IMG` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品图片',
  `GOODS_IMGS` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品图片群',
  `GOODS_VOLUME` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品规格-净体积',
  `GOODS_CARRIER_AREA` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品规格-承载容器底面积',
  `GOODS_CARRIER_HEIGHT` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品规格-承载容器高度',
  `CREATED_BY` bigint(20) NULL DEFAULT NULL COMMENT '创建人',
  `CREATED_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `UPDATED_BY` bigint(20) NULL DEFAULT NULL COMMENT '更新人',
  `UPDATED_TIME` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `STATUS` int(2) NOT NULL DEFAULT 0 COMMENT '商品状态 0筹备中 1正常可下单 2已售罄 3已下架',
  `TENANT_ID` bigint(20) NOT NULL COMMENT '租户id',
  `TYPE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品类型',
  `GOODS_WEIGHT` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '商品重量',
  PRIMARY KEY (`GOODS_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1378344849365823492 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品表 商品表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ORD_GOODS
-- ----------------------------
INSERT INTO `ORD_GOODS` VALUES (1, '商品名称', '5', 5.00000000, 5.00000000, 5.00000000, '5', 'https://fanyi.caiyunapp.com/static/img/logo-website.33fde8d.png', 'https://fanyi.caiyunapp.com/static/img/logo-website.33fde8d.png', '1', '1', '1', 1, '2021-04-03 14:54:31', 1, '2021-04-03 14:54:37', 0, 1, '555', 'aaa');
INSERT INTO `ORD_GOODS` VALUES (1378325926482386946, '商品', '', 0.00000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, '0');
INSERT INTO `ORD_GOODS` VALUES (1378344849365823489, '商品2', '', 0.00000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, '0');
INSERT INTO `ORD_GOODS` VALUES (1378344849365823490, '1', '1', 1.20000000, 1.30000000, 1.40000000, '1', NULL, NULL, '1', '1', '1', 1, '2021-04-11 14:33:04', NULL, NULL, 1, 1, NULL, '1');

SET FOREIGN_KEY_CHECKS = 1;

第二步 ：引入返回json数据的公共类，可以放在entity文件里面     JsonResult：

package cn.nucun.order.pojo.entity;
import lombok.Data;
import lombok.experimental.Accessors;
//参考https://www.cnblogs.com/huanshilang/p/13063908.html
@Data
@Accessors(chain = true)
public class JsonResult<T> {
    private T data;
    private String code;
    private String msg;
    /**
     * 若没有数据返回，默认状态码为0，提示信息为：操作成功！
     */
    public JsonResult() {
        this.code = "0";
        this.msg = "操作成功！";
    }
    /**
     * 若没有数据返回，可以人为指定状态码和提示信息
     * @param code
     * @param msg
     */
    public JsonResult(String code, String msg) {
        this.code = code;
        this.msg = msg;
    }
    /**
     * 有数据返回时，状态码为0，默认提示信息为：操作成功！
     * @param data
     */
    public JsonResult(T data) {
        this.data = data;
        this.code = "0";
        this.msg = "操作成功！";
    }
    /**
     * 有数据返回，状态码为0，人为指定提示信息
     * @param data
     * @param msg
     */
    public JsonResult(T data, String msg) {
        this.data = data;
        this.code = "0";
        this.msg = msg;
    }
    // 省略get