mybatis的批量插入

最新推荐文章于 2022-09-01 13:45:07 发布

me-ht

最新推荐文章于 2022-09-01 13:45:07 发布

阅读量250

点赞数

分类专栏： mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/qq_36745087/article/details/78268651

版权

mybatis 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

<?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="com.jjmc.dcl.dao.SaveMessageLogsDao">
<insert id="insertMessageLogs"  parameterType="java.util.List">
insert into DCL_Message_His (Mobile,User_Type,Message_Type,Send_Status,Created_Data,Des) 
values
<foreach collection="list" item="SaveMessageLogs" index="index" separator="," >  
(#{SaveMessageLogs.mobile},
#{SaveMessageLogs.userType},
#{SaveMessageLogs.messageType},
#{SaveMessageLogs.sendStatus},
#{SaveMessageLogs.createDate},
#{SaveMessageLogs.des})
</foreach>
</insert>
</mapper>
传入的参数类型是一个list<SaveMessageLogs>，SaveMessageLogs是自己定义的一个model类。
================================================================================
<?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="com.jjmc.dcl.dao.SaveMessageLogsDao">
<insert id="insertBatchMessageLogs"  parameterType="java.util.List">
insert into DCL_Message_His (Mobile,User_Type,Message_Type,Send_Status,Created_Data,Des) 
values
<foreach collection="list" item="item" index="index" separator="," >  
(#{item.mobile},
#{item.userType},
#{item.messageType},
#{item.sendStatus},
#{item.createDate},
#{item.des})
</foreach>
</insert> 
传入的参数也可以是List<Map<Object,Object>>，这样就不需要新建一个model类。