sql.xml 文件
<insert id="testxxx22" parameterType="java.util.List">
INSERT INTO sy_test (
open_id,
sy_code,
card_img,
card_name,
card_title
)
VALUES
<foreach collection="list" item="SystemInfo" index="index" separator="," >
(#{SystemInfo.open_id}, #{SystemInfo.sy_code}, #{SystemInfo.card_img}, #{SystemInfo.card_name}, #{SystemInfo.card_title} )
</foreach>
</insert>
Mapper文件
int testxxx(@Param("open_id") String open_id,@Param("sy_code") String sy_code,
@Param("card_img") String card_img,@Param("card_name") String card_name,
@Param("card_title") String card_title);
Service文件
@Autowired
private SqlSessionTemplate sqlSessionTemplate;
public int testxxx(List<Map> SSDSA) {
SqlSession sqlSession = sqlSessionTemplate.getSqlSessionFactory().openSession(ExecutorType.BATCH,false);
try {
sqlSession.insert("com.dzh.MyBatis.mapper.sql.testxxx22",SSDSA);
sqlSession.commit(); //提交事务
sqlSession.clearCache();//清除缓存
}catch (Exception e) {
//没有提交的数据可以回滚
sqlSession.rollback();
}finally {
sqlSession.close();
}
sqlSession.close();
return 1;
}
参考文章 https://blog.csdn.net/weixin_42884584/article/details/82379664