示例如下:
此时Mybatis的写法为:
<if test="businessName != null and businessName.size>0">
and e.fname in
<foreach collection="businessName" item="oneItem" separator=","
open="(" close=")">
#{oneItem}
</foreach>
</if>
<if test="areaName != null and areaName.size>0">
and f.fname in
<foreach collection="areaName" item="oneItem" separator=","
open="(" close=")">
#{oneItem}
</foreach>
</if>
顺便说一下get请求参数含有List对象问题。
示例:
此时采用get方式对于businessName和areaName如何传递参数呢?
http://127.0.0.1:8383/salesManager/showSelectSalesInfo?beginDate=2020-01-01%2000:00:00&endDate=2021-01-01%2000:00:00&businessName=123,345&areaName=456,498&showType=2
可以看到list对象之间用英文逗号(,)隔开即可。