基于WEB的高速危险化学品应急处置系统,java网站毕业设计

基于WEB的高速危险化学品应急处置系统登录注册界面

基于WEB的高速危险化学品应急处置系统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_a1(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '危险品名称',
	v2 varchar(100) comment '危险品备注',
	v3 varchar(100) comment '图片'
) comment '危险品';

事故预案表创建语句如下:


create table t_a2(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '事故预案名称',
	v2 varchar(100) comment '事故预案名称'
) comment '事故预案';

法律法规表创建语句如下:


create table t_a3(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '法规名称',
	v2 varchar(100) comment '法规内容'
) comment '法律法规';

应急专家表创建语句如下:


create table t_a4(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '专家名称',
	v2 varchar(100) comment '联系电话',
	v3 varchar(100) comment '头像'
) comment '应急专家';

应急资源表创建语句如下:


create table t_b1(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '应急资源名称',
	v2 varchar(100) comment '位置',
	v3 varchar(100) comment '数量'
) comment '应急资源';

应急GIS表创建语句如下:


create table t_b2(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '应急GIS名称',
	v2 varchar(100) comment '应急GI内容'
) comment '应急GIS';

应急人员表创建语句如下:


create table t_b3(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '人员名称',
	v2 varchar(100) comment '联系电话',
	v3 varchar(100) comment '头像'
) comment '应急人员';

应急组织表创建语句如下:


create table t_b4(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '组织名称',
	v2 varchar(100) 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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话'
) comment '用户';

基于WEB的高速危险化学品应急处置系统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_a1(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100)
);
--危险品字段加注释
comment on column t_a1.id is '主键';
comment on column t_a1.v1 is '危险品名称';
comment on column t_a1.v2 is '危险品备注';
comment on column t_a1.v3 is '图片';
--危险品表加注释
comment on table t_a1 is '危险品';

事故预案表创建语句如下:


create table t_a2(
	id integer,
	v1 varchar(100),
	v2 varchar(100)
);
--事故预案字段加注释
comment on column t_a2.id is '主键';
comment on column t_a2.v1 is '事故预案名称';
comment on column t_a2.v2 is '事故预案名称';
--事故预案表加注释
comment on table t_a2 is '事故预案';

法律法规表创建语句如下:


create table t_a3(
	id integer,
	v1 varchar(100),
	v2 varchar(100)
);
--法律法规字段加注释
comment on column t_a3.id is '主键';
comment on column t_a3.v1 is '法规名称';
comment on column t_a3.v2 is '法规内容';
--法律法规表加注释
comment on table t_a3 is '法律法规';

应急专家表创建语句如下:


create table t_a4(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100)
);
--应急专家字段加注释
comment on column t_a4.id is '主键';
comment on column t_a4.v1 is '专家名称';
comment on column t_a4.v2 is '联系电话';
comment on column t_a4.v3 is '头像';
--应急专家表加注释
comment on table t_a4 is '应急专家';

应急资源表创建语句如下:


create table t_b1(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100)
);
--应急资源字段加注释
comment on column t_b1.id is '主键';
comment on column t_b1.v1 is '应急资源名称';
comment on column t_b1.v2 is '位置';
comment on column t_b1.v3 is '数量';
--应急资源表加注释
comment on table t_b1 is '应急资源';

应急GIS表创建语句如下:


create table t_b2(
	id integer,
	v1 varchar(100),
	v2 varchar(100)
);
--应急GIS字段加注释
comment on column t_b2.id is '主键';
comment on column t_b2.v1 is '应急GIS名称';
comment on column t_b2.v2 is '应急GI内容';
--应急GIS表加注释
comment on table t_b2 is '应急GIS';

应急人员表创建语句如下:


create table t_b3(
	id integer,
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100)
);
--应急人员字段加注释
comment on column t_b3.id is '主键';
comment on column t_b3.v1 is '人员名称';
comment on column t_b3.v2 is '联系电话';
comment on column t_b3.v3 is '头像';
--应急人员表加注释
comment on table t_b3 is '应急人员';

应急组织表创建语句如下:


