类的定义 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>