mybatis批量插入

1.实体类

@Data
@TableName("sys_user")
public class SysUserEntity implements Serializable {
    //用户ID
    @TableId
    private Long userId;

//角色ID列表

  @TableField(exist=false)
  private List<Long> roleIdList;

}

2.

3.

@Repository
public interface SysUserRoleDao extends BaseMapper<SysUserRoleEntity> {
    void add(@Param("SysUserEntity") SysUserEntity user);
}

4.

<insert id="add" parameterType="SysUserEntity">
    insert into sys_user_role (user_id,role_id) values
    <foreach collection="SysUserEntity.roleIdList" item="item" index="index" separator=",">
        (#{SysUserEntity.userId,jdbcType=BIGINT},
        #{item,jdbcType=BIGINT})
    </foreach>
</insert>