- 基于BS模式的研究生综合管理系统设计与实现mysql数据库创建语句
- 基于BS模式的研究生综合管理系统设计与实现oracle数据库创建语句
- 基于BS模式的研究生综合管理系统设计与实现sqlserver数据库创建语句
- 基于BS模式的研究生综合管理系统设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于BS模式的研究生综合管理系统设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于BS模式的研究生综合管理系统设计与实现mysql数据库版本源码：
超级管理员表创建语句如下：
create table t_admin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '超级管理员账号',
password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');
成绩表创建语句如下：
create table t_cj(
id int primary key auto_increment comment '主键',
ptadminId int comment '导师',
studentId int comment '学生',
v1 varchar(100) comment '课程名称',
cj int comment '成绩',
content varchar(100) comment '评语'
) comment '成绩';
导师申请表创建语句如下：
create table t_dssq(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
ptadminId int comment '申请导师',
v1 varchar(100) comment '申请标题',
v3 varchar(100) comment '内容',
insertDate datetime comment '申请日期',
status varchar(100) comment '状态',
back varchar(100) comment '回复'
) comment '导师申请';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '标题',
pic varchar(100) comment '图片',
showDate datetime comment '日期',
v3 varchar(100) comment '内容'
) comment '公告';
课程表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
ptadminId int comment '导师',
v1 varchar(100) comment '课程名称',
v2 varchar(100) comment '每周几次',
v3 varchar(100) comment '共几周',
v4 varchar(100) comment '时间周期',
skdd varchar(100) comment '上课地点',
remark varchar(100) comment '注意事项'
) comment '课程';
论文表创建语句如下：
create table t_lw(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
ptadminId int comment '导师',
v1 varchar(100) comment '论文名称',
fileUrl varchar(100) comment '论文附件',
back varchar(100) comment '评语',
status varchar(100) comment '状态'
) comment '论文';
导师表创建语句如下：
create table t_ptadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ptadminName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
zc varchar(100) comment '职称',
ssxy varchar(100) comment '所属学院',
zykc varchar(100) comment '所授专业课程',
phone varchar(100) comment '电话',
sex varchar(100) comment '性别'
) comment '导师';
培养计划表创建语句如下：
create table t_pyjh(
id int primary key auto_increment comment '主键',
ptadminId int comment '导师',
v1 varchar(100) comment '计划标题',
v3 varchar(100) comment '计划内容',
fileUrl varchar(100) comment '计划附件'
) comment '培养计划';
研究生表创建语句如下：
create table t_student(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
studentName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
nj varchar(100) comment '年级',
zy varchar(100) comment '专业',
ssxy varchar(100) comment '所属学院',
zykc varchar(100) comment '所授专业课程',
ptadminId int comment '所属导师'
) comment '研究生';
基于BS模式的研究生综合管理系统设计与实现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_cj(
id integer,
ptadminId int,
studentId int,
v1 varchar(100),
cj int,
content varchar(100)
);
--成绩字段加注释
comment on column t_cj.id is '主键';
comment on column t_cj.ptadminId is '导师';
comment on column t_cj.studentId is '学生';
comment on column t_cj.v1 is '课程名称';
comment on column t_cj.cj is '成绩';
comment on column t_cj.content is '评语';
--成绩表加注释
comment on table t_cj is '成绩';
导师申请表创建语句如下：
create table t_dssq(
id integer,
studentId int,
ptadminId int,
v1 varchar(100),
v3 varchar(100),
insertDate datetime,
status varchar(100),
back varchar(100)
);
--导师申请字段加注释
comment on column t_dssq.id is '主键';
comment on column t_dssq.studentId is '学生';
comment on column t_dssq.ptadminId is '申请导师';
comment on column t_dssq.v1 is '申请标题';
comment on column t_dssq.v3 is '内容';
comment on column t_dssq.insertDate is '申请日期';
comment on column t_dssq.status is '状态';
comment on column t_dssq.back is '回复';
--导师申请表加注释
comment on table t_dssq is '导师申请';
公告表创建语句如下：
create table t_gg(
id integer,
v1 varchar(100),
pic varchar(100),
showDate datetime,
v3 varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--公告表加注释
comment on table t_gg is '公告';
课程表创建语句如下：
create table t_kc(
id integer,
ptadminId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
skdd varchar(100),
remark varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.ptadminId is '导师';
comment on column t_kc.v1 is '课程名称';
comment on column t_kc.v2 is '每周几次';
comment on column t_kc.v3 is '共几周';
comment on column t_kc.v4 is '时间周期';
comment on column t_kc.skdd is '上课地点';
comment on column t_kc.remark is '注意事项';
--课程表加注释
comment on table t_kc is '课程';
论文表创建语句如下：
create table t_lw(
id integer,
studentId int,
ptadminId int,
v1 varchar(100),
fileUrl varchar(100),
back varchar(100),
status varchar(100)
);
--论文字段加注释
comment on column t_lw.id is '主键';
comment on column t_lw.studentId is '学生';
comment on column t_lw.ptadminId is '导师';
comment on column t_lw.v1 is '论文名称';
comment on column t_lw.fileUrl is '论文附件';
comment on column t_lw.back is '评语';
comment on column t_lw.status is '状态';
--论文表加注释
comment on table t_lw is '论文';
导师表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadminName varchar(100),
age varchar(100),
zc varchar(100),
ssxy varchar(100),
zykc varchar(100),
phone varchar(100),
sex varchar(100)
);
--导师字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.zc is '职称';
comment on column t_ptadmin.ssxy is '所属学院';
comment on column t_ptadmin.zykc is '所授专业课程';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.sex is '性别';
--导师表加注释
comment on table t_ptadmin is '导师';
培养计划表创建语句如下：
create table t_pyjh(
id integer,
ptadminId int,
v1 varchar(100),
v3 varchar(100),
fileUrl varchar(100)
);
--培养计划字段加注释
comment on column t_pyjh.id is '主键';
comment on column t_pyjh.ptadminId is '导师';
comment on column t_pyjh.v1 is '计划标题';
comment on column t_pyjh.v3 is '计划内容';
comment on column t_pyjh.fileUrl is '计划附件';
--培养计划表加注释
comment on table t_pyjh is '培养计划';
研究生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
nj varchar(100),
zy varchar(100),
ssxy varchar(100),
zykc varchar(100),
ptadminId int
);
--研究生字段加注释
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.phone is '电话';
comment on column t_student.age is '年龄';
comment on column t_student.sex is '性别';
comment on column t_student.nj is '年级';
comment on column t_student.zy is '专业';
comment on column t_student.ssxy is '所属学院';
comment on column t_student.zykc is '所授专业课程';
comment on column t_student.ptadminId is '所属导师';
--研究生表加注释
comment on table t_student is '研究生';
oracle特有，对应序列如下：
create sequence s_t_cj;
create sequence s_t_dssq;
create sequence s_t_gg;
create sequence s_t_kc;
create sequence s_t_lw;
create sequence s_t_ptadmin;
create sequence s_t_pyjh;
create sequence s_t_student;
基于BS模式的研究生综合管理系统设计与实现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_cj(
id int identity(1,1) primary key not null,--主键
ptadminId int,--导师
studentId int,--学生
v1 varchar(100),--课程名称
cj int,--成绩
content varchar(100)--评语
);
导师申请表创建语句如下：
--导师申请表注释
create table t_dssq(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
ptadminId int,--申请导师
v1 varchar(100),--申请标题
v3 varchar(100),--内容
insertDate datetime,--申请日期
status varchar(100),--状态
back varchar(100)--回复
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--标题
pic varchar(100),--图片
showDate datetime,--日期
v3 varchar(100)--内容
);
课程表创建语句如下：
--课程表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
ptadminId int,--导师
v1 varchar(100),--课程名称
v2 varchar(100),--每周几次
v3 varchar(100),--共几周
v4 varchar(100),--时间周期
skdd varchar(100),--上课地点
remark varchar(100)--注意事项
);
论文表创建语句如下：
--论文表注释
create table t_lw(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
ptadminId int,--导师
v1 varchar(100),--论文名称
fileUrl varchar(100),--论文附件
back varchar(100),--评语
status varchar(100)--状态
);
导师表创建语句如下：
--导师表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ptadminName varchar(100),--姓名
age varchar(100),--年龄
zc varchar(100),--职称
ssxy varchar(100),--所属学院
zykc varchar(100),--所授专业课程
phone varchar(100),--电话
sex varchar(100)--性别
);
培养计划表创建语句如下：
--培养计划表注释
create table t_pyjh(
id int identity(1,1) primary key not null,--主键
ptadminId int,--导师
v1 varchar(100),--计划标题
v3 varchar(100),--计划内容
fileUrl varchar(100)--计划附件
);
研究生表创建语句如下：
--研究生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
nj varchar(100),--年级
zy varchar(100),--专业
ssxy varchar(100),--所属学院
zykc varchar(100),--所授专业课程
ptadminId int--所属导师
);
登录后主页.jpg?x-oss-process=style/00001)
基于BS模式的研究生综合管理系统设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计：
成绩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_cj")
public class Cj {
//主键
@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 ptadminId;
//学生
private Integer studentId;
//课程名称
private String v1;
//成绩
private Integer cj;
//评语
private String content;
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}导师申请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_dssq")
public class Dssq {
//主键
@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 studentId;
//申请导师
private Integer ptadminId;
//申请标题
private String v1;
//内容
private String v3;
//申请日期
private Date insertDate;
//状态
private String status;
//回复
private String back;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}公告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_gg")
public class Gg {
//主键
@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 v1;
//图片
private String pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}课程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 Integer ptadminId;
//课程名称
private String v1;
//每周几次
private String v2;
//共几周
private String v3;
//时间周期
private String v4;
//上课地点
private String skdd;
//注意事项
private String remark;
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}论文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_lw")
public class Lw {
//主键
@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 studentId;
//导师
private Integer ptadminId;
//论文名称
private String v1;
//论文附件
private String fileUrl;
//评语
private String back;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//年龄
private String age;
//职称
private String zc;
//所属学院
private String ssxy;
//所授专业课程
private String zykc;
//电话
private String phone;
//性别
private String sex;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getSsxy() {return ssxy;}
public void setSsxy(String ssxy) {this.ssxy = ssxy;}
public String getZykc() {return zykc;}
public void setZykc(String zykc) {this.zykc = zykc;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}培养计划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_pyjh")
public class Pyjh {
//主键
@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 ptadminId;
//计划标题
private String v1;
//计划内容
private String v3;
//计划附件
private String fileUrl;
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}研究生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 phone;
//年龄
private String age;
//性别
private String sex;
//年级
private String nj;
//专业
private String zy;
//所属学院
private String ssxy;
//所授专业课程
private String zykc;
//所属导师
private Integer ptadminId;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getNj() {return nj;}
public void setNj(String nj) {this.nj = nj;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getSsxy() {return ssxy;}
public void setSsxy(String ssxy) {this.ssxy = ssxy;}
public String getZykc() {return zykc;}
public void setZykc(String zykc) {this.zykc = zykc;}
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
}基于BS模式的研究生综合管理系统设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
成绩javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//成绩
public class Cj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//导师
private Integer ptadminId;
//学生
private Integer studentId;
//课程名称
private String v1;
//成绩
private Integer cj;
//评语
private String content;
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getCj() {return cj;}
public void setCj(Integer cj) {this.cj = cj;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}导师申请javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//导师申请
public class Dssq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//申请导师
private Integer ptadminId;
//申请标题
private String v1;
//内容
private String v3;
//申请日期
private Date insertDate;
//状态
private String status;
//回复
private String back;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String v1;
//图片
private String pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}课程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 Integer ptadminId;
//课程名称
private String v1;
//每周几次
private String v2;
//共几周
private String v3;
//时间周期
private String v4;
//上课地点
private String skdd;
//注意事项
private String remark;
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getSkdd() {return skdd;}
public void setSkdd(String skdd) {this.skdd = skdd;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}论文javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//论文
public class Lw extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//导师
private Integer ptadminId;
//论文名称
private String v1;
//论文附件
private String fileUrl;
//评语
private String back;
//状态
private String status;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
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 Ptadmin 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 ptadminName;
//年龄
private String age;
//职称
private String zc;
//所属学院
private String ssxy;
//所授专业课程
private String zykc;
//电话
private String phone;
//性别
private String sex;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getSsxy() {return ssxy;}
public void setSsxy(String ssxy) {this.ssxy = ssxy;}
public String getZykc() {return zykc;}
public void setZykc(String zykc) {this.zykc = zykc;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}培养计划javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//培养计划
public class Pyjh extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//导师
private Integer ptadminId;
//计划标题
private String v1;
//计划内容
private String v3;
//计划附件
private String fileUrl;
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
}研究生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 phone;
//年龄
private String age;
//性别
private String sex;
//年级
private String nj;
//专业
private String zy;
//所属学院
private String ssxy;
//所授专业课程
private String zykc;
//所属导师
private Integer ptadminId;
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getNj() {return nj;}
public void setNj(String nj) {this.nj = nj;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getSsxy() {return ssxy;}
public void setSsxy(String ssxy) {this.ssxy = ssxy;}
public String getZykc() {return zykc;}
public void setZykc(String zykc) {this.zykc = zykc;}
public Integer getPtadminId() {return ptadminId;}
public void setPtadminId(Integer ptadminId) {this.ptadminId = ptadminId;}
}