springboot+mybatis-plus+layui练习增删改查、批量删除、分页，条件组合查询

回忆搅拌幻想

已于 2022-10-31 02:39:37 修改

阅读量1k

点赞数

文章标签： mybatis spring boot layui

于 2022-10-31 02:37:58 首次发布

本文链接：https://blog.csdn.net/weixin_55712503/article/details/127608155

版权

创建数据库

CREATE TABLE `t_h_accident_info_temp`  (
  `HOST_ORG_NO` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '父级组织机构编号',
  `ORG_NO` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组织机构编号',
  `EMS_KGMC` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'EMS的开关名称',
  `PMS_LINE_ID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'PMS的线路ID',
  `PMS_XLMC` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'PMS的线路名称',
  `HOST_ORG_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '父级组织机构名称',
  `ORG_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组织机构名称',
  `CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `PMS_BDZ` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'PMS的变电站',
  `SFZX` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '是否专线'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

INSERT INTO `t_h_accident_info_temp` VALUES ('2109', '210907', '绵阳.玉龙站/10kV.玉漏线912开关', 'SBID0000003864718A57934AFE8E76C2DFE0548A57', '10kV玉漏线', '国网绵阳供电公司', '国网盐亭供电公司', '2021-06-22 14:59:59', '35kV玉龙变电站', '0');
INSERT INTO `t_h_accident_info_temp` VALUES ('2102', '210207', '泸州.后山/10kV.山湾线917开关', 'SBID00000034CEE28D9C594554A7665CC77793F45F', '10kV山湾线917', '国网泸州供电公司', '国网泸州供电公司客户服务中心', '2021-06-22 10:56:51', '110kV后山变电站', '0');
INSERT INTO `t_h_accident_info_temp` VALUES ('2102', '210207', '泸州.龙马潭/10kV.龙关龙安线913开关', 'SBID000000DE00F2A77FEB4A188D04B7B91CDA9BD3', '10kV龙关龙安线913', '国网泸州供电公司', '国网泸州供电公司客户服务中心', '2021-06-22 10:56:52', '110kV龙马潭变电站', '0');
INSERT INTO `t_h_accident_info_temp` VALUES ('2109', '210901', '绵阳.魏城站/10kV.魏东线921开关', 'SBID00000096A269864AC1427EA0161D0F1C5B1BA8', '10kV魏东线', '国网绵阳供电公司', '国网绵阳高新区供电中心', '2021-06-22 14:59:59', '110kV魏城变电站', '0');
INSERT INTO `t_h_accident_info_temp` VALUES ('2108', '123456', '达州.双堰站/10kV.双镇二线917开关', 'SBID0000009CC1869207E2408D9AEFED48B87F17F2', '10kV双镇二线', '国网达州供电公司', '国网四川省电力公司达州市新桥供电分公司', '2022-10-30 17:33:16', '110kV双堰变电站', '1');
INSERT INTO `t_h_accident_info_temp` VALUES ('2109', '210901', '绵阳.魏城站/10kV.魏刘线953开关', 'SBID0000004FC8C0A7BD2248FAB3D5CB8B6487BD9D', '10kV魏刘线', '国网绵阳供电公司', '国网绵阳高新区供电中心', '2021-06-22 14:59:59', '110kV魏城变电站', '0');
INSERT INTO `t_h_accident_info_temp` VALUES ('2109', '210901', '绵阳.魏城站/10kV.魏镇线951开关', 'SBID000000D39C5765C14E4C74998A8740F9B11373', '10kV魏镇线', '国网绵阳供电公司', '国网绵阳高新区供电中心', '2021-06-22 14:59:59', '110kV魏城变电站', '0');
INSERT INTO `t_h_accident_info_temp` VALUES ('2109', '210901', '绵阳.魏城站/10kV.魏徐线957开关', 'SBID000000101A94E41A3846268B688F94D11D73FC', '10kV魏徐线', '国网绵阳供电公司', '国网绵阳高新区供电中心', '2021-06-22 14:59:59', '110kV魏城变电站', '0');
INSERT INTO `t_h_accident_info_temp` VALUES ('2109', '210901', '绵阳.回龙站/10kV.回科线972开关', 'SBID0000006AA5221F57EC42DDBEB0B173F55E3292', '10kV回科线', '国网绵阳供电公司', '国网绵阳高新区供电中心', '2021-06-22 14:59:59', '110kV回龙变电站', '0');
INSERT INTO `t_h_accident_info_temp` VALUES ('2109', '210901', '绵阳.新皂站/10kV.新麻线918开关', '0A72F501-ABCE-4028-8515-837C6D108549-12247', '10kV新麻线', '国网绵阳供电公司', '国网绵阳高新区供电中心', '2021-06-22 14:59:59', '110kV新皂变电站', '0');

实体类

package com.zym.tourism.pojo;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

@Data
@NoArgsConstructor
@AllArgsConstructor
@TableName("t_h_accident_info_temp")
public class Temp {
    /**
     * 父级组织机构编号
     */
    private String hostOrgNo;

    /**
     * 组织机构编号
     */
    private String orgNo;

    /**
     * EMS的开关名称
     */
    private String emsKgmc;

    /**
     * PMS的线路ID
     */
    @TableId
    private String pmsLineId;

    /**
     * PMS的线路名称
     */
    private String pmsXlmc;

    /**
     * 父级组织机构名称
     */
    private String hostOrgName;

    /**
     * 组织机构名称
     */
    private String orgName;

    /**
     * 创建时间
     */
    @TableField(value ="CREATE_TIME", fill= FieldFill.INSERT)
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date createTime;

    /**
     * PMS的变电站
     */
    private String pmsBdz;

    /**
     * 是否专线
     */
    private String sfzx;

    /**
     * 开始时间
     */
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    @TableField(exist = false)
    private Date startTime;

    /**
     * 结束时间
     */
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    @TableField(exist = false)
    private Date endTime;

}

封装layUI数据对象

package com.zym.tourism.utils;

public class DataGridView
{
    /**
     * 封装layUi数据表格的数据对象
     */
    private Integer code=0;
    private String msg="";
    private Long count;
    private Object data;

    public DataGridView(Object data) {
        super();
        this.data = data;
    }

    public DataGridView(Long count, Object data) {
        super();
        this.count = count;
        this.data = data;
    }

    public Integer getCode() {
        return code;
    }

    public void setCode(Integer code) {
        this.code = code;
    }

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }

    public Long getCount() {
        return count;
    }

    public void setCount(Long count) {
        this.count = count;
    }

    public Object getData() {
        return data;
    }

    public void setData(Object data) {
        this.data = data;
    }
}

