Mybatis批量插入

抄自
http://www.linuxidc.com/Linux/2014-02/96916.htm
https://my.oschina.net/jsonavaj/blog/265112

<select id="insertOrderDish" parameterType="java.util.List">  insert into  ordersdish(id,ordersId,dishId)  values  <foreach collection="list" item="item" index="index"   separator=",">   (#{item.id,jdbcType=VARCHAR},#{item.orderId,jdbcType=BIGINT},#{item.dishId,jdbcType=INTEGER})  </foreach> </select>