sql 查询返回实体类,实体类中装有一个集合
1.实体类中的字段,get/set 方案自己生成,这里就不写了,list里面装的是另一个实体对象
public class StudentBillBean {
private String studentId;
private String child_name;
private String school_pid;
private String school_no;
private String grade;
private String class_in;
private List<ParentBillBean> users;
2.然后在mapper里面对应的关联
<resultMap id="Studnetbill" type="实体类的路径" >
<result column="studentId" property="studentId"/>
<result column="child_name" property="child_name"/>
<result column="class_in" property="class_in"/>
<result column="grade" property="grade"/>
<result column="school_no" property="school_no"/>
<result column="school_pid" property="school_pid"/>
<collection property="users" ofType="List中实体类的路径">
<result column="user_name" property="user_name"/>
<result column="user_mobile" property="user_mobile"/>
<result column="user_relation" property="user_relation"/>
</collection>
</resultMap>
3.然后就可以写sql进行查询了
<resultMap id="collegeMap" type="com.zytb999.aspira.domian.College">
<id property="id" column="ID"/>
<result property="name" column="NAME"/>
<result property="province" column="PROVINCE"/>
<result property="city" column="CITY"/>
<result property="address" column="ADDRESS"/>
<result property="code" column="CODE"/>
<result property="type" column="TYPE"/>
<result property="level" column="LEVEL"/>
<result property="is985" column="IS985"/>
<result property="is211" column="IS211"/>
<result property="isDoubleTop" column="ISDOUBLETOP"/>
<result property="hasPostgraduate" column="HAS_POSTGRADUATE"/>
<result property="attachedTo" column="ATTACHEDTO"/>
<result property="website" column="WEBSITE"/>
<result property="phone" column="PHONE"/>
<result property="careerChoice" column="CAREER_CHOICE"/>
<result property="schoolLogo" column="SCHOOL_LOGO"/>
<result property="instruction" column="INSTRUCTION"/>
<result property="attribute" column="ATTRIBUTE"/>
<result property="isdep" column="ISDEP"/>
<result property="tags" column="TAGS"/>
<association property="collegeIntro" javaType="com.zytb999.aspira.domian.CollegeIntro">
<result property="enrollPlan" column="ENROLL_PLAN"/>
<result property="min" column="MIN"/>
<result property="minRank" column="MINRANK"/>
<result property="forwScore" column="FORW_SCORE"/>
</association>
</resultMap>
private String careerChoice;//就业去向
//private String introduction;//学校简介
@TableField("SCHOOL_LOGO")
private String schoolLogo;//校徽logo的url地址
@TableField("INSTRUCTION")
private String instruction;//学校介绍json格式
@TableField("ATTRIBUTE")
private String attribute;//学校属性
@TableField("ISDEP")
private int isdep;//是否是独立学院
@TableField("TAGS")
private String tags;//学校标签描述
@TableField("XYH_RANK_IDX")
private String xyhRankIdx;
private String[] tagsArray;//标签数组形式
private CollegeIntro collegeIntro;//学校一些详情信息
private UniRank uniRank;//关联学校排行
private List<SchRecom> recoms;//关联相似院校
private List majors;