mybatis使用in
- 作者: 狼大大3640766
- 来源: 51数据库
- 2020-10-02
在service中把参数放到HashMap中
List list = new ArrayList();
list.add("x");
list.add("y");
list.add("z");
String s = "A"
Date d = new Date();
HashMap param = new HashMap();
param.put("list",list);
param.put("s",s);
param.put("d",d);
XXXDao.queryXXX(param);
在Mybatis的Mapper中是这么写：
<select id="findbyidsmap" resultmap="baseresultmap"> select * from tb1 where id in <foreach item="item" index="index" collection="list" open="(" separator="," close=")"> #{item} </foreach> </select><select id="findbyidsmap" resultmap="baseresultmap"> select * from tb1 where id in <foreach item="item" index="index" collection="array" open="(" separator="," close=")"> #{item} </foreach> </select>根据参数类型进行选择
List
list.add("x");
list.add("y");
list.add("z");
String s = "A"
Date d = new Date();
HashMap
param.put("list",list);
param.put("s",s);
param.put("d",d);
XXXDao.queryXXX(param);
在Mybatis的Mapper中是这么写：
<select id="findbyidsmap" resultmap="baseresultmap"> select * from tb1 where id in <foreach item="item" index="index" collection="list" open="(" separator="," close=")"> #{item} </foreach> </select><select id="findbyidsmap" resultmap="baseresultmap"> select * from tb1 where id in <foreach item="item" index="index" collection="array" open="(" separator="," close=")"> #{item} </foreach> </select>根据参数类型进行选择
推荐阅读
