0531周六

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