QQ827741251 

 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>

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

 

版权声明：本文为blog-java原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/blog-java/p/4521893.html