<select id="findbdzq" parameterClass="Map" resultMap="biaodilist">
select SEC_CODE,
SEC_ABBR,
FINANCLE_BIDDING ,
MARGIN_BIDDING,
TRADEMARKET,
ORDER_DATE
from GATHER_DT_BDZQLB tbl
where tbl.IS_VALID ='1'
<isNotEmpty prepend=" and " property="maktype">tbl.TRADEMARKET = #maktype# </isNotEmpty>
and to_char(tbl.ORDER_DATE,'yyyyMMdd')
in <iterate property="datels" open="(" close=")" conjunction=","> #datels[]# </iterate>
order by tbl.TRADEMARKET
</select>
转载于:https://my.oschina.net/gao0516/blog/140548