分类:
2008-10-17 13:28:03
Teachers表:
create table TEACHERS
(
ID NUMBER(10) not null,
TEACHERNAME VARCHAR2(15)
)
alter table TEACHERS
add constraint DERE primary key (ID)
Students表:
create table STUDENTS
(
ID NUMBER(10) not null,
STUDENTNAME VARCHAR2(15),
TEACHER_ID NUMBER(10)
)
alter table STUDENTS
add constraint RERE primary key (ID)
alter table STUDENTS
add constraint FFF foreign key (TEACHER_ID)
references TEACHERS (ID);
Teacher.java
package mypack;
public class Teacher {
//教师id
private Long id;
//教师名称
private String teacherName;
/**
* 缺省构造函数
*/
public Teacher() {
}
/**
* 得到教师id
* @return Long 教师id
*/
public Long getId() {
return id;
}
/**
* 设置教师id
* @param id Long 教师id
*/
public void setId(Long id) {
this.id = id;
}
/**
* 得到教师名称
* @return String 教师名称
*/
public String getTeacherName() {
return teacherName;
}
/**
* 设置教师名称
* @param teacherName String 教师名称
*/
public void setTeacherName(String teacherName) {
this.teacherName = teacherName;
}
/**
* 构造函数
* @param teacherName String
*/
public Teacher(String teacherName) {
this.teacherName = teacherName;
}
}
Student.java
package mypack;
public class Student {
//学生id
private Long id;
//学生名称
private String studentName;
//教师类
private Teacher teacher;
/**
* 缺省构造函数
*/
public Student() {
}
/**
* 得到学生id
* @return Long 学生id
*/
public Long getId() {
return id;
}
/**
* 设置学生id
* @param id Long 学生id
*/
public void setId(Long id) {
this.id = id;
}
/**
* 得到学生名称
* @return String 学生名称
*/
public String getStudentName() {
return studentName;
}
/**
* 设置学生名称
* @param studentName String 学生名称
*/
public void setStudentName(String studentName) {
this.studentName = studentName;
}
/**
* 得到教师对象
* @return Teacher 教师对象
*/
public Teacher getTeacher() {
return teacher;
}
/**
* 设置教师对象
* @param teacher Teacher 教师对象
*/
public void setTeacher(Teacher teacher) {
this.teacher = teacher;
}
/**
* 构造函数
* @param string String
* @param teacher Teacher
*/
public Student(String studentName, Teacher teacher) {
this.studentName = studentName;
this.teacher = teacher;
}
}
##
hibernate.dialect net.sf.hibernate.dialect.9Dialect
hibernate.dialect net.sf.hibernate.dialect.OracleDialect
hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
hibernate.connection.username jbcm
hibernate.connection.password jbcm
hibernate.connection.url jdbc:oracle:thin:@localhost:1521:wsy
Teacher.hbm.xml
PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"">
Student.hbm.xml
PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"">
name="teacher"
column="teacher_id"
class="mypack.Teacher"
cascade="save-update"
/>
[1]