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