Mybatis-新增

1.添加对象

	<insert id="insert" parameterType="****.pojo.event">
		insert into t_event (eventId,name,remark)
		values(#{eventId,jdbcType=INTEGER},#{name,jdbcType=VARCHAR},#{remark,jdbcType=VARCHAR})
	</insert>

2.对象的批量新增，具有多个属性

 

<insert id="insertBatch" parameterType="java.util.List">
	 insert into t_event (eventId,name) values
	 <foreach collection="list" item="item" index="index" separator="," >  
       (#{item.eventId},#{item.name})  
  	 </foreach>  
</insert>

3.表格仅具有一列，新增批量

 

    <insert id="insertBatch" parameterType="java.lang.String">  
        insert into t_event (eventId) values
        <foreach collection="list" item="item" index="index" separator="," >  
        (#{item})  
  	</foreach>  
    </insert>