學生到課率監控系統(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;}}