基于微服务的陕西省地质环境数据报送系统设计与开发

基于微服务的陕西省地质环境数据报送系统设计与开发
课题名称:基于微服务的陕西省地质环境数据报送系统设计与开发

具体专业:计算机科学与技术
开发语言:java
完成日期:五月中旬
具体要求:按照现代软件工程的基本方法,进行系统业务分析、需求建模、概要设计、详细设计、编码、测试及部署等相关工作
主要实现以下功能:
(1)采用J2EE技术,研发基于B/S架构的“应用系统开发框架”,为业务系统建设提供统一的访问框架;
(2)地质灾害年报报送功能:报送年度防治方案等,人为因素引发地质灾害点管理
(3)地质灾害月报功能:报送应急演练、宣传培训、搬迁避险、排查巡查,从基础数据填报,生成月报信息。
(4)地质灾害日报功能:由省、市、县用户填报值班记录和签到记录,搞个发邮件通知
(5)利用微服务架构思想对关键系统模块进行服务化设计并封装相关接口。
注:数据库尽量用oracle或者mysql

基于微服务的陕西省地质环境数据报送系统设计与开发登录注册界面

基于微服务的陕西省地质环境数据报送系统设计与开发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_dzzhyb(
	id int primary key auto_increment comment '主键',
	employeeId int comment '用户',
	types varchar(100) comment '类型',
	yf varchar(100) comment '月份',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	fileUrl varchar(100) comment '文件',
	status varchar(100) comment '状态'
) comment '地址灾害月报';

用户表创建语句如下:


create table t_employee(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码 ',
	employeeName varchar(100) comment '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	pic varchar(100) comment '头像',
	js varchar(100) comment '角色'
) comment '用户';

公告表创建语句如下:


create table t_gg(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate datetime comment '日期'
) comment '公告';

年度防治方案表创建语句如下:


create table t_ndfzfa(
	id int primary key auto_increment comment '主键',
	employeeId int comment '用户',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	fileUrl varchar(100) comment '文件',
	status varchar(100) comment '状态'
) comment '年度防治方案';

人为地质灾害表创建语句如下:


create table t_rwdzzh(
	id int primary key auto_increment comment '主键',
	employeeId int comment '用户',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	fileUrl varchar(100) comment '文件',
	status varchar(100) comment '状态'
) comment '人为地质灾害';

值班签到表创建语句如下:


