MyBatisPlus的CRUD方法解释

一、更新操作

1、此方法未更新的数据不会改变

Integer updateById(@Param("entity") T entity);

2、此方法未更新的数据会变为null

Integer updateAllColumnById(@Param("entity") T entity);

二、查询操作

1、根据单个id查询

T selectById(Serialzable id);

2、根据多个列查询（id+lastName）

selectOne(employee);

列：
Employee employee = new Employee();
employee.setLastName("张三");
employee.setGender("0");

Employee employeeResule = employeeMapper.selectOne(employee);

selectOne(employee)当多个数据都满足查询条件时，会报错

3、通过多个id进行查询

List<Integer>  idList = new ArrayList<>();
idList.add(4);
idList.add(5);
idList.add(6);
idList.add(7);
List<Employee> emps = employeeMapper.selectBatchIds(idList);

4、通过Map封装条件查询

Map<String,Object> columnMap = new HashMap<>();
columnMap.put("last_name","Tom");
columnMap.put("gender",1);
List<Employee> emps = employeeMapper.selectByMap(columnMap);

5、分页查询

List<Employee> emps = employeeMapper.selectPage(new Page<>(3,2),null);

三、删除操作

1、通过id删除

Integer result = employeeMapper.deleteById(13);

2、通过Map封装条件删除

Map<String ,Object> columnMap = new HashMap<>();
columnMap.put("last_name","MP");
columnMap.put("email","zhangsan@wangyi.com");
Integer result = employeeMap.deleteByMap(columnMap);

3、批量删除

List<Integer> idList = new Arraylist<>();
idList.add(3);
idList.add(4);
idList.add(5);
Integer result = employeeMapper.deleteBatchIds(idList);