mybatis数据库的批量插入

最新推荐文章于 2023-12-01 14:49:31 发布

小徐敲java

最新推荐文章于 2023-12-01 14:49:31 发布

阅读量313

点赞数

文章标签： mybatis 数据库 java

本文链接：https://blog.csdn.net/qq_19891197/article/details/128243906

版权

1：两个批量插入方式的接口

public interface VibratorMapper {


    Integer insert(Map<String, Object> map);

    Integer insertAlarm(List<Map<String, Object>> list);
}

2：批量插入的xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.jeecg.modules.hdx.mapper.VibratorMapper">

	<!--第一是map里面放list批量插入-->
    <insert id="insert" parameterType="java.util.Map">
    INSERT INTO
        ${tableName} (device_ip, channel, content)
        VALUES
        <foreach item="item" index="index" collection="list" separator=",">

          (#{item.deviceIP}, #{item.channel}, #{item.content})
        </foreach>
    </insert>

	<!--第二是list的批量插入-->
    <insert id="insertAlarm" >
        INSERT INTO
        ntcp_alarm (power, deviceStatus, genset, alarmLevel)
        VALUES
        <foreach item="item" index="index" collection="list" separator=",">

            (#{item.power}, #{item.deviceStatus}, #{item.genset}, #{item.alarmLevel})
        </foreach>
    </insert>



</mapper>