基于二维码的固定资产管理系统(xfa99)_mysql_oracle代码分享

• 基于二维码的固定资产管理系统mysql数据库创建语句
• 基于二维码的固定资产管理系统oracle数据库创建语句
• 基于二维码的固定资产管理系统sqlserver数据库创建语句
• 基于二维码的固定资产管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 基于二维码的固定资产管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

基于二维码的固定资产管理系统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_gonggao(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content text comment '内容',
	insertDate datetime comment '发起日期'
) comment '公告';

设备表创建语句如下：

create table t_sb(
	id int primary key auto_increment comment '主键',
	sbName varchar(100) comment '设备名称编号',
	ip varchar(100) comment 'ip地址',
	fzr varchar(100) comment '负责人',
	wz varchar(100) comment '设备铭牌',
	remark text comment '设备说明',
	status varchar(100) comment ''
) comment '设备';

设备报废表创建语句如下：

create table t_sbbf(
	id int primary key auto_increment comment '主键',
	sbId int comment '设备名称编号',
	showDate datetime comment '报废日期',
	czr varchar(100) comment '负责人',
	remark varchar(100) comment '备注'
) comment '设备报废';

设备出库表创建语句如下：

create table t_sbck(
	id int primary key auto_increment comment '主键',
	sbId int comment '设备名称编号',
	showDate datetime comment '出库日期',
	czr varchar(100) comment '负责人',
	remark varchar(100) comment '备注'
) comment '设备出库';

设备入库表创建语句如下：

create table t_sbrk(
	id int primary key auto_increment comment '主键',
	sbId int comment '设备名称编号',
	showDate datetime comment '入库日期',
	czr varchar(100) comment '负责人',
	remark varchar(100) comment '备注'
) comment '设备入库';

设备维修表创建语句如下：

create table t_sbwx(
	id int primary key auto_increment comment '主键',
	sbId int comment '设备名称编号',
	showDate datetime comment '维修日期',
	czr varchar(100) comment '负责人',
	remark varchar(100) comment '备注'
) comment '设备维修';

巡检记录表创建语句如下：

