1. 数据库schema
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);
2. Teacher.java和Student.java
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;
}