我有三个表:create table student(
sid number primary key, //学号
sname varchar2(20), //姓名
spass varchar2(20) //密码
);
create table cource
(
cid number primary key, //课程号
cname varchar2(20), //课程名
stutime number //学时
);
create table sc
(
sid number ,
cid number,
score number, //分数
staTime date, //开课时间
constraint pk primary key(sid,cid),
constraint fk_sid foreign key(sid) references student_tyut(sid),
constraint fk_cid foreign key(cid) references cource_tyut(cid)
);
以及对应的三个类:
public class Student implements Serializable{
private int sid;
private String sname;
private String spass;
//省略setter和getter方法
}
public class Cource implements Serializable { private int cid;
private String cname;
private int stuTime;
//省略setter和getter方法
}
public class StudentCource implements Serializable {
private Student student;
private Cource cource;
private int score;
private Date staTime;
//省略setter和getter方法
}请问:我的StudentCource.hbm.xml要怎么写啊?hibernate的映射有点糊涂,希望达人赐教~
sid number primary key, //学号
sname varchar2(20), //姓名
spass varchar2(20) //密码
);
create table cource
(
cid number primary key, //课程号
cname varchar2(20), //课程名
stutime number //学时
);
create table sc
(
sid number ,
cid number,
score number, //分数
staTime date, //开课时间
constraint pk primary key(sid,cid),
constraint fk_sid foreign key(sid) references student_tyut(sid),
constraint fk_cid foreign key(cid) references cource_tyut(cid)
);
以及对应的三个类:
public class Student implements Serializable{
private int sid;
private String sname;
private String spass;
//省略setter和getter方法
}
public class Cource implements Serializable { private int cid;
private String cname;
private int stuTime;
//省略setter和getter方法
}
public class StudentCource implements Serializable {
private Student student;
private Cource cource;
private int score;
private Date staTime;
//省略setter和getter方法
}请问:我的StudentCource.hbm.xml要怎么写啊?hibernate的映射有点糊涂,希望达人赐教~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货