首先需要创建entity的实体类对象,把需要封装的数据封装进去,然后使用一个List集合里面装载entity对象,具体代码如下:
productProcessDrawbackEntityList.add(productProcessDrawbackEntity);
在mybatis的mapper.xml配置文件中这样写表达式和标签,注意标签是select标签
<select id="batchInsertion" parameterType="java.util.List">
INSERT INTO product_process_drawback
(created,
drawback_id,
information,
company_id,
dept_id,
receiver,
master,
attachment,
state
)
VALUES
<foreach collection="list" index="index" item="item" separator=",">
(#{item.created},
#{item.drawbackId},
#{item.information},
#{item.companyId},
#{item.deptId},
#{item.receiver},
#{item.master},
#{item.attachment},
#{item.state}
)
</foreach>
</select>
即可实现批量插入的功能