一、自动填充日期篇
实体类:
@Data
@TableName("tb_item")
public class Item {
@TableId(type = IdType.AUTO)
private Long id;//商品id
private String name;//商品名称
private Long price;//价格(分)
private Integer stock;//库存数量
private String image;//商品图片
private String category;//分类名称
private String brand;//品牌名称
private String spec;//规格
private Integer sold;//销量
private Integer commentCount;//评论数
private Integer status;//商品状态 1-正常,2-下架
@TableField("isAD")
private Boolean isAD;//商品状态 1-正常,2-下架
@TableField(value = "create_time",fill = FieldFill.INSERT)
private Date createTime;//创建时间
@TableField(value = "update_time",fill = FieldFill.INSERT_UPDATE)
private Date updateTime;//更新时间
}
自动填充id
@TableId(type = IdType.AUTO)
映射到数据库的字段,自动填充方式
@TableField(value = "create_time",fill = FieldFill.INSERT)
配置类:
@Component
public class MybatisMetaObjectHandler implements MetaObjectHandler {
@Override
public void insertFill(MetaObject metaObject) {
metaObject.setValue("createTime", new Date());
metaObject.setValue("updateTime", new Date());
}
@Override
public void updateFill(MetaObject metaObject) {
metaObject.setValue("updateTime", new Date());
}
}
二、分页
//分页查询
Page- itemPage = new Page<>(page,size);
Page
- page1 = itemMapper.selectPage(itemPage, null);
配置类:
//mybatisplus分页配置类
@Configuration
public class MybatisPlusConfig {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor(){
MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
return mybatisPlusInterceptor;
}
}