Mybatis批量安插oracle,mysql

2013-04-02

Mybatis批量插入oracle,mysqloracleinsert idaddUserData parameterTypejava.util.ListINSERT INT

Mybatis批量插入oracle,mysql
oracle

<insert id="addUserData" parameterType="java.util.List">INSERT INTO T_P_USER_DATA (USER_ID, DEPART_ID)<foreach collection="list" item="item" index="index" separator=" UNION ALL ">      SELECT #{item.userId}, #{item.departId} FROM DUAL</foreach>  </insert>

mysql

<insert id="addUserData" parameterType="java.util.List">INSERT INTO T_P_USER_DATA (USER_ID, DEPART_ID)VALUES <foreach collection="list" item="item" index="index"      separator=",">      ( #{item.userId}, #{item.departId})  </foreach>  </insert>