- Map类型参数paramMap的预处理
//初始化Map
Map<String, String> paramMap = new HashMap<>(16);
//put键值对
paramMap.put("BKLB","2");
paramMap.put("BKBSM","T");
paramMap.put("","s");
paramMap.put("BKHM",null);
//移除key为null、空串,value为null、空串的键值对
Map<String, String> newMap = paramMap.entrySet().stream().filter((e) ->
e.getValue() != null && e.getValue() != "" &&
e.getKey() != null && e.getKey() != "").collect(Collectors.toMap(
(e) -> (String) e.getKey(),
(e) -> (String) e.getValue()));
- mybatis中的处理
<update id="deleteList" parameterType="java.util.Map" >
update PC_CLBMDXXSJX
set DELETE_FLAG = '1'
<where>
1 = 0 OR (1 = 1