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();