1、mapper接口继承BaseMapper
public interface AMapper extends BaseMapper<A> {
}
2、实体类
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName("数据库表名")
@ApiModel(value="实体类对象", description="数据库表描述")
3、使用额外条件查询
QueryWrapper<实体类> queryWrapper= new QueryWrapper<>();
queryWrapper.eq("表字段",值);
queryWrapper.ne("表字段",值);
service.getOne(queryWrapper);
//query查询
//query().eq("a",5).eq("b",1).eq("c",4)
// .orderByAsc("a").orderByAsc("b").list();
//返回map
QueryWrapper queryWrapper = new QueryWrapper();
queryWrapper.select("id","sname as name");
List<Map> list = service.getBaseMapper().selectMaps(queryWrapper);
官方文档:https://mp.baomidou.com/guide/
详细描述queryMapper(引用):https://blog.csdn.net/bird_tp/article/details/105587582