mybatis插入 对象中含有List属性
bean
public class Paper {
int paperId;
String paperName;
int creator;
String createDate;
List<Integer> questionId;
把data插入到表中,形成三条记录,(8,1),(8,2),(8,3)
@Test
public void Test4(){
ApplicationContext context=new ClassPathXmlApplicationContext("applicationContext.xml");
PaperService paperService= (PaperService) context.getBean("paperService");
Paper paper=new Paper();
paper.setPaperId(8);
paper.setPaperName("哈哈");
paper.setCreator(1);
paper.setCreateDate("2019.9.16");
List<Integer> list =new ArrayList<Integer>();
list.add(1);
list.add(2);
list.add(3);
paper.setQuestionId(list);
System.out.println(paper);
//paperService.addPaper(paper);
paperService.addQuestionToPaper(paper);
}
xml文件
<mapper namespace="com.iotek.rbacapp.mapper.PaperMapper">
<insert id="addQuestionToPaper" parameterType="com.iotek.rbacapp.bean.Paper">
insert into paper_question(paperId,questionId) values
<foreach collection="questionId" separator="," item="items">
(
#{paperId},
#{items}
)
</foreach>
</insert>
</mapper>
成功!