mybatis进行批量插入

<insert id="batchInsert" parameterType="java.util.List">
  INSERT INTO person_workover(
  personno, personname,
  currentdate, starttime, endtime,
  lehgthtime, workcost,
  trafficcost, mealcost,
  suncost, creattime,
  creatby, updatetime, updateby,
  year, mouth,aduitstate
  )VALUES
  <foreach collection="list" separator="," index="index" item="item">
    (
    #{item.personno,jdbcType=INTEGER}, #{item.personname,jdbcType=INTEGER},
    #{item.currentdate,jdbcType=INTEGER}, #{item.starttime,jdbcType=VARCHAR}, #{item.endtime,jdbcType=VARCHAR},
    #{item.lehgthtime,jdbcType=VARCHAR}, #{item.workcost,jdbcType=VARCHAR},
    #{item.trafficcost,jdbcType=VARCHAR}, #{item.mealcost,jdbcType=VARCHAR},
    #{item.suncost,jdbcType=VARCHAR}, #{item.creattime,jdbcType=VARCHAR},
    #{item.creatby,jdbcType=TIMESTAMP}, #{item.updatetime,jdbcType=VARCHAR}, #{item.updateby,jdbcType=VARCHAR},
    #{item.year,jdbcType=VARCHAR}, #{item.mouth,jdbcType=VARCHAR}, #{item.aduitstate,jdbcType=VARCHAR}
    )
  </foreach>
</insert>