Mybatis Plus 常见用法+公共字段填充

1.查询数据库中的所有数据

 //查询数据库中的所有数据
        return businessMapper.selectList(null);

2.分页+按照姓名条件查询

LambdaQueryWrapper<Node> queryWrapper = new LambdaQueryWrapper<>();
        //设置条件查询
        queryWrapper
                .like(nodePageDto.getName() != null,
                Node::getName, nodePageDto.getName())
                .eq(nodePageDto.getRegionId()!=null,Node::getRegionId,nodePageDto.getRegionId());

        Page<Node> Page = new Page<>(nodePageDto.getPageIndex(), nodePageDto.getPageSize());
        Page<Node> result = nodeMapper.selectPage(Page, queryWrapper);

3.根据名字 查个数 count

//去tb_vending_machine 查vmcount
            QueryWrapper<VendingMachine> query = new QueryWrapper<>();
            query.eq("node_id",record.getId());
            Integer integer = vendingMachineMapper.selectCount(query);
            nodeVo.setVmCount(integer);

4.根据id条件查询查集合

 //设置条件查询
        queryWrapper
                .eq(id!=null,VendingMachine::getNodeId,id);
        List<VendingMachine> vendingMachines = vendingMachineMapper.selectList(queryWrapper);

使用mybatis需要再实体类添加注解(ps注意添加主键自增长)

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@TableName("tb_sku_class")//指明表的表名
public class SkuClass {
    @TableId(type = IdType.AUTO)//指明表的id
    private Integer classId;
    @TableField("class_name")//指明表的字段名
    private String className;
    @TableField("parent_id")
    private Integer parentId;

}

mapper层

public interface XXXMapper extends BaseMapper<XXX> {

}

添加依赖

<dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.2</version>
        </dependency>

分页拦截器

@Configuration
public class MybatisPlusConfig {
 
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
        return mybatisPlusInterceptor;
    }
}

公共字段填充注解

    @TableField(fill = FieldFill.INSERT)//插入的时候自动填充
    LocalDateTime createTime;
    @TableField(fill = FieldFill.UPDATE)//更新的时候自动填充
    LocalDateTime updateTime;