myBatis 批量写入数据

不想长胖的阿井

于 2023-11-07 19:25:34 发布

阅读量114

点赞数

分类专栏： java 文章标签： mybatis java 开发语言数据库

本文链接：https://blog.csdn.net/qq_22679769/article/details/134268936

版权

java 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

id	name	age
S0001	张三	16
S0002	李四	18

        List paramList = new ArrayList<>();
        Map<String, Object> map = new HashMap<>();
        map.put("id", "S0001");
        map.put("name", "张三");
        map.put("age", 16);
        paramList.add(map);
        Map<String, Object> map1 = new HashMap<>();
        map1.put("id", "S0002");
        map1.put("name", "李四");
        map1.put("age", 18);
        paramList.add(map1);


 <insert id="insertStudentInfo"  parameterType="map">
        <if test="paramList != null and paramList.size() > 0">
            INSERT INTO STUDENT_INFO
            ( ID, NAME, AGE)
            VALUES
            <foreach collection="paramList" item="item" separator=",">
            (#{item.id},#{item.name},#{item.age})
            </foreach>
        </if>
    </insert>