为什么推荐使用 mybatis-mp 框架?
官方文档: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