概述:
记录一下学习
1、mybatis代码
<insert id="insertRoleAuthority" parameterType="com.rinlink.intelligent.entity.RoleInfo">
insert into role_authority(role_id,authority_id,create_by,create_time) values
<foreach collection="authorityIdsArr" item="authorityId" separator="," >
( #{roleId,jdbcType=VARCHAR}, #{authorityId,jdbcType=VARCHAR},
#{createBy,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP})
</foreach>
</insert>
2、生成SQL代码
insert into role_authority(role_id,authority_id,create_by,create_time) values ( ?, ?, ?, ?) , ( ?, ?, ?, ?) , ( ?, ?, ?, ?) , ( ?, ?, ?, ?) , ( ?, ?, ?, ?) , ( ?, ?, ?, ?) , ( ?, ?, ?, ?) , ( ?, ?, ?, ?) , ( ?, ?, ?, ?) , ( ?, ?, ?, ?) , ( ?, ?, ?, ?)
总结:主要传入一个数组数据authorityIdsArr
3、设置联合索引
ALTER TABLE 表名
ADD UNIQUE KEY(字段名1, 字段名2);