<select id="findItTProjectOfferList" resultType="ItTBidProject">
SELECT
<include refid="itTBidProjectColumns"/>
FROM it_t_bid_project a
<include refid="itTBidProjectJoins"/>
<where>
a.project_id in
<foreach item="item" index="index" collection="projectIDList" open="(" separator="," close=")">
#{projectIDList[${index}]}
SELECT
<include refid="itTBidProjectColumns"/>
FROM it_t_bid_project a
<include refid="itTBidProjectJoins"/>
<where>
a.project_id in
<foreach item="item" index="index" collection="projectIDList" open="(" separator="," close=")">
#{projectIDList[${index}]}
</foreach>
说明,程序中JAVA有一个ItTBidProject对象,对象里面有一个List<String> projectIDList;
现在需要in projectIDList里面每一个string