List 集合方式
接口:
public int insertList(List<SysUser> list);
xml:
<!-- 批量添加 -->
<insert id="insertList" parameterType="java.util.List">
insert into sys_user(
user_id,dept_id,login_name,user_name,email,
phonenumber,sex,password,salt,status,
create_by,remark,tenant_id,user_type,sign,
delFlag,create_time,update_by,update_time)
values
<foreach collection ="list" item="u" index= "index" separator =",">
(
#{u.userId},#{u.deptId},#{u.loginName},#{u.userName},#{u.email},
#{u.phonenumber},#{u.sex},#{u.password},#{u.salt},#{u.status},
#{u.createBy},#{u.remark},#{u.tenantId},#{u.userType},#{u.sign},
#{u.delFlag},#{u.createTime},#{u.updateBy},#{u.updateTime}
)
</foreach >
</insert>
注意:collection是传入参数的类型