V6.109 edit by lijun @ 2025-01-15 1.设备遥调遥控需要先绑定设备Ukey上的UkeyID[可通过网页工具，或者...

DELL

2025-01-14 2c735cefd694ddbadfd7456f5ad27e0e242efb11

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
Êþº¾4
:
(com/dec/fbs9100/BTS61850_Task_Thread_SQL
java/lang/Object
<init>
()V
Code
    
LineNumberTable
LocalVariableTable
this
*Lcom/dec/fbs9100/BTS61850_Task_Thread_SQL;
checkHistoryIfNotExistsTable
#(Lcom/dec/fbs9100/MysqlConnPool;I)Z
com/dec/fbs9100/Sql_Mysql

"(Lcom/dec/fbs9100/MysqlConnPool;)V
`db_batt_history`

 sqlMysqlUseDB
(Ljava/lang/String;)V
java/lang/StringBuilder
#`db_batt_history`.tb_batt_realdata_
 
"#$
append
(I)Ljava/lang/StringBuilder;&

_
(#)
-(Ljava/lang/String;)Ljava/lang/StringBuilder;+
java/util/Date
*    .
yyyy_MM
021
com/base/Com34
getDateTimeFormat
6(Ljava/util/Date;Ljava/lang/String;)Ljava/lang/String;
678
toString
()Ljava/lang/String;
:;<
sqlMysqlCheckIfTableExist
(Ljava/lang/String;)Z
>?
    close_con    ABC
logger
&Lorg/apache/logging/log4j/core/Logger;E
checkHistoryIfNotExistsTable():
G6H
java/sql/SQLException
JLK
$org/apache/logging/log4j/core/LoggerMN
error
*(Ljava/lang/String;Ljava/lang/Throwable;)V
    conn_pool
Lcom/dec/fbs9100/MysqlConnPool;
BattGroupId

I
sql
Lcom/dec/fbs9100/Sql_Mysql;
tname
Ljava/lang/String;

e
Ljava/sql/SQLException;
 StackMapTable[
com/dec/fbs9100/MysqlConnPool]
java/lang/Throwable
CreateTb_BattRealDataTable
3(Lcom/dec/fbs9100/MysqlConnPool;ILjava/util/Date;)Va
>CREATE TABLE IF NOT EXISTS `db_batt_history`.tb_batt_realdata_c
 (e
+  `num` bigint(20) NOT NULL AUTO_INCREMENT,g
-  `BattGroupId` int(11) NOT NULL DEFAULT '1',i
@  `recrod_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',k
)  `group_vol` float NOT NULL DEFAULT '0',m
*  `online_vol` float NOT NULL DEFAULT '0',o
*  `group_curr` float NOT NULL DEFAULT '0',q
)  `group_tmp` float NOT NULL DEFAULT '0',s
,  `batt_state` int(11) NOT NULL DEFAULT '0',u
0  `batt_test_type` int(11) NOT NULL DEFAULT '0',w
H  `batt_test_starttime` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',y
1  `batt_test_tlong` int(11) NOT NULL DEFAULT '0',{
-  `batt_test_cap` float NOT NULL DEFAULT '0',}
)  `mon_num` int(11) NOT NULL DEFAULT '1',
'  `mon_vol` float NOT NULL DEFAULT '0',
'  `mon_tmp` float NOT NULL DEFAULT '0',ƒ
'  `mon_res` float NOT NULL DEFAULT '0',…
'  `mon_ser` float NOT NULL DEFAULT '0',‡
,  `mon_conn_res` float NOT NULL DEFAULT '0',‰
'  `mon_cap` float NOT NULL DEFAULT '0',‹
+  `mon_JH_curr` float NOT NULL DEFAULT '0',
*  `note` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`num`),‘
6  KEY `index_battgroupid` (`BattGroupId`) USING BTREE,“
5  KEY `index_record_time` (`recrod_time`) USING BTREE•
6) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
—˜
sqlMysqlExecuteš
CreateTb_BattRealDataTable():
pool
time
Ljava/util/Date;
sql_str 
java/lang/String
deleteHistoryData
2(Lcom/dec/fbs9100/MysqlConnPool;Ljava/util/Date;)V¤
¤ select TABLE_NAME,UPDATE_TIME  from information_schema.tables  where table_schema='db_batt_history'  AND TABLE_NAME like 'tb_batt_realdata_%'  AND CREATE_TIME <= '¦
yyyy-MM-dd HH:mm:ss¨
';ª
 DROP TABLE IF EXISTS 
¬­®
sqlMysqlTotalQuery
((Ljava/lang/String;)Ljava/sql/ResultSet;
Ÿ°±²
valueOf
&(Ljava/lang/Object;)Ljava/lang/String;´

,¶
db_batt_history.¸

TABLE_NAMEº¼»
java/sql/ResultSet½¾
    getString
&(Ljava/lang/String;)Ljava/lang/String;À
    åˆ é™¤ï¼šÂ
     at 
JÄÅ
warnºÇÈÉ
next
()Z
ËÌ
sqlMysqlTotalExecuteÎ
deleteHistoryData():ºÐÑ
close
deldate
sql_select_strs
sql_delete_strs
res
Ljava/sql/ResultSet;
count
UpdateBattInfTable
H(Lcom/dec/fbs9100/MysqlConnPool;Lcom/dec/fbs9100/FBS9100_StatAndParam;)VÛ
4 UPDATE `db_battinf`.`tb_battinf` SET PublicKeyX = '    ÝßÞ
$com/dec/fbs9100/FBS9100_StatAndParamàV

publicKeyXâ
',SerialNumber = '    ÝäåV
serialNumberç

'é
 WHERE FBSDeviceId =     ÝëìR
dev_idî
.BTS61850_Task_Thread_SQL.UpdateBattInfTable():

m_ConnPool
param
&Lcom/dec/fbs9100/FBS9100_StatAndParam;
updateBattRtState_Table
`(Lcom/dec/fbs9100/MysqlConnPool;Lcom/dec/fbs9100/FBS9100_VCData;[Lcom/battdata_rt/BattData_RT;)Võ
9 UPDATE `db_ram_db`.`tb_batt_rsalarm` SET record_time = '÷
,groupvol_alm =     ùûú
com/dec/fbs9100/FBS9100_VCDataüý
groupvolalm
[Z
ÿ#

(Z)Ljava/lang/StringBuilder;

,test_end_cap=    ù



test_end_cap
[D

#
    
(D)Ljava/lang/StringBuilder;

,test_end_vol=    ù
 


test_end_vol

,test_timelong=     ù



 test_timelong

 WHERE BattGroupId =     



com/battdata_rt/BattData_RTQR

3BTS61850_Task_Thread_SQL.updateBattRtState_Table():
vc_data
 Lcom/dec/fbs9100/FBS9100_VCData;
battdata
[Lcom/battdata_rt/BattData_RT;

i

queryDeviceUkeyID
4(Lcom/dec/fbs9100/MysqlConnPool;I)Ljava/lang/String;
%

'
@SELECT KeyID FROM `db_battinf`.`tb_battinf` WHERE FBSDeviceId = 
)
 LIMIT 1

+
,®
 sqlMysqlQuery
.
KeyID
Ÿ
0
18
trim
G
3
4
printStackTrace
6
-BTS61850_Task_Thread_SQL.queryDeviceUkeyID():
ukeyID

SourceFile
BTS61850_Task_Thread_SQL.java!


/

*·±

    
     

+s»Y*·M,¶»Y·¶!%¶'»*Y·,-¸/¶'¶5N,-¶96,¶=¬:,´@»YD·¶F¶'¶5¶I,¶=§:,¶=¿¬    ;BG    ;hBah
6     4;?BDahjnq4sOPsQR
    jST4UVDWXYÿBZ

Ge\    ^_
 ì»Y`·¶!%¶',-¸/¶'b¶'d¶'f¶'h¶'j¶'l¶'n¶'p¶'r¶'t¶'v¶'x¶'z¶'|¶'~¶'€¶'‚¶'„¶'†¶'ˆ¶'Š¶'Œ¶'Ž¶'¶'’¶'”¶'¶5N»Y*·:-¶–§5:´@»Y™·¶F¶'¶5¶I¶=§:¶=¿¶=±«±´G«ÔÜ
–%( )%**+/,4-9.>/C0H1M2R3W4\5a6f7k8p9u:z;<„=‰>Ž?“@˜A(¡B«D±E¶FÔHÜGÞHãIæHëJ>ì›PìQR
윝¡KžV«AST¶WXYÿ´Z
*Ÿ
Gg\        ¡¢
A

†»Y£·+¥¸/¶'§¶'¶5M©N»Y*·:
:6,¶«:§sž»Y-¸¯·³¶'¶5N»Y-¸¯·µ¶'·¹¹¶'¶5N´@»Y¿··¹¹¶'Á¶'»*Y·,¥¸/¶'¶5¶Ã„
¹Æ
šÿ‰žœ-¶Ê§“:´@»YÍ·¶F¶'¶5¶IÆ-¹Ï
§#:    ´@»YÍ·    ¶F¶'¶5    ¶I¶=§p:Æ-¹Ï
§#:    ´@»YÍ·    ¶F¶'¶5    ¶I¶=¿Æ-¹Ï
§#:    ´@»YÍ·    ¶F¶'¶5    ¶I¶=±.¾ÁGæíðG.á


&
)G
V
]
`G
–%P    TPUV(W+X.Z6[9\>]R`ra¦b©[³d¸e¾hÃiákæmínòo
r
j
k
m
&n
+o
Ir
Ns
Qk
Vm
]n
bo
€r
…tp
†OP
†Ò

kÓV
hÔV(
^ST+
[ÕÖ.
X×RÃWXòWX    
+WX    
bWX    Yo ÿ9Z*ŸŸº
ûVWGnGG\ÿ    Z*ŸŸº
\
GÿZ*ŸŸº
NG    ØÙ

0v»YÚ·+´Ü¶'á¶'+´ã¶'æ¶'è¶'+´ê¶!¶5M»Y*·N-,¶–§2:-´@»Yí·¶F¶'¶5¶I-¶=§:-¶=¿-¶=±:?BG:ah
:|    }!~-|1€:‚?ƒD„a†h…j†n‡q†uˆ4vïPvðñ
1EžV:<STDWXYÿBZÝŸ
Ge\    òó

ÊÐ>§Ç,2ǧ»»Yô·»*Y·,¥¸/¶'æ¶'ö¶'+´ø3¶þ

¶'+´
1¶


¶'+´
1¶

¶'+´
1¶

¶',2´
¶!¶5:»Y*·:¶–§6:´@»Y
·¶F¶'¶5¶I¶=§:¶=¿¶=„
,¾¡ÿ9±„‹ŽG„¯·
Z‹Œ+‘9’H“W”f•uz–„˜‹™š¯œ·›¹œ¾ÁœÆ‹Ï HЛPÐ


Ð

Í
 RzLžV„BSTWXY*ü
ÿZù
!
Ÿ
Gh\    ù    
"
#
w    ü
$M»Y
&·¶!
(¶'¶5N»Y*·:
:-¶
*:¹Æ
™
-¹¹¶
/M§|:¶
2Æ.¹Ï
§$:´@»Y
5·¶F¶'¶5¶I¶=§r:Æ.¹Ï
§$:´@»Y
5·¶F¶'¶5¶I¶=¿Æ.¹Ï
§$:´@»Y
5·¶F¶'¶5¶I¶=,°)ILGX_bG)S‹’™œGÊÑÔG
n©ª«&¬)®1¯;°I²N³SµX·_¸d¹ƒ¼‹´µ’·™¸ž¹½¼Â½ÅµÊ·Ñ¸Ö¹õ¼ú¾f
üïPüìR
ø
7VàžV&ÖST)ÓÕÖNWXdWXžWXÖWXYa
ÿLZ
ŸŸº
GUG G\ÿZ
ŸŸº\
G ÿZ
ŸŸºNG 

8
9