消防栓监控系统设计与开发

摘要: 目前,消防栓没有有效的监管措施,只能依靠人员巡检,必然会造成监管不到位,并且造成维护和保养的落实不到位。随着互联网的快速发展,企业渐渐的意识到消防栓监控的重要性。消防栓监控技术是指客户通过浏览器、服务器、数据库的信息交互来获取现场的设备信息和产品的生产状况,并且最后将信息存储在数据库中。

本文介绍的消防栓监控系统以服务器、数据库、监控机以及现场控制器为核心设计开发的。通过监控机的浏览器向服务器发送请求,服务器处理请求后与数据库实现数据传输,最终动态的显示在浏览器上。通过消防栓监控系统实现了控制消防栓、消防栓动态的实时显示等重要功能。本文提出的系统设计方案克服了地域性的限制,提高了消防栓管理和维护。

关键词:远程监控,Web,消防栓

 

1 文献综述

监控系统是集各种技术为一体的高科技产品,它操作便捷、控制效果好。它可以很

有效的应用于人们的生活和企业的生产。目前,对监控系统的定义是比较一致的,即指可以实现数据采集、设备监视等功能的计算机系统,通常人们叫它 SCADA。在这个系统中,计算机可以直接对监控对象进行操作、处理。通常远程监控系统有如下特点:实时性、易维护性、可靠性、通信功能等。监控技术通过与计算机网络技术的结合,促进了新的相关技术不断出现。例如远程监控、远程制造等。消防栓实时监控是指本地监控机通过网络实现对现场设备远程监控、了解消防栓动态。研究消防栓监控的主要意义如下:

第一:采用远程实时监控技术,技术人员可以通过客户端对设备进行操作,而不用亲自到现场解决,这样大大提高了劳动生产率。

第二:远程监控技术可以充分利用人力资源。如果设备出现现场技术人员不能解决的问题,可以通过网络询问设备对应的厂商或者相关的专家,通过专家的处理使得生产活动正常进行,保障了生产活动的正常进行。

第三:消防栓监控系统通过使用数据库完成对数据的存储,这样对未来设备的故障诊断提供了数据基础。

在远程监控系统的发展过程中,我们把它分为两种类型 消防栓监控系统设计与开发登录注册界面

消防栓监控系统设计与开发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_error(
	id int primary key auto_increment comment '主键',
	ename varchar(100) comment '异常名称',
	description varchar(100) comment '异常描述'
) comment '异常';

消防栓信息表创建语句如下:


create table t_hydrant(
	id int primary key auto_increment comment '主键',
	hlocation varchar(100) comment '定位',
	htime datetime comment '加入时间',
	hpicture varchar(100) comment '消防栓图片',
	htype varchar(100) comment '消防栓类型',
	title varchar(100) comment '编号'
) comment '消防栓信息';

维修订单表创建语句如下:


create table t_repair(
	id int primary key auto_increment comment '主键',
	hydrantId int comment '消防栓',
	rmanId int comment '维修员',
	errorId int comment '异常',
	rtime datetime comment '维修时间',
	result varchar(100) comment '维修结果'
) comment '维修订单';

维修人员表创建语句如下:


create table t_rman(
	id int primary key auto_increment comment '主键',
	rname varchar(100) comment '维修员姓名',
	rphone varchar(100) comment '维修员电话',
	raddress varchar(100) comment '维修员地址'
) comment '维修人员';

消防栓状态表创建语句如下:


create table t_state(
	id int primary key auto_increment comment '主键',
	hydrantId int comment '消防栓',
	stime datetime comment '状态时间',
	stypeId int comment '状态类型',
	snumber int comment '状态数值'
) comment '消防栓状态';

状态类型表创建语句如下:


create table t_stype(
	id int primary key auto_increment comment '主键',
	tname varchar(100) comment '状态名称',
	unit varchar(100) comment '状态单位'
) comment '状态类型';

用户表创建语句如下:


