Mybatis批量插入 插入或更新

 插入或更新

<insert id="insertORupdate" parameterType="model.BookClick" >
    insert into t_book_click (id, book_id, click_num, 
      create_date, update_time,type)
    values (#{id,jdbcType=INTEGER}, #{bookId,jdbcType=INTEGER}, #{clickNum,jdbcType=INTEGER}, 
      #{createDate,jdbcType=VARCHAR}, #{updateTime,jdbcType=TIMESTAMP},#{type,jdbcType=INTEGER})
      ON DUPLICATE KEY UPDATE click_num=click_num+#{clickNum},update_time=VALUES(update_time);
 
  </insert>

 

批量插入

 <insert id="insertBatch" parameterType="java.util.List">
  	insert into t_app_info
  	(code,code_name,customer_id,param,app_from_type,system_info,udid,num,create_time)
  	values
  	<foreach collection="list" item="info" index="index" separator=",">
  	(
  	#{info.code},#{info.codeName},#{info.customerId},#{info.param},#{info.appFromType},
  	#{info.systemInfo},#{info.udid},#{info.num},#{info.createTime}
  	)
  	</foreach>
  </insert>