更多成品,定做java毕业设计,请咨询管理员qq:2812491287

实验室管理系统

实验室管理系统登录注册界面

实验室管理系统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 '性别'
) comment '用户';

罚款表创建语句如下:


create table t_fk(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	sbId int comment '设备',
	fee int comment '罚款金额',
	content varchar(100) comment '罚款说明',
	insertDate datetime comment '罚款日期I'
) comment '罚款';

公告表创建语句如下:


create table t_gonggao(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate datetime comment '日期'
) comment '公告';

国资处表创建语句如下:


create table t_gzc(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	gzcName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别'
) comment '国资处';

设备表创建语句如下:


create table t_sb(
	id int primary key auto_increment comment '主键',
	sbName varchar(100) comment '设备编号',
	cwdz varchar(100) comment '存放地址',
	xh varchar(100) comment '型号',
	pic varchar(100) comment '图片',
	insertDate datetime comment '启用日期',
	status varchar(100) comment '状态'
) comment '设备';

设备使用申请表创建语句如下:


create table t_sbsy(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	sbId int comment '设备',
	title varchar(100) comment '申请说明',
	insertDate datetime comment '申请时间',
	back datetime comment '归还时间',
	status varchar(100) comment '状态'
) comment '设备使用申请';

设备用途表创建语句如下:


create table t_sbyt(
	id int primary key auto_increment comment '主键',
	sbId int comment '设备',
	title varchar(100) comment '标题',
	content 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)
);
--用户字段加注释
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 table t_customer is '用户';

罚款表创建语句如下:


create table t_fk(
	id integer,
	customerId int,
	sbId int,
	fee int,
	content varchar(100),
	insertDate datetime
);
--罚款字段加注释
comment on column t_fk.id is '主键';
comment on column t_fk.customerId is '用户';
comment on column t_fk.sbId is '设备';
comment on column t_fk.fee is '罚款金额';
comment on column t_fk.content is '罚款说明';
comment on column t_fk.insertDate is '罚款日期I';
--罚款表加注释
comment on table t_fk is '罚款';

公告表创建语句如下:


create table t_gonggao(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.pic is '图片';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.showDate is '日期';
--公告表加注释
comment on table t_gonggao is '公告';

国资处表创建语句如下:


create table t_gzc(
	id integer,
	username varchar(100),
	password varchar(100),
	gzcName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100)
);
--国资处字段加注释
comment on column t_gzc.id is '主键';
comment on column t_gzc.username is '账号';
comment on column t_gzc.password is '密码';
comment on column t_gzc.gzcName is '姓名';
comment on column t_gzc.phone is '电话';
comment on column t_gzc.age is '年龄';
comment on column t_gzc.sex is '性别';
--国资处表加注释
comment on table t_gzc is '国资处';

设备表创建语句如下:


create table t_sb(
	id integer,
	sbName varchar(100),
	cwdz varchar(100),
	xh varchar(100),
	pic varchar(100),
	insertDate datetime,
	status varchar(100)
);
--设备字段加注释
comment on column t_sb.id is '主键';
comment on column t_sb.sbName is '设备编号';
comment on column t_sb.cwdz is '存放地址';
comment on column t_sb.xh is '型号';
comment on column t_sb.pic is '图片';
comment on column t_sb.insertDate is '启用日期';
comment on column t_sb.status is '状态';
--设备表加注释
comment on table t_sb is '设备';

设备使用申请表创建语句如下:


create table t_sbsy(
	id integer,
	customerId int,
	sbId int,
	title varchar(100),
	insertDate datetime,
	back datetime,
	status varchar(100)
);
--设备使用申请字段加注释
comment on column t_sbsy.id is '主键';
comment on column t_sbsy.customerId is '用户';
comment on column t_sbsy.sbId is '设备';
comment on column t_sbsy.title is '申请说明';
comment on column t_sbsy.insertDate is '申请时间';
comment on column t_sbsy.back is '归还时间';
comment on column t_sbsy.status is '状态';
--设备使用申请表加注释
comment on table t_sbsy is '设备使用申请';

