程序新增单体剩余容量数据读取

DELL

2024-04-19 cfe3b8044b61ced5772914bfbbdc629fbedf4bd5

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
Êþº¾4
÷
com/dec/fbs9100/Sql_Mysql
java/lang/Object
    DB_AppSys
Ljava/lang/String;
 ConstantValue    
`db_app_sys`
DB_BATT_INF
`db_battinf`
DB_BATT_TESTDATA
`db_batt_testdata`
DB_PARAM

`db_param`
DB_ALARM

`db_alarm`
DB_USER
    `db_user`
DB_RamDB
`db_ram_db`
DB_RamDB_BATT_RT
`db_ram_batt_rt`
WEB_Site!
web_site
DB_BATT_HISTORY$
`db_batt_history`
DB_DEV_TESTPARAM'
`db_dev_testparam`
DB_IED_SCOUT*
`db_ied_scout`
TB_HardDevSmsState-
tb_hard_dev_sms_state
    TB_AppSys0

tb_app_sys
TB_BattTestDataInf3
tb_batttestdata_inf

TB_UserInf6
tb_user_inf

TB_UserLog9
tb_user_log
TB_UserBattGroup_BaoJiGroup<
tb_user_battgroup_baojigroup
%TB_UserBattGroup_BaoJiGroup_BattGroup?
&tb_user_battgroup_baojigroup_battgroup
TB_UserBattGroup_BaoJiGroup_UsrB
 tb_user_battgroup_baojigroup_usr
TB_UserTaskTemplateE
tb_user_task_batt_template
TB_UserTaskH
tb_user_task
 TB_UserPaiXiuK
tb_user_paixiu
TB_UserListForTaskN
tb_user_task_user_list
TB_UserTaskParamQ
tb_user_task_param
TB_UserBattCkeckTaskT
tb_user_task_batt_check
TB_UserBattTestTaskW
tb_user_task_batt_test
TB_UserBattTaskChangeZ
tb_user_task_change

