电力管理系统

电力管理系统登录注册界面

电力管理系统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 '姓名',
	headPic varchar(100) comment '头像',
	email varchar(100) comment '邮箱',
	phone 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_jszl(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '技术资料名称',
	fileUrl varchar(100) comment '附件',
	content varchar(100) comment '详细介绍',
	showDate datetime comment '日期'
) comment '技术资料';

设备表创建语句如下:


create table t_sb(
	id int primary key auto_increment comment '主键',
	sbName varchar(100) comment '设备名称编号',
	pic varchar(100) comment '图片',
	content varchar(100) comment '设备说明',
	cj varchar(100) comment '厂家',
	showDate datetime comment '添加日期'
) comment '设备';

设备购置计划表创建语句如下:


create table t_sbgzjh(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '购置计划标题',
	content varchar(100) comment '说明',
	insertDate datetime comment '申请日期',
	back varchar(100) comment '回复',
	status varchar(100) comment '状态',
	customerId int comment ''
) comment '设备购置计划';

设备检修表创建语句如下:


create table t_sbjx(
	id int primary key auto_increment comment '主键',
	sbName varchar(100) comment '设备名称编号',
	pic varchar(100) comment '现场拍照',
	content varchar(100) comment '检修记录',
	showDate datetime comment '检修日期',
	lxr varchar(100) comment '操作人'
) comment '设备检修';

设备校准表创建语句如下:


create table t_sbjz(
	id int primary key auto_increment comment '主键',
	sbName varchar(100) comment '设备名称编号',
	pic varchar(100) comment '现场拍照',
	content varchar(100) comment '详细记录',
	showDate datetime comment '校准日期',
	lxr varchar(100) comment '操作人'
) comment '设备校准';

站点表创建语句如下:


create table t_zd(
	id int primary key auto_increment comment '主键',
	zdName varchar(100) comment '站点名称编号',
	pic varchar(100) comment '图片',
	content varchar(100) comment '站点说明',
	cj varchar(100) comment '站点位置',
	showDate datetime comment '添加日期'
) comment '站点';

站点维护情况表创建语句如下:


create table t_zdwx(
	id int primary key auto_increment comment '主键',
	zdName varchar(100) comment '站点名称编号',
	pic varchar(100) comment '现场拍照',
	content varchar(100) comment '维护记录',
	showDate datetime comment '记录日期',
	lxr varchar(100) comment '操作人'
) comment '站点维护情况';

站点运行情况表创建语句如下:


create table t_zdyx(
	id int primary key auto_increment comment '主键',
	zdName varchar(100) comment '站点名称编号',
	pic varchar(100) comment '现场拍照',
	content varchar(100) comment '详细记录',
	showDate datetime comment '记录日期',
	lxr 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),
	headPic varchar(100),
	email varchar(100),
	phone 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.email is '邮箱';
comment on column t_customer.phone 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_jszl(
	id integer,
	title varchar(100),
	fileUrl varchar(100),
	content varchar(100),
	showDate datetime
);
--技术资料字段加注释
comment on column t_jszl.id is '主键';
comment on column t_jszl.title is '技术资料名称';
comment on column t_jszl.fileUrl is '附件';
comment on column t_jszl.content is '详细介绍';
comment on column t_jszl.showDate is '日期';
--技术资料表加注释
comment on table t_jszl is '技术资料';

设备表创建语句如下:


create table t_sb(
	id integer,
	sbName varchar(100),
	pic varchar(100),
	content varchar(100),
	cj varchar(100),
	showDate datetime
);
--设备字段加注释
comment on column t_sb.id is '主键';
comment on column t_sb.sbName is '设备名称编号';
comment on column t_sb.pic is '图片';
comment on column t_sb.content is '设备说明';
comment on column t_sb.cj is '厂家';
comment on column t_sb.showDate is '添加日期';
--设备表加注释
comment on table t_sb is '设备';

设备购置计划表创建语句如下:


create table t_sbgzjh(
	id integer,
	title varchar(100),
	content varchar(100),
	insertDate datetime,
	back varchar(100),
	status varchar(100),
	customerId int
);
--设备购置计划字段加注释
comment on column t_sbgzjh.id is '主键';
comment on column t_sbgzjh.title is '购置计划标题';
comment on column t_sbgzjh.content is '说明';
comment on column t_sbgzjh.insertDate is '申请日期';
comment on column t_sbgzjh.back is '回复';
comment on column t_sbgzjh.status is '状态';
comment on column t_sbgzjh.customerId is '';
--设备购置计划表加注释
comment on table t_sbgzjh is '设备购置计划';

设备检修表创建语句如下:


