81,092
社区成员
发帖
与我相关
我的任务
分享
public class Teacher {
private int TID;
private List<Major> majors ;}
public class Major {
private int MID;
private List<Major> ;}
这样就行了,不用new<class name="Teacher">
<id name="id" column="TID">
<generator class="native"/> </id>
<set name="majors" table="Teacher_Major" inverse="false">
<key column="TeacherId"/>
<many-to-many column="MajorId"
class="Major"/>
</set></class>
public class Teacher {
private int TID;
private List<Major> majors = new ArrayList<Major>();
}
public class Major {
private int MID;
private List<Major> majors = new ArrayList<Major>();
}
还有什么属性自己加,配置文件里也有加,类中加get set方法
测试这样就行了:
List<Major> majors = new ArrayList<Major>();
Major m = new Major();
majors.add(m);
Teather t = new Teacher();
t.setMajors(majors);
//这有什么属性往里set就行了
session.save(t);
<class name="Teacher">
<id name="id" column="TID">
<generator class="native"/>
</id>
<set name="majors" table="Teacher_Major">
<key column="TeacherId"/>
<many-to-many column="MajorId"
class="Major"/>
</set>
</class>
<class name="Major">
<id name="id" column="MID">
<generator class="native"/>
</id>
<set name="techers" inverse="true" table="Teacher_Major">
<key column="MajorId"/>
<many-to-many column="TeacherId"
class="Teacher"/>
</set>
</class>
教师表 T_TEACHER 专业表T_MAJOR 教师和专业的关联表 T_TEACHER_MAJOR
T_TEACHER(TID,TNAME,TAGE....,TS);
T_MAJOR(MID,MNAME,MDESC....,TS);
T_TEACHER_MAJOR(TID,MID,TS);
教师教的专业是什么:
SELECT T_TEACHER_MAJOR.TID,T_TEACHER.TNAME,T_TEACHER_MAJOR.MID,T_MAJOR.MNAME
FROM T_TEACHER_MAJOR,T_TEACHER,T_MAJOR
WHERE T_TEACHER_MAJOR.TID = T_TEACHER.TID
AND T_TEACHER_MAJOR.MID = T_MAJOR.MID;
如果确实需要一个“表”,把上面的sql做成视图