基于WEB实验室预约系统

基于WEB实验室预约系统登录注册界面

基于WEB实验室预约系统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_kc(
	id int primary key auto_increment comment '主键',
	libId int comment '实验室',
	yyDate varchar(100) comment '预约日期',
	zc varchar(100) comment '周次',
	kcName varchar(100) comment '课程名称',
	sjd varchar(100) comment '时间段'
) comment '插入课程';

实验室表创建语句如下:


create table t_lib(
	id int primary key auto_increment comment '主键',
	libName varchar(100) comment '实验室名称',
	address varchar(100) comment '地址',
	sysmId int comment '实验室负责人',
	phone varchar(100) comment '实验室电话',
	sx int 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 '姓名',
	email varchar(100) comment '邮箱',
	phone varchar(100) comment '电话',
	bj varchar(100) comment '班级'
) comment '学生';

实验室管理员表创建语句如下:


create table t_sysm(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '工号',
	password varchar(100) comment '密码',
	sysmName varchar(100) comment '姓名',
	email varchar(100) comment '邮箱',
	phone varchar(100) comment '电话'
) comment '实验室管理员';

实验室预约表创建语句如下:


create table t_yy(
	id int primary key auto_increment comment '主键',
	libId int comment '实验室',
	yyDate varchar(100) comment '预约日期',
	xq varchar(100) comment '星期',
	zc varchar(100) comment '周次',
	studentId int comment '学生',
	status varchar(100) comment '状态',
	sjd varchar(100) comment '时间段',
	resion varchar(100) comment '审核原因'
) comment '实验室预约';

基于WEB实验室预约系统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_kc(
	id integer,
	libId int,
	yyDate varchar(100),
	zc varchar(100),
	kcName varchar(100),
	sjd varchar(100)
);
--插入课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.libId is '实验室';
comment on column t_kc.yyDate is '预约日期';
comment on column t_kc.zc is '周次';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.sjd is '时间段';
--插入课程表加注释
comment on table t_kc is '插入课程';

实验室表创建语句如下:


create table t_lib(
	id integer,
	libName varchar(100),
	address varchar(100),
	sysmId int,
	phone varchar(100),
	sx int
);
--实验室字段加注释
comment on column t_lib.id is '主键';
comment on column t_lib.libName is '实验室名称';
comment on column t_lib.address is '地址';
comment on column t_lib.sysmId is '实验室负责人';
comment on column t_lib.phone is '实验室电话';
comment on column t_lib.sx is '单个时间段人员上限';
--实验室表加注释
comment on table t_lib is '实验室';

学生表创建语句如下:


create table t_student(
	id integer,
	username varchar(100),
	password varchar(100),
	studentName varchar(100),
	email varchar(100),
	phone varchar(100),
	bj varchar(100)
);
--学生字段加注释
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.email is '邮箱';
comment on column t_student.phone is '电话';
comment on column t_student.bj is '班级';
--学生表加注释
comment on table t_student is '学生';

实验室管理员表创建语句如下:


create table t_sysm(
	id integer,
	username varchar(100),
	password varchar(100),
	sysmName varchar(100),
	email varchar(100),
	phone varchar(100)
);
--实验室管理员字段加注释
comment on column t_sysm.id is '主键';
comment on column t_sysm.username is '工号';
comment on column t_sysm.password is '密码';
comment on column t_sysm.sysmName is '姓名';
comment on column t_sysm.email is '邮箱';
comment on column t_sysm.phone is '电话';
--实验室管理员表加注释
comment on table t_sysm is '实验室管理员';

实验室预约表创建语句如下:


create table t_yy(
	id integer,
	libId int,
	yyDate varchar(100),
	xq varchar(100),
	zc varchar(100),
	studentId int,
	status varchar(100),
	sjd varchar(100),
	resion varchar(100)
);
--实验室预约字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.libId is '实验室';
comment on column t_yy.yyDate is '预约日期';
comment on column t_yy.xq is '星期';
comment on column t_yy.zc is '周次';
comment on column t_yy.studentId is '学生';
comment on column t_yy.status is '状态';
comment on column t_yy.sjd is '时间段';
comment on column t_yy.resion is '审核原因';
--实验室预约表加注释
comment on table t_yy is '实验室预约';

oracle特有,对应序列如下:


create sequence s_t_kc;
create sequence s_t_lib;
create sequence s_t_student;
create sequence s_t_sysm;
create sequence s_t_yy;

基于WEB实验室预约系统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_kc(
	id int identity(1,1) primary key not null,--主键
	libId int,--实验室
	yyDate varchar(100),--预约日期
	zc varchar(100),--周次
	kcName varchar(100),--课程名称
	sjd varchar(100)--时间段
);

实验室表创建语句如下:


--实验室表注释
create table t_lib(
	id int identity(1,1) primary key not null,--主键
	libName varchar(100),--实验室名称
	address varchar(100),--地址
	sysmId int,--实验室负责人
	phone varchar(100),--实验室电话
	sx int--单个时间段人员上限
);

学生表创建语句如下:


