mybatis 插入 类里的list属性

类的定义
public class Authority {
    private int roleId;
    private List<Integer> selectList;
}

data：{1,{2,3,4}}

你准备把data插入到表中，形成三条记录，(1,2),(1,3),(1,4)

mybatis这样就可以把类中list属性插入了

<insert id="insertAuthorityByRole" parameterType="com.example.demo.entity.Authority">
    INSERT INTO authority (roleId, menuId)
    VALUES
    <foreach collection="selectList" item="item" index= "index" separator =",">
        (
        #{roleId},
        #{item}
        )
    </foreach>
</insert>