- 基于电信大数据的群体行为异常判定mysql数据库创建语句
- 基于电信大数据的群体行为异常判定oracle数据库创建语句
- 基于电信大数据的群体行为异常判定sqlserver数据库创建语句
- 基于电信大数据的群体行为异常判定spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于电信大数据的群体行为异常判定spring+springMVC+mybatis框架对象(javaBean,pojo)设计
要求做一个能够判定阈值并报警的程序
数据由数据库生成
模拟人口流入量流出量 最大人口等的阈值 达到阈值后系统报警
就是一个人口流入流出 和最大人口阈值的报警系统 人口用数据库模拟
需要模拟一段时间(比如五分钟 需要我自己能改)的流入流出量 并设定一个阈值 当达到阈值后系统会报警 分为几种情况 节假日 天气情况 这两个变量需要我自己能改
登录注册界面.jpg?x-oss-process=style/00001)
基于电信大数据的群体行为异常判定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_wsd(
id int primary key auto_increment comment '主键',
wd int comment '温度',
sd int comment '湿度',
insertDate datetime comment '日期'
) comment '温湿度';
预警阈值表创建语句如下:
create table t_yjfz(
id int primary key auto_increment comment '主键',
title varchar(100) comment '预警名称',
fz int comment '阈值',
types varchar(100) comment '向上、向下预警'
) comment '预警阈值';
预警信息表创建语句如下:
create table t_yjxx(
id int primary key auto_increment comment '主键',
title varchar(100) comment '预警名称',
types 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_wsd(
id integer,
wd int,
sd int,
insertDate datetime
);
--温湿度字段加注释
comment on column t_wsd.id is '主键';
comment on column t_wsd.wd is '温度';
comment on column t_wsd.sd is '湿度';
comment on column t_wsd.insertDate is '日期';
--温湿度表加注释
comment on table t_wsd is '温湿度';
预警阈值表创建语句如下:
create table t_yjfz(
id integer,
title varchar(100),
fz int,
types varchar(100)
);
--预警阈值字段加注释
comment on column t_yjfz.id is '主键';
comment on column t_yjfz.title is '预警名称';
comment on column t_yjfz.fz is '阈值';
comment on column t_yjfz.types is '向上、向下预警';
--预警阈值表加注释
comment on table t_yjfz is '预警阈值';
预警信息表创建语句如下:
create table t_yjxx(
id integer,
title varchar(100),
types varchar(100),
insertDate datetime
);
--预警信息字段加注释
comment on column t_yjxx.id is '主键';
comment on column t_yjxx.title is '预警名称';
comment on column t_yjxx.types is '类型';
comment on column t_yjxx.insertDate is '日期';
--预警信息表加注释
comment on table t_yjxx is '预警信息';
oracle特有,对应序列如下:
create sequence s_t_wsd;
create sequence s_t_yjfz;
create sequence s_t_yjxx;
基于电信大数据的群体行为异常判定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_wsd(
id int identity(1,1) primary key not null,--主键
wd int,--温度
sd int,--湿度
insertDate datetime--日期
);
预警阈值表创建语句如下:
--预警阈值表注释
create table t_yjfz(
id int identity(1,1) primary key not null,--主键
title varchar(100),--预警名称
fz int,--阈值
types varchar(100)--向上、向下预警
);
预警信息表创建语句如下:
--预警信息表注释
create table t_yjxx(
id int identity(1,1) primary key not null,--主键
title varchar(100),--预警名称
types varchar(100),--类型
insertDate datetime--日期
);
登录后主页.jpg?x-oss-process=style/00001)
基于电信大数据的群体行为异常判定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_wsd")
public class Wsd {
//主键
@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 wd;
//湿度
private Integer sd;
//日期
private Date insertDate;
public Integer getWd() {return wd;}
public void setWd(Integer wd) {this.wd = wd;}
public Integer getSd() {return sd;}
public void setSd(Integer sd) {this.sd = sd;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}
预警阈值javaBean创建语句如下:
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//预警阈值
@Table(name = "t_yjfz")
public class Yjfz {
//主键
@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 Integer fz;
//向上、向下预警
private String types;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFz() {return fz;}
public void setFz(Integer fz) {this.fz = fz;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}
预警信息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_yjxx")
public class Yjxx {
//主键
@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 types;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 Wsd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//温度
private Integer wd;
//湿度
private Integer sd;
//日期
private Date insertDate;
public Integer getWd() {return wd;}
public void setWd(Integer wd) {this.wd = wd;}
public Integer getSd() {return sd;}
public void setSd(Integer sd) {this.sd = sd;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}
预警阈值javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//预警阈值
public class Yjfz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//预警名称
private String title;
//阈值
private Integer fz;
//向上、向下预警
private String types;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getFz() {return fz;}
public void setFz(Integer fz) {this.fz = fz;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}
预警信息javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//预警信息
public class Yjxx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//预警名称
private String title;
//类型
private String types;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}