oracle与mysql不同,不能使用常规方式进行批量插入
<insert id="saveInterfaveList">
INSERT ALL
<foreach collection="list" item="interfaceList">
INTO INTERFACE_LIST(ID,PROJECT_ID,INTERFACE_CODE,REQUEST_SYS,RESPONSE_SYS,INTERFACE_MODE,
DESCRIPTION,DATA_FLOW,PROTOCOL,INTERFACE_STATUS,PRD_TIME,REMARKS)
VALUES (#{interfaceList.id,jdbcType=VARCHAR},
#{interfaceList.projectId,jdbcType=VARCHAR},
#{interfaceList.interfaceCode,jdbcType=VARCHAR},
#{interfaceList.requestSys,jdbcType=VARCHAR},
#{interfaceList.responseSys,jdbcType=VARCHAR},
#{interfaceList.interfaceMode,jdbcType=VARCHAR},
#{interfaceList.description,jdbcType=VARCHAR},
#{interfaceList.dataFlow,jdbcType=VARCHAR},
#{interfaceList.protocol,jdbcType=VARCHAR},
#{interfaceList.interfaceStatus,jdbcType=VARCHAR},
#{interfaceList.prdTime,jdbcType=VARCHAR},
#{interfaceList.remarks,jdbcType=VARCHAR})
</foreach>
SELECT * FROM dual
</insert>