mybatis foreach标签模糊查询
<select id="searchByRouteStatus"parameterType="java.util.Map" resultMap="BaseResultMapExt">select
<include refid="Base_Column_List_Ext" />
from "t_tourist_route" tr
<where>
tr.status_id in
<!--statusList 为map中的键值-->
<foreach close=")" collection="statusList" item="item" open="("
separator=",">
#{item}
</foreach>
<if test="departureDate!=null">
<if test="returnDate!=null">
and tr.departure_date BETWEEN #{departureDate} AND
#{returnDate}
</if>
</if>
<if test="routeName!=null">
and tr.route_name like '%'||#{routeName}||'%'
</if>
<if test="routeNumber!=null">
and tr.route_number like '%'||#{routeNumber}||'%'
</if>
</where>
</select>
页:
[1]