oracle mybatis实现批量insert
使用mybatis XML文件实现
<insert id="insertBatch" parameterType ="java.util.List" > INSERT INTO TABLE_NAME( column1, column2, column3 ) ( <foreach collection="list" item="item" index="" separator="union all"> select #{item.value1}, #{item.value2}, #{item.value3} from dual </foreach> ) </insert>
浙公网安备 33010602011771号