官方文档：http://mybatis-mp.cn

1 单表：

//单条

SysUser sysUser=QueryChain.of(sysUserMapper)
        .like(SysUser::getName,"xx")
        .limit(1)
        .get()

//list

List<SysUser> list=QueryChain.of(sysUserMapper)
        .like(SysUser::getName,"xx")
        .list()

//分页

Pager<SysUser> page=QueryChain.of(sysUserMapper)
        .like(SysUser::getName,"xx")
        .paging(Pager.of(1,20))

2 连表：

//VO

@Data
@ResultEntity(SysUser.class)
public class SysUserRoleVo {

    private Integer id;

    private String userName;

    @ResultEntityField(target = SysUser.class, property = "password")
    private String pwd;


    @NestedResultEntity(target = SysRole.class)
    private SysRole role;
}


//单条

SysUserVO sysUserVO=QueryChain.of(sysUserMapper)
        .select(SysUserVO.class)
        .from(SysUser.class)
        .join(SysUser.class, SysRole.class, on -> on.eq(SysUser::getRoleId, SysRole::getId)
        .like(SysUser::getName,"xx")
        .limit(1)
        .returnType(SysUserVO.class)
        .get()

//list

List<SysUserVO> list=QueryChain.of(sysUserMapper)
        .select(SysUserVO.class)
        .from(SysUser.class)
        .join(SysUser.class, SysRole.class, on -> on.eq(SysUser::getRoleId, SysRole::getId)
        .like(SysUser::getName,"xx")
        .returnType(SysUserVO.class)
        .list()



//分页

Pager<SysUserVO> page=QueryChain.of(sysUserMapper)
        .select(SysUserVO.class)
        .from(SysUser.class)
        .join(SysUser.class, SysRole.class, on -> on.eq(SysUser::getRoleId, SysRole::getId)
        .like(SysUser::getName,"xx")
        .returnType(SysUserVO.class)
        .paging(Pager.of(1,20))

轻轻松松 简简单单 帮你迅速开发；还有很多很好的功能和特性，请前往官网查看 ：http://mybatis-mp.c

mybatis-mp 可以说 没有构建不出来的sql 欢迎体验：http://mybatis-mp.cn