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;
}
}
## Oracle
hibernate.dialect net.sf.hibernate.dialect.Oracle9Dialect
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
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping >
<class name="mypack.Teacher" table="teachers" >
<id name="id" type="long" column="ID">
<generator class="increment"/>
</id>
<property name="teacherName" type="string" >
<column name="teacherName" length="15" />
</property>
</class>
</hibernate-mapping>
Student.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping >
<class name="mypack.Student" table="students" >
<id name="id" type="long" column="ID">
<generator class="increment"/>
</id>
<property name="studentName" type="string" >
<column name="studentName" length="15" />
</property>
<many-to-one
name="teacher"
column="teacher_id"
class="mypack.Teacher"
cascade="save-update"
/>
</class>
</hibernate-mapping>

