实验室系统

实验室系统登录注册界面

实验室系统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_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '学号工号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	yx varchar(100) comment '院系',
	bm varchar(100) comment '类型'
) comment '用户';

反馈维修表创建语句如下:


create table t_fkwx(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	sbId int comment '设备',
	title varchar(100) comment '详细说明',
	insertDate datetime comment '申请日期',
	status varchar(100) comment '状态',
	back varchar(100) comment '回复内容'
) comment '反馈维修';

设备表创建语句如下:


create table t_sb(
	id int primary key auto_increment comment '主键',
	sysName varchar(100) comment '设备名称',
	v0 varchar(100) comment '设备编号',
	v1 varchar(100) comment '设备数量',
	v2 varchar(100) comment '设备存位置',
	v4 varchar(100) comment '负责人',
	ewm varchar(100) comment ''
) comment '设备';

实验室表创建语句如下:


create table t_sys(
	id int primary key auto_increment comment '主键',
	sysName varchar(100) comment '实验室名称',
	v1 varchar(100) comment '编号',
	v2 varchar(100) comment '位置',
	v3 varchar(100) comment '容纳人数',
	v4 varchar(100) comment '负责人',
	ewm varchar(100) comment ''
) comment '实验室';

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


create table t_sysyy(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	sysId int comment '实验室',
	title varchar(100) comment '预约说明',
	insertDate datetime comment '申请日期',
	status varchar(100) comment '状态',
	back 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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	yx varchar(100),
	bm varchar(100)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '学号工号';
comment on column t_customer.password is '密码';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.yx is '院系';
comment on column t_customer.bm is '类型';
--用户表加注释
comment on table t_customer is '用户';

反馈维修表创建语句如下:


create table t_fkwx(
	id integer,
	customerId int,
	sbId int,
	title varchar(100),
	insertDate datetime,
	status varchar(100),
	back varchar(100)
);
--反馈维修字段加注释
comment on column t_fkwx.id is '主键';
comment on column t_fkwx.customerId is '用户';
comment on column t_fkwx.sbId is '设备';
comment on column t_fkwx.title is '详细说明';
comment on column t_fkwx.insertDate is '申请日期';
comment on column t_fkwx.status is '状态';
comment on column t_fkwx.back is '回复内容';
--反馈维修表加注释
comment on table t_fkwx is '反馈维修';

设备表创建语句如下:


create table t_sb(
	id integer,
	sysName varchar(100),
	v0 varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v4 varchar(100),
	ewm varchar(100)
);
--设备字段加注释
comment on column t_sb.id is '主键';
comment on column t_sb.sysName is '设备名称';
comment on column t_sb.v0 is '设备编号';
comment on column t_sb.v1 is '设备数量';
comment on column t_sb.v2 is '设备存位置';
comment on column t_sb.v4 is '负责人';
comment on column t_sb.ewm is '';
--设备表加注释
comment on table t_sb is '设备';

实验室表创建语句如下:


create table t_sys(
	id integer,
	sysName varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	ewm varchar(100)
);
--实验室字段加注释
comment on column t_sys.id is '主键';
comment on column t_sys.sysName is '实验室名称';
comment on column t_sys.v1 is '编号';
comment on column t_sys.v2 is '位置';
comment on column t_sys.v3 is '容纳人数';
comment on column t_sys.v4 is '负责人';
comment on column t_sys.ewm is '';
--实验室表加注释
comment on table t_sys is '实验室';

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


create table t_sysyy(
	id integer,
	customerId int,
	sysId int,
	title varchar(100),
	insertDate datetime,
	status varchar(100),
	back varchar(100)
);
--实验室预约字段加注释
comment on column t_sysyy.id is '主键';
comment on column t_sysyy.customerId is '用户';
comment on column t_sysyy.sysId is '实验室';
comment on column t_sysyy.title is '预约说明';
comment on column t_sysyy.insertDate is '申请日期';
comment on column t_sysyy.status is '状态';
comment on column t_sysyy.back is '回复内容';
--实验室预约表加注释
comment on table t_sysyy is '实验室预约';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_fkwx;
create sequence s_t_sb;
create sequence s_t_sys;
create sequence s_t_sysyy;

实验室系统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_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--学号工号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--性别
	yx varchar(100),--院系
	bm varchar(100)--类型
);

反馈维修表创建语句如下:


--反馈维修表注释
create table t_fkwx(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	sbId int,--设备
	title varchar(100),--详细说明
	insertDate datetime,--申请日期
	status varchar(100),--状态
	back varchar(100)--回复内容
);

设备表创建语句如下:


--设备表注释
create table t_sb(
	id int identity(1,1) primary key not null,--主键
	sysName varchar(100),--设备名称
	v0 varchar(100),--设备编号
	v1 varchar(100),--设备数量
	v2 varchar(100),--设备存位置
	v4 varchar(100),--负责人
	ewm varchar(100)--
);

实验室表创建语句如下:


