<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>
新闻热点
疑难解答