【Mybatis扩展】Mybaits使用EntityWrapper进行嵌套条件查询

Mybatis-Plus嵌套条件查询

/**
 * selectList(@Param("ew") Wrapper<T> wrapper);
 * @throws Exception
 */
@Test
public void testSelectList() throws Exception {
  // 查询tbl_employee表中，性别为女，姓名中带“老师” 或者 邮箱中带有a的
  List<Employee> emps = employeeMapper.selectList(
      new EntityWrapper<Employee>()
      .eq("gender", 0)
      .like("last_name", "老师")
//              .or()   //WHERE (gender = ? AND last_name LIKE ? OR email LIKE ?)
      .orNew()  //WHERE (gender = ? AND last_name LIKE ?) OR (email LIKE ?)
      .like("email", "a"));
  System.out.println(emps);
}

or()和orNew()的区别在于是否另起一个or

  or() : WHERE (gender = ? AND last_name LIKE ? OR email LIKE ?)
  orNew : WHERE (gender = ? AND last_name LIKE ?) OR (email LIKE ?)