Mybatis-plus分页插件

package com.zym.tourism.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
@MapperScan("marchsoft.modules.api.mapper")
public class MybatisPlusConfig {

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }
}

自定义操作状态接口

package com.zym.tourism.config;

public interface SysConstant {
    /**
     *操作状态
     * */
    String ADD_SUCCESS="添加成功";
    String ADD_ERROR="添加失败";

    String UPDATE_SUCCESS="修改成功";
    String UPDATE_ERROR="修改失败";

    String DELETE_SUCCESS="删除成功";
    String DELETE_ERROR="删除失败";

    Integer CODE_SUCCESS = 0;//操作成功
    Integer CODE_ERROR = -1;//操作失败

}

返回类型

package com.zym.tourism.utils;

import com.zym.tourism.config.SysConstant;

public class ResultObj {
    private Integer code;
    private String msg;


    /**
     * 添加成功
     */
    public static final ResultObj ADD_SUCCESS = new ResultObj(SysConstant.CODE_SUCCESS,SysConstant.ADD_SUCCESS);
    /**
     * 添加失败
     */
    public static final ResultObj ADD_ERROR = new ResultObj(SysConstant.CODE_ERROR,SysConstant.ADD_ERROR);
    /**
     * 更新成功
     */
    public static final ResultObj UPDATE_SUCCESS = new ResultObj(SysConstant.CODE_SUCCESS,SysConstant.UPDATE_SUCCESS);
    /**
     * 更新失败
     */
    public static final ResultObj UPDATE_ERROR = new ResultObj(SysConstant.CODE_ERROR,SysConstant.UPDATE_ERROR);
    /**
     * 删除成功
     */
    public static final ResultObj DELETE_SUCCESS = new ResultObj(SysConstant.CODE_SUCCESS,SysConstant.DELETE_SUCCESS);
    /**
     * 删除失败
     */
    public static final ResultObj DELETE_ERROR = new ResultObj(SysConstant.CODE_ERROR,SysConstant.DELETE_ERROR);

    /**
     * 状态码0 成功
     */
    public static final ResultObj STATUS_TRUE = new ResultObj(SysConstant.CODE_SUCCESS);

    /**
     * 状态码-1 失败
     */
    public static final ResultObj STATUS_FALSE = new ResultObj(SysConstant.CODE_ERROR);

    private ResultObj(Integer code, String msg) {
        this.code = code;
        this.msg = msg;
    }

    private ResultObj(Integer code) {
        this.code = code;
    }

    public Integer getCode() {
        return code;
    }

    public void setCode(Integer code) {
        this.code = code;
    }

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }

}

mapper接口

package com.zym.tourism.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zym.tourism.pojo.Temp;

public interface TempMapper extends BaseMapper<Temp> {
}

service接口

package com.zym.tourism.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.zym.tourism.pojo.Temp;

public interface TempService extends IService<Temp> {
}