master:
url: jdbc:mysql://127.0.0.1:3306/qmy-qm-platform?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&**allowMultiQueries=true**
mapper.xml如下:
<insert id="insertQmSearchDatas" parameterType="java.util.List">
insert into qmy_qm_search_data(search_param,search_data,search_ec_queue,search_shareholder_ec_queue,created_time,updated_time)
values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.searchParam},
#{item.searchData},
#{item.searchEcQueue},
#{item.searchShareholderEcQueue},
#{item.createdTime},
#{item.updatedTime})
</foreach>
</insert>
service调用如下:
try {
status = iQmSearchDataService.insertQmSearchDatas(qmSearchDataList);
} catch (Exception e) {
log.error("数据库插入异常" + e.getMessage());
}
会的朋友加qq探讨一下 1479756648