程序代写代做 android ER Java 1. 4

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