spring boot2.0 + mybatis 批量插入

 

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