在mybatis中應該這樣使用
<insert id="insertRecordBatch" parameterType="java.util.List"> insert all <foreach collection="list" item="item" index="index" separator=" " > into RAW_AMORT_SCHEDULE(BOND_CODE,AMORTIZE_DATE,AMORTIZE_TYPE,AMORTIZE_RATE,REMARKS) values (#{item.bondCode},to_date(#{item.amortizeDate},'YYYYMMDD'),#{item.amortizeType},#{item.amortizeRate},#{item.remarks}) </foreach> SELECT 1 FROM DUAL </insert>新聞熱點
疑難解答