create table t_b4(
	id integer,
	v1 varchar(100),
	v2 varchar(100)
);
--应急组织字段加注释
comment on column t_b4.id is '主键';
comment on column t_b4.v1 is '组织名称';
comment on column t_b4.v2 is '联系电话';
--应急组织表加注释
comment on table t_b4 is '应急组织';

用户表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	age varchar(100),
	sex 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.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
--用户表加注释
comment on table t_customer is '用户';

oracle特有,对应序列如下:


create sequence s_t_a1;
create sequence s_t_a2;
create sequence s_t_a3;
create sequence s_t_a4;
create sequence s_t_b1;
create sequence s_t_b2;
create sequence s_t_b3;
create sequence s_t_b4;
create sequence s_t_customer;

基于WEB的高速危险化学品应急处置系统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_a1(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--危险品名称
	v2 varchar(100),--危险品备注
	v3 varchar(100)--图片
);

事故预案表创建语句如下:


--事故预案表注释
create table t_a2(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--事故预案名称
	v2 varchar(100)--事故预案名称
);

法律法规表创建语句如下:


--法律法规表注释
create table t_a3(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--法规名称
	v2 varchar(100)--法规内容
);

应急专家表创建语句如下:


--应急专家表注释
create table t_a4(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--专家名称
	v2 varchar(100),--联系电话
	v3 varchar(100)--头像
);

应急资源表创建语句如下:


--应急资源表注释
create table t_b1(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--应急资源名称
	v2 varchar(100),--位置
	v3 varchar(100)--数量
);

应急GIS表创建语句如下:


--应急GIS表注释
create table t_b2(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--应急GIS名称
	v2 varchar(100)--应急GI内容
);

应急人员表创建语句如下:


--应急人员表注释
create table t_b3(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--人员名称
	v2 varchar(100),--联系电话
	v3 varchar(100)--头像
);

应急组织表创建语句如下:


--应急组织表注释
create table t_b4(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--组织名称
	v2 varchar(100)--联系电话
);

用户表创建语句如下:


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

基于WEB的高速危险化学品应急处置系统登录后主页

基于WEB的高速危险化学品应急处置系统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_a1")
public class A1 {
//主键
@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 String v2;
//图片
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
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_a2")
public class A2 {
//主键
@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 String v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

法律法规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_a3")
public class A3 {
//主键
@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 String v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

应急专家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_a4")
public class A4 {
//主键
@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 String v2;
//头像
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
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_b1")
public class B1 {
//主键
@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 String v2;
//数量
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

应急GISjavaBean创建语句如下:


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

//应急GIS
@Table(name = "t_b2")
public class B2 {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//应急GIS名称
private String v1;
//应急GI内容
private String v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

应急人员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_b3")
public class B3 {
//主键
@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 String v2;
//头像
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
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_b4")
public class B4 {
//主键
@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 String v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

用户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 age;
//性别
private String sex;
//电话
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 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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

基于WEB的高速危险化学品应急处置系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

危险品javaBean创建语句如下:


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

//危险品
public class A1  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//危险品名称
private String v1;
//危险品备注
private String v2;
//图片
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
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 A2  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故预案名称
private String v1;
//事故预案名称
private String v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

法律法规javaBean创建语句如下:


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

//法律法规
public class A3  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//法规名称
private String v1;
//法规内容
private String v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

应急专家javaBean创建语句如下:


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

//应急专家
public class A4  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//专家名称
private String v1;
//联系电话
private String v2;
//头像
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
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 B1  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//应急资源名称
private String v1;
//位置
private String v2;
//数量
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

应急GISjavaBean创建语句如下:


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

//应急GIS
public class B2  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//应急GIS名称
private String v1;
//应急GI内容
private String v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

应急人员javaBean创建语句如下:


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

//应急人员
public class B3  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//人员名称
private String v1;
//联系电话
private String v2;
//头像
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
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 B4  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//组织名称
private String v1;
//联系电话
private String v2;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
}

用户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 age;
//性别
private String sex;
//电话
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 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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}

源代码下载点这里

评论