![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicmbw5yNjdzMjJzMhJzY3QWZwYjZmJWYwcDZzUmZhZWNzIDN18CX0JXZ252bj91Ztl2Lc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
Mysql的insert語句:
mybatis:foreach
Mybatis:批量插入環境搭建:
SysLog實體類:
SysLogMapper:
SysLogMapper.xml:
<insert id="insertLogs" parameterType="list">
insert into sys_log(
id,username,operatingTime,useTime,ip,url,method,requestType,title,businessType,returnArgs
)
VALUES
<foreach collection="sysLogs" item="sysLog" index="index" separator=",">
(
#{sysLog.id},
#{sysLog.username},
#{sysLog.operatingTime},
#{sysLog.useTime},
#{sysLog.ip},
#{sysLog.url},
#{sysLog.method},
#{sysLog.requestType},
#{sysLog.title},
#{sysLog.businessType},
#{sysLog.returnArgs}
)
foreach>
insert>