create table t_xjjl(
	id int primary key auto_increment comment '主键',
	sbId int comment '设备名称编号',
	insertDate datetime comment '巡检日期',
	content text 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_gonggao(
	id integer,
	title varchar(100),
	content text,
	insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.insertDate is '发起日期';
--公告表加注释
comment on table t_gonggao is '公告';

设备表创建语句如下：

create table t_sb(
	id integer,
	sbName varchar(100),
	ip varchar(100),
	fzr varchar(100),
	wz varchar(100),
	remark text,
	status varchar(100)
);
--设备字段加注释
comment on column t_sb.id is '主键';
comment on column t_sb.sbName is '设备名称编号';
comment on column t_sb.ip is 'ip地址';
comment on column t_sb.fzr is '负责人';
comment on column t_sb.wz is '设备铭牌';
comment on column t_sb.remark is '设备说明';
comment on column t_sb.status is '';
--设备表加注释
comment on table t_sb is '设备';

设备报废表创建语句如下：

create table t_sbbf(
	id integer,
	sbId int,
	showDate datetime,
	czr varchar(100),
	remark varchar(100)
);
--设备报废字段加注释
comment on column t_sbbf.id is '主键';
comment on column t_sbbf.sbId is '设备名称编号';
comment on column t_sbbf.showDate is '报废日期';
comment on column t_sbbf.czr is '负责人';
comment on column t_sbbf.remark is '备注';
--设备报废表加注释
comment on table t_sbbf is '设备报废';

设备出库表创建语句如下：

create table t_sbck(
	id integer,
	sbId int,
	showDate datetime,
	czr varchar(100),
	remark varchar(100)
);
--设备出库字段加注释
comment on column t_sbck.id is '主键';
comment on column t_sbck.sbId is '设备名称编号';
comment on column t_sbck.showDate is '出库日期';
comment on column t_sbck.czr is '负责人';
comment on column t_sbck.remark is '备注';
--设备出库表加注释
comment on table t_sbck is '设备出库';

设备入库表创建语句如下：

create table t_sbrk(
	id integer,
	sbId int,
	showDate datetime,
	czr varchar(100),
	remark varchar(100)
);
--设备入库字段加注释
comment on column t_sbrk.id is '主键';
comment on column t_sbrk.sbId is '设备名称编号';
comment on column t_sbrk.showDate is '入库日期';
comment on column t_sbrk.czr is '负责人';
comment on column t_sbrk.remark is '备注';
--设备入库表加注释
comment on table t_sbrk is '设备入库';

设备维修表创建语句如下：

create table t_sbwx(
	id integer,
	sbId int,
	showDate datetime,
	czr varchar(100),
	remark varchar(100)
);
--设备维修字段加注释
comment on column t_sbwx.id is '主键';
comment on column t_sbwx.sbId is '设备名称编号';
comment on column t_sbwx.showDate is '维修日期';
comment on column t_sbwx.czr is '负责人';
comment on column t_sbwx.remark is '备注';
--设备维修表加注释
comment on table t_sbwx is '设备维修';

巡检记录表创建语句如下：

create table t_xjjl(
	id integer,
	sbId int,
	insertDate datetime,
	content text
);
--巡检记录字段加注释
comment on column t_xjjl.id is '主键';
comment on column t_xjjl.sbId is '设备名称编号';
comment on column t_xjjl.insertDate is '巡检日期';
comment on column t_xjjl.content is '巡检内容';
--巡检记录表加注释
comment on table t_xjjl is '巡检记录';

oracle特有，对应序列如下：

create sequence s_t_customer;
create sequence s_t_gonggao;
create sequence s_t_sb;
create sequence s_t_sbbf;
create sequence s_t_sbck;
create sequence s_t_sbrk;
create sequence s_t_sbwx;
create sequence s_t_xjjl;

基于二维码的固定资产管理系统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_gonggao(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content text,--内容
	insertDate datetime--发起日期
);

设备表创建语句如下：

--设备表注释
create table t_sb(
	id int identity(1,1) primary key not null,--主键
	sbName varchar(100),--设备名称编号
	ip varchar(100),--ip地址
	fzr varchar(100),--负责人
	wz varchar(100),--设备铭牌
	remark text,--设备说明
	status varchar(100)--
);

设备报废表创建语句如下：

--设备报废表注释
create table t_sbbf(
	id int identity(1,1) primary key not null,--主键
	sbId int,--设备名称编号
	showDate datetime,--报废日期
	czr varchar(100),--负责人
	remark varchar(100)--备注
);

设备出库表创建语句如下：

--设备出库表注释
create table t_sbck(
	id int identity(1,1) primary key not null,--主键
	sbId int,--设备名称编号
	showDate datetime,--出库日期
	czr varchar(100),--负责人
	remark varchar(100)--备注
);

设备入库表创建语句如下：

--设备入库表注释
create table t_sbrk(
	id int identity(1,1) primary key not null,--主键
	sbId int,--设备名称编号
	showDate datetime,--入库日期
	czr varchar(100),--负责人
	remark varchar(100)--备注
);

设备维修表创建语句如下：

--设备维修表注释
create table t_sbwx(
	id int identity(1,1) primary key not null,--主键
	sbId int,--设备名称编号
	showDate datetime,--维修日期
	czr varchar(100),--负责人
	remark varchar(100)--备注
);

巡检记录表创建语句如下：

--巡检记录表注释
create table t_xjjl(
	id int identity(1,1) primary key not null,--主键
	sbId int,--设备名称编号
	insertDate datetime,--巡检日期
	content text--巡检内容
);

基于二维码的固定资产管理系统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_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 content;
//发起日期
private Date insertDate;
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;}
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_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;
//ip地址
private String ip;
//负责人
private String fzr;
//设备铭牌
private String wz;
//设备说明
private String remark;
//
private String status;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
public String getIp() {return ip;}
public void setIp(String ip) {this.ip = ip;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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_sbbf")
public class Sbbf {
//主键
@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 Long sbId;
//报废日期
private Date showDate;
//负责人
private String czr;
//备注
private String remark;
public Long getSbId() {return sbId;}
public void setSbId(Long sbId) {this.sbId = sbId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

设备出库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_sbck")
public class Sbck {
//主键
@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 Long sbId;
//出库日期
private Date showDate;
//负责人
private String czr;
//备注
private String remark;
public Long getSbId() {return sbId;}
public void setSbId(Long sbId) {this.sbId = sbId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

设备入库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_sbrk")
public class Sbrk {
//主键
@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 Long sbId;
//入库日期
private Date showDate;
//负责人
private String czr;
//备注
private String remark;
public Long getSbId() {return sbId;}
public void setSbId(Long sbId) {this.sbId = sbId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

设备维修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_sbwx")
public class Sbwx {
//主键
@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 Long sbId;
//维修日期
private Date showDate;
//负责人
private String czr;
//备注
private String remark;
public Long getSbId() {return sbId;}
public void setSbId(Long sbId) {this.sbId = sbId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

巡检记录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_xjjl")
public class Xjjl {
//主键
@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 Long sbId;
//巡检日期
private Date insertDate;
//巡检内容
private String content;
public Long getSbId() {return sbId;}
public void setSbId(Long sbId) {this.sbId = sbId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Gonggao  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
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;}
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 Sb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称编号
private String sbName;
//ip地址
private String ip;
//负责人
private String fzr;
//设备铭牌
private String wz;
//设备说明
private String remark;
//
private String status;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
public String getIp() {return ip;}
public void setIp(String ip) {this.ip = ip;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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 Sbbf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称编号
private Long sbId;
//报废日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//负责人
private String czr;
//备注
private String remark;
public Long getSbId() {return sbId;}
public void setSbId(Long sbId) {this.sbId = sbId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

设备出库javaBean创建语句如下：

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

//设备出库
public class Sbck  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称编号
private Long sbId;
//出库日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//负责人
private String czr;
//备注
private String remark;
public Long getSbId() {return sbId;}
public void setSbId(Long sbId) {this.sbId = sbId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

设备入库javaBean创建语句如下：

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

//设备入库
public class Sbrk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称编号
private Long sbId;
//入库日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//负责人
private String czr;
//备注
private String remark;
public Long getSbId() {return sbId;}
public void setSbId(Long sbId) {this.sbId = sbId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

设备维修javaBean创建语句如下：

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

//设备维修
public class Sbwx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称编号
private Long sbId;
//维修日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//负责人
private String czr;
//备注
private String remark;
public Long getSbId() {return sbId;}
public void setSbId(Long sbId) {this.sbId = sbId;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

巡检记录javaBean创建语句如下：

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

//巡检记录
public class Xjjl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称编号
private Long sbId;
//巡检日期
private Date insertDate;
//巡检内容
private String content;
public Long getSbId() {return sbId;}
public void setSbId(Long sbId) {this.sbId = sbId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}