批量删除

 <!-- 批量插入 -->
    <insert id="insertBatch" parameterType="list">
    insert into INCOME_DECLARE_WORKHOUR (
    `UID`,
    PROJ_NO,
    MODIF_VER,
    `MONTH`,
    MEM_EMPID,
    `DAY`,
    WORKHOUR,
    REMARK,
    CREATED_BY,
    CREATED_DATE,
    UPDATED_BY,
    UPDATED_DATE
    )
    values
    <foreach collection="list" item="item" index="index" separator=",">
        (
        #{item.uid,jdbcType=VARCHAR}, 
        #{item.projNo,jdbcType=VARCHAR},
        #{item.modifVer,jdbcType=VARCHAR},
        #{item.month,jdbcType=VARCHAR}, 
        #{item.memEmpid,jdbcType=VARCHAR}, 
        #{item.day,jdbcType=VARCHAR},
        #{item.workhour,jdbcType=DECIMAL}, 
        #{item.remark,jdbcType=VARCHAR},
        #{item.createdBy,jdbcType=VARCHAR},
        #{item.createdDate,jdbcType=TIMESTAMP}, 
        #{item.updatedBy,jdbcType=VARCHAR}, 
        #{item.updatedDate,jdbcType=TIMESTAMP}
        )
    </foreach>
  </insert>

批量删除

删除的时候,如果用主键就是删除一条数据;如果不是用主键,那就是删除多条数据.

这里一次性删除多条数据

    <delete id="deleteBatch" parameterType="map">
    delete from INCOME_DECLARE_WORKHOUR
    where `UID` = #{uid,jdbcType=VARCHAR}
      and PROJ_NO = #{projNo,jdbcType=VARCHAR}
      and MODIF_VER = #{modifVer,jdbcType=VARCHAR}
      and `MONTH` = #{month,jdbcType=VARCHAR}
      and MEM_EMPID = #{memEmpid,jdbcType=VARCHAR}
  </delete>

批量更新

批量更新和批量删除做法一致

  <update id="updateByPrimaryKey" parameterType="com.omcube.iempmg.model.po.IncomeDeclareWorkhour">
    update INCOME_DECLARE_WORKHOUR
    set WORKHOUR = #{workhour,jdbcType=DECIMAL},
      REMARK = #{remark,jdbcType=VARCHAR},
      CREATED_BY = #{createdBy,jdbcType=VARCHAR},
      CREATED_DATE = #{createdDate,jdbcType=TIMESTAMP},
      UPDATED_BY = #{updatedBy,jdbcType=VARCHAR},
      UPDATED_DATE = #{updatedDate,jdbcType=TIMESTAMP}
    where `UID` = #{uid,jdbcType=VARCHAR}
      and PROJ_NO = #{projNo,jdbcType=VARCHAR}
      and MODIF_VER = #{modifVer,jdbcType=VARCHAR}
      and `MONTH` = #{month,jdbcType=VARCHAR}
      and MEM_EMPID = #{memEmpid,jdbcType=VARCHAR}
      and `DAY` = #{day,jdbcType=VARCHAR}
  </update>