前端修改或者添加页面

image.png

后端数据库表数据

image.png

后端实体类字段
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
package com.orchids.springmybatisplus.model.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;

import com.orchids.springmybatisplus.model.enums.Sex;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;

/**
* @Author qwh
* @Date 2024/5/31 16:53
*/
@Data
@Schema(description = "学生信息表")
@TableName(value = "student")
public class Student extends BaseEntity {
private static final long serialVersionUID = 1L;

@Schema(description = "名字")
@TableField(value = "name")
private String name;

@Schema(description = "年龄")
@TableField(value = "age")
private Integer age;

@Schema(description = "性别")
@TableField(value = "sex")
private Sex sex;

}

后端实体类基类
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
package com.orchids.springmybatisplus.model.entity;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonIgnore;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
* @Author qwh
* @Date 2024/5/31 16:54
*/
@Data
public class BaseEntity implements Serializable {

@Schema(description = "主键")
@TableId(value = "id", type = IdType.AUTO)
private Long id;

@Schema(description = "创建时间")
@TableField(value = "create_time")
@JsonIgnore
private Date createTime;

@Schema(description = "更新时间")
@TableField(value = "update_time")
@JsonIgnore
private Date updateTime;

@Schema(description = "逻辑删除")
@JsonIgnore
@TableLogic()
@TableField("is_deleted")
private Byte isDeleted;

}

解决方法的在基类 @TableField()注解内添加条件

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
package com.orchids.springmybatisplus.model.entity;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonIgnore;
import io.swagger.v3.oas.annotations.media.Schema;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
* @Author qwh
* @Date 2024/5/31 16:54
*/
@Data
public class BaseEntity implements Serializable {

@Schema(description = "主键")
@TableId(value = "id", type = IdType.AUTO)
private Long id;

@Schema(description = "创建时间")
@TableField(value = "create_time",fill = FieldFill.INSERT)
@JsonIgnore
private Date createTime;

@Schema(description = "更新时间")
@TableField(value = "update_time",fill = FieldFill.UPDATE)
@JsonIgnore
private Date updateTime;

@Schema(description = "逻辑删除")
@JsonIgnore
@TableLogic()
@TableField("is_deleted")
private Byte isDeleted;

}