- 高校科研管理系统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_gg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
cotnent varchar(100) comment '内容',
showDate datetime comment '日期'
) comment '公告';
科研处表创建语句如下：
create table t_kyc(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
kycName varchar(100) comment '负责人姓名',
phone varchar(100) comment '电话'
) comment '科研处';
项目申请表创建语句如下：
create table t_order(
id int primary key auto_increment comment '主键',
teacherId int comment '老师',
xmmc varchar(100) comment '项目名称',
types varchar(100) comment '类型',
content varchar(100) comment '申请内容',
fileUrl varchar(100) comment '附件',
insertDate datetime comment '申请日期',
status varchar(100) comment '状态',
back1 varchar(100) comment '科研处回复',
back1Date datetime comment '科研处回复日期',
back2 varchar(100) comment '院领导回复',
back2Date datetime 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 '性别'
) comment '老师';
院领导表创建语句如下：
create table t_yld(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
yldName varchar(100) comment '领导姓名',
phone varchar(100) 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_gg(
id integer,
title varchar(100),
pic varchar(100),
cotnent varchar(100),
showDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.cotnent is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';
科研处表创建语句如下：
create table t_kyc(
id integer,
username varchar(100),
password varchar(100),
kycName varchar(100),
phone varchar(100)
);
--科研处字段加注释
comment on column t_kyc.id is '主键';
comment on column t_kyc.username is '账号';
comment on column t_kyc.password is '密码';
comment on column t_kyc.kycName is '负责人姓名';
comment on column t_kyc.phone is '电话';
--科研处表加注释
comment on table t_kyc is '科研处';
项目申请表创建语句如下：
create table t_order(
id integer,
teacherId int,
xmmc varchar(100),
types varchar(100),
content varchar(100),
fileUrl varchar(100),
insertDate datetime,
status varchar(100),
back1 varchar(100),
back1Date datetime,
back2 varchar(100),
back2Date datetime
);
--项目申请字段加注释
comment on column t_order.id is '主键';
comment on column t_order.teacherId is '老师';
comment on column t_order.xmmc is '项目名称';
comment on column t_order.types is '类型';
comment on column t_order.content is '申请内容';
comment on column t_order.fileUrl is '附件';
comment on column t_order.insertDate is '申请日期';
comment on column t_order.status is '状态';
comment on column t_order.back1 is '科研处回复';
comment on column t_order.back1Date is '科研处回复日期';
comment on column t_order.back2 is '院领导回复';
comment on column t_order.back2Date is '院领导回复日期';
--项目申请表加注释
comment on table t_order 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)
);
--老师字段加注释
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 table t_teacher is '老师';
院领导表创建语句如下：
create table t_yld(
id integer,
username varchar(100),
password varchar(100),
yldName varchar(100),
phone varchar(100)
);
--院领导字段加注释
comment on column t_yld.id is '主键';
comment on column t_yld.username is '账号';
comment on column t_yld.password is '密码';
comment on column t_yld.yldName is '领导姓名';
comment on column t_yld.phone is '电话';
--院领导表加注释
comment on table t_yld is '院领导';
oracle特有，对应序列如下：
create sequence s_t_gg;
create sequence s_t_kyc;
create sequence s_t_order;
create sequence s_t_teacher;
create sequence s_t_yld;
高校科研管理系统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_gg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
cotnent varchar(100),--内容
showDate datetime--日期
);
科研处表创建语句如下：
--科研处表注释
create table t_kyc(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
kycName varchar(100),--负责人姓名
phone varchar(100)--电话
);
项目申请表创建语句如下：
--项目申请表注释
create table t_order(
id int identity(1,1) primary key not null,--主键
teacherId int,--老师
xmmc varchar(100),--项目名称
types varchar(100),--类型
content varchar(100),--申请内容
fileUrl varchar(100),--附件
insertDate datetime,--申请日期
status varchar(100),--状态
back1 varchar(100),--科研处回复
back1Date datetime,--科研处回复日期
back2 varchar(100),--院领导回复
back2Date datetime--院领导回复日期
);
老师表创建语句如下：
--老师表注释
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)--性别
);
院领导表创建语句如下：
--院领导表注释
create table t_yld(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
yldName varchar(100),--领导姓名
phone varchar(100)--电话
);
登录后主页.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_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 title;
//图片
private String pic;
//内容
private String cotnent;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date 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_kyc")
public class Kyc {
//主键
@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 kycName;
//电话
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 getKycName() {return kycName;}
public void setKycName(String kycName) {this.kycName = kycName;}
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_order")
public class Order {
//主键
@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 teacherId;
//项目名称
private String xmmc;
//类型
private String types;
//申请内容
private String content;
//附件
private String fileUrl;
//申请日期
private Date insertDate;
//状态
private String status;
//科研处回复
private String back1;
//科研处回复日期
private Date back1Date;
//院领导回复
private String back2;
//院领导回复日期
private Date back2Date;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getXmmc() {return xmmc;}
public void setXmmc(String xmmc) {this.xmmc = xmmc;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 getBack1() {return back1;}
public void setBack1(String back1) {this.back1 = back1;}
public Date getBack1Date() {return back1Date;}
public void setBack1Date(Date back1Date) {this.back1Date = back1Date;}
public String getBack2() {return back2;}
public void setBack2(String back2) {this.back2 = back2;}
public Date getBack2Date() {return back2Date;}
public void setBack2Date(Date back2Date) {this.back2Date = back2Date;}
}老师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;
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;}
}院领导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_yld")
public class Yld {
//主键
@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 yldName;
//电话
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 getYldName() {return yldName;}
public void setYldName(String yldName) {this.yldName = yldName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}高校科研管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
公告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 title;
//图片
private String pic;
//内容
private String cotnent;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}科研处javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//科研处
public class Kyc 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 kycName;
//电话
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 getKycName() {return kycName;}
public void setKycName(String kycName) {this.kycName = kycName;}
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 Order extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//老师
private Integer teacherId;
//项目名称
private String xmmc;
//类型
private String types;
//申请内容
private String content;
//附件
private String fileUrl;
//申请日期
private Date insertDate;
//状态
private String status;
//科研处回复
private String back1;
//科研处回复日期
private Date back1Date;
//院领导回复
private String back2;
//院领导回复日期
private Date back2Date;
public Integer getTeacherId() {return teacherId;}
public void setTeacherId(Integer teacherId) {this.teacherId = teacherId;}
public String getXmmc() {return xmmc;}
public void setXmmc(String xmmc) {this.xmmc = xmmc;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 getBack1() {return back1;}
public void setBack1(String back1) {this.back1 = back1;}
public Date getBack1Date() {return back1Date;}
public void setBack1Date(Date back1Date) {this.back1Date = back1Date;}
public String getBack2() {return back2;}
public void setBack2(String back2) {this.back2 = back2;}
public Date getBack2Date() {return back2Date;}
public void setBack2Date(Date back2Date) {this.back2Date = back2Date;}
}老师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;
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;}
}院领导javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//院领导
public class Yld 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 yldName;
//电话
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 getYldName() {return yldName;}
public void setYldName(String yldName) {this.yldName = yldName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}