mybatis-mp 常规简单用法 - 超级方便！！！

mybatis-mp 官网: https://mybatis-mp.cn  

mybatis-mp 是基于mybatis扩展的一款超级好用的ORM框架！！！

1. 方便快捷的查询

SysUser sysUser = QueryChain.of(sysUserMapper)
   .from(SysUser.class)
   .eq(SysUser::getId, 1)
   .like(SysUser::getUserName,"admin")
   .get();


List<SysUser> list = QueryChain.of(sysUserMapper)
   .from(SysUser.class)
   .eq(SysUser::getId, 1)
   .like(SysUser::getUserName,"admin")
   .list();


Pager<SysUser> page = QueryChain.of(sysUserMapper)
   .from(SysUser.class)
   .eq(SysUser::getId, 1)
   .like(SysUser::getUserName,"admin")
   .paging();

2. 超好用的VO映射

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

    private Integer id;
     
    private String userName;

}



SysUserVo sysUserVo = QueryChain.of(sysUserMapper)
   .from(SysUser.class)
   .eq(SysUser::getId, 1)
   .like(SysUser::getUserName,"admin")
   .returnType(SysUserVo.class)
   .get();


List<SysUserVo> list = QueryChain.of(sysUserMapper)
   .from(SysUser.class)
   .eq(SysUser::getId, 1)
   .like(SysUser::getUserName,"admin")
   .returnType(SysUserVo.class)
   .list();


Pager<SysUserVo> page = QueryChain.of(sysUserMapper)
   .from(SysUser.class)
   .eq(SysUser::getId, 1)
   .like(SysUser::getUserName,"admin")
   .returnType(SysUserVo.class)
   .paging();

3: 只单表？ 还有多表！

Integer count = QueryChain.of(sysUserMapper)
        .select(SysUser::getId, c->c.count())
        .from(SysUser.class)
        .join(SysUser.class, SysRole.class)
        .returnType(Integer.TYPE)
        .get();

这样还不简单吗

4：多表性能差？ 

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

    private Integer id;

    private String userName;

    private String password;

    @Fetch(source = SysUser.class, property = "roleId", target = SysRole.class, targetProperty = "id")
    private SysRoleVo sysRole;

}


List<SysUserVo> list = QueryChain.of(sysUserMapper)
    .from(SysUser.class)
    .like(SysUser::getUserName, "admin")
    .returnType(SysUserVo.class)
    .list();

//框架自动帮你以非join的方式，加载sysRole；不能动态加条件？

List<SysUserVo> list = QueryChain.of(sysUserMapper)
    .from(SysUser.class)
    .like(SysUser::getUserName, "admin")
    .fetchFilter(SysUserVo::getSysRole, where -> where.eq(SysRole::getName,"test"))
    .returnType(SysUserVo.class)
    .list();

类似强大的功能还很多很多，欢迎前往官网：https://mybatis-mp.cn 查看 ！！！