我用的方式是:利用mysql特性,拼写insert sql
先写在mapper文件中加入下面的代码:
<insert id="batchInsert" parameterType="List">
insert into TB_SystemInfo (systemID, systemName, createTime,createID,updateUserID, updateTime) values
<foreach collection="list" item="SystemInfo" index="index" separator="," >
(#{SystemInfo.systemID}, #{SystemInfo.systemName}, #{SystemInfo.createTime}, #{SystemInfo.createID}, #{SystemInfo.updateUserID}, #{SystemInfo.updateTime}, )
</foreach>
</insert>
然后在代码中的用法:
@Autowired
private SqlSessionTemplate sqlSessionTemplate;
@Override
public void updateSystemList() {
long t3 = System.currentTimeMillis();
System.out.println("-----------------------开始插入: " + System.currentTimeMillis());
SqlSession sq