浅谈MyBatis循环Map(高级用法)

//service：
public List getByMap(Map> map){
    Map paramsMap= new HashMap();
    params.put("paramsMap", map);
    return this.getByMap(paramsMap);  
}
//dao:
int getByMap(Map map)

//service直接调用dao
int getByMap(@param("paramsMap") Map map)

  
  ${k} = #{k}  
 

  
  ${v} = #{v}  
 

  
    
    ${k} = ${paramsMap[k]}  
   
 

  #{key} = #{value}

  
    
    ${k} = #{paramsMap[k]}  
   
 

  
    
    ${k} = #{paramsMap[${k}]} 
   
 

select * from 表名
where (
  (id = 1 and name in ('悟空','唐僧','八戒') or
  (id = 2 and name in ('刘备','张飞','关羽') or
  (id = 3 and name in ('小三','王五','王八') or
  ……
)

Map> map = new HashMap<>();
List nameList = new ArrayList<>();
nameList.add("悟空");
nameList.add("唐僧");
nameList.add("八戒");
map.put("1",nameList);

nameList = new ArrayList<>();
nameList.add("刘备");
nameList.add("张飞");
nameList.add("关羽");
map.put("2",nameList);

SELECT * FROM 表名
WHERE 

  (id = #{key} AND name in
  
    #{name}
  
  )

SELECT * FROM 表名
WHERE 

  (id = #{key} AND name in
  
    #{name}
  
  )