添加空气温度告警，空气湿度告警，烟感告警列

whyclj

2019-06-24 66db8d445a53a8ed8410f7196f5c65de7a29bce7

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
Êþº¾4
‚
com/dev/btse/data/TmpSensor_SQL
java/lang/Object
<init>
()V
Code
    
LineNumberTable
LocalVariableTable
this
!Lcom/dev/btse/data/TmpSensor_SQL;
createRealDataBase
&(Lcom/battmonitor/sql/MysqlConnPool;)V
com/battmonitor/sql/Sql_Mysql

!com/battmonitor/sql/MysqlConnPool
getConn
()Ljava/sql/Connection;

(Ljava/sql/Connection;)V
)CREATE DATABASE IF NOT EXISTS `db_sensor`
 
sqlMysqlExecute
(Ljava/lang/String;)V
"$#
java/sql/SQLException%
printStackTrace
    conn_pool
#Lcom/battmonitor/sql/MysqlConnPool;
sql
Lcom/battmonitor/sql/Sql_Mysql;

e
Ljava/sql/SQLException;
 StackMapTable
createHisDataBase/
1CREATE DATABASE IF NOT EXISTS `db_sensor_history`
createSensor_infTable2
ÉCREATE TABLE IF NOT EXISTS `db_sensor`.`tb_sensor_inf` (  `num` bigint(20) NOT NULL AUTO_INCREMENT,  `province` varchar(255) NOT NULL COMMENT '省' DEFAULT '',  `city` varchar(255) NOT NULL COMMENT '市' DEFAULT '',  `county` varchar(255) NOT NULL COMMENT '区/县' DEFAULT '',  `sensor_dev_id` int(11) NOT NULL DEFAULT '0' COMMENT '设备id',  `device_name` varchar(255) NOT NULL COMMENT '设备名称' DEFAULT '',  `note` varchar(255) NOT NULL DEFAULT '',  `airtmp_alarm` float NOT NULL DEFAULT '52.5',  `airhum_alarm` float NOT NULL DEFAULT '40.8',  `smoke_alarm` int(11) NOT NULL DEFAULT '8000',  PRIMARY KEY (`num`),  KEY `int_sensor_dev_id` (`sensor_dev_id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8;4
…SELECT * FROM information_schema.columns WHERE table_schema='db_sensor' AND table_name='tb_sensor_inf' AND column_name='airtmp_alarm'
678
 sqlMysqlQuery
((Ljava/lang/String;)Ljava/sql/ResultSet;:<;
java/sql/ResultSet=>
next
()Z@
`ALTER TABLE `db_sensor`.`tb_sensor_inf` ADD COLUMN `airtmp_alarm` float NOT NULL DEFAULT '52.5';B
…SELECT * FROM information_schema.columns WHERE table_schema='db_sensor' AND table_name='tb_sensor_inf' AND column_name='airhum_alarm'D
`ALTER TABLE `db_sensor`.`tb_sensor_inf` ADD COLUMN `airhum_alarm` float NOT NULL DEFAULT '40.8';F
„SELECT * FROM information_schema.columns WHERE table_schema='db_sensor' AND table_name='tb_sensor_inf' AND column_name='smoke_alarm'H
aALTER TABLE `db_sensor`.`tb_sensor_inf` ADD COLUMN `smoke_alarm` int(11) NOT NULL DEFAULT '8000';
JK
    close_con
sql_str
Ljava/lang/String;
res
Ljava/sql/ResultSet;Q
java/lang/StringS
java/lang/Throwable
createSensor_mapinfoTableV

»CREATE TABLE IF NOT EXISTS `db_sensor`.`tb_sensor_mapinfo` (  `num` bigint(20) NOT NULL AUTO_INCREMENT,  `sensor_dev_id` int(11) NOT NULL DEFAULT '',  `longitude` double NOT NULL DEFAULT '0',  `latitude` double NOT NULL DEFAULT '0',  `address` varchar(255) NOT NULL DEFAULT '',  `note` varchar(255) NOT NULL DEFAULT '',  PRIMARY KEY (`num`),  UNIQUE KEY `unique_sensor_dev_id` (`sensor_dev_id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8;
createSensor_StateTableY
%CREATE TABLE IF NOT EXISTS `db_sensor`.`tb_sensor_state` (  `num` bigint(20) NOT NULL AUTO_INCREMENT,  `sensor_dev_id` int(11) NOT NULL COMMENT '设备id',  `record_time` datetime NOT NULL COMMENT '记录时间',  `airtmp` float NOT NULL COMMENT '空气温度',  `airhum` float NOT NULL COMMENT '空气湿度',  `smoke` int(11) NOT NULL COMMENT '烟感',  `water` int(11) NOT NULL,  `lightintensity` int(11) NOT NULL,  `CO2concentration` int(11) NOT NULL,  `COconcentration` int(11) NOT NULL,  `CH4concentration` int(11) NOT NULL,  `O2concentration` int(11) NOT NULL,  `dev_commcount` int(11) NOT NULL,  `dev_errcommcount` int(11) NOT NULL,  `note` varchar(255) NOT NULL DEFAULT '',  PRIMARY KEY (`num`),  UNIQUE KEY `index_sensor_dev_id` (`sensor_dev_id`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8;
queryTmpSensorById
G(Lcom/battmonitor/sql/MysqlConnPool;I)Lcom/dev/btse/data/TmpSensor_inf;]
java/lang/StringBuilder_
<SELECT * FROM db_sensor.tb_sensor_inf WHERE sensor_dev_id = 
\a 
\cde
append
(I)Ljava/lang/StringBuilder;
\ghi
toString
()Ljava/lang/String;k
com/dev/btse/data/TmpSensor_inf
j    n
city:pqr
    getString
&(Ljava/lang/String;)Ljava/lang/String;
jtu 
setCityw
province
jyz 
setProvince|
county
j~ 
    setCounty
device_name
jƒ„ 
setDevice_name†
 sensor_dev_id:ˆ‰Š
getInt
(Ljava/lang/String;)I
jŒŽ
setSensor_dev_id
(I)V

I
sensor
!Lcom/dev/btse/data/TmpSensor_inf;
insertOrUpdateTmpSensorState
H(Lcom/battmonitor/sql/MysqlConnPool;Lcom/dev/btse/data/TmpSensorState;)V•
2`db_sensor`.`tb_sensor_state` SET sensor_dev_id =     —™˜
 com/dev/btse/data/TmpSensorState†›

,
\dž
-(Ljava/lang/String;)Ljava/lang/StringBuilder; 
 record_time = '¢
java/util/Date
¡    ¥
yyyy-MM-dd HH:mm:ss
§©¨
com/battmonitor/base/Comª«
getDateTimeFormat
6(Ljava/util/Date;Ljava/lang/String;)Ljava/lang/String;­
',¯

 airtmp = 
—±²³
    getAirtmp
()F
\µd¶
(F)Ljava/lang/StringBuilder;¸

 airhum = 
—º»³
    getAirhum½
     smoke = 
—¿ÀÁ
getSmoke
()IÃ
     water = 
—ÅÆÁ
getWaterÈ
 lightintensity = 
—ÊËÁ
getLightintensityÍ
 CO2concentration = 
—ÏÐÁ
getCO2concentrationÒ
 COconcentration = 
—ÔÕÁ
getCOconcentration×
 CH4concentration = 
—ÙÚÁ
getCH4concentrationÜ
 O2concentration = 
—Þß³
getO2concentrationá
 dev_commcount = 
—ãäÁ
getDev_commcountæ
 dev_errcommcount = 
—èéÁ
getDev_errcommcountë
 REPLACE INTO 
state
"Lcom/dev/btse/data/TmpSensorState;
sql_str_replace
queryAllTmpSensor
5(Lcom/battmonitor/sql/MysqlConnPool;)Ljava/util/List;
    Signature
X(Lcom/battmonitor/sql/MysqlConnPool;)Ljava/util/List<Lcom/dev/btse/data/TmpSensor_inf;>;ô
( SELECT *  FROM db_sensor.tb_sensor_inf ö
java/util/ArrayList
õ    ùûú
java/util/Listüý
add
(Ljava/lang/Object;)Z
pool
tmpinf
Ljava/util/List;
tmp
LocalVariableTypeTable
3Ljava/util/List<Lcom/dev/btse/data/TmpSensor_inf;>;
queryTmpSensorState
H(Lcom/battmonitor/sql/MysqlConnPool;I)Lcom/dev/btse/data/TmpSensorState;

CSELECT *  FROM `db_sensor`.`tb_sensor_state` WHERE sensor_dev_id = 
—    
—Œ

airhum:
 


getFloat
(Ljava/lang/String;)F
—



    setAirhum
(F)V

airtmp
—



    setAirtmp

smoke
—

Ž
setSmoke

water
—
!
"Ž
setWater
$
lightintensity
—
&
'Ž
setLightintensity
)
cO2concentration
—
+
,Ž
setCO2concentration
.
cH4concentration
—
0
1Ž
setCH4concentration
3
cOconcentration
—
5
6Ž
setCOconcentration
8
o2concentration
—
:
;

setO2concentration
=
record_time:
?
@
A
getTimestamp
((Ljava/lang/String;)Ljava/sql/Timestamp;
—
C
D
E
setRecord_time
(Ljava/util/Date;)V
createTmpSensorHistoryDataTable
'(Lcom/battmonitor/sql/MysqlConnPool;I)V
I
CCREATE TABLE IF NOT EXISTS  `db_sensor_history`.`tb_sensor_hisdata_
K
` (
M
+  `num` bigint(20) NOT NULL AUTO_INCREMENT,
O
B  `sensor_dev_id` int(11) NOT NULL DEFAULT '1' COMMENT '设备id',
Q
@  `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
S
=  `airtmp` float NOT NULL DEFAULT '0' COMMENT '空气温度',
U
=  `airhum` float NOT NULL DEFAULT '0' COMMENT '空气湿度',
W
:  `smoke` int(11) NOT NULL DEFAULT '100' COMMENT '烟感',
Y
8  `water` int(11) NOT NULL DEFAULT '0' COMMENT '水浸',
[
G  `lightintensity` int(11) NOT NULL DEFAULT '0' COMMENT '光照强度',
]
F  `CO2concentration` int(11) NOT NULL DEFAULT '0' COMMENT 'CO2浓度',
_
1  `COconcentration` int(11) NOT NULL DEFAULT '0',
a
2  `CH4concentration` int(11) NOT NULL DEFAULT '0',
c
1  `O2concentration` int(11) NOT NULL DEFAULT '0',
e
.  `note` varchar(255) DEFAULT NULL DEFAULT '',
g
  PRIMARY KEY (`num`),
i
9  KEY `index_sensor_dev_id` (`sensor_dev_id`) USING BTREE
k
%) ENGINE=InnoDB DEFAULT CHARSET=utf8;
saveSensorHistoryData
n
3INSERT INTO `db_sensor_history`.`tb_sensor_hisdata_
p

`
r
†(sensor_dev_id,record_time,airtmp,airhum,smoke,water,lightintensity,CO2concentration,COconcentration,CH4concentration,O2concentration)
t
     VALUES (
—
v
wÁ
getSensor_dev_id
y
, '
{
', 
}
, 

);

SourceFile
TmpSensor_SQL.java!


/

*·±

 
     
Š»Y*¶·L+¶§M,¶!±
"
 &'()
*+,ÿ
"    -
Š»Y*¶·L+.¶§M,¶!±
"
  &'()
*+,ÿ
"    0

Os1L»Y*¶·M,+¶,3¶5N-¹9
š    ,?¶,A¶5N-¹9
š    ,C¶,E¶5N-¹9
š!,G¶§N-¶!,¶I§:,¶I¿,¶I±VY"^e
R'68:>$?*C1G:H@LGPPQVTZU^WeVgWkXnWrY4s&'pLM
d();NOZ*+,(þ*P:ÿP
"KR    T
Ò1UL»Y*¶·M,+¶§N-¶!,¶I§:,¶I¿,¶I±"#
.`jlmnp#o%p)q,p0r*1&'.LM
"()*+,ÿP
"KR    W
Ò1XL»Y*¶·M,+¶§N-¶!,¶I§:,¶I¿,¶I±"#
.yŒŽ’#‘%’)“,’0”*1&'.LM
"()*+,ÿP
"KR    Z[

ž
M»\Y^·`¶b¶fN»Y*¶·:-¶5:¹9
™h»jY·lM,m¹o¶s,v¹o¶x,{¹o¶},€¹o¶‚,…¹‡¶‹§:¶!¶I§:¶I¿¶I,° {~" …
NžŸ ¡(¢2£:¤G¥T¦a§n¨{ª€«…­¬­”®—­œ¯Hž&'ž†
œ‘‹LM ~()(SNO€*+,ÿ~
jP
"NR        ’“
%
.»\Y”·`+´–¶bš¶œŸ¶œ»¡Y·£¤¸¦¶œ¬¶œ®¶œ+¶°¶´š¶œ·¶œ+¶¹¶´š¶œ¼¶œ+¶¾¶bš¶œ¶œ+¶Ä¶bš¶œǶœ+¶É¶bš¶œ̶œ+¶Î¶bš¶œѶœ+¶Ó¶bš¶œÖ¶œ+¶Ø¶bš¶œÛ¶œ+¶Ý¶´š¶œග+¶â¶bš¶œ嶜+¶ç¶b¶fM»\Yê·`,¶œ¶fN»Y*¶·:-¶§:¶!¶I§:¶I¿¶I±


"



j¸    ¹º.»?¼P½a¾r¿ƒÀ”Á¥Â¶ÃÇÄØÅä¸èÆùÇ
É
Ê
Ë
Í
Ì
 Í
%Î
(Í
-Ï>
.&'
.ìí
èFLMù5îM
(()
*+,!ÿ
—PP
"NR        ïðñò
ª£óL»õY·÷M»Y*¶·N-+¶5:§[»jY·l:m¹o¶s{¹o¶}€¹o¶‚v¹o¶x…¹‡¶‹,¹øW¹9
šÿ¡§:¶!-¶I§:-¶I¿-¶I,°ƒ†"”
Z×ÖÙÚÛÝ!Þ*ß8àFáTâbãpåy݃çˆèê”é–êšëê¡ìH£þ' LM
˜ÿ
Œ()…NO*O

‘ˆ*+

˜ÿ
,%ÿ!Pù:ûWL"MR    



ý÷
M»\Y
·`¶b¶fN»Y*¶·:-¶5:¹9
™À»—Y·
M,…¹‡¶
    ,

¹
¶
,
¹
¶
,
¹‡¶
,
¹‡¶
 ,
#¹‡¶
%,
(¹‡¶
*,
-¹‡¶
/,
2¹‡¶
4,
7¹
¶
9,
<¹
>¶
B§:¶!¶I§:¶I¿¶I,°)Ô×")Þæ
nñòôòõ!ö)ø3ù;úHûVüdýrþ€ÿŽ
œ

ª
¸
Æ
Ô
Ù
Þ
    æ
è
    í

ð
    õ
H÷þ'÷†
õìíãLM!Ö())ÎNOÙ*+,"ÿ×
—P:
"NR        
F
G

˜¨»\Y
H·`¶b
J¶œ
L¶œ
N¶œ
P¶œ
R¶œ
T¶œ
V¶œ
X¶œ
Z¶œ
\¶œ
^¶œ
`¶œ
b¶œ
d¶œ
f¶œ
h¶œ
j¶œ¶fM»Y*¶·N-,¶§:¶!-¶I§:-¶I¿-¶I±„‰Œ"„“š
r


 
&
,
2
8
>
D
J
P
V
 \
!b
"h
#n
$t
x
%„
'‰
(Ž
)“
+š
*œ
+ 
,£
+§
.4¨þ'¨†
x0LM„$()Ž*+,ÿŒ
P
"MR    
l“

Õë»\Y
m·`+´–¶b
o¶œ
q¶œ
s¶œ+¶
u¶b
x¶œ»¡Y·£¤¸¦¶œ
z¶œ+¶°¶´š¶œ+¶¹¶´
|¶œ+¶¾¶bš¶œ+¶Ä¶b
|¶œ+¶É¶b
|¶œ+¶Î¶b
|¶œ+¶Ó¶bš¶œ+¶Ø¶b
|¶œ+¶Ý¶´
~¶œ¶fM»Y*¶·N-,¶§:¶!-¶I§:-¶I¿-¶I±ÇÌÏ"ÇÖÝ
j
6
7
8#
90
:E
;Q
<^
=j
>w
?„
@‘
A
Bª
C±
D·
6»
EÇ
GÌ
HÑ
IÖ
KÝ
Jß
Kã
Læ
Kê
M4ëþ'ëìí
»0LMÇ$()Ñ*+,ÿÏ—P
"MR

€