create table t_zbqd(
	id int primary key auto_increment comment '主键',
	employeeId int comment '用户',
	ssx varchar(100) comment '省市县',
	title varchar(100) comment '标题',
	content varchar(100) comment '值班内容',
	insertDate datetime 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_dzzhyb(
	id integer,
	employeeId int,
	types varchar(100),
	yf varchar(100),
	title varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	status varchar(100)
);
--地址灾害月报字段加注释
comment on column t_dzzhyb.id is '主键';
comment on column t_dzzhyb.employeeId is '用户';
comment on column t_dzzhyb.types is '类型';
comment on column t_dzzhyb.yf is '月份';
comment on column t_dzzhyb.title is '标题';
comment on column t_dzzhyb.content is '内容';
comment on column t_dzzhyb.fileUrl is '文件';
comment on column t_dzzhyb.status is '状态';
--地址灾害月报表加注释
comment on table t_dzzhyb is '地址灾害月报';

用户表创建语句如下:


create table t_employee(
	id integer,
	username varchar(100),
	password varchar(100),
	employeeName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic varchar(100),
	js varchar(100)
);
--用户字段加注释
comment on column t_employee.id is '主键';
comment on column t_employee.username is '账号';
comment on column t_employee.password is '密码 ';
comment on column t_employee.employeeName is '姓名';
comment on column t_employee.age is '年龄';
comment on column t_employee.sex is '性别';
comment on column t_employee.phone is '电话';
comment on column t_employee.pic is '头像';
comment on column t_employee.js is '角色';
--用户表加注释
comment on table t_employee is '用户';

公告表创建语句如下:


create table t_gg(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.content is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';

年度防治方案表创建语句如下:


create table t_ndfzfa(
	id integer,
	employeeId int,
	title varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	status varchar(100)
);
--年度防治方案字段加注释
comment on column t_ndfzfa.id is '主键';
comment on column t_ndfzfa.employeeId is '用户';
comment on column t_ndfzfa.title is '标题';
comment on column t_ndfzfa.content is '内容';
comment on column t_ndfzfa.fileUrl is '文件';
comment on column t_ndfzfa.status is '状态';
--年度防治方案表加注释
comment on table t_ndfzfa is '年度防治方案';

人为地质灾害表创建语句如下:


create table t_rwdzzh(
	id integer,
	employeeId int,
	title varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	status varchar(100)
);
--人为地质灾害字段加注释
comment on column t_rwdzzh.id is '主键';
comment on column t_rwdzzh.employeeId is '用户';
comment on column t_rwdzzh.title is '标题';
comment on column t_rwdzzh.content is '内容';
comment on column t_rwdzzh.fileUrl is '文件';
comment on column t_rwdzzh.status is '状态';
--人为地质灾害表加注释
comment on table t_rwdzzh is '人为地质灾害';

值班签到表创建语句如下:


create table t_zbqd(
	id integer,
	employeeId int,
	ssx varchar(100),
	title varchar(100),
	content varchar(100),
	insertDate datetime
);
--值班签到字段加注释
comment on column t_zbqd.id is '主键';
comment on column t_zbqd.employeeId is '用户';
comment on column t_zbqd.ssx is '省市县';
comment on column t_zbqd.title is '标题';
comment on column t_zbqd.content is '值班内容';
comment on column t_zbqd.insertDate is '签到日期';
--值班签到表加注释
comment on table t_zbqd is '值班签到';

oracle特有,对应序列如下:


create sequence s_t_dzzhyb;
create sequence s_t_employee;
create sequence s_t_gg;
create sequence s_t_ndfzfa;
create sequence s_t_rwdzzh;
create sequence s_t_zbqd;

基于微服务的陕西省地质环境数据报送系统设计与开发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_dzzhyb(
	id int identity(1,1) primary key not null,--主键
	employeeId int,--用户
	types varchar(100),--类型
	yf varchar(100),--月份
	title varchar(100),--标题
	content varchar(100),--内容
	fileUrl varchar(100),--文件
	status varchar(100)--状态
);

用户表创建语句如下:


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

公告表创建语句如下:


--公告表注释
create table t_gg(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate datetime--日期
);

年度防治方案表创建语句如下:


--年度防治方案表注释
create table t_ndfzfa(
	id int identity(1,1) primary key not null,--主键
	employeeId int,--用户
	title varchar(100),--标题
	content varchar(100),--内容
	fileUrl varchar(100),--文件
	status varchar(100)--状态
);

人为地质灾害表创建语句如下:


--人为地质灾害表注释
create table t_rwdzzh(
	id int identity(1,1) primary key not null,--主键
	employeeId int,--用户
	title varchar(100),--标题
	content varchar(100),--内容
	fileUrl varchar(100),--文件
	status varchar(100)--状态
);

值班签到表创建语句如下:


--值班签到表注释
create table t_zbqd(
	id int identity(1,1) primary key not null,--主键
	employeeId int,--用户
	ssx varchar(100),--省市县
	title varchar(100),--标题
	content varchar(100),--值班内容
	insertDate datetime--签到日期
);

基于微服务的陕西省地质环境数据报送系统设计与开发登录后主页

基于微服务的陕西省地质环境数据报送系统设计与开发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_dzzhyb")
public class Dzzhyb {
//主键
@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 employeeId;
//类型
private String types;
//月份
private String yf;
//标题
private String title;
//内容
private String content;
//文件
private String fileUrl;
//状态
private String status;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_employee")
public class Employee {
//主键
@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 employeeName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//角色
private String js;
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 getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
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;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}

公告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 title;
//图片
private String pic;
//内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
}

年度防治方案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_ndfzfa")
public class Ndfzfa {
//主键
@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 employeeId;
//标题
private String title;
//内容
private String content;
//文件
private String fileUrl;
//状态
private String status;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_rwdzzh")
public class Rwdzzh {
//主键
@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 employeeId;
//标题
private String title;
//内容
private String content;
//文件
private String fileUrl;
//状态
private String status;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_zbqd")
public class Zbqd {
//主键
@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 employeeId;
//省市县
private String ssx;
//标题
private String title;
//值班内容
private String content;
//签到日期
private Date insertDate;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getSsx() {return ssx;}
public void setSsx(String ssx) {this.ssx = ssx;}
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;}
}

基于微服务的陕西省地质环境数据报送系统设计与开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

地址灾害月报javaBean创建语句如下:


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

//地址灾害月报
public class Dzzhyb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer employeeId;
//类型
private String types;
//月份
private String yf;
//标题
private String title;
//内容
private String content;
//文件
private String fileUrl;
//状态
private String status;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Employee  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 employeeName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//角色
private String js;
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 getEmployeeName() {return employeeName;}
public void setEmployeeName(String employeeName) {this.employeeName = employeeName;}
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;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}

公告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 title;
//图片
private String pic;
//内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
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;}
}

年度防治方案javaBean创建语句如下:


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

//年度防治方案
public class Ndfzfa  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer employeeId;
//标题
private String title;
//内容
private String content;
//文件
private String fileUrl;
//状态
private String status;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Rwdzzh  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer employeeId;
//标题
private String title;
//内容
private String content;
//文件
private String fileUrl;
//状态
private String status;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Zbqd  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer employeeId;
//省市县
private String ssx;
//标题
private String title;
//值班内容
private String content;
//签到日期
private Date insertDate;
public Integer getEmployeeId() {return employeeId;}
public void setEmployeeId(Integer employeeId) {this.employeeId = employeeId;}
public String getSsx() {return ssx;}
public void setSsx(String ssx) {this.ssx = ssx;}
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;}
}

源代码下载点这里

评论