Mybatis sql in
- 作者: 断惆怅
- 来源: 51数据库
- 2020-10-03
在service中把参数放到HashMap中
List<String> list = new ArrayList<String>();
list.add("x");
list.add("y");
list.add("z");
String s = "A"
Date d = new Date();
HashMap<String,Object> param = new HashMap<String,Object>();
param.put("list",list);
param.put("s",s);
param.put("d",d);
XXXDao.queryXXX(param);
在Mybatis的Mapper中是这么写:
<select id = "queryXXX",resultType = "XXX", paramterType = "java.lang.HashMap">
select * from tab where zi_duan1 = #{s} and zi_duan2 = #{d}
and zi_duan3 in
<foreach item="item" index="index" collection="list" open="("
separator="," close=")">
#{item}
</foreach>
</select>
List<String> list = new ArrayList<String>();
list.add("x");
list.add("y");
list.add("z");
String s = "A"
Date d = new Date();
HashMap<String,Object> param = new HashMap<String,Object>();
param.put("list",list);
param.put("s",s);
param.put("d",d);
XXXDao.queryXXX(param);
在Mybatis的Mapper中是这么写:
<select id = "queryXXX",resultType = "XXX", paramterType = "java.lang.HashMap">
select * from tab where zi_duan1 = #{s} and zi_duan2 = #{d}
and zi_duan3 in
<foreach item="item" index="index" collection="list" open="("
separator="," close=")">
#{item}
</foreach>
</select>
推荐阅读