- 教师课时及科研成果统计系统mysql数据库创建语句
- 教师课时及科研成果统计系统oracle数据库创建语句
- 教师课时及科研成果统计系统sqlserver数据库创建语句
- 教师课时及科研成果统计系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 教师课时及科研成果统计系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
教师课时及科研成果统计系统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_keyan(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
title varchar(100) comment '项目名称',
content text comment '详细说明',
pic varchar(100) comment '附件',
status varchar(100) comment '状态',
back text comment '回复',
insertDate datetime comment '发起日期'
) comment '科研成果申报';
上课课时表创建语句如下：
create table t_ks(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
showDate datetime comment '日期',
nums int comment '上课课时',
ksName varchar(100) comment '课程名称',
dd varchar(100) comment '地点',
remark text comment '备注'
) comment '上课课时';
老师表创建语句如下：
create table t_teacher(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
teacherName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
zc varchar(100) comment '职称',
yx varchar(100) comment '院系'
) comment '老师';
通知公告表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '日期'
) comment '通知公告';
咨询表创建语句如下：
create table t_zixun(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
content text comment '问题',
status varchar(100) comment '状态',
back text comment '回复',
insertDate datetime comment '日期'
) comment '咨询';
教师课时及科研成果统计系统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_keyan(
id integer,
teacherId int,
title varchar(100),
content text,
pic varchar(100),
status varchar(100),
back text,
insertDate datetime
);
--科研成果申报字段加注释
comment on column t_keyan.id is '主键';
comment on column t_keyan.teacherId is '老师';
comment on column t_keyan.title is '项目名称';
comment on column t_keyan.content is '详细说明';
comment on column t_keyan.pic is '附件';
comment on column t_keyan.status is '状态';
comment on column t_keyan.back is '回复';
comment on column t_keyan.insertDate is '发起日期';
--科研成果申报表加注释
comment on table t_keyan is '科研成果申报';
上课课时表创建语句如下：
create table t_ks(
id integer,
teacherId int,
showDate datetime,
nums int,
ksName varchar(100),
dd varchar(100),
remark text
);
--上课课时字段加注释
comment on column t_ks.id is '主键';
comment on column t_ks.teacherId is '老师';
comment on column t_ks.showDate is '日期';
comment on column t_ks.nums is '上课课时';
comment on column t_ks.ksName is '课程名称';
comment on column t_ks.dd is '地点';
comment on column t_ks.remark is '备注';
--上课课时表加注释
comment on table t_ks is '上课课时';
老师表创建语句如下：
create table t_teacher(
id integer,
username varchar(100),
password varchar(100),
teacherName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
zc varchar(100),
yx varchar(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.phone is '电话';
comment on column t_teacher.age is '年龄';
comment on column t_teacher.sex is '';
comment on column t_teacher.zc is '职称';
comment on column t_teacher.yx is '院系';
--老师表加注释
comment on table t_teacher is '老师';
通知公告表创建语句如下：
create table t_tongzhi(
id integer,
title varchar(100),
content text,
insertDate datetime
);
--通知公告字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知公告表加注释
comment on table t_tongzhi is '通知公告';
咨询表创建语句如下：
create table t_zixun(
id integer,
teacherId int,
content text,
status varchar(100),
back text,
insertDate datetime
);
--咨询字段加注释
comment on column t_zixun.id is '主键';
comment on column t_zixun.teacherId is '老师';
comment on column t_zixun.content is '问题';
comment on column t_zixun.status is '状态';
comment on column t_zixun.back is '回复';
comment on column t_zixun.insertDate is '日期';
--咨询表加注释
comment on table t_zixun is '咨询';
oracle特有，对应序列如下：
create sequence s_t_keyan;
create sequence s_t_ks;
create sequence s_t_teacher;
create sequence s_t_tongzhi;
create sequence s_t_zixun;
教师课时及科研成果统计系统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_keyan(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
title varchar(100),--项目名称
content text,--详细说明
pic varchar(100),--附件
status varchar(100),--状态
back text,--回复
insertDate datetime--发起日期
);
上课课时表创建语句如下：
--上课课时表注释
create table t_ks(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
showDate datetime,--日期
nums int,--上课课时
ksName varchar(100),--课程名称
dd varchar(100),--地点
remark text--备注
);
老师表创建语句如下：
--老师表注释
create table t_teacher(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
teacherName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
zc varchar(100),--职称
yx varchar(100)--院系
);
通知公告表创建语句如下：
--通知公告表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime--日期
);
咨询表创建语句如下：
--咨询表注释
create table t_zixun(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
content text,--问题
status varchar(100),--状态
back text,--回复
insertDate datetime--日期
);
登录后主页.jpg?x-oss-process=style/00001)
教师课时及科研成果统计系统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_keyan")
public class Keyan {
//主键
@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 Long teacherId;
//项目名称
private String title;
//详细说明
private String content;
//附件
private String pic;
//状态
private String status;
//回复
private String back;
//发起日期
private Date insertDate;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}上课课时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_ks")
public class Ks {
//主键
@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 Long teacherId;
//日期
private Date showDate;
//上课课时
private Integer nums;
//课程名称
private String ksName;
//地点
private String dd;
//备注
private String remark;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public String getKsName() {return ksName;}
public void setKsName(String ksName) {this.ksName = ksName;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
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_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 phone;
//年龄
private String age;
//
private String sex;
//职称
private String zc;
//院系
private String yx;
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 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 getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
}通知公告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_tongzhi")
public class Tongzhi {
//主键
@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 Date insertDate;
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}咨询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_zixun")
public class Zixun {
//主键
@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 Long teacherId;
//问题
private String content;
//状态
private String status;
//回复
private String back;
//日期
private Date insertDate;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}教师课时及科研成果统计系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
科研成果申报javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//科研成果申报
public class Keyan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Long teacherId;
//项目名称
private String title;
//详细说明
private String content;
//附件
private String pic;
//状态
private String status;
//回复
private String back;
//发起日期
private Date insertDate;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}上课课时javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//上课课时
public class Ks extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Long teacherId;
//日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//上课课时
private Integer nums;
//课程名称
private String ksName;
//地点
private String dd;
//备注
private String remark;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public String getKsName() {return ksName;}
public void setKsName(String ksName) {this.ksName = ksName;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
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 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 phone;
//年龄
private String age;
//
private String sex;
//职称
private String zc;
//院系
private String yx;
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 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 getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
}通知公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//通知公告
public class Tongzhi 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 Date insertDate;
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}咨询javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//咨询
public class Zixun extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Long teacherId;
//问题
private String content;
//状态
private String status;
//回复
private String back;
//日期
private Date insertDate;
public Long getTeacherId() {return teacherId;}
public void setTeacherId(Long teacherId) {this.teacherId = teacherId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
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;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}