SpringBoot整合MyBatis-Plus进阶(自动填充，SQL注入)

前期准备

首先完成MyBatis-Plus基础整合。可以参考上一篇文章SpringBoot整合MyBatis-Plus

1.自动填充

1.1 实体类修改

需要自动填充的字段添加属性

@Data
@TableName("salesbill")
public class Salesbill {
   
    @TableId(value = "billId",type = IdType.AUTO)
    private long billId;
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date date;
    @TableField("customerID")
    private long customerID;
    @TableField("categoryID")
    private long categoryID;
    private double price;
    private double grossWeight;
    private double tareWeight;
    private String remack;
    private long address;
    // 注意！这里需要标记为填充字段
    @TableField(fill = FieldFill.INSERT)
    private String createName;
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    // 注意！这里需要标记为填充字段
    @TableField(fill = FieldFill.INSERT)
    private Date createTime;
}

1.2 自定义填充实现类

@Slf4j
@Component
public class MyMetaObjectHandler implements MetaObjectHandler {
   

    @Override
    public void insertFill(MetaObject metaObject) {
   
        log.info("start insert fill ....");
        this.strictInsertFill(metaObject, "createTime", LocalDateTime::