TB_UserSms]
tb_user_sms
TB_UserSmsFormat`
tb_user_sms_format
TB_UserPermitGroupc
tb_user_permitgroup
TB_UserPermitGroupDataf
tb_user_permitgroup_data
TB_UserJieJiaRii
tb_user_jiejiari
ServerState_Tablel
`db_ram_db`.`tb_server_state`
BattRtData_Tableo
`db_ram_db`.`tb_batt_rtdata`
BattRtState_Tabler
`db_ram_db`.`tb_batt_rtstate`
BattRtAlarm_Tableu
`db_ram_db`.`tb_batt_rtalarm`
BattRsAlarm_Tablex
`db_ram_db`.`tb_batt_rsalarm`
CInterfaceState_Table{
!`db_ram_db`.`tb_cinterface_state`
HardDevSmsState_Table~
#`db_ram_db`.`tb_hard_dev_sms_state`
FBS9100State_Table
`db_ram_db`.`tb_fbs9100_state`
FBS9100S_DcDcState_Table„
$`db_ram_db`.`tb_fbs9100s_dcdc_state`
FBS9100SetParam_Table‡
!`db_ram_db`.`tb_fbs9100_setparam`
FBS9100SysParam_TableŠ
!`db_ram_db`.`tb_fbs9100_sysparam`
FBS9100SetDLParam_Table
#`db_ram_db`.`tb_fbs9100s_fod_param`
FBS9100sFodState_Table
#`db_ram_db`.`tb_fbs9100s_fod_state`
FBS9100S_DFUState_Table“
#`db_ram_db`.`tb_fbs9100s_DFU_state`
BMP7100State_Table–
`db_ram_db`.`tb_bpm7100_state`
FBS9600State_Table™
`db_ram_db`.`tb_fbs9600_state`
FBS9600SetParam_Tableœ
!`db_ram_db`.`tb_fbs9600_setparam`
SocketClientStateTableŸ
#`db_ram_db`.`tb_socketclient_state`
RamDB_CMCC_POWER_Data¢
`db_ram_db`.`cmcc_power_data`
FBS9100_61850_jhstate_Table¥
`db_ram_db`.`tb_61850_jhstate`
FBS9100_offlineyhplan¨
$`db_ram_db`.tb_fbs9100_offlineyhplan
AppSys_Table«
`db_app_sys`.`tb_app_sys`
FBSDevStateChangeInf_Table®
(`db_app_sys`.`tb_fbsdev_statechange_inf`
AppDevBattGroup_Table±
#`db_app_sys`.`tb_app_bts_battgroup`
 BattInf_Table´
`db_battinf`.`tb_battinf`
BattCurrInf_Table·
`db_battinf`.`tb_battcurr_inf`
BattMainInf_Tableº
 `db_battinf`.`tb_batt_maint_inf`
BattMainProcess_Table½
$`db_battinf`.`tb_batt_maint_process`
BattTestDataInf_TableÀ
(`db_batt_testdata`.`tb_batttestdata_inf`
BattResData_TableÃ
#`db_batt_testdata`.`tb_BattResData`
BattResDataInf_TableÆ
'`db_batt_testdata`.`tb_battresdata_inf`
UserInfTableÉ
`db_user`.`tb_user_inf`
UserLogTableÌ
`db_user`.`tb_user_log`
UserBattGroup_BaoJiGroup_TableÏ
(`db_user`.`tb_user_battgroup_baojigroup`
'UserBattGroup_BaoJiGroup_BattGroupTableÒ
2`db_user`.`tb_user_battgroup_baojigroup_battgroup`
!UserBattGroup_BaoJiGroup_UsrTableÕ
,`db_user`.`tb_user_battgroup_baojigroup_usr`
UserTaskTemplateTableØ
&`db_user`.`tb_user_task_batt_template`
 UserTaskTableÛ
`db_user`.`tb_user_task`
UserPaiXiuTableÞ
`db_user`.`tb_user_paixiu`
UserListForTaskTableá
"`db_user`.`tb_user_task_user_list`
UserTaskParamTableä
`db_user`.`tb_user_task_param`
UserBattCheckTaskTableç
#`db_user`.`tb_user_task_batt_check`
UserBattTestTaskTableê
"`db_user`.`tb_user_task_batt_test`
UserBattTaskChangeTableí
`db_user`.`tb_user_task_change`
UsrBattMaintCheck_Tableð
#`db_user`.`tb_user_battmaint_check`
UsrBattMaintCheckProcess_Tableó
+`db_user`.`tb_user_battmaint_check_process`
UserSmsTableö
`db_user`.`tb_user_sms`
UserSmsFormatTableù
`db_user`.`tb_user_sms_format`
UserPermitGroupTableü
`db_user`.`tb_user_permitgroup`
UserPermitGroupDataTableÿ
$`db_user`.`tb_user_permitgroup_data`
UserJieJiaRiTable

`db_user`.`tb_user_jiejiari`
Tb_BattDischarge_ParamTable

web_site.tb_battdischarge_param
Tb_BattMap_InformationTable

web_site.tb_battmap_information
Tb_Batt_DevDischargeTable

web_site.tb_batt_devdischarge
Tb_BattDischarge_PlanTable

web_site.tb_battdischarge_plan
Tb_Batt_ElectricityTable

web_site.tb_batt_electricity
Tb_Batt_Devdischarge_ParamTable

#web_site.tb_batt_devdischarge_param
Tb_Batt_Devdischarge_CMTable

 web_site.tb_batt_devdischarge_CM
Tb_Batt_Devdischarge_CTTable

 web_site.tb_batt_devdischarge_CT
Tb_Batt_Devdischarge_CUTable

 web_site.tb_batt_devdischarge_CU
Tb_CustomPageTable
 
web_site.tb_custompage
Tb_Vip_UserTable
#
web_site.tb_vip_user
Tb_Batt_Param_LowTable
&
web_site.tb_batt_param_low
Tb_AnnounceTable
)
web_site.tb_announce
Tb_BtsStateChange_inf
,
(`db_batt_history`.`tb_btsstaechange_inf`
Tb_Batt_RealData
/
#`db_batt_history`.tb_batt_realdata_
Batt_TestParam_Table
2
%`db_dev_testparam`.tb_batt_testparam_
Connect_Inf_Table
5
`db_ied_scout`.tb_connect_inf
Ied_NodeState_Table
8
`db_ied_scout`.tb_ied_nodestate
    mysql_con
Ljava/sql/Connection;
logger
&Lorg/apache/logging/log4j/core/Logger;
<init>
"(Lcom/dec/fbs9100/MysqlConnPool;)V
Code

A
=
B
()V    

D
;
<

F
H
G
com/dec/fbs9100/MysqlConnPool
I
J
getConn
()Ljava/sql/Connection;    

L
9
:    
F
N
;
O
!Lorg/apache/logging/log4j/Logger;
Q
$org/apache/logging/log4j/core/Logger
LineNumberTable
LocalVariableTable
this
Lcom/dec/fbs9100/Sql_Mysql;
conn_t
Lcom/dec/fbs9100/MysqlConnPool;
sqlMysqlCheckIfTableExist
(Ljava/lang/String;)Z

Exceptions
\
java/sql/SQLException
^
java/lang/StringBuilder
`
SHOW TABLES LIKE '

]
b
=
c
(Ljava/lang/String;)V

]
e
f
g
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
i

