mybatis一对多.docxVIP

Public class classes{Private int id;Private String name;Private Teacher teacher;}Create table student(S_id int primary key auto_increment,S_name varchar(20),Class_id int);Insert into student(s_name,class_id)values(‘jack’,1);Insert into student(s_name,class_id)values(‘lucy’,1);Insert into student(s_name,class_id)values(‘lily’,1);Insert into student(s_name,class_id)values(‘lele’,2);Insert into student(s_name,class_id)values(‘hh,2);Insert into student(s_name,class_id)values(‘kk’,2);Create table class( C_id int primary key auto_increament, C_name varchar(20), Teacher_id int);Public class student{Private int id;Private String name;}Public class classes{Private int id;Private listStudent list;}select id=”getClass” parameterType=”int” resultMap=”getClassMap”Select * from class c,student s where c.c_id=s.class_id and c.c_id=#{id}/selectresultMap type=”Classes” id=”getClassMap”id property=”id” column=”c_id”/result property=”name” column=”c_name”/collection property=”list” ofType=”Student” --list中的Student对象id property=”id” column=”s_id”/result property=”name” column=”s_name”//collection/resultMapClasses c=session.selectone(statement,2);System.out.println(c);!—一对一 --resultMap type=”Classes” id=”getClass2Map”id property=”id” column=”c_id”/result property=”name” column=”c_name”/association property=”teacher” column=”teacher_id” select=”getTeacher”/association/resultMapselect id=”getTeacher” resultType=”Teacher”Select t_id id,t_name name from teacher where t_id=#{id}/selectselect id=”getClass2” resultMap=”getClass2Map”Select * from class where c_id=#{id}/select2) Java BeanGoods.javapublicclass Goods {private Integer goodsId;private String goodsName;private Integer goodsStorageNum;private Integer goodsScore;private GoodsStatus goodsStatus;private String goodsDescription;private ListGoodsImg goodsImgList; ... getter and setter ...}GoodImg.javapublicclass GoodsImg {private Integer imgId;private Integer goodsId;private String imgDir;private Integer imgSize;private String imgName;