SSM mybatis 批量插入数据

 PageData pd = new PageData();

 List<PageData> list = new ArrayList<PageData>();

 pd.put("UPDATE_TIME", new Date()); //修改时间
 pd.put("CREATE_NAME", Jurisdiction.getUsername()); //创建人姓名
 pd.put("UPDATE_NAME", Jurisdiction.getUsername()); //修改人姓名
 list.add(pd);

-------------------------------------------------

public void addEmpByBatch(List<PageData> list) throws Exception {
    dao.delete("JinXiuMapper.addEmpByBatch", list);
}

-------------------------------------------------

INSERT INTO user(
USER_ID,
USER_NAME,
USER_AREA,
CREATE_TIME,
UPDATE_TIME,
CREATE_NAME,
UPDATE_NAME,
BIRTHDAY
)
values
<foreach collection="list" item="item" index="index" separator="," >
    (
    #{item.USER_ID},
    #{item.USER_NAME},
    #{item.USER_AREA},
    #{item.CREATE_TIME},
    #{item.UPDATE_TIME},
    #{item.CREATE_NAME},
    #{item.UPDATE_NAME},
    #{item.BIRTHDAY}

    )
</foreach>

转载于:https://www.cnblogs.com/g-yang/p/9527982.html