mybatis批量插入

 
 

  
  <insert id="batchSave" parameterType="java.util.ArrayList" >
 
 
 
 

  
  INSERT INTO j_product_evaluation(PE_ID,PRODUCT_ID,EVALUATION_ITEM_ID,SCORE,
 
 
 
 

  
  STATUS,DESCRIPTION,USER_ID,CREATE_DATE)
 
 
 
 

  
         VALUES
 
 
 
 

  
         <foreach item="item" index="index" collection="list" separator="," >
 
 
 
 

  
          ( #{item.peId}, #{item.productId}, #{item.evaluationItemId} , #{item.score}, 
 
 
 
 

  
  #{item.status}, #{item.description}, #{item.userId}, #{item.createDate})
 
 
 
 

  
         </foreach>
 
 
 
 

  
  </insert>