xbatis 是什么​

xbatis 是一款基于 mybatis 的 ORM 框架，ORM 程度非常高，几乎不需要再写 SQL;

同时内置多种数据库函数 , 具有良好的不同数据库迁移能力，注意它可以同时支持多种数据库！！！，一款真正意义上的 ORM 框架

xbatis 具有良好程序设计，非常稳定（经过 testcase 验证）；优雅的 API、简而易懂的方法操作，让你写代码和写 SQL 几乎一样，学习成本几乎为零。

功能强大，支持 多表 / 子查询，自动分页，优雅的 XML 自动分页等众多功能！！

支持分页，原生自带或 XML 中自动分页

 public class Demo { @Autowired private SysUserMapper sysUserMapper; public void page() { Pager<SysUser> pager= QueryChain.of(sysUserMapper) .join(SysUser::getRoleId, SysRole::getId) .like(SysUser::getUserName,"abc") .paging(Pager.of(1)); } }

不喜欢 JOIN，又不想写代码，懒？可以

 @Data @ResultEntity(SysUser.class) public class SysUserVo { private Integer id; private String userName; private LocalDateTime createTime; @Fetch(source = SysUser.class , property=SysUser.Fields.roleId, target = SysRole.class, targetProperty = SysRole.Fields.id, targetSelectProperty = SysRole.Fields.roleName, orderBy = SysRole.Fields.id+" asc") private List<String> sysRoleNames; @Fetch(source = SysUser.class , property=SysUser.Fields.roleId, target = SysRole.class, targetProperty = SysRole.Fields.id, orderBy = SysRole.Fields.id+" asc") private List<SysRole> sysRoles; } @Service public class Test{ @Autowired private SysUserMapper sysUserMapper; public void demo() { Pager<SysUserVo> pager = QueryChain.of(sysUserMapper) .select(SysUserVo.class) .eq(SysUser::getId,1) .like(SysUser::getUserName,"xxx") .returnType(SysUserVo.class) .paging(Pager.of(1,10)); } }

单表查询，自动加载另外一张表数据，省事

枚举名称，还需要自己注入？来

 @Data @ResultEntity(SysUser.class) public class SysUserVo { private Integer id; private String userName; private String password; private Integer status; @PutEnumValue(source = SysUser.class, property = SysUser.Fields.status, target = StatusEnum.class) private String statusName; }

一个注解搞定，牛不牛，再也不用自己写代码搞了

不同数据库，我想执行不同的函数或 sql，怎么弄？来这里

 SysUser sysUser = QueryChain.of(sysUserMapper) .select(SysUser::getId) // dbAdapt((query, selector) 可以多次 .dbAdapt((query, selector) -> { selector.when(DbType.H2, (dbType) -> { //H2 拼接 id = 3 query.eq(SysUser::getId, 3); }).when(DbType.MYSQL, (dbType) -> { //MYSQL 拼接 id = 3 query.eq(SysUser::getId, 2); }).otherwise((dbType) -> { //其他 拼接 id = 3 query.eq(SysUser::getId, 1); }); }) .get();

更多无敌功能，来 https://xbatis.cn