1. 4
1.1 4
1.2 4
2. 4
2.1 5
2.2 5
2.3 6
6
6
3. 7
3.1 7
3.1.1 7
3.1.2 8
3.1.3 12
3.1.4 13
3.2 ER 1
3.3 1
3.3.1 1
3.3.2 2
3.3.3 2
3.4 2
3.4.1 2
3.4.2 2
3.4.3 2
3.4.4 2
3.5 3
3.5.1 3
3.5.2 3
3.5.3 3
3.5.4 3
3.5.5 3
3.5.6 4
3.6 4
4. 4
4.1 4
4.1.1 4
4.1.2 4
4.1.3 5
4.1.4 5
4.2 5
4.3 5
4.3.1 5
4.3.2 5
4.3.3 5
4.3.4 5
4.4 6
4.4.1 6
4.4.2 6
4.4.3 6
4.4.4 6
4.5 6
4.5.1 6
4.5.2 6
4.5.3 7
4.5.4 7
4.5.5 7
4.5.6 7
4.6 7
1.
1.377.82
1.1
1.2
WebAPP
2.
WebWeb21
21
androidJava
Java EETomcat
MySQL
2.1
2.2
13
13
4
22
22
2121
21
13
4
13
2.3
IntelAMDCPU 2.0G4.0G1000M800G
Windows Server 2010TomcatMySQL
Web
IE11 Windows 2010
androidiosGPS
Android5.0ios10
3.Web
3.1
Web31
31
3.2
1
2
Web32
32
3
3.3
3334
33
34
1
IPID35
2
36
3
4
37
35
Fig. 35 Video search activity diagram
36
Fig. 36 Online video playing activity diagram
37
Fig. 37 Video batch deletion activity diagram
5
IPID
6
7
8
3.4
38
Fig. 38 Alarm record management use case diagram
38
AppAppIDID
3
4
3.5
39
39
Fig. 39 Alarm data statistics activity diagram
3.6
AppAppGPSidGPSGPSGPS
3.7
39
8
3.2 ER
MySQL
1
ID51
31
Tab. 31 User Table
userID
Int
ID
userName
Varchar
userPwd
Varchar
userRight
Int
userMail
Varchar
userPhone
Varchar
userDept
Varchar
empTime
Varchar
2
3233
3POI
POIpoint of interestPOIIDPOI34
32
Tab. 32 Video Table
vidID
Int
ID
vidName
Varchar
vidStartTime
Datetime
vidUrl
Varchar
vidSkchImgUrl
Varchar
vidType
Int
mptID
Int
ID
staffID
Int
ID
53
Tab. 53 Picture Table
imgID
Int
ID
imgName
Varchar
imgRes
Varchar
imgSktUrl
Varchar
imgUrl
Varchar
imgType
Int
createTime
Datetime
mptID
Int
ID
staffID
Int
ID
34 POI
Tab.34 POI Table
poiID
Int
POIID
poiPixX
Int
POI
poiPixY
Int
POI
poiType
Int
POI
rotID
Int
ID
4
IPPOI35
35
Tab. 35 Monitor Table
mptID
Int
ID
mptName
Varchar
mptIP
Varchar
IP
height
Double
poiID
Int
POI
5
ID36
36
Tab. 36 AlarmRecord Table
almRecID
Int
ID
almTime
Datetime
optLocX
Double
optLocY
Double
isHandled
Int
mptID
Int
ID
rotAngle
Double
staffID
Int
ID
3.3
3.3.1
WebAndroid
3.3.2
3.3.3
3.4
3.4.1
5
10
3.4.2
5090
3.4.3
724
3.4.4
10
3.5
3.5.1
3.5.2
3.5.3
3.5.4
3.5.5
3.5.6
3.6
1
Web
2
3
4.
4.1
4.1.1
AppApp
4.1.2
4.1.3
4.1.4
4.2
App