create table t_user(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	name varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	role varchar(100) comment '角色',
	address 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_error(
	id integer,
	ename varchar(100),
	description varchar(100)
);
--异常字段加注释
comment on column t_error.id is '主键';
comment on column t_error.ename is '异常名称';
comment on column t_error.description is '异常描述';
--异常表加注释
comment on table t_error is '异常';

消防栓信息表创建语句如下:


create table t_hydrant(
	id integer,
	hlocation varchar(100),
	htime datetime,
	hpicture varchar(100),
	htype varchar(100),
	title varchar(100)
);
--消防栓信息字段加注释
comment on column t_hydrant.id is '主键';
comment on column t_hydrant.hlocation is '定位';
comment on column t_hydrant.htime is '加入时间';
comment on column t_hydrant.hpicture is '消防栓图片';
comment on column t_hydrant.htype is '消防栓类型';
comment on column t_hydrant.title is '编号';
--消防栓信息表加注释
comment on table t_hydrant is '消防栓信息';

维修订单表创建语句如下:


create table t_repair(
	id integer,
	hydrantId int,
	rmanId int,
	errorId int,
	rtime datetime,
	result varchar(100)
);
--维修订单字段加注释
comment on column t_repair.id is '主键';
comment on column t_repair.hydrantId is '消防栓';
comment on column t_repair.rmanId is '维修员';
comment on column t_repair.errorId is '异常';
comment on column t_repair.rtime is '维修时间';
comment on column t_repair.result is '维修结果';
--维修订单表加注释
comment on table t_repair is '维修订单';

维修人员表创建语句如下:


create table t_rman(
	id integer,
	rname varchar(100),
	rphone varchar(100),
	raddress varchar(100)
);
--维修人员字段加注释
comment on column t_rman.id is '主键';
comment on column t_rman.rname is '维修员姓名';
comment on column t_rman.rphone is '维修员电话';
comment on column t_rman.raddress is '维修员地址';
--维修人员表加注释
comment on table t_rman is '维修人员';

消防栓状态表创建语句如下:


create table t_state(
	id integer,
	hydrantId int,
	stime datetime,
	stypeId int,
	snumber int
);
--消防栓状态字段加注释
comment on column t_state.id is '主键';
comment on column t_state.hydrantId is '消防栓';
comment on column t_state.stime is '状态时间';
comment on column t_state.stypeId is '状态类型';
comment on column t_state.snumber is '状态数值';
--消防栓状态表加注释
comment on table t_state is '消防栓状态';

状态类型表创建语句如下:


create table t_stype(
	id integer,
	tname varchar(100),
	unit varchar(100)
);
--状态类型字段加注释
comment on column t_stype.id is '主键';
comment on column t_stype.tname is '状态名称';
comment on column t_stype.unit is '状态单位';
--状态类型表加注释
comment on table t_stype is '状态类型';

用户表创建语句如下:


create table t_user(
	id integer,
	username varchar(100),
	password varchar(100),
	name varchar(100),
	phone varchar(100),
	role varchar(100),
	address varchar(100)
);
--用户字段加注释
comment on column t_user.id is '主键';
comment on column t_user.username is '账号';
comment on column t_user.password is '密码';
comment on column t_user.name is '姓名';
comment on column t_user.phone is '电话';
comment on column t_user.role is '角色';
comment on column t_user.address is '地址';
--用户表加注释
comment on table t_user is '用户';

oracle特有,对应序列如下:


create sequence s_t_error;
create sequence s_t_hydrant;
create sequence s_t_repair;
create sequence s_t_rman;
create sequence s_t_state;
create sequence s_t_stype;
create sequence s_t_user;

消防栓监控系统设计与开发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_error(
	id int identity(1,1) primary key not null,--主键
	ename varchar(100),--异常名称
	description varchar(100)--异常描述
);

消防栓信息表创建语句如下:


--消防栓信息表注释
create table t_hydrant(
	id int identity(1,1) primary key not null,--主键
	hlocation varchar(100),--定位
	htime datetime,--加入时间
	hpicture varchar(100),--消防栓图片
	htype varchar(100),--消防栓类型
	title varchar(100)--编号
);

维修订单表创建语句如下:


--维修订单表注释
create table t_repair(
	id int identity(1,1) primary key not null,--主键
	hydrantId int,--消防栓
	rmanId int,--维修员
	errorId int,--异常
	rtime datetime,--维修时间
	result varchar(100)--维修结果
);

维修人员表创建语句如下:


--维修人员表注释
create table t_rman(
	id int identity(1,1) primary key not null,--主键
	rname varchar(100),--维修员姓名
	rphone varchar(100),--维修员电话
	raddress varchar(100)--维修员地址
);

消防栓状态表创建语句如下:


--消防栓状态表注释
create table t_state(
	id int identity(1,1) primary key not null,--主键
	hydrantId int,--消防栓
	stime datetime,--状态时间
	stypeId int,--状态类型
	snumber int--状态数值
);

状态类型表创建语句如下:


--状态类型表注释
create table t_stype(
	id int identity(1,1) primary key not null,--主键
	tname varchar(100),--状态名称
	unit varchar(100)--状态单位
);

用户表创建语句如下:


--用户表注释
create table t_user(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	name varchar(100),--姓名
	phone varchar(100),--电话
	role varchar(100),--角色
	address 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_error")
public class Error {
//主键
@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 ename;
//异常描述
private String description;
public String getEname() {return ename;}
public void setEname(String ename) {this.ename = ename;}
public String getDescription() {return description;}
public void setDescription(String description) {this.description = description;}
}

消防栓信息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_hydrant")
public class Hydrant {
//主键
@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 hlocation;
//加入时间
private Date htime;
//消防栓图片
private String hpicture;
//消防栓类型
private String htype;
//编号
private String title;
public String getHlocation() {return hlocation;}
public void setHlocation(String hlocation) {this.hlocation = hlocation;}
public Date getHtime() {return htime;}
public void setHtime(Date htime) {this.htime = htime;}
public String getHpicture() {return hpicture;}
public void setHpicture(String hpicture) {this.hpicture = hpicture;}
public String getHtype() {return htype;}
public void setHtype(String htype) {this.htype = htype;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}

维修订单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_repair")
public class Repair {
//主键
@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 hydrantId;
//维修员
private Integer rmanId;
//异常
private Integer errorId;
//维修时间
private Date rtime;
//维修结果
private String result;
public Integer getHydrantId() {return hydrantId;}
public void setHydrantId(Integer hydrantId) {this.hydrantId = hydrantId;}
public Integer getRmanId() {return rmanId;}
public void setRmanId(Integer rmanId) {this.rmanId = rmanId;}
public Integer getErrorId() {return errorId;}
public void setErrorId(Integer errorId) {this.errorId = errorId;}
public Date getRtime() {return rtime;}
public void setRtime(Date rtime) {this.rtime = rtime;}
public String getResult() {return result;}
public void setResult(String result) {this.result = result;}
}

维修人员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_rman")
public class Rman {
//主键
@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 rname;
//维修员电话
private String rphone;
//维修员地址
private String raddress;
public String getRname() {return rname;}
public void setRname(String rname) {this.rname = rname;}
public String getRphone() {return rphone;}
public void setRphone(String rphone) {this.rphone = rphone;}
public String getRaddress() {return raddress;}
public void setRaddress(String raddress) {this.raddress = raddress;}
}

消防栓状态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_state")
public class State {
//主键
@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 hydrantId;
//状态时间
private Date stime;
//状态类型
private Integer stypeId;
//状态数值
private Integer snumber;
public Integer getHydrantId() {return hydrantId;}
public void setHydrantId(Integer hydrantId) {this.hydrantId = hydrantId;}
public Date getStime() {return stime;}
public void setStime(Date stime) {this.stime = stime;}
public Integer getStypeId() {return stypeId;}
public void setStypeId(Integer stypeId) {this.stypeId = stypeId;}
public Integer getSnumber() {return snumber;}
public void setSnumber(Integer snumber) {this.snumber = snumber;}
}

状态类型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_stype")
public class Stype {
//主键
@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 tname;
//状态单位
private String unit;
public String getTname() {return tname;}
public void setTname(String tname) {this.tname = tname;}
public String getUnit() {return unit;}
public void setUnit(String unit) {this.unit = unit;}
}

用户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_user")
public class User {
//主键
@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 name;
//电话
private String phone;
//角色
private String role;
//地址
private String address;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getRole() {return role;}
public void setRole(String role) {this.role = role;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

消防栓监控系统设计与开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

异常javaBean创建语句如下:


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

//异常
public class Error  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//异常名称
private String ename;
//异常描述
private String description;
public String getEname() {return ename;}
public void setEname(String ename) {this.ename = ename;}
public String getDescription() {return description;}
public void setDescription(String description) {this.description = description;}
}

消防栓信息javaBean创建语句如下:


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

//消防栓信息
public class Hydrant  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//定位
private String hlocation;
//加入时间
private Date htime;
//消防栓图片
private String hpicture;
//消防栓类型
private String htype;
//编号
private String title;
public String getHlocation() {return hlocation;}
public void setHlocation(String hlocation) {this.hlocation = hlocation;}
public Date getHtime() {return htime;}
public void setHtime(Date htime) {this.htime = htime;}
public String getHpicture() {return hpicture;}
public void setHpicture(String hpicture) {this.hpicture = hpicture;}
public String getHtype() {return htype;}
public void setHtype(String htype) {this.htype = htype;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}

维修订单javaBean创建语句如下:


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

//维修订单
public class Repair  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//消防栓
private Integer hydrantId;
//维修员
private Integer rmanId;
//异常
private Integer errorId;
//维修时间
private Date rtime;
//维修结果
private String result;
public Integer getHydrantId() {return hydrantId;}
public void setHydrantId(Integer hydrantId) {this.hydrantId = hydrantId;}
public Integer getRmanId() {return rmanId;}
public void setRmanId(Integer rmanId) {this.rmanId = rmanId;}
public Integer getErrorId() {return errorId;}
public void setErrorId(Integer errorId) {this.errorId = errorId;}
public Date getRtime() {return rtime;}
public void setRtime(Date rtime) {this.rtime = rtime;}
public String getResult() {return result;}
public void setResult(String result) {this.result = result;}
}

维修人员javaBean创建语句如下:


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

//维修人员
public class Rman  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//维修员姓名
private String rname;
//维修员电话
private String rphone;
//维修员地址
private String raddress;
public String getRname() {return rname;}
public void setRname(String rname) {this.rname = rname;}
public String getRphone() {return rphone;}
public void setRphone(String rphone) {this.rphone = rphone;}
public String getRaddress() {return raddress;}
public void setRaddress(String raddress) {this.raddress = raddress;}
}

消防栓状态javaBean创建语句如下:


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

//消防栓状态
public class State  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//消防栓
private Integer hydrantId;
//状态时间
private Date stime;
//状态类型
private Integer stypeId;
//状态数值
private Integer snumber;
public Integer getHydrantId() {return hydrantId;}
public void setHydrantId(Integer hydrantId) {this.hydrantId = hydrantId;}
public Date getStime() {return stime;}
public void setStime(Date stime) {this.stime = stime;}
public Integer getStypeId() {return stypeId;}
public void setStypeId(Integer stypeId) {this.stypeId = stypeId;}
public Integer getSnumber() {return snumber;}
public void setSnumber(Integer snumber) {this.snumber = snumber;}
}

状态类型javaBean创建语句如下:


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

//状态类型
public class Stype  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//状态名称
private String tname;
//状态单位
private String unit;
public String getTname() {return tname;}
public void setTname(String tname) {this.tname = tname;}
public String getUnit() {return unit;}
public void setUnit(String unit) {this.unit = unit;}
}

用户javaBean创建语句如下:


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

//用户
public class User  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 name;
//电话
private String phone;
//角色
private String role;
//地址
private String address;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getRole() {return role;}
public void setRole(String role) {this.role = role;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

源代码下载点这里

评论