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