create table t_sbjx(
	id integer,
	sbName varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime,
	lxr varchar(100)
);
--设备检修字段加注释
comment on column t_sbjx.id is '主键';
comment on column t_sbjx.sbName is '设备名称编号';
comment on column t_sbjx.pic is '现场拍照';
comment on column t_sbjx.content is '检修记录';
comment on column t_sbjx.showDate is '检修日期';
comment on column t_sbjx.lxr is '操作人';
--设备检修表加注释
comment on table t_sbjx is '设备检修';

设备校准表创建语句如下:


create table t_sbjz(
	id integer,
	sbName varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime,
	lxr varchar(100)
);
--设备校准字段加注释
comment on column t_sbjz.id is '主键';
comment on column t_sbjz.sbName is '设备名称编号';
comment on column t_sbjz.pic is '现场拍照';
comment on column t_sbjz.content is '详细记录';
comment on column t_sbjz.showDate is '校准日期';
comment on column t_sbjz.lxr is '操作人';
--设备校准表加注释
comment on table t_sbjz is '设备校准';

站点表创建语句如下:


create table t_zd(
	id integer,
	zdName varchar(100),
	pic varchar(100),
	content varchar(100),
	cj varchar(100),
	showDate datetime
);
--站点字段加注释
comment on column t_zd.id is '主键';
comment on column t_zd.zdName is '站点名称编号';
comment on column t_zd.pic is '图片';
comment on column t_zd.content is '站点说明';
comment on column t_zd.cj is '站点位置';
comment on column t_zd.showDate is '添加日期';
--站点表加注释
comment on table t_zd is '站点';

站点维护情况表创建语句如下:


create table t_zdwx(
	id integer,
	zdName varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime,
	lxr varchar(100)
);
--站点维护情况字段加注释
comment on column t_zdwx.id is '主键';
comment on column t_zdwx.zdName is '站点名称编号';
comment on column t_zdwx.pic is '现场拍照';
comment on column t_zdwx.content is '维护记录';
comment on column t_zdwx.showDate is '记录日期';
comment on column t_zdwx.lxr is '操作人';
--站点维护情况表加注释
comment on table t_zdwx is '站点维护情况';

站点运行情况表创建语句如下:


create table t_zdyx(
	id integer,
	zdName varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime,
	lxr varchar(100)
);
--站点运行情况字段加注释
comment on column t_zdyx.id is '主键';
comment on column t_zdyx.zdName is '站点名称编号';
comment on column t_zdyx.pic is '现场拍照';
comment on column t_zdyx.content is '详细记录';
comment on column t_zdyx.showDate is '记录日期';
comment on column t_zdyx.lxr is '操作人';
--站点运行情况表加注释
comment on table t_zdyx is '站点运行情况';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_jszl;
create sequence s_t_sb;
create sequence s_t_sbgzjh;
create sequence s_t_sbjx;
create sequence s_t_sbjz;
create sequence s_t_zd;
create sequence s_t_zdwx;
create sequence s_t_zdyx;

电力管理系统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),--姓名
	headPic varchar(100),--头像
	email varchar(100),--邮箱
	phone 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_jszl(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--技术资料名称
	fileUrl varchar(100),--附件
	content varchar(100),--详细介绍
	showDate datetime--日期
);

设备表创建语句如下:


--设备表注释
create table t_sb(
	id int identity(1,1) primary key not null,--主键
	sbName varchar(100),--设备名称编号
	pic varchar(100),--图片
	content varchar(100),--设备说明
	cj varchar(100),--厂家
	showDate datetime--添加日期
);

设备购置计划表创建语句如下:


--设备购置计划表注释
create table t_sbgzjh(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--购置计划标题
	content varchar(100),--说明
	insertDate datetime,--申请日期
	back varchar(100),--回复
	status varchar(100),--状态
	customerId int--
);

设备检修表创建语句如下:


--设备检修表注释
create table t_sbjx(
	id int identity(1,1) primary key not null,--主键
	sbName varchar(100),--设备名称编号
	pic varchar(100),--现场拍照
	content varchar(100),--检修记录
	showDate datetime,--检修日期
	lxr varchar(100)--操作人
);

设备校准表创建语句如下:


--设备校准表注释
create table t_sbjz(
	id int identity(1,1) primary key not null,--主键
	sbName varchar(100),--设备名称编号
	pic varchar(100),--现场拍照
	content varchar(100),--详细记录
	showDate datetime,--校准日期
	lxr varchar(100)--操作人
);

站点表创建语句如下:


--站点表注释
create table t_zd(
	id int identity(1,1) primary key not null,--主键
	zdName varchar(100),--站点名称编号
	pic varchar(100),--图片
	content varchar(100),--站点说明
	cj varchar(100),--站点位置
	showDate datetime--添加日期
);