设备用途表创建语句如下:


create table t_sbyt(
	id integer,
	sbId int,
	title varchar(100),
	content varchar(100)
);
--设备用途字段加注释
comment on column t_sbyt.id is '主键';
comment on column t_sbyt.sbId is '设备';
comment on column t_sbyt.title is '标题';
comment on column t_sbyt.content is '详细说明';
--设备用途表加注释
comment on table t_sbyt is '设备用途';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_fk;
create sequence s_t_gonggao;
create sequence s_t_gzc;
create sequence s_t_sb;
create sequence s_t_sbsy;
create sequence s_t_sbyt;

实验室管理系统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)--性别
);

罚款表创建语句如下:


--罚款表注释
create table t_fk(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	sbId int,--设备
	fee int,--罚款金额
	content varchar(100),--罚款说明
	insertDate datetime--罚款日期I
);

公告表创建语句如下:


--公告表注释
create table t_gonggao(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate datetime--日期
);

国资处表创建语句如下:


--国资处表注释
create table t_gzc(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	gzcName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100)--性别
);

设备表创建语句如下:


--设备表注释
create table t_sb(
	id int identity(1,1) primary key not null,--主键
	sbName varchar(100),--设备编号
	cwdz varchar(100),--存放地址
	xh varchar(100),--型号
	pic varchar(100),--图片
	insertDate datetime,--启用日期
	status varchar(100)--状态
);

设备使用申请表创建语句如下:


--设备使用申请表注释
create table t_sbsy(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	sbId int,--设备
	title varchar(100),--申请说明
	insertDate datetime,--申请时间
	back datetime,--归还时间
	status varchar(100)--状态
);

设备用途表创建语句如下:


--设备用途表注释
create table t_sbyt(
	id int identity(1,1) primary key not null,--主键
	sbId int,--设备
	title varchar(100),--标题
	content 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;
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;}
}

罚款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_fk")
public class Fk {
//主键
@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 Integer fee;
//罚款说明
private String content;
//罚款日期I
private Date insertDate;
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 Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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_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 pic;
//内容
private String content;
//日期
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
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_gzc")
public class Gzc {
//主键
@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 gzcName;
//电话
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 getGzcName() {return gzcName;}
public void setGzcName(String gzcName) {this.gzcName = gzcName;}
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_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 sbName;
//存放地址
private String cwdz;
//型号
private String xh;
//图片
private String pic;
//启用日期
private Date insertDate;
//状态
private String status;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
public String getCwdz() {return cwdz;}
public void setCwdz(String cwdz) {this.cwdz = cwdz;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
}

设备使用申请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_sbsy")
public class Sbsy {
//主键
@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 Date back;
//状态
private String status;
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 Date getBack() {return back;}
public void setBack(Date back) {this.back = back;}
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_sbyt")
public class Sbyt {
//主键
@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 sbId;
//标题
private String title;
//详细说明
private String content;
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 String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

实验室管理系统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;
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;}
}

罚款javaBean创建语句如下:


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

//罚款
public class Fk  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 Integer fee;
//罚款说明
private String content;
//罚款日期I
private Date insertDate;
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 Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Gonggao  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 content;
//日期
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
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 Gzc  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 gzcName;
//电话
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 getGzcName() {return gzcName;}
public void setGzcName(String gzcName) {this.gzcName = gzcName;}
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 Sb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备编号
private String sbName;
//存放地址
private String cwdz;
//型号
private String xh;
//图片
private String pic;
//启用日期
private Date insertDate;
//状态
private String status;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
public String getCwdz() {return cwdz;}
public void setCwdz(String cwdz) {this.cwdz = cwdz;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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;}
}

设备使用申请javaBean创建语句如下:


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

//设备使用申请
public class Sbsy  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 Date back;
//状态
private String status;
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 Date getBack() {return back;}
public void setBack(Date back) {this.back = back;}
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 Sbyt  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备
private Integer sbId;
//标题
private String title;
//详细说明
private String content;
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 String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}

评论