'

]
k
l
m
toString
()Ljava/lang/String;


o
p
q
 sqlMysqlQuery
((Ljava/lang/String;)Ljava/sql/ResultSet;
s
u
t
java/sql/ResultSet
v
w
next
()Z
tb
sql_str
res
Ljava/sql/ResultSet;
exist

Z
 StackMapTable
€
java/lang/String
sqlMysqlExecute
ƒ
…
„
java/sql/Connection
†
‡
createStatement
()Ljava/sql/Statement;
‰
‹
Š
java/sql/Statement
Œ

setQueryTimeout
(I)V
‰


Y
execute
sql
Ljava/sql/Statement;
sqlMysqlTotalExecute
 sqlMysqlUseDB
–
use 


˜

c
db
makeManualCommit
(Ljava/util/ArrayList;)Z
    Signature
,(Ljava/util/ArrayList<Ljava/lang/String;>;)Z
ƒ
Ÿ
 
¡
 setAutoCommit
(Z)V

£
¥
¤
java/util/ArrayList
¦
§
get
(I)Ljava/lang/Object;

£
©
ª
«
size
()I
ƒ
­
®
B
commit

[
k

P
±
²
³
error
*(Ljava/lang/String;Ljava/lang/Throwable;)V
ƒ
µ
¶
B
rollback
al_sql_strs
Ljava/util/ArrayList;
exe_res

n

I

e
Ljava/sql/SQLException;
e1
LocalVariableTypeTable
)Ljava/util/ArrayList<Ljava/lang/String;>;
Â
java/lang/Throwable
‰
Ä
Å
q
executeQuery
query
ex
sqlMysqlTotalQuery
sqlMysqlUpdate
    close_con
ƒ
Ì
Í
B
close
getBattTestRecordCountNew
(ILjava/lang/String;)I
Ñ
!SELECT test_record_count_ex FROM 
Ó
 WHERE BattGroupId=

]
Õ
f
Ö
(I)Ljava/lang/StringBuilder;
Ø
 FOR UPDATE
Ú
UPDATE 
Ü
- SET test_record_count_ex=test_record_count+1
Þ
&SELECT MAX(test_record_count_ex) FROM 
à
INSERT INTO 
â
7 (BattGroupId,test_record_count, test_record_count_ex) 
ä
     VALUES (
æ

,
è

)
s
ê
ë
ì
getInt
(I)I
bg_id
table
count
res_exe
sql_str0
sql_str1
sql_str2
sql_str3

SourceFile
Sql_Mysql.java!
h


 






 "
#%
&(
)+
,.
/1
24
57
8:
;=
>@
AC
DF
GI
JL
MO
PR
SU
VX
Y[
\^
_a
bd
eg
hj
km
np
qs
tv
wy
z|
}
€‚
ƒ…
†ˆ
‰‹
ŒŽ
‘
’”
•—
˜š
›
ž 
¡£
¤¦
§©
ª¬
­¯
°²
³µ
¶¸
¹»
¼¾
¿Á
ÂÄ
ÅÇ
ÈÊ
ËÍ
ÎÐ
ÑÓ
ÔÖ
×Ù
ÚÜ
Ýß
àâ
ãå
æè
éë
ìî
ïñ
òô
õ÷
øú
ûý
þ










    





 


















!

"
$

%
'

