ibatis批量插入
ORACLE:
<insert id="insertList" parameter" > INTO PA_TASK(ID, PROJECT_ID, STATUS, CREATE_TIME, UPDATE_TIME, NAME, TYPE, BUDGET_ID, TOTAL_NUM, END_TIME, FINISH_TIME, USER_ID, CREATOR_ID)VALUES(PA_SEQ.NEXTVAL, #list[].projectId#, #list[].status#, #list[].createTime#, #list[].updateTime#, #list[].name#, #list[].type#, #list[].budgetId#, #list[].totalNum#, #list[].endTime#, #list[].finishTime#, #list[].userId#, #list[].creatorId#)</iterate>SELECT * FROM dual</insert>
<insert id="insertList" parameterclose="" conjunction=",">(#[].projectId#, #[].advertId#, #[].mediaId#)</iterate></insert>
