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 查看 ！！！