站点维护情况表创建语句如下:


--站点维护情况表注释
create table t_zdwx(
	id int identity(1,1) primary key not null,--主键
	zdName varchar(100),--站点名称编号
	pic varchar(100),--现场拍照
	content varchar(100),--维护记录
	showDate datetime,--记录日期
	lxr varchar(100)--操作人
);

站点运行情况表创建语句如下:


--站点运行情况表注释
create table t_zdyx(
	id int identity(1,1) primary key not null,--主键
	zdName varchar(100),--站点名称编号
	pic varchar(100),--现场拍照
	content varchar(100),--详细记录
	showDate datetime,--记录日期
	lxr 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 headPic;
//邮箱
private String email;
//电话
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 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 getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
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_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_jszl")
public class Jszl {
//主键
@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 fileUrl;
//详细介绍
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_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 pic;
//设备说明
private String content;
//厂家
private String cj;
//添加日期
private Date showDate;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
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 String getCj() {return cj;}
public void setCj(String cj) {this.cj = cj;}
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_sbgzjh")
public class Sbgzjh {
//主键
@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;
//回复
private String back;
//状态
private String status;
//
private Integer customerId;
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;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}

设备检修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_sbjx")
public class Sbjx {
//主键
@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 pic;
//检修记录
private String content;
//检修日期
private Date showDate;
//操作人
private String lxr;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
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;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
}

设备校准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_sbjz")
public class Sbjz {
//主键
@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 pic;
//详细记录
private String content;
//校准日期
private Date showDate;
//操作人
private String lxr;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
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;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
}

站点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_zd")
public class Zd {
//主键
@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 zdName;
//图片
private String pic;
//站点说明
private String content;
//站点位置
private String cj;
//添加日期
private Date showDate;
public String getZdName() {return zdName;}
public void setZdName(String zdName) {this.zdName = zdName;}
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 String getCj() {return cj;}
public void setCj(String cj) {this.cj = cj;}
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_zdwx")
public class Zdwx {
//主键
@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 zdName;
//现场拍照
private String pic;
//维护记录
private String content;
//记录日期
private Date showDate;
//操作人
private String lxr;
public String getZdName() {return zdName;}
public void setZdName(String zdName) {this.zdName = zdName;}
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;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
}

站点运行情况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_zdyx")
public class Zdyx {
//主键
@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 zdName;
//现场拍照
private String pic;
//详细记录
private String content;
//记录日期
private Date showDate;
//操作人
private String lxr;
public String getZdName() {return zdName;}
public void setZdName(String zdName) {this.zdName = zdName;}
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;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
}

电力管理系统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 headPic;
//邮箱
private String email;
//电话
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 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 getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
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 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 Jszl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//技术资料名称
private String title;
//附件
private String fileUrl;
//详细介绍
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Sb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称编号
private String sbName;
//图片
private String pic;
//设备说明
private String content;
//厂家
private String cj;
//添加日期
private Date showDate;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
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 String getCj() {return cj;}
public void setCj(String cj) {this.cj = cj;}
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 Sbgzjh  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;
//回复
private String back;
//状态
private String status;
//
private Integer customerId;
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;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}

设备检修javaBean创建语句如下:


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

//设备检修
public class Sbjx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称编号
private String sbName;
//现场拍照
private String pic;
//检修记录
private String content;
//检修日期
private Date showDate;
//操作人
private String lxr;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
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;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
}

设备校准javaBean创建语句如下:


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

//设备校准
public class Sbjz  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备名称编号
private String sbName;
//现场拍照
private String pic;
//详细记录
private String content;
//校准日期
private Date showDate;
//操作人
private String lxr;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
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;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
}

站点javaBean创建语句如下:


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

//站点
public class Zd  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//站点名称编号
private String zdName;
//图片
private String pic;
//站点说明
private String content;
//站点位置
private String cj;
//添加日期
private Date showDate;
public String getZdName() {return zdName;}
public void setZdName(String zdName) {this.zdName = zdName;}
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 String getCj() {return cj;}
public void setCj(String cj) {this.cj = cj;}
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 Zdwx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//站点名称编号
private String zdName;
//现场拍照
private String pic;
//维护记录
private String content;
//记录日期
private Date showDate;
//操作人
private String lxr;
public String getZdName() {return zdName;}
public void setZdName(String zdName) {this.zdName = zdName;}
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;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
}

站点运行情况javaBean创建语句如下:


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

//站点运行情况
public class Zdyx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//站点名称编号
private String zdName;
//现场拍照
private String pic;
//详细记录
private String content;
//记录日期
private Date showDate;
//操作人
private String lxr;
public String getZdName() {return zdName;}
public void setZdName(String zdName) {this.zdName = zdName;}
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;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
}

评论