- 基于javaweb的网上预约实验室管理系统的设计与实现mysql数据库创建语句
- 基于javaweb的网上预约实验室管理系统的设计与实现oracle数据库创建语句
- 基于javaweb的网上预约实验室管理系统的设计与实现sqlserver数据库创建语句
- 基于javaweb的网上预约实验室管理系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于javaweb的网上预约实验室管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于javaweb的网上预约实验室管理系统的设计与实现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_gonggao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
cotnent varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '系统公告';
个人通知表创建语句如下：
create table t_message(
id int primary key auto_increment comment '主键',
studentId int comment '个人通知',
title varchar(100) comment '标题',
cotnent varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '个人通知';
实验室预约表创建语句如下：
create table t_order(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
yybh varchar(100) comment '预约编号',
yyxx varchar(100) comment '预约信息',
sysbh varchar(100) comment '实验室编号',
syssbbh varchar(100) comment '实验室设备编号',
yyDate datetime comment '申请日期',
status varchar(100) comment '状态',
isgh varchar(100) comment '是否归还',
ghDate datetime 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 '姓名',
xh varchar(100) comment '学号',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
headPic varchar(100) comment '头像'
) comment '学生';
实验室表创建语句如下：
create table t_sys(
id int primary key auto_increment comment '主键',
sysbh varchar(100) comment '实验室编号',
sysName varchar(100) comment '实验室名称',
wz varchar(100) comment '位置',
kfsj varchar(100) comment '开放时间',
ghsj varchar(100) comment '归还时间',
status varchar(100) comment '状态'
) comment '实验室';
实验室设备表创建语句如下：
create table t_syssb(
id int primary key auto_increment comment '主键',
syssbbh varchar(100) comment '实验室设备编号',
sysName varchar(100) comment '实验室设备名称',
sl int comment '数量',
xh varchar(100) comment '型号',
scnf varchar(100) comment '生产年号',
cjmc varchar(100) comment '厂家名称',
kfsj varchar(100) comment '开放时间',
ghsj varchar(100) comment '归还时间',
status varchar(100) comment '状态'
) comment '实验室设备';
信息反馈表创建语句如下：
create table t_xxfk(
id int primary key auto_increment comment '主键',
studentId int comment '学生',
yybh varchar(100) comment '预约编号',
syssbbh varchar(100) comment '实验室设备编号',
v1 varchar(100) comment '是否故障',
beizhu varchar(100) comment '备注'
) comment '信息反馈';
基于javaweb的网上预约实验室管理系统的设计与实现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_gonggao(
id integer,
title varchar(100),
cotnent varchar(100),
insertDate datetime
);
--系统公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.cotnent is '内容';
comment on column t_gonggao.insertDate is '日期';
--系统公告表加注释
comment on table t_gonggao is '系统公告';
个人通知表创建语句如下：
create table t_message(
id integer,
studentId int,
title varchar(100),
cotnent varchar(100),
insertDate datetime
);
--个人通知字段加注释
comment on column t_message.id is '主键';
comment on column t_message.studentId is '个人通知';
comment on column t_message.title is '标题';
comment on column t_message.cotnent is '内容';
comment on column t_message.insertDate is '日期';
--个人通知表加注释
comment on table t_message is '个人通知';
实验室预约表创建语句如下：
create table t_order(
id integer,
studentId int,
yybh varchar(100),
yyxx varchar(100),
sysbh varchar(100),
syssbbh varchar(100),
yyDate datetime,
status varchar(100),
isgh varchar(100),
ghDate datetime
);
--实验室预约字段加注释
comment on column t_order.id is '主键';
comment on column t_order.studentId is '学生';
comment on column t_order.yybh is '预约编号';
comment on column t_order.yyxx is '预约信息';
comment on column t_order.sysbh is '实验室编号';
comment on column t_order.syssbbh is '实验室设备编号';
comment on column t_order.yyDate is '申请日期';
comment on column t_order.status is '状态';
comment on column t_order.isgh is '是否归还';
comment on column t_order.ghDate is '归还日期';
--实验室预约表加注释
comment on table t_order is '实验室预约';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
studentName varchar(100),
xh varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
headPic 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.xh 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.headPic is '头像';
--学生表加注释
comment on table t_student is '学生';
实验室表创建语句如下：
create table t_sys(
id integer,
sysbh varchar(100),
sysName varchar(100),
wz varchar(100),
kfsj varchar(100),
ghsj varchar(100),
status varchar(100)
);
--实验室字段加注释
comment on column t_sys.id is '主键';
comment on column t_sys.sysbh is '实验室编号';
comment on column t_sys.sysName is '实验室名称';
comment on column t_sys.wz is '位置';
comment on column t_sys.kfsj is '开放时间';
comment on column t_sys.ghsj is '归还时间';
comment on column t_sys.status is '状态';
--实验室表加注释
comment on table t_sys is '实验室';
实验室设备表创建语句如下：
create table t_syssb(
id integer,
syssbbh varchar(100),
sysName varchar(100),
sl int,
xh varchar(100),
scnf varchar(100),
cjmc varchar(100),
kfsj varchar(100),
ghsj varchar(100),
status varchar(100)
);
--实验室设备字段加注释
comment on column t_syssb.id is '主键';
comment on column t_syssb.syssbbh is '实验室设备编号';
comment on column t_syssb.sysName is '实验室设备名称';
comment on column t_syssb.sl is '数量';
comment on column t_syssb.xh is '型号';
comment on column t_syssb.scnf is '生产年号';
comment on column t_syssb.cjmc is '厂家名称';
comment on column t_syssb.kfsj is '开放时间';
comment on column t_syssb.ghsj is '归还时间';
comment on column t_syssb.status is '状态';
--实验室设备表加注释
comment on table t_syssb is '实验室设备';
信息反馈表创建语句如下：
create table t_xxfk(
id integer,
studentId int,
yybh varchar(100),
syssbbh varchar(100),
v1 varchar(100),
beizhu varchar(100)
);
--信息反馈字段加注释
comment on column t_xxfk.id is '主键';
comment on column t_xxfk.studentId is '学生';
comment on column t_xxfk.yybh is '预约编号';
comment on column t_xxfk.syssbbh is '实验室设备编号';
comment on column t_xxfk.v1 is '是否故障';
comment on column t_xxfk.beizhu is '备注';
--信息反馈表加注释
comment on table t_xxfk is '信息反馈';
oracle特有，对应序列如下：
create sequence s_t_gonggao;
create sequence s_t_message;
create sequence s_t_order;
create sequence s_t_student;
create sequence s_t_sys;
create sequence s_t_syssb;
create sequence s_t_xxfk;
基于javaweb的网上预约实验室管理系统的设计与实现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_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
cotnent varchar(100),--内容
insertDate datetime--日期
);
个人通知表创建语句如下：
--个人通知表注释
create table t_message(
id int identity(1,1) primary key not null,--主键
studentId int,--个人通知
title varchar(100),--标题
cotnent varchar(100),--内容
insertDate datetime--日期
);
实验室预约表创建语句如下：
--实验室预约表注释
create table t_order(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
yybh varchar(100),--预约编号
yyxx varchar(100),--预约信息
sysbh varchar(100),--实验室编号
syssbbh varchar(100),--实验室设备编号
yyDate datetime,--申请日期
status varchar(100),--状态
isgh varchar(100),--是否归还
ghDate datetime--归还日期
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
studentName varchar(100),--姓名
xh varchar(100),--学号
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
headPic varchar(100)--头像
);
实验室表创建语句如下：
--实验室表注释
create table t_sys(
id int identity(1,1) primary key not null,--主键
sysbh varchar(100),--实验室编号
sysName varchar(100),--实验室名称
wz varchar(100),--位置
kfsj varchar(100),--开放时间
ghsj varchar(100),--归还时间
status varchar(100)--状态
);
实验室设备表创建语句如下：
--实验室设备表注释
create table t_syssb(
id int identity(1,1) primary key not null,--主键
syssbbh varchar(100),--实验室设备编号
sysName varchar(100),--实验室设备名称
sl int,--数量
xh varchar(100),--型号
scnf varchar(100),--生产年号
cjmc varchar(100),--厂家名称
kfsj varchar(100),--开放时间
ghsj varchar(100),--归还时间
status varchar(100)--状态
);
信息反馈表创建语句如下：
--信息反馈表注释
create table t_xxfk(
id int identity(1,1) primary key not null,--主键
studentId int,--学生
yybh varchar(100),--预约编号
syssbbh varchar(100),--实验室设备编号
v1 varchar(100),--是否故障
beizhu varchar(100)--备注
);
登录后主页.jpg?x-oss-process=style/00001)
基于javaweb的网上预约实验室管理系统的设计与实现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_gonggao")
public class Gonggao {
//主键
@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 cotnent;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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_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 Integer studentId;
//标题
private String title;
//内容
private String cotnent;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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_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 studentId;
//预约编号
private String yybh;
//预约信息
private String yyxx;
//实验室编号
private String sysbh;
//实验室设备编号
private String syssbbh;
//申请日期
private Date yyDate;
//状态
private String status;
//是否归还
private String isgh;
//归还日期
private Date ghDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getYybh() {return yybh;}
public void setYybh(String yybh) {this.yybh = yybh;}
public String getYyxx() {return yyxx;}
public void setYyxx(String yyxx) {this.yyxx = yyxx;}
public String getSysbh() {return sysbh;}
public void setSysbh(String sysbh) {this.sysbh = sysbh;}
public String getSyssbbh() {return syssbbh;}
public void setSyssbbh(String syssbbh) {this.syssbbh = syssbbh;}
public Date getYyDate() {return yyDate;}
public void setYyDate(Date yyDate) {this.yyDate = yyDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getIsgh() {return isgh;}
public void setIsgh(String isgh) {this.isgh = isgh;}
public Date getGhDate() {return ghDate;}
public void setGhDate(Date ghDate) {this.ghDate = ghDate;}
}学生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 xh;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
private String headPic;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}实验室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_sys")
public class Sys {
//主键
@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 sysbh;
//实验室名称
private String sysName;
//位置
private String wz;
//开放时间
private String kfsj;
//归还时间
private String ghsj;
//状态
private String status;
public String getSysbh() {return sysbh;}
public void setSysbh(String sysbh) {this.sysbh = sysbh;}
public String getSysName() {return sysName;}
public void setSysName(String sysName) {this.sysName = sysName;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
public String getKfsj() {return kfsj;}
public void setKfsj(String kfsj) {this.kfsj = kfsj;}
public String getGhsj() {return ghsj;}
public void setGhsj(String ghsj) {this.ghsj = ghsj;}
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_syssb")
public class Syssb {
//主键
@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 syssbbh;
//实验室设备名称
private String sysName;
//数量
private Integer sl;
//型号
private String xh;
//生产年号
private String scnf;
//厂家名称
private String cjmc;
//开放时间
private String kfsj;
//归还时间
private String ghsj;
//状态
private String status;
public String getSyssbbh() {return syssbbh;}
public void setSyssbbh(String syssbbh) {this.syssbbh = syssbbh;}
public String getSysName() {return sysName;}
public void setSysName(String sysName) {this.sysName = sysName;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getScnf() {return scnf;}
public void setScnf(String scnf) {this.scnf = scnf;}
public String getCjmc() {return cjmc;}
public void setCjmc(String cjmc) {this.cjmc = cjmc;}
public String getKfsj() {return kfsj;}
public void setKfsj(String kfsj) {this.kfsj = kfsj;}
public String getGhsj() {return ghsj;}
public void setGhsj(String ghsj) {this.ghsj = ghsj;}
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_xxfk")
public class Xxfk {
//主键
@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 String yybh;
//实验室设备编号
private String syssbbh;
//是否故障
private String v1;
//备注
private String beizhu;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getYybh() {return yybh;}
public void setYybh(String yybh) {this.yybh = yybh;}
public String getSyssbbh() {return syssbbh;}
public void setSyssbbh(String syssbbh) {this.syssbbh = syssbbh;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getBeizhu() {return beizhu;}
public void setBeizhu(String beizhu) {this.beizhu = beizhu;}
}基于javaweb的网上预约实验室管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
系统公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//系统公告
public class Gonggao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String cotnent;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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 Message extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//个人通知
private Integer studentId;
//标题
private String title;
//内容
private String cotnent;
//日期
private Date insertDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getCotnent() {return cotnent;}
public void setCotnent(String cotnent) {this.cotnent = cotnent;}
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 Order extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//预约编号
private String yybh;
//预约信息
private String yyxx;
//实验室编号
private String sysbh;
//实验室设备编号
private String syssbbh;
//申请日期
private Date yyDate;
//状态
private String status;
//是否归还
private String isgh;
//归还日期
private Date ghDate;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getYybh() {return yybh;}
public void setYybh(String yybh) {this.yybh = yybh;}
public String getYyxx() {return yyxx;}
public void setYyxx(String yyxx) {this.yyxx = yyxx;}
public String getSysbh() {return sysbh;}
public void setSysbh(String sysbh) {this.sysbh = sysbh;}
public String getSyssbbh() {return syssbbh;}
public void setSyssbbh(String syssbbh) {this.syssbbh = syssbbh;}
public Date getYyDate() {return yyDate;}
public void setYyDate(Date yyDate) {this.yyDate = yyDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getIsgh() {return isgh;}
public void setIsgh(String isgh) {this.isgh = isgh;}
public Date getGhDate() {return ghDate;}
public void setGhDate(Date ghDate) {this.ghDate = ghDate;}
}学生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 xh;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
private String headPic;
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 getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}实验室javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//实验室
public class Sys extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//实验室编号
private String sysbh;
//实验室名称
private String sysName;
//位置
private String wz;
//开放时间
private String kfsj;
//归还时间
private String ghsj;
//状态
private String status;
public String getSysbh() {return sysbh;}
public void setSysbh(String sysbh) {this.sysbh = sysbh;}
public String getSysName() {return sysName;}
public void setSysName(String sysName) {this.sysName = sysName;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
public String getKfsj() {return kfsj;}
public void setKfsj(String kfsj) {this.kfsj = kfsj;}
public String getGhsj() {return ghsj;}
public void setGhsj(String ghsj) {this.ghsj = ghsj;}
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 Syssb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//实验室设备编号
private String syssbbh;
//实验室设备名称
private String sysName;
//数量
private Integer sl;
//型号
private String xh;
//生产年号
private String scnf;
//厂家名称
private String cjmc;
//开放时间
private String kfsj;
//归还时间
private String ghsj;
//状态
private String status;
public String getSyssbbh() {return syssbbh;}
public void setSyssbbh(String syssbbh) {this.syssbbh = syssbbh;}
public String getSysName() {return sysName;}
public void setSysName(String sysName) {this.sysName = sysName;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getScnf() {return scnf;}
public void setScnf(String scnf) {this.scnf = scnf;}
public String getCjmc() {return cjmc;}
public void setCjmc(String cjmc) {this.cjmc = cjmc;}
public String getKfsj() {return kfsj;}
public void setKfsj(String kfsj) {this.kfsj = kfsj;}
public String getGhsj() {return ghsj;}
public void setGhsj(String ghsj) {this.ghsj = ghsj;}
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 Xxfk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//学生
private Integer studentId;
//预约编号
private String yybh;
//实验室设备编号
private String syssbbh;
//是否故障
private String v1;
//备注
private String beizhu;
public Integer getStudentId() {return studentId;}
public void setStudentId(Integer studentId) {this.studentId = studentId;}
public String getYybh() {return yybh;}
public void setYybh(String yybh) {this.yybh = yybh;}
public String getSyssbbh() {return syssbbh;}
public void setSyssbbh(String syssbbh) {this.syssbbh = syssbbh;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getBeizhu() {return beizhu;}
public void setBeizhu(String beizhu) {this.beizhu = beizhu;}
}