<select id="select_station" parameterClass="java.util.Map" resultClass="fixStationFixcount">
SELECT rec_id recId,
fix_count fixCount,
fix_station_id fixStationId
from fix_station_fixcount
<dynamic prepend="where">
<isNotNull prepend="and" property="productCode">
product_type_code = #productCode#
</isNotNull>
and fix_station_id in
<iterate open="(" close=")" conjunction=","
property="stationlist">
#stationlist[]#
</iterate>
</dynamic>
SELECT rec_id recId,
fix_count fixCount,
fix_station_id fixStationId
from fix_station_fixcount
<dynamic prepend="where">
<isNotNull prepend="and" property="productCode">
product_type_code = #productCode#
</isNotNull>
and fix_station_id in
<iterate open="(" close=")" conjunction=","
property="stationlist">
#stationlist[]#
</iterate>
</dynamic>