<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>