/*** *条件构造器 查询操作SelectList */ @Test public void testEntitymapperSelectList() { //查询数据库,性别为男(1),并且名字中带有霸的记录或者email中带有123的记录。 List<Employee> employeeList=employeeMapper.selectList(new EntityWrapper<Employee>() .eq("gender",1) .like("name", "霸") //.or()//SELECT id AS id,`name`,email,gender,age FROM employee WHERE (gender = ? AND name LIKE ? OR email LIKE ?) .orNew()//SELECT id AS id,`name`,email,gender,age FROM employee WHERE (gender = ? AND name LIKE ?) OR (email LIKE ?) .like("email", "123") ); System.out.println("*******************"+employeeList); for (Employee employee : employeeList) { System.out.println(employee.getName()); } } |
|