代码改变世界

mybatis批量插入数据

2016-04-29 14:53  夜半花开  阅读(218)  评论(0编辑  收藏  举报
 <insert id="batchInsert" parameterType="java.util.Map" >
     insert into t_cm_dept_branch (ID, DEPT_ID, BRANCH_ID, 
      DEPT_NAME, BRANCH_NAME, CREATE_USER, 
      CREATE_TIME,DEPT_TYPE,BRANCH_ISPARENT) values
     <foreach collection="list" item="item" separator=",">
         (#{item.id}, #{item.deptId}, #{item.branchId}, 
          #{item.deptName}, #{item.branchName}, #{item.createUser}, 
          #{item.createTime},#{item.deptType},#{item.branchIsParent})
     </foreach>
  </insert>