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

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

--超级管理员
create table t_admin(
    id int identity(1,1) primary key not null,--主键
    username varchar(100),--超级管理员账号
    password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');

辅导员表创建语句如下：

--辅导员表注释
create table t_fdy(
    id int identity(1,1) primary key not null,--主键
    username varchar(100),--账号（真实姓名）
    password varchar(100),--密码
    fdyName varchar(100),--辅导员名称
    age varchar(100),--年龄
    sex varchar(100),--性别
    phone varchar(100)--电话
);

课程表创建语句如下：

--课程表注释
create table t_kc(
    id int identity(1,1) primary key not null,--主键
    kcName varchar(100),--课程名称
    num varchar(100),--课程编号
    kcxz varchar(100),--课程性质
    xf varchar(100),--学分
    xs varchar(100),--学时
    sy varchar(100),--实验
    kkxq varchar(100),--开课学期
    jffs varchar(100),--记分方式
    sj varchar(100),--时间
    dd varchar(100)--地点
);

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

--课程上课记录表注释
create table t_kcsk(
    id int identity(1,1) primary key not null,--主键
    kcId int,--课程
    studentId int,--学生
    types varchar(100),--缺课或在课
    insertDate datetime,--点名时间
    bjName varchar(100)--
);

通知表创建语句如下：

--通知表注释
create table t_message(
    id int identity(1,1) primary key not null,--主键
    title varchar(100),--标题
    content varchar(100),--内容
    showDate varchar(100)--日期
);

学生表创建语句如下：

--学生表注释
create table t_student(
    id int identity(1,1) primary key not null,--主键
    username varchar(100),--账号（真实姓名）
    password varchar(100),--密码
    studentName varchar(100),--姓名
    bj varchar(100),--班级
    xh varchar(100),--学号
    sex varchar(100),--性别
    age varchar(100),--年龄
    phone varchar(100),--电话
    zw varchar(100),--职务
    zp varchar(100),--照片
    status varchar(100)--
);

老师表创建语句如下：

--老师表注释
create table t_teacher(
    id int identity(1,1) primary key not null,--主键
    username varchar(100),--账号（真实姓名）
    password varchar(100),--密码
    teacherName varchar(100),--老师名称
    age varchar(100),--年龄
    sex varchar(100),--性别
    phone varchar(100)--电话
);

辅导员javaBean创建语句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//辅导员
@Table(name = "t_fdy")
public class Fdy {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
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 javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//课程
@Table(name = "t_kc")
public class Kc {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
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 javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//课程上课记录
@Table(name = "t_kcsk")
public class Kcsk {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
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 javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//通知
@Table(name = "t_message")
public class Message {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
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 javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//学生
@Table(name = "t_student")
public class Student {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
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 javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//老师
@Table(name = "t_teacher")
public class Teacher {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
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;}
}