--实验室表注释
create table t_sys(
	id int identity(1,1) primary key not null,--主键
	sysName varchar(100),--实验室名称
	v1 varchar(100),--编号
	v2 varchar(100),--位置
	v3 varchar(100),--容纳人数
	v4 varchar(100),--负责人
	ewm varchar(100)--
);

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


--实验室预约表注释
create table t_sysyy(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	sysId int,--实验室
	title varchar(100),--预约说明
	insertDate datetime,--申请日期
	status varchar(100),--状态
	back varchar(100)--回复内容
);

实验室系统登录后主页

实验室系统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_customer")
public class Customer {
//主键
@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 customerName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//院系
private String yx;
//类型
private String bm;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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 getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
}

反馈维修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_fkwx")
public class Fkwx {
//主键
@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 customerId;
//设备
private Integer sbId;
//详细说明
private String title;
//申请日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getSbId() {return sbId;}
public void setSbId(Integer sbId) {this.sbId = sbId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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_sb")
public class Sb {
//主键
@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 sysName;
//设备编号
private String v0;
//设备数量
private String v1;
//设备存位置
private String v2;
//负责人
private String v4;
//
private String ewm;
public String getSysName() {return sysName;}
public void setSysName(String sysName) {this.sysName = sysName;}
public String getV0() {return v0;}
public void setV0(String v0) {this.v0 = v0;}
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 getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getEwm() {return ewm;}
public void setEwm(String ewm) {this.ewm = ewm;}
}

实验室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 sysName;
//编号
private String v1;
//位置
private String v2;
//容纳人数
private String v3;
//负责人
private String v4;
//
private String ewm;
public String getSysName() {return sysName;}
public void setSysName(String sysName) {this.sysName = sysName;}
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 getEwm() {return ewm;}
public void setEwm(String ewm) {this.ewm = ewm;}
}

实验室预约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_sysyy")
public class Sysyy {
//主键
@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 customerId;
//实验室
private Integer sysId;
//预约说明
private String title;
//申请日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getSysId() {return sysId;}
public void setSysId(Integer sysId) {this.sysId = sysId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
}

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

用户javaBean创建语句如下:


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

//用户
public class Customer  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 customerName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//院系
private String yx;
//类型
private String bm;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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 getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
}

反馈维修javaBean创建语句如下:


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

//反馈维修
public class Fkwx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//设备
private Integer sbId;
//详细说明
private String title;
//申请日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getSbId() {return sbId;}
public void setSbId(Integer sbId) {this.sbId = sbId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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 Sb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称
private String sysName;
//设备编号
private String v0;
//设备数量
private String v1;
//设备存位置
private String v2;
//负责人
private String v4;
//
private String ewm;
public String getSysName() {return sysName;}
public void setSysName(String sysName) {this.sysName = sysName;}
public String getV0() {return v0;}
public void setV0(String v0) {this.v0 = v0;}
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 getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getEwm() {return ewm;}
public void setEwm(String ewm) {this.ewm = ewm;}
}

实验室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 sysName;
//编号
private String v1;
//位置
private String v2;
//容纳人数
private String v3;
//负责人
private String v4;
//
private String ewm;
public String getSysName() {return sysName;}
public void setSysName(String sysName) {this.sysName = sysName;}
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 getEwm() {return ewm;}
public void setEwm(String ewm) {this.ewm = ewm;}
}

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


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

//实验室预约
public class Sysyy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//实验室
private Integer sysId;
//预约说明
private String title;
//申请日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getSysId() {return sysId;}
public void setSysId(Integer sysId) {this.sysId = sysId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
}

相关毕业设计源码

基于spring的一汽大众4s店汽车销售系统的设计与实现

基于spring的一汽大众4s店汽车销售系统的设计与实现(4sqichexiaoshou),提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

基于SSM技术的智能分销管理系统的设计与实现

基于SSM技术的智能分销管理系统的设计与实现,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

二手车网上交易系统

二手车网上交易系统,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

温室大棚数据采集控制系统上位机软件

对大棚管理员信息的增加、删除、修改、查看以及大棚分配,大棚管理员属性包括管理员编号、管理员名称、管理员邮箱、管理员电话、大棚编号、大棚名称。超级管理员才可对此模块进行操作。

crm系统设计和实现

crm系统设计和实现(crmxitong),提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

基于JAVA的电子邮件收发系统的设计与实现

基于JAVA的电子邮件收发系统的设计与实现,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

基于WEB的电力工程企业信息采集系统设计与开发

基于WEB的电力工程企业信息采集系统设计与开发(dianligongcheng),提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

酒店客房管理系统

酒店客房管理系统,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

基于智能判分的英语在线考试系统

基于智能判分的英语在线考试系统,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

旅游景点路线推荐系统

旅游景点路线推荐系统,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

酒店管理系统 _部分源代码分享

酒店管理系统,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

面向智慧校园社区的班级管理系统设计与实现

面向智慧校园社区的班级管理系统设计与实现,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

评论