学生到课率监控系统(go_class_system)_ssm_oracle

超级管理员表创建语句如下：

create table t_admin(
    id integer,
    username varchar(100),
    password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

辅导员表创建语句如下：

create table t_fdy(
    id integer,
    username varchar2(100),
    password varchar2(100),
    fdyName varchar2(100),
    age varchar2(100),
    sex varchar2(100),
    phone varchar2(100)
);
--辅导员字段加注释
comment on column t_fdy.id is '主键';
comment on column t_fdy.username is '账号（真实姓名）';
comment on column t_fdy.password is '密码';
comment on column t_fdy.fdyName is '辅导员名称';
comment on column t_fdy.age is '年龄';
comment on column t_fdy.sex is '性别';
comment on column t_fdy.phone is '电话';
--辅导员表加注释
comment on table t_fdy is '辅导员';

课程表创建语句如下：

create table t_kc(
    id integer,
    kcName varchar2(100),
    num varchar2(100),
    kcxz varchar2(100),
    xf varchar2(100),
    xs varchar2(100),
    sy varchar2(100),
    kkxq varchar2(100),
    jffs varchar2(100),
    sj varchar2(100),
    dd varchar2(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.num is '课程编号';
comment on column t_kc.kcxz is '课程性质';
comment on column t_kc.xf is '学分';
comment on column t_kc.xs is '学时';
comment on column t_kc.sy is '实验';
comment on column t_kc.kkxq is '开课学期';
comment on column t_kc.jffs is '记分方式';
comment on column t_kc.sj is '时间';
comment on column t_kc.dd is '地点';
--课程表加注释
comment on table t_kc is '课程';

课程上课记录表创建语句如下：

create table t_kcsk(
    id integer,
    kcId integer,
    studentId integer,
    types varchar2(100),
    insertDate date,
    bjName varchar2(100)
);
--课程上课记录字段加注释
comment on column t_kcsk.id is '主键';
comment on column t_kcsk.kcId is '课程';
comment on column t_kcsk.studentId is '学生';
comment on column t_kcsk.types is '缺课或在课';
comment on column t_kcsk.insertDate is '点名时间';
comment on column t_kcsk.bjName is '';
--课程上课记录表加注释
comment on table t_kcsk is '课程上课记录';

通知表创建语句如下：

create table t_message(
    id integer,
    title varchar2(100),
    content varchar2(100),
    showDate varchar2(100)
);
--通知字段加注释
comment on column t_message.id is '主键';
comment on column t_message.title is '标题';
comment on column t_message.content is '内容';
comment on column t_message.showDate is '日期';
--通知表加注释
comment on table t_message is '通知';

学生表创建语句如下：

create table t_student(
    id integer,
    username varchar2(100),
    password varchar2(100),
    studentName varchar2(100),
    bj varchar2(100),
    xh varchar2(100),
    sex varchar2(100),
    age varchar2(100),
    phone varchar2(100),
    zw varchar2(100),
    zp varchar2(100),
    status varchar2(100)
);
--学生字段加注释
comment on column t_student.id is '主键';
comment on column t_student.username is '账号（真实姓名）';
comment on column t_student.password is '密码';
comment on column t_student.studentName is '姓名';
comment on column t_student.bj is '班级';
comment on column t_student.xh is '学号';
comment on column t_student.sex is '性别';
comment on column t_student.age is '年龄';
comment on column t_student.phone is '电话';
comment on column t_student.zw is '职务';
comment on column t_student.zp is '照片';
comment on column t_student.status is '';
--学生表加注释
comment on table t_student is '学生';

老师表创建语句如下：

create table t_teacher(
    id integer,
    username varchar2(100),
    password varchar2(100),
    teacherName varchar2(100),
    age varchar2(100),
    sex varchar2(100),
    phone varchar2(100)
);
--老师字段加注释
comment on column t_teacher.id is '主键';
comment on column t_teacher.username is '账号（真实姓名）';
comment on column t_teacher.password is '密码';
comment on column t_teacher.teacherName is '老师名称';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '性别';
comment on column t_teacher.phone is '电话';
--老师表加注释
comment on table t_teacher is '老师';

oracle特有，对应序列如下：

create sequence s_t_fdy;
create sequence s_t_kc;
create sequence s_t_kcsk;
create sequence s_t_message;
create sequence s_t_student;
create sequence s_t_teacher;

辅导员javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//辅导员
public class Fdy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号（真实姓名）
private String username;
//密码
private String password;
//辅导员名称
private String fdyName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getFdyName() {return fdyName;}
public void setFdyName(String fdyName) {this.fdyName = fdyName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

课程javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//课程
public class Kc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程名称
private String kcName;
//课程编号
private String num;
//课程性质
private String kcxz;
//学分
private String xf;
//学时
private String xs;
//实验
private String sy;
//开课学期
private String kkxq;
//记分方式
private String jffs;
//时间
private String sj;
//地点
private String dd;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getNum() {return num;}
public void setNum(String num) {this.num = num;}
public String getKcxz() {return kcxz;}
public void setKcxz(String kcxz) {this.kcxz = kcxz;}
public String getXf() {return xf;}
public void setXf(String xf) {this.xf = xf;}
public String getXs() {return xs;}
public void setXs(String xs) {this.xs = xs;}
public String getSy() {return sy;}
public void setSy(String sy) {this.sy = sy;}
public String getKkxq() {return kkxq;}
public void setKkxq(String kkxq) {this.kkxq = kkxq;}
public String getJffs() {return jffs;}
public void setJffs(String jffs) {this.jffs = jffs;}
public String getSj() {return sj;}
public void setSj(String sj) {this.sj = sj;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
}

课程上课记录javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//课程上课记录
public class Kcsk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程
private Integer kcId;
//学生
private Integer studentId;
//缺课或在课
private String types;
//点名时间
private Date insertDate;
//
private String bjName;
public Integer getKcId() {return kcId;}
public void setKcId(Integer kcId) {this.kcId = kcId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBjName() {return bjName;}
public void setBjName(String bjName) {this.bjName = bjName;}
}

通知javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//通知
public class Message  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

学生javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//学生
public class Student  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号（真实姓名）
private String username;
//密码
private String password;
//姓名
private String studentName;
//班级
private String bj;
//学号
private String xh;
//性别
private String sex;
//年龄
private String age;
//电话
private String phone;
//职务
private String zw;
//照片
private String zp;
//
private String status;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getStudentName() {return studentName;}
public void setStudentName(String studentName) {this.studentName = studentName;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getZp() {return zp;}
public void setZp(String zp) {this.zp = zp;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

老师javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//老师
public class Teacher  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号（真实姓名）
private String username;
//密码
private String password;
//老师名称
private String teacherName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getTeacherName() {return teacherName;}
public void setTeacherName(String teacherName) {this.teacherName = teacherName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}