mybatis select as
- 作者: 王者风范Laughing
- 来源: 51数据库
- 2020-09-26
在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 * 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}
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 * 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}
推荐阅读
