- 计算机设备管理与共享平台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_ckrk(
id int primary key auto_increment comment '主键',
types varchar(100) comment '出库入库',
sname varchar(100) comment '设备名称',
guige varchar(100) comment '规格',
zcbh varchar(100) comment '资产编号',
sl varchar(100) comment '数量',
insertDate datetime comment '日期'
) comment '出库入库';
用户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '学号工号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
yx varchar(100) comment '院系',
csny varchar(100) comment '出生年月',
bz varchar(100) comment '备注',
bm varchar(100) comment '类型',
status varchar(100) comment '状态'
) comment '用户';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '标题',
showDate datetime comment '日期',
v3 varchar(100) comment '内容'
) comment '公告';
设备购置申请表创建语句如下：
create table t_gzsq(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
sname varchar(100) comment '设备名称',
guige varchar(100) comment '规格',
zcbh varchar(100) comment '资产编号',
sl varchar(100) comment '数量',
insertDate datetime comment '日期',
status varchar(100) comment '状态',
back varchar(100) comment '回复内容'
) comment '设备购置申请';
设备故障维修申报表创建语句如下：
create table t_gzwxsb(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
sname varchar(100) comment '设备名称',
guige varchar(100) comment '规格',
zcbh varchar(100) comment '资产编号',
sl varchar(100) comment '数量',
insertDate datetime comment '日期',
status varchar(100) comment '状态',
back varchar(100) comment '回复内容'
) comment '设备故障维修申报';
普通管理员表创建语句如下：
create table t_ptadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ptadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话'
) comment '普通管理员';
设备表创建语句如下：
create table t_sb(
id int primary key auto_increment comment '主键',
sname varchar(100) comment '设备名称',
guige varchar(100) comment '规格',
sl varchar(100) comment '数量',
rzrq datetime comment '财务入账日期',
zcbh varchar(100) comment '资产编号',
money varchar(100) comment '价值',
jzlx varchar(100) comment '价值类型',
zcfl varchar(100) comment '资产分类',
zcdl varchar(100) comment '资产大类',
qdfs varchar(100) comment '取得方式',
qdrq datetime comment '取得日期',
zdrq datetime comment '制单日期',
bxjzrq varchar(100) comment '保修截止日期',
sybm varchar(100) comment '使用部门',
glbm varchar(100) comment '管理部门',
syfx varchar(100) comment '使用方向',
syzk varchar(100) comment '使用状况',
syr varchar(100) comment '使用人',
cfdd varchar(100) comment '存放地点',
content varchar(100) comment '备注'
) comment '设备';
设备申请表创建语句如下：
create table t_sbsq(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
sname varchar(100) comment '设备名称',
zcbh varchar(100) comment '资产编号',
sl 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_ckrk(
id integer,
types varchar(100),
sname varchar(100),
guige varchar(100),
zcbh varchar(100),
sl varchar(100),
insertDate datetime
);
--出库入库字段加注释
comment on column t_ckrk.id is '主键';
comment on column t_ckrk.types is '出库入库';
comment on column t_ckrk.sname is '设备名称';
comment on column t_ckrk.guige is '规格';
comment on column t_ckrk.zcbh is '资产编号';
comment on column t_ckrk.sl is '数量';
comment on column t_ckrk.insertDate is '日期';
--出库入库表加注释
comment on table t_ckrk is '出库入库';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
yx varchar(100),
csny varchar(100),
bz varchar(100),
bm varchar(100),
status 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.headPic 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.csny is '出生年月';
comment on column t_customer.bz is '备注';
comment on column t_customer.bm is '类型';
comment on column t_customer.status is '状态';
--用户表加注释
comment on table t_customer is '用户';
公告表创建语句如下：
create table t_gg(
id integer,
v1 varchar(100),
showDate datetime,
v3 varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--公告表加注释
comment on table t_gg is '公告';
设备购置申请表创建语句如下：
create table t_gzsq(
id integer,
customerId int,
sname varchar(100),
guige varchar(100),
zcbh varchar(100),
sl varchar(100),
insertDate datetime,
status varchar(100),
back varchar(100)
);
--设备购置申请字段加注释
comment on column t_gzsq.id is '主键';
comment on column t_gzsq.customerId is '用户';
comment on column t_gzsq.sname is '设备名称';
comment on column t_gzsq.guige is '规格';
comment on column t_gzsq.zcbh is '资产编号';
comment on column t_gzsq.sl is '数量';
comment on column t_gzsq.insertDate is '日期';
comment on column t_gzsq.status is '状态';
comment on column t_gzsq.back is '回复内容';
--设备购置申请表加注释
comment on table t_gzsq is '设备购置申请';
设备故障维修申报表创建语句如下：
create table t_gzwxsb(
id integer,
customerId int,
sname varchar(100),
guige varchar(100),
zcbh varchar(100),
sl varchar(100),
insertDate datetime,
status varchar(100),
back varchar(100)
);
--设备故障维修申报字段加注释
comment on column t_gzwxsb.id is '主键';
comment on column t_gzwxsb.customerId is '用户';
comment on column t_gzwxsb.sname is '设备名称';
comment on column t_gzwxsb.guige is '规格';
comment on column t_gzwxsb.zcbh is '资产编号';
comment on column t_gzwxsb.sl is '数量';
comment on column t_gzwxsb.insertDate is '日期';
comment on column t_gzwxsb.status is '状态';
comment on column t_gzwxsb.back is '回复内容';
--设备故障维修申报表加注释
comment on table t_gzwxsb is '设备故障维修申报';
普通管理员表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadminName varchar(100),
phone varchar(100)
);
--普通管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.phone is '电话';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';
设备表创建语句如下：
create table t_sb(
id integer,
sname varchar(100),
guige varchar(100),
sl varchar(100),
rzrq datetime,
zcbh varchar(100),
money varchar(100),
jzlx varchar(100),
zcfl varchar(100),
zcdl varchar(100),
qdfs varchar(100),
qdrq datetime,
zdrq datetime,
bxjzrq varchar(100),
sybm varchar(100),
glbm varchar(100),
syfx varchar(100),
syzk varchar(100),
syr varchar(100),
cfdd varchar(100),
content varchar(100)
);
--设备字段加注释
comment on column t_sb.id is '主键';
comment on column t_sb.sname is '设备名称';
comment on column t_sb.guige is '规格';
comment on column t_sb.sl is '数量';
comment on column t_sb.rzrq is '财务入账日期';
comment on column t_sb.zcbh is '资产编号';
comment on column t_sb.money is '价值';
comment on column t_sb.jzlx is '价值类型';
comment on column t_sb.zcfl is '资产分类';
comment on column t_sb.zcdl is '资产大类';
comment on column t_sb.qdfs is '取得方式';
comment on column t_sb.qdrq is '取得日期';
comment on column t_sb.zdrq is '制单日期';
comment on column t_sb.bxjzrq is '保修截止日期';
comment on column t_sb.sybm is '使用部门';
comment on column t_sb.glbm is '管理部门';
comment on column t_sb.syfx is '使用方向';
comment on column t_sb.syzk is '使用状况';
comment on column t_sb.syr is '使用人';
comment on column t_sb.cfdd is '存放地点';
comment on column t_sb.content is '备注';
--设备表加注释
comment on table t_sb is '设备';
设备申请表创建语句如下：
create table t_sbsq(
id integer,
customerId int,
sname varchar(100),
zcbh varchar(100),
sl varchar(100),
insertDate datetime,
status varchar(100),
back varchar(100)
);
--设备申请字段加注释
comment on column t_sbsq.id is '主键';
comment on column t_sbsq.customerId is '用户';
comment on column t_sbsq.sname is '设备名称';
comment on column t_sbsq.zcbh is '资产编号';
comment on column t_sbsq.sl is '数量';
comment on column t_sbsq.insertDate is '日期';
comment on column t_sbsq.status is '状态';
comment on column t_sbsq.back is '回复内容';
--设备申请表加注释
comment on table t_sbsq is '设备申请';
oracle特有，对应序列如下：
create sequence s_t_ckrk;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_gzsq;
create sequence s_t_gzwxsb;
create sequence s_t_ptadmin;
create sequence s_t_sb;
create sequence s_t_sbsq;
计算机设备管理与共享平台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_ckrk(
id int identity(1,1) primary key not null,--主键
types varchar(100),--出库入库
sname varchar(100),--设备名称
guige varchar(100),--规格
zcbh varchar(100),--资产编号
sl varchar(100),--数量
insertDate datetime--日期
);
用户表创建语句如下：
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--学号工号
password varchar(100),--密码
customerName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
yx varchar(100),--院系
csny varchar(100),--出生年月
bz varchar(100),--备注
bm varchar(100),--类型
status varchar(100)--状态
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--标题
showDate datetime,--日期
v3 varchar(100)--内容
);
设备购置申请表创建语句如下：
--设备购置申请表注释
create table t_gzsq(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
sname varchar(100),--设备名称
guige varchar(100),--规格
zcbh varchar(100),--资产编号
sl varchar(100),--数量
insertDate datetime,--日期
status varchar(100),--状态
back varchar(100)--回复内容
);
设备故障维修申报表创建语句如下：
--设备故障维修申报表注释
create table t_gzwxsb(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
sname varchar(100),--设备名称
guige varchar(100),--规格
zcbh varchar(100),--资产编号
sl varchar(100),--数量
insertDate datetime,--日期
status varchar(100),--状态
back varchar(100)--回复内容
);
普通管理员表创建语句如下：
--普通管理员表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ptadminName varchar(100),--姓名
phone varchar(100)--电话
);
设备表创建语句如下：
--设备表注释
create table t_sb(
id int identity(1,1) primary key not null,--主键
sname varchar(100),--设备名称
guige varchar(100),--规格
sl varchar(100),--数量
rzrq datetime,--财务入账日期
zcbh varchar(100),--资产编号
money varchar(100),--价值
jzlx varchar(100),--价值类型
zcfl varchar(100),--资产分类
zcdl varchar(100),--资产大类
qdfs varchar(100),--取得方式
qdrq datetime,--取得日期
zdrq datetime,--制单日期
bxjzrq varchar(100),--保修截止日期
sybm varchar(100),--使用部门
glbm varchar(100),--管理部门
syfx varchar(100),--使用方向
syzk varchar(100),--使用状况
syr varchar(100),--使用人
cfdd varchar(100),--存放地点
content varchar(100)--备注
);
设备申请表创建语句如下：
--设备申请表注释
create table t_sbsq(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
sname varchar(100),--设备名称
zcbh varchar(100),--资产编号
sl varchar(100),--数量
insertDate datetime,--日期
status varchar(100),--状态
back 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_ckrk")
public class Ckrk {
//主键
@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 types;
//设备名称
private String sname;
//规格
private String guige;
//资产编号
private String zcbh;
//数量
private String sl;
//日期
private Date insertDate;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getSname() {return sname;}
public void setSname(String sname) {this.sname = sname;}
public String getGuige() {return guige;}
public void setGuige(String guige) {this.guige = guige;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
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_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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//院系
private String yx;
//出生年月
private String csny;
//备注
private String bz;
//类型
private String bm;
//状态
private String status;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 getCsny() {return csny;}
public void setCsny(String csny) {this.csny = csny;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
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_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 v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}设备购置申请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_gzsq")
public class Gzsq {
//主键
@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 String sname;
//规格
private String guige;
//资产编号
private String zcbh;
//数量
private String sl;
//日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSname() {return sname;}
public void setSname(String sname) {this.sname = sname;}
public String getGuige() {return guige;}
public void setGuige(String guige) {this.guige = guige;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
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_gzwxsb")
public class Gzwxsb {
//主键
@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 String sname;
//规格
private String guige;
//资产编号
private String zcbh;
//数量
private String sl;
//日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSname() {return sname;}
public void setSname(String sname) {this.sname = sname;}
public String getGuige() {return guige;}
public void setGuige(String guige) {this.guige = guige;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//电话
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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_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 sname;
//规格
private String guige;
//数量
private String sl;
//财务入账日期
private Date rzrq;
//资产编号
private String zcbh;
//价值
private String money;
//价值类型
private String jzlx;
//资产分类
private String zcfl;
//资产大类
private String zcdl;
//取得方式
private String qdfs;
//取得日期
private Date qdrq;
//制单日期
private Date zdrq;
//保修截止日期
private String bxjzrq;
//使用部门
private String sybm;
//管理部门
private String glbm;
//使用方向
private String syfx;
//使用状况
private String syzk;
//使用人
private String syr;
//存放地点
private String cfdd;
//备注
private String content;
public String getSname() {return sname;}
public void setSname(String sname) {this.sname = sname;}
public String getGuige() {return guige;}
public void setGuige(String guige) {this.guige = guige;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public Date getRzrq() {return rzrq;}
public void setRzrq(Date rzrq) {this.rzrq = rzrq;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getMoney() {return money;}
public void setMoney(String money) {this.money = money;}
public String getJzlx() {return jzlx;}
public void setJzlx(String jzlx) {this.jzlx = jzlx;}
public String getZcfl() {return zcfl;}
public void setZcfl(String zcfl) {this.zcfl = zcfl;}
public String getZcdl() {return zcdl;}
public void setZcdl(String zcdl) {this.zcdl = zcdl;}
public String getQdfs() {return qdfs;}
public void setQdfs(String qdfs) {this.qdfs = qdfs;}
public Date getQdrq() {return qdrq;}
public void setQdrq(Date qdrq) {this.qdrq = qdrq;}
public Date getZdrq() {return zdrq;}
public void setZdrq(Date zdrq) {this.zdrq = zdrq;}
public String getBxjzrq() {return bxjzrq;}
public void setBxjzrq(String bxjzrq) {this.bxjzrq = bxjzrq;}
public String getSybm() {return sybm;}
public void setSybm(String sybm) {this.sybm = sybm;}
public String getGlbm() {return glbm;}
public void setGlbm(String glbm) {this.glbm = glbm;}
public String getSyfx() {return syfx;}
public void setSyfx(String syfx) {this.syfx = syfx;}
public String getSyzk() {return syzk;}
public void setSyzk(String syzk) {this.syzk = syzk;}
public String getSyr() {return syr;}
public void setSyr(String syr) {this.syr = syr;}
public String getCfdd() {return cfdd;}
public void setCfdd(String cfdd) {this.cfdd = cfdd;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}设备申请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_sbsq")
public class Sbsq {
//主键
@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 String sname;
//资产编号
private String zcbh;
//数量
private String sl;
//日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSname() {return sname;}
public void setSname(String sname) {this.sname = sname;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
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 Ckrk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//出库入库
private String types;
//设备名称
private String sname;
//规格
private String guige;
//资产编号
private String zcbh;
//数量
private String sl;
//日期
private Date insertDate;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getSname() {return sname;}
public void setSname(String sname) {this.sname = sname;}
public String getGuige() {return guige;}
public void setGuige(String guige) {this.guige = guige;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
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 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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//院系
private String yx;
//出生年月
private String csny;
//备注
private String bz;
//类型
private String bm;
//状态
private String status;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 getCsny() {return csny;}
public void setCsny(String csny) {this.csny = csny;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
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 Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}设备购置申请javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//设备购置申请
public class Gzsq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//设备名称
private String sname;
//规格
private String guige;
//资产编号
private String zcbh;
//数量
private String sl;
//日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSname() {return sname;}
public void setSname(String sname) {this.sname = sname;}
public String getGuige() {return guige;}
public void setGuige(String guige) {this.guige = guige;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
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 Gzwxsb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//设备名称
private String sname;
//规格
private String guige;
//资产编号
private String zcbh;
//数量
private String sl;
//日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSname() {return sname;}
public void setSname(String sname) {this.sname = sname;}
public String getGuige() {return guige;}
public void setGuige(String guige) {this.guige = guige;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
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 Ptadmin 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 ptadminName;
//电话
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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 Sb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称
private String sname;
//规格
private String guige;
//数量
private String sl;
//财务入账日期
private Date rzrq;
//资产编号
private String zcbh;
//价值
private String money;
//价值类型
private String jzlx;
//资产分类
private String zcfl;
//资产大类
private String zcdl;
//取得方式
private String qdfs;
//取得日期
private Date qdrq;
//制单日期
private Date zdrq;
//保修截止日期
private String bxjzrq;
//使用部门
private String sybm;
//管理部门
private String glbm;
//使用方向
private String syfx;
//使用状况
private String syzk;
//使用人
private String syr;
//存放地点
private String cfdd;
//备注
private String content;
public String getSname() {return sname;}
public void setSname(String sname) {this.sname = sname;}
public String getGuige() {return guige;}
public void setGuige(String guige) {this.guige = guige;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public Date getRzrq() {return rzrq;}
public void setRzrq(Date rzrq) {this.rzrq = rzrq;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getMoney() {return money;}
public void setMoney(String money) {this.money = money;}
public String getJzlx() {return jzlx;}
public void setJzlx(String jzlx) {this.jzlx = jzlx;}
public String getZcfl() {return zcfl;}
public void setZcfl(String zcfl) {this.zcfl = zcfl;}
public String getZcdl() {return zcdl;}
public void setZcdl(String zcdl) {this.zcdl = zcdl;}
public String getQdfs() {return qdfs;}
public void setQdfs(String qdfs) {this.qdfs = qdfs;}
public Date getQdrq() {return qdrq;}
public void setQdrq(Date qdrq) {this.qdrq = qdrq;}
public Date getZdrq() {return zdrq;}
public void setZdrq(Date zdrq) {this.zdrq = zdrq;}
public String getBxjzrq() {return bxjzrq;}
public void setBxjzrq(String bxjzrq) {this.bxjzrq = bxjzrq;}
public String getSybm() {return sybm;}
public void setSybm(String sybm) {this.sybm = sybm;}
public String getGlbm() {return glbm;}
public void setGlbm(String glbm) {this.glbm = glbm;}
public String getSyfx() {return syfx;}
public void setSyfx(String syfx) {this.syfx = syfx;}
public String getSyzk() {return syzk;}
public void setSyzk(String syzk) {this.syzk = syzk;}
public String getSyr() {return syr;}
public void setSyr(String syr) {this.syr = syr;}
public String getCfdd() {return cfdd;}
public void setCfdd(String cfdd) {this.cfdd = cfdd;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}设备申请javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//设备申请
public class Sbsq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//设备名称
private String sname;
//资产编号
private String zcbh;
//数量
private String sl;
//日期
private Date insertDate;
//状态
private String status;
//回复内容
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSname() {return sname;}
public void setSname(String sname) {this.sname = sname;}
public String getZcbh() {return zcbh;}
public void setZcbh(String zcbh) {this.zcbh = zcbh;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
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;}
}