Skip to content

2.2.1 - 2023-12-16
Compare
Choose a tag to compare
@abel533 abel533 released this 16 Dec 01:02
· 16 commits to master since this release
2.2.1
1ebcdf7
  • 复杂example查询示例
  • 测试批量插入ID
  • 完善测试代码
  • JPA不加注解时排除接口、数组、枚举、基本类型、注解类型，fixed #93
  • 依赖的 mybatis-provider 升级为 2.2.3

Example 示例

Example<User> example = new Example<>();
example.createCriteria().andEqualTo(User::getSex, "男").andOr(
    example.orPart().andLike(User::getUserName, "杨%"),
    example.orPart().le(User::getId, 10));
List<User> users1 = mapper.selectByExample(example);

//wrapper写法，结果一样
List<User> list = mapper.wrapper().eq(User::getSex, "男")
    .or(
        c -> c.startsWith(User::getUserName, "杨"),
        c -> c.le(User::getId, 10)).list();

生成的 SQL:

SELECT id,name AS userName,sex,status FROM user WHERE ( sex = ? AND ( ( name LIKE ? ) OR ( id <= ? ) ) )

简化括号后：

SELECT id,name AS userName,sex,status FROM user WHERE sex = ? AND ( name LIKE ?  OR id <= ? )
Assets 2