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>