批量新增批量修改mybatis文件

最新推荐文章于 2024-03-04 10:18:42 发布

layman1024

最新推荐文章于 2024-03-04 10:18:42 发布

阅读量284

点赞数

分类专栏： mybatis

本文链接：https://blog.youkuaiyun.com/layman1024/article/details/80905219

版权

mybatis 专栏收录该内容

18 篇文章

订阅专栏

  <insert id ="batchInsertProcessActual" parameterType="java.util.List" >
        insert into sx_zl_process_actual 
         (
          actual_id, project_name, stake_mark, 
          construction_time, check_time, check_project_name, 
          order_flag, standard_num, deviation, 
          result1, result2, result3, 
          result4, result5, result6, 
          result7, result8, result9, 
          result10, process_id, check_level_id, del_flag, 
          create_time, create_user, create_user_name, 
          modify_time, modify_user, modify_user_name
          )
        values
      <foreach collection ="list" item="item" index= "index" separator=",">
          (
            #{item.actualId,jdbcType=CHAR}, #{item.projectName,jdbcType=VARCHAR}, #{item.stakeMark,jdbcType=VARCHAR}, 
            #{item.constructionTime,jdbcType=TIMESTAMP}, #{item.checkTime,jdbcType=TIMESTAMP}, #{item.checkProjectName,jdbcType=VARCHAR}, 
            #{item.orderFlag,jdbcType=INTEGER}, #{item.standardNum,jdbcType=VARCHAR}, #{item.deviation,jdbcType=VARCHAR}, 
            #{item.result1,jdbcType=VARCHAR}, #{item.result2,jdbcType=VARCHAR}, #{item.result3,jdbcType=VARCHAR}, 
            #{item.result4,jdbcType=VARCHAR}, #{item.result5,jdbcType=VARCHAR}, #{item.result6,jdbcType=VARCHAR}, 
            #{item.result7,jdbcType=VARCHAR}, #{item.result8,jdbcType=VARCHAR}, #{item.result9,jdbcType=VARCHAR}, 
            #{item.result10,jdbcType=VARCHAR},
             #{item.processId,jdbcType=CHAR}, 
             #{item.checkLevelId,jdbcType=CHAR}, 
            #{item.delFlag,jdbcType=CHAR}, 
            #{item.createTime,jdbcType=TIMESTAMP}, #{item.createUser,jdbcType=CHAR}, #{item.createUserName,jdbcType=VARCHAR}, 
            #{item.modifyTime,jdbcType=TIMESTAMP}, #{item.modifyUser,jdbcType=CHAR}, #{item.modifyUserName,jdbcType=VARCHAR}
          )
     </foreach >
  </insert>
 
  <update id="batchUpdateSxZlProcessActual" parameterType="java.util.List">
          <foreach collection="list" item="item" index="index" open="" close="" separator=";" >  
                update sx_zl_process_actual
                <set>
                  project_name = #{item.projectName,jdbcType=VARCHAR},
                  stake_mark = #{item.stakeMark,jdbcType=VARCHAR},
                  construction_time = #{item.constructionTime,jdbcType=TIMESTAMP},
                  check_time = #{item.checkTime,jdbcType=TIMESTAMP},
                  check_project_name = #{item.checkProjectName,jdbcType=VARCHAR},
                  order_flag = #{item.orderFlag,jdbcType=INTEGER},
                  standard_num = #{item.standardNum,jdbcType=VARCHAR},
                  deviation = #{item.deviation,jdbcType=VARCHAR},
                  result1 = #{item.result1,jdbcType=VARCHAR},
                  result2 = #{item.result2,jdbcType=VARCHAR},
                  result3 = #{item.result3,jdbcType=VARCHAR},
                  result4 = #{item.result4,jdbcType=VARCHAR},
                  result5 = #{item.result5,jdbcType=VARCHAR},
                  result6 = #{item.result6,jdbcType=VARCHAR},
                  result7 = #{item.result7,jdbcType=VARCHAR},
                  result8 = #{item.result8,jdbcType=VARCHAR},
                  result9 = #{item.result9,jdbcType=VARCHAR},
                  result10 = #{item.result10,jdbcType=VARCHAR},
                  process_id = #{item.processId,jdbcType=CHAR},
                  check_level_id = #{item.checkLevelId,jdbcType=CHAR},
                  modify_time = #{item.modifyTime,jdbcType=TIMESTAMP},
                  modify_user = #{item.modifyUser,jdbcType=CHAR},
                  modify_user_name = #{item.modifyUserName,jdbcType=VARCHAR}
                </set>  
               where actual_id = #{item.actualId,jdbcType=CHAR}
         </foreach>  
    </update>

dao:

int batchInsertProcessActual(List<SxZlProcessActual> recordList);

int batchUpdateSxZlProcessActual(List<SxZlProcessActual> recordList);