mybatis批量插入

tongjiDao.xml

<!-- 批量插入统计数据 -->
    <insert id="insertBatchTongji">
        INSERT INTO jingji_tjsj_tongji(
            tj_id,
            zb_mb_id,
            zb_code,
            zb_name,
            years,
            months,
            tj_zongliang,
            tj_zengzhang,
            versions,
            create_by,
            create_date,
            update_by,
            update_date,
            remarks,
            status,
            ssjiedian
        ) values
        <foreach collection="list" item="item" index="index" separator=",">
            (
                #{item.tjId},
                #{item.zbMbId},
                #{item.zbCode},
                #{item.zbName},
                #{item.years},
                #{item.months},
                #{item.monthDataZl},
                #{item.monthDataZz},
                #{item.versions},
                #{item.createBy.userCode},
                #{item.createDate},
                #{item.updateBy.userCode},
                #{item.updateDate},
                #{item.remarks},
                #{item.status},
                #{item.ssjiedian}
            )
        </foreach>
    </insert>

tongjidao.java

@MyBatisDao
public interface TongjiDao extends CrudDao<Tongji> {
/**
     * 批量插入统计数据
     * @Title: insertBatchTongji 
     * @Description: 批量插入统计数据
     * @param list
     * @author 杨峰
     * @date 2015年11月20日
     */
    void insertBatchTongji(List<Tongji> list);
}

 

 

转载于:https://www.cnblogs.com/chuanqimessi/p/5258074.html