--学生表注释
create table t_student(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--学号
	password varchar(100),--密码
	studentName varchar(100),--姓名
	email varchar(100),--邮箱
	phone varchar(100),--电话
	bj varchar(100)--班级
);

实验室管理员表创建语句如下:


--实验室管理员表注释
create table t_sysm(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--工号
	password varchar(100),--密码
	sysmName varchar(100),--姓名
	email varchar(100),--邮箱
	phone varchar(100)--电话
);

实验室预约表创建语句如下:


--实验室预约表注释
create table t_yy(
	id int identity(1,1) primary key not null,--主键
	libId int,--实验室
	yyDate varchar(100),--预约日期
	xq varchar(100),--星期
	zc varchar(100),--周次
	studentId int,--学生
	status varchar(100),--状态
	sjd varchar(100),--时间段
	resion varchar(100)--审核原因
);

基于WEB实验室预约系统登录后主页

基于WEB实验室预约系统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_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 libId;
//预约日期
private String yyDate;
//周次
private String zc;
//课程名称
private String kcName;
//时间段
private String sjd;
public Integer getLibId() {return libId;}
public void setLibId(Integer libId) {this.libId = libId;}
public String getYyDate() {return yyDate;}
public void setYyDate(String yyDate) {this.yyDate = yyDate;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getSjd() {return sjd;}
public void setSjd(String sjd) {this.sjd = sjd;}
}

实验室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_lib")
public class Lib {
//主键
@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 libName;
//地址
private String address;
//实验室负责人
private Integer sysmId;
//实验室电话
private String phone;
//单个时间段人员上限
private Integer sx;
public String getLibName() {return libName;}
public void setLibName(String libName) {this.libName = libName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Integer getSysmId() {return sysmId;}
public void setSysmId(Integer sysmId) {this.sysmId = sysmId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getSx() {return sx;}
public void setSx(Integer sx) {this.sx = sx;}
}

学生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 email;
//电话
private String phone;
//班级
private String bj;
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 getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
}

实验室管理员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_sysm")
public class Sysm {
//主键
@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 sysmName;
//邮箱
private String email;
//电话
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 getSysmName() {return sysmName;}
public void setSysmName(String sysmName) {this.sysmName = sysmName;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
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_yy")
public class Yy {
//主键
@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 libId;
//预约日期
private String yyDate;
//星期
private String xq;
//周次
private String zc;
//学生
private Integer studentId;
//状态
private String status;
//时间段
private String sjd;
//审核原因
private String resion;
public Integer getLibId() {return libId;}
public void setLibId(Integer libId) {this.libId = libId;}
public String getYyDate() {return yyDate;}
public void setYyDate(String yyDate) {this.yyDate = yyDate;}
public String getXq() {return xq;}
public void setXq(String xq) {this.xq = xq;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getSjd() {return sjd;}
public void setSjd(String sjd) {this.sjd = sjd;}
public String getResion() {return resion;}
public void setResion(String resion) {this.resion = resion;}
}

基于WEB实验室预约系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

插入课程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 libId;
//预约日期
private String yyDate;
//周次
private String zc;
//课程名称
private String kcName;
//时间段
private String sjd;
public Integer getLibId() {return libId;}
public void setLibId(Integer libId) {this.libId = libId;}
public String getYyDate() {return yyDate;}
public void setYyDate(String yyDate) {this.yyDate = yyDate;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getSjd() {return sjd;}
public void setSjd(String sjd) {this.sjd = sjd;}
}

实验室javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//实验室
public class Lib  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//实验室名称
private String libName;
//地址
private String address;
//实验室负责人
private Integer sysmId;
//实验室电话
private String phone;
//单个时间段人员上限
private Integer sx;
public String getLibName() {return libName;}
public void setLibName(String libName) {this.libName = libName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Integer getSysmId() {return sysmId;}
public void setSysmId(Integer sysmId) {this.sysmId = sysmId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getSx() {return sx;}
public void setSx(Integer sx) {this.sx = sx;}
}

学生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 email;
//电话
private String phone;
//班级
private String bj;
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 getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
}

实验室管理员javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//实验室管理员
public class Sysm  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 sysmName;
//邮箱
private String email;
//电话
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 getSysmName() {return sysmName;}
public void setSysmName(String sysmName) {this.sysmName = sysmName;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
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 Yy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//实验室
private Integer libId;
//预约日期
private String yyDate;
//星期
private String xq;
//周次
private String zc;
//学生
private Integer studentId;
//状态
private String status;
//时间段
private String sjd;
//审核原因
private String resion;
public Integer getLibId() {return libId;}
public void setLibId(Integer libId) {this.libId = libId;}
public String getYyDate() {return yyDate;}
public void setYyDate(String yyDate) {this.yyDate = yyDate;}
public String getXq() {return xq;}
public void setXq(String xq) {this.xq = xq;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getSjd() {return sjd;}
public void setSjd(String sjd) {this.sjd = sjd;}
public String getResion() {return resion;}
public void setResion(String resion) {this.resion = resion;}
}

源代码下载点这里

评论