修改版本号

DELL

4 天以前 49b6a24edf112017776de237a5ec89a1c0683f1f

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
Êþº¾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â
',KeyID = '    ÝäåV
keyIDç
',SerialNumber = '    ÝéêV
serialNumberì

'î
 WHERE FBSDeviceId =     ÝðñR
dev_id
Góô
printStackTrace

m_ConnPool
param
&Lcom/dec/fbs9100/FBS9100_StatAndParam;

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->.C/H0M1R2W3\4a5f6k7p8u9z:;„<‰=Ž>“?˜@'¡A«C±D¶EÔGÜFÞGãHæGëI>ì›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
–%O    SOTU(V+W.Y6Z9[>\R_r`¦a©Z³c¸d¾gÃhájælímòn
q
i
j
l
&m
+n
Iq
Nr
Qj
Vl
]m
bn
€q
…sp
†OP
†Ò

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

$j»YÚ·+´Ü¶'á¶'+´ã¶'æ¶'+´è¶'ë¶'í¶'+´ï¶!¶5M»Y*·N-,¶–§:¶ò-¶=§:-¶=¿-¶=±FKNGFU\
:{    |-}9{=FK‚PƒU…\„^…b†e…i‡4jõPjö÷
=-žVF$STPWXYÿNZÝŸ
GM\
øù