1716jsp监控管理系统Myeclipse开发mysql数据库web结构java编程计算机网页项目源码

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50067 Source Host : localhost:3306 Source Database : jspjkgl Target Server Type : MYSQL Target Server Version : 50067 File Encoding : 65001 Date: 2021-04-26 10:46:10 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for cljg -- ---------------------------- DROP TABLE IF EXISTS `cljg`; CREATE TABLE `cljg` ( `cljgid` int(11) NOT NULL auto_increment, `gj` varchar(40) default NULL COMMENT '告警', `bt` varchar(40) default NULL COMMENT '标题', `ckjg` varchar(4000) default NULL COMMENT '查看结果', `djr` varchar(40) default NULL COMMENT '登记人', `djsj` varchar(40) default NULL COMMENT '登记时间', `zt` varchar(40) default NULL COMMENT '状态', PRIMARY KEY (`cljgid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of cljg -- ---------------------------- INSERT INTO `cljg` VALUES ('1', '202104252106000005', '2021-04-25A区中级告警处理结果', '123213', '123', '2021-04-26 08:52:19', '完成'); INSERT INTO `cljg` VALUES ('2', '202104260937000049', '2021-04-26日C区中级告警处理结果', '啥发大水发', '123', '2021-04-26 09:38:08', '完成'); -- ---------------------------- -- Table structure for gaojing -- ---------------------------- DROP TABLE IF EXISTS `gaojing`; CREATE TABLE `gaojing` ( `gjid` int(11) NOT NULL auto_increment, `ls` varchar(40) default NULL COMMENT '流水', `bt` varchar(40) default NULL COMMENT '标题', `dj` varchar(40) default NULL COMMENT '等级', `qy` varchar(40) default NULL COMMENT '区域', `gjms` varchar(4000) default NULL COMMENT '告警描述', `gjsj` varchar(40) default NULL COMMENT '告警时间', `fcr` varchar(40) default NULL COMMENT '发出人', `zt` varchar(40) default NULL COMMENT '状态', PRIMARY KEY (`gjid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gaojing -- ---------------------------- INSERT INTO `gaojing` VALUES ('1', '202104252106000005', '2021-04-25A区中级告警', '中级', 'A区', 'A区在15时间段中发生中级告警', '2021-04-26 21:06:05', 'admin', '已处理'); INSERT INTO `gaojing` VALUES ('2', '202104260937000049', '2021-04-26日C区中级告警', '中级', 'C区', '在C区15时中发生中级告警', '2021-04-26 09:37:49', 'admin', '已处理'); -- ---------------------------- -- Table structure for gly -- ---------------------------- DROP TABLE IF EXISTS `gly`; CREATE TABLE `gly` ( `glyid` int(11) NOT NULL auto_increment, `yhm` varchar(40) default NULL COMMENT '用户名', `mm` varchar(40) default NULL COMMENT '密码', `xm` varchar(40) default NULL COMMENT '姓名', PRIMARY KEY (`glyid`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gly -- ---------------------------- INSERT INTO `gly` VALUES ('1', 'admin', 'admin', 'admin'); -- ---------------------------- -- Table structure for gonggao -- ---------------------------- DROP TABLE IF EXISTS `gonggao`; CREATE TABLE `gonggao` ( `ggid` int(11) NOT NULL auto_increment, `bt` varchar(40) default NULL COMMENT '标题', `nr` varchar(4000) default NULL COMMENT '内容', `fbsj` varchar(40) default NULL COMMENT '发布时间', PRIMARY KEY (`ggid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gonggao -- ---------------------------- INSERT INTO `gonggao` VALUES ('1', '系统公告', '系统公告系统公告系统公告', '2021-04-25 11:38:11'); INSERT INTO `gonggao` VALUES ('2', '111', '2222', '2021-04-26 09:34:15'); -- ---------------------------- -- Table structure for liuliang -- ---------------------------- DROP TABLE IF EXISTS `liuliang`; CREATE TABLE `liuliang` ( `llid` int(11) NOT NULL auto_increment, `qy` varchar(40) default NULL COMMENT '区域', `sj` varchar(40) default NULL COMMENT '时间', `lds` int(40) default NULL COMMENT '流动数', `djsj` varchar(40) default NULL COMMENT '登记时间', `lyjl` varchar(40) default NULL COMMENT '来源记录', PRIMARY KEY (`llid`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of liuliang -- ---------------------------- INSERT INTO `liuliang` VALUES ('1', 'A区', '2021-04-26 15:34:56', '2', '2021-04-25 15:34:56', '网站'); INSERT INTO `liuliang` VALUES ('2', 'A区', '2021-04-26 15:34:56', '1', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('3', 'A区', '2021-04-26 15:34:56', '4', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('4', 'A区', '2021-04-26 15:34:56', '42', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('5', 'A区', '2021-04-26 15:34:56', '56', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('6', 'A区', '2021-04-26 15:34:56', '77', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('7', 'A区', '2021-04-26 15:34:56', '33', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('8', 'A区', '2021-04-26 15:34:56', '22', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('9', 'A区', '2021-04-26 15:34:56', '12', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('10', 'A区', '2021-04-26 15:34:56', '123', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('11', 'A区', '2021-04-26 15:34:56', '12', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('12', 'A区', '2021-04-26 15:34:56', '12', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('13', 'A区', '2021-04-26 15:34:56', '12', '2021-04-25 18:32:34', '导入'); INSERT INTO `liuliang` VALUES ('14', 'A区', '2021-04-26 09:36:03', '1', '2021-04-26 09:36:03', '网站'); INSERT INTO `liuliang` VALUES ('15', 'C区', '2021-04-26 15:34:56', '1', '2021-04-26 09:36:57', '导入'); INSERT INTO `liuliang` VALUES ('16', 'C区', '2021-04-26 15:34:56', '4', '2021-04-26 09:36:57', '导入'); INSERT INTO `liuliang` VALUES ('17', 'C区', '2021-04-26 15:34:56', '42', '2021-04-26 09:36:57', '导入'); INSERT INTO `liuliang` VALUES ('18', 'C区', '2021-04-26 15:34:56', '56', '2021-04-26 09:36:57', '导入'); INSERT INTO `liuliang` VALUES ('19', 'C区', '2021-04-26 15:34:56', '77', '2021-04-26 09:36:57', '导入'); INSERT INTO `liuliang` VALUES ('20', 'C区', '2021-04-26 15:34:56', '33', '2021-04-26 09:36:57', '导入'); INSERT INTO `liuliang` VALUES ('21', 'C区', '2021-04-26 15:34:56', '22', '2021-04-26 09:36:57', '导入'); INSERT INTO `liuliang` VALUES ('22', 'C区', '2021-04-26 15:34:56', '12', '2021-04-26 09:36:57', '导入'); INSERT INTO `liuliang` VALUES ('23', 'C区', '2021-04-26 15:34:56', '123', '2021-04-26 09:36:57', '导入'); INSERT INTO `liuliang` VALUES ('24', 'C区', '2021-04-26 15:34:56', '12', '2021-04-26 09:36:57', '导入'); INSERT INTO `liuliang` VALUES ('25', 'C区', '2021-04-26 15:34:56', '12', '2021-04-26 09:36:57', '导入'); INSERT INTO `liuliang` VALUES ('26', 'C区', '2021-04-26 15:34:56', '12', '2021-04-26 09:36:57', '导入'); -- ---------------------------- -- Table structure for quyu -- ---------------------------- DROP TABLE IF EXISTS `quyu`; CREATE TABLE `quyu` ( `qyid` int(11) NOT NULL auto_increment, `qy` varchar(40) default NULL COMMENT '区域', `dz` varchar(40) default NULL COMMENT '地址', PRIMARY KEY (`qyid`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of quyu -- ---------------------------- INSERT INTO `quyu` VALUES ('1', 'A区', '海科路'); INSERT INTO `quyu` VALUES ('2', 'B区', '北京路'); INSERT INTO `quyu` VALUES ('3', 'C区', '河路002'); -- ---------------------------- -- Table structure for qy