主要内容通常应该包括以下几部分:
1、项目概述
1.1、说明:对于目前疫情的情况进行精确的分析,并且能够对国内疫情的现状进行实时监测,使得显示的数据能够让甲方清除的了解疫情状况。
1.2、需要用的工具有Hbuilder,ideal,mysql,jdk,通过这些工具设计网页和数据,展示出完整的疫情实时大数据。
2、系统设计
2.1、mysql和navicat软件的安装,创建全国疫情情况表;ideal和jdk安装和环境变量的控制。
2.2、SSM环境搭建
创建数据库(使用navicate写关于疫情中国城市的疫情分布人数情况)
可以借鉴:()
/*
NavicatMySQLDataTransfer
SourceServer:yiqing
SourceServerVersion:
SourceHost:localhost:
SourceDatabase:yiqing
TargetServerType:MYSQL
TargetServerVersion:
FileEncoding:
Date:-01-:07:04
*/
SETFOREIGN_KEY_CHECKS=0;
------------------------------
--Tablestructureforpatient
------------------------------
DROPTABLEIFEXISTS`patient`;
CREATETABLE`patient`(
`id`int(11)NOTNULL,
`country`varchar()DEFAULTNULL,
`province`varchar()DEFAULTNULL,
`patient_name`varchar()DEFAULTNULL,
`patient_type`varchar()DEFAULTNULL,
`patient_state`varchar()DEFAULTNULL,
`create_datetime`datetimeDEFAULTNULL,
`suretime`datetimeDEFAULTNULL,
`hardtime`datetimeDEFAULTNULL,
`curetime`datetimeDEFAULTNULL,
`dietime`datetimeDEFAULTNULL,
PRIMARYKEY(`id`)
)ENGINE=InnoDBDEFAULTCHARSET=utf8;
------------------------------
--Recordsofpatient
------------------------------
INSERTINTO`patient`VALUES(1,中国,安徽省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(2,中国,安徽省,李四,2,3,-01-:00:00,-01-:24:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(3,中国,安徽省,王五,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(4,中国,安徽省,赵六,2,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(5,中国,安徽省,花花,2,4,-01-:00:00,-01-:00:00,-02-:00:00,null,-02-:00:00);
INSERTINTO`patient`VALUES(6,中国,安徽省,丽丽,2,4,-01-:00:00,-01-:00:00,-02-:00:00,null,-02-:00:00);
INSERTINTO`patient`VALUES(7,中国,贵州省,赵华,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(8,中国,安徽省,钱琪,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(9,中国,安徽省,孙八,2,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(10,中国,安徽省,李雷,1,4,-02-:00:00,-02-:00:00,null,null,-02-:00:00);
INSERTINTO`patient`VALUES(11,中国,山西省,小明,2,4,-02-:00:00,-02-:00:00,null,null,-02-:00:00);
INSERTINTO`patient`VALUES(12,中国,河北省,李九,1,3,-02-:00:00,-03-:00:00,null,null,null);
INSERTINTO`patient`VALUES(13,中国,河北省,张秦1,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(14,中国,吉林省,李验,2,3,-01-:00:00,-01-:24:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(15,中国,河北省,张三一,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(16,中国,吉林省,李四一,2,3,-01-:00:00,-01-:24:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(17,中国,江苏省,王五一,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(18,中国,贵州省,赵六一,2,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(19,中国,福建省,花花一,2,4,-01-:00:00,-01-:00:00,-02-:00:00,null,-02-:00:00);
INSERTINTO`patient`VALUES(20,中国,安徽省,丽丽一,2,4,-01-:00:00,-01-:00:00,-02-:00:00,null,-02-:00:00);
INSERTINTO`patient`VALUES(21,中国,江西省,赵华一,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(22,中国,山东省,钱琪一,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(23,中国,河南省,孙八好,2,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(24,中国,湖北省,李雷一,1,4,-02-:00:00,-02-:00:00,null,null,-02-:00:00);
INSERTINTO`patient`VALUES(25,中国,湖南省,小明一,2,4,-02-:00:00,-02-:00:00,null,null,-02-:00:00);
INSERTINTO`patient`VALUES(26,中国,广东省,李九一,1,3,-02-:00:00,-03-:00:00,null,null,null);
INSERTINTO`patient`VALUES(27,中国,海南省,钱琪一,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(28,中国,安徽省,孙八一,2,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(29,中国,四川省,李雷与,1,4,-02-:00:00,-02-:00:00,null,null,-02-:00:00);
INSERTINTO`patient`VALUES(30,中国,吉林省,小明考,2,4,-02-:00:00,-02-:00:00,null,null,-02-:00:00);
INSERTINTO`patient`VALUES(31,中国,河北省,李九就,1,3,-02-:00:00,-03-:00:00,null,null,null);
INSERTINTO`patient`VALUES(32,中国,台湾省,小明孔,2,4,-02-:00:00,-02-:00:00,null,null,-02-:00:00);
INSERTINTO`patient`VALUES(33,中国,青海省,小明华,2,4,-02-:00:00,-02-:00:00,null,null,-02-:00:00);
INSERTINTO`patient`VALUES(34,中国,甘肃省,李四5,2,3,-01-:00:00,-01-:24:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(35,中国,陕西省,王五5,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(36,中国,河南省,赵六5,2,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(37,中国,江苏省,花花5,2,4,-01-:00:00,-01-:00:00,-02-:00:00,null,-02-:00:00);
INSERTINTO`patient`VALUES(38,中国,江西省,丽丽5,2,4,-01-:00:00,-01-:00:00,-02-:00:00,null,-02-:00:00);
INSERTINTO`patient`VALUES(39,中国,山东省,赵华5,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(40,中国,湖南省,钱琪5,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(41,中国,海南省,孙八5,2,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(42,中国,湖北省,李雷5,1,4,-02-:00:00,-02-:00:00,null,null,-02-:00:00);
INSERTINTO`patient`VALUES(43,中国,云南省,小明5,2,4,-02-:00:00,-02-:00:00,null,null,-02-:00:00);
INSERTINTO`patient`VALUES(44,中国,河北省,李九5,1,3,-02-:00:00,-03-:00:00,null,null,null);
INSERTINTO`patient`VALUES(45,中国,香港,张三9,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(46,中国,甘肃省,李四9,2,3,-01-:00:00,-01-:24:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(47,中国,陕西省,王五9,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(48,中国,河南省,赵六9,2,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(49,中国,上海市,花花9,2,4,-01-:00:00,-01-:00:00,-02-:00:00,null,-02-:00:00);
INSERTINTO`patient`VALUES(50,中国,江西省,丽丽9,2,4,-01-:00:00,-01-:00:00,-02-:00:00,null,-02-:00:00);
INSERTINTO`patient`VALUES(51,中国,山东省,赵华9,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(52,中国,台湾,钱琪9,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(53,中国,海南省,孙八9,2,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(54,中国,广西省,杨英才1,2,5,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(55,中国,安徽省,杨英才2,2,7,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(56,中国,云南省,杨英才3,2,6,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(57,中国,重庆省,杨英才4,2,9,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(58,中国,四川省,杨英才5,2,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(59,中国,新疆省,杨英才6,2,2,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(60,中国,贵州省,杨英才7,2,5,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(61,中国,北京省,杨英才8,2,9,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(62,中国,石家庄省,杨英才9,2,6,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(63,中国,河南省,杨英才10,2,4,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(64,中国,湖南省,杨英才11,2,1,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(65,中国,湖北省,杨英才12,2,2,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(66,中国,山西省,杨英才13,2,6,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(67,中国,太原省,杨英才14,2,0,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(68,中国,山东省,杨英才15,2,6,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(69,中国,贵州省,杨英才16,2,2,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(70,中国,江西省,杨英才17,2,7,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(71,中国,黑龙江省,杨英才18,2,8,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(72,中国,呼和浩特省,杨英才19,2,0,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(73,中国,江苏省,杨英才20,2,6,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(74,中国,北京市,光南,2,3,-01-:00:00,-01-:24:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(75,中国,江西省,丁汉白,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(76,中国,江西省,纪珍珠,2,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(77,中国,安徽省,萧驰野,2,4,-01-:00:00,-01-:00:00,-02-:00:00,null,-02-:00:00);
INSERTINTO`patient`VALUES(78,中国,安徽省,沈兰州,2,4,-01-:00:00,-01-:00:00,-02-:00:00,null,-02-:00:00);
INSERTINTO`patient`VALUES(79,中国,贵州省,贺朝,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(80,中国,安徽省,谢俞,1,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(81,中国,重庆市,王权富贵,2,3,-01-:00:00,-01-:00:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(82,中国,四川省,东方月初,1,4,-02-:00:00,-02-:00:00,null,null,-02-:00:00);
INSERTINTO`patient`VALUES(83,中国,安徽省,张三93,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(84,中国,重庆省,张三94,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(85,中国,新疆省,张三95,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(86,中国,贵州省,张三96,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(87,中国,河北省,张三97,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(88,中国,河南省,张三98,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(89,中国,山东省,张三99,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(90,中国,山西省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(91,中国,广西省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(92,中国,广东省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(93,中国,山西省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(94,中国,陕西省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(95,中国,吉林省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(96,中国,辽宁省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(97,中国,安徽省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(98,中国,重庆省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(99,中国,四川省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(,中国,内蒙古省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(,中国,黑龙江省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
INSERTINTO`patient`VALUES(,中国,浙江省,张三,1,3,-01-:00:00,-01-:03:00,null,-02-:00:00,null);
2.查看数据库版本
1.安装tomcat(自行在网上官方网站下载)
2.创建web项目(ideal开发软件)
1.SSM环境搭建的方式:
a)springBoot快速易用
b)SSM手动搭建
1.spring+mybatis环境
2.测试mybatis
自行写一个测试类简单代码
3、项目运行
4、源码展示
UserController(控制器代码):
package