项目上要求删除全部用逻辑删除,然后遇到有列表多选保存时,刚开始做的是将之前全部删除,再将新选择的内容全部保存,这样的问题会导致数据库里没有用的数据会越来越多,因为每一次调用都会先全部删除,再全部新增,所以想写一个工具类,快速找出哪些是新增,修改,删除的数据
废话少说,直接上代码
/**
* 获取新增修改删除列表
*
* @Param: [oldList:原列表, newList:现列表, key:唯一标识(eg:User::getUserID)]
* @Return: org.apache.commons.lang3.tuple.ImmutableTriple<java.util.List < T>,java.util.List<T>,java.util.List<T>> 左:新增列表 中:修改列表 右:删除列表
* @Author:
* @Date: 2021/7/30 19:16
*/
public static <T> ImmutableTriple<List<T>, List<T>, List<T>> getUpdateList(List<T> oldList, List<T> newList, Function<T, Object> key) {
List<T> insertList = new ArrayList<>();
List<T> updateList = new ArrayList<>();
List<T> deleteList = new ArrayList<>();
Map<Object, T> oldMap = oldList.stream().collect(Collectors.toMap(key, Function.identity(), (key1, key2) -> key2));
Map<Object, T> newMap = newList.stream().collect(Collectors.toMap(key, Function.identity(), (key1, key2) -> key2));
List<Object> codeString = new ArrayList<>();
codeString.addAll(oldMap.keySet());
codeString.addAll(newMap.keySet());
Map<Object, Long> counts = codeString.stream().collect(Collectors.groupingBy(e -> e, Collectors.counting()));
counts.forEach((code, count) -> {
T oldItem = oldMap.get(code);
T newItem = newMap.get(code);
if (count == 1) {
//为新增数据
if (newItem != null) {
insertList.add(newItem);
}
//为删除数据
if (oldItem != null) {
deleteList.add(oldItem);
}
} else {
//为修改数据
updateList.add(newItem);
}
});
return ImmutableTriple.of(insertList, updateList, deleteList);
}