(
*

+
-

.
0

1
3

4
6

7

9
:

;
<

=
>

?a*·
@*
µ
C*+¶
Eµ
K*+´
MÀ
Pµ
C±
R•“    —˜™
S
T
U
V
W


X
Y
Z

[
?¨0»
]Y
_·
a+¶
d
h¶
d¶
jM*,¶
nN6-¹
r
™6¬
R¢£¤!¥*§-«
S40
T
U0
x

y
z
{!
|
}
~
þ-

s



c
Z

[
?e*´
K¹
‚
M,¹
ˆ,+¹
ŽW±
R±
²³´
S 
T
U
y


‘
’

“
c
Z

[
?f*´
K¹
‚
M,X¹
ˆ,+¹
ŽW±
R¸
¹º»
S 
T
U
y


‘
’

”
c
Z

[
?N*»
]Y
•·
a+¶
d¶
j¶
—±
R
ÀÁ
S
T
U
™


š
›
œ

?8Ï=*´
K¹
ž>§*+¶
¢À
¶
—„
+¶
¨¡ÿì™z*´
K¹
¬
§nN*´
C-¶
¯-¶
°=š*´
K¹
´
*´
K¹
ž§o:*´
C¶
¯¶
°§\:š*´
K¹
´
*´
K¹
ž§:*´
C¶
¯¶
°¿š*´
K¹
´
*´
K¹
ž§:*´
C¶
¯¶
°¬58
[G^a
[Gtv
[£º½
[
RrÆÈÊËÊ(Î,Ï5Ñ9ÓEÔG×KØTÚ^ÛcÝtÕv×z؃ڍےݠߣקذںۿÝÍà
SRÏ
T
UÏ
·
¸
Í
¹
}
º
»9
¼
½c
¾
½’
¾
½¿
¾
½
¿
Ï
·
À

~M ý

ÿ

£


[L
[R
Áÿ

£

ÁL
[ÿ

£
L
[

p
q

?Î2
M*´
K¹
‚
N-¹
ˆ+:-¹
ÃM§N*´
C-¶
¯-¶
°,°
 #
[
R"çéêëì í$î0ð
S>2
T
U2
y
0
z
{
‘
’    
Æ$
Ç
½
~ÿ#


s

[

È
q

?Ï3
M*´
K¹
‚
N-X¹
ˆ+:-¹
ÃM§N*´
C-¶
¯-¶
°,°
!$
[
R"ôö÷øù!ú%û1ý
S>3
T
U3
y
1
z
{
‘
’    
Æ%
Ç
½
~ÿ$


s

[

É
c

?¬-*´
K¹
‚
M,¹
ˆ+N,-¹
ŽW§M*´
C,¶
¯,¶
°±

[
R





     

,

S4-
T
U-
y


‘
’
Æ 
Ç
½
~_
[

Ê
B

?o*´
K¹
Ë
§L*´
C+¶
¯+¶
°±
    
[
R
    
 


S
T
U 
¼
½

~L
[

Î
Ï

?³
—>6»
]Y
з
a,¶
d
Ò¶
d¶
Ô
׶
d¶
j:»
]Y
Ù·
a,¶
d
Û¶
d
Ò¶
d¶
Ô¶
j:»
]Y
Ý·
a,¶
d
Ò¶
d¶
Ô¶
j:»
]Y
ß·
a,¶
d
á¶
d
ã¶
d¶
Ô
å¶
d¶
Ô
å¶
d¶
Ô
ç¶
d¶
j:*´
K¹
ž*¶
n:        ¹
r
™'*¶
—*¶
n:        ¹
r
™    ¹
é>§>*¶
—*´
K¹
¬
§t:    *´
C    ¶
¯    ¶
°6š‡*´
K¹
´
*´
K¹
ž§q:*´
C¶
¯¶
°§^:
š)*´
K¹
´
*´
K¹
ž§:*´
C¶
¯¶
°
¿š)*´
K¹
´
*´
K¹
ž§:*´
C¶
¯¶
°¬¥öù
[

$
'
[¥

:
A
T
W
[
o
‚
…
[
Rº.



#
(
<
F
K
Y
 c
h
!|
" 
!¥
$¯
%·
&Á
'Ç
(Ï
)Ù
*â
,å
-ç
.í
1ö
2û
3
    
4

6

8

9
$
:
)
<
:
5
<
6
A
8
J
9
T
:
Y
<
g
?
j
6
o
8
x
9
‚
:
‡
<
•
A
SŽ
—
T
U
—
í
»

—
î
•
ï
»
’
ð
}(
o
ñK
L
òh
/
ó¥ò
ô·?
z
{    û
¼
½    
)
¼
½
Y
¼
½
‡
¼
½
~Ž
ÿå










sÿ    










[m
[R
Áÿ









Á

[ÿ    








Z
[

õ
ö