mybatis批量插入的解决方法， insert 批量插入数据方式

 1     <insert id="listModelInsert" parameterType="list">
 2         INSERT INTO NM_DEVICE_DATA
 3         (ID, DEVICE_ID, TARGET, VALUE, CREATE_TIME,DETAIL)
 4         <foreach collection="list" item="model"  index="index" separator="union all">
 5             select #{model.id},#{model.deviceId}, #{model.target},#{model.value},sysdate,
 6             <if test="model.detail == null">
 7                 '' from dual
 8             </if>
 9             <if test="model.detail != null">
10             #{model.detail}  from dual
11             </if>
12         </foreach>
13     </insert>

小弟不才，若能用当上，万分荣幸

posted on 2015-05-22 11:37 疯狂的狮子阅读(1167) 评论(0) 编辑收藏举报