<insert id="saveSalesDate" parameterType="hashmap"> insert into sales_date <foreach collection="goodsIds" item="id" index="i"> select #{id},sysdate from dual union </foreach> </insert>我要把最后一个union去掉拼成一个sql,请大神指点一下