机房判断是否存在

81041

2019-01-07 f330e96565000d3e3ce16dce0b255ac6956baca8

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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
Êþº¾4
J
*com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl
java/lang/Object
com/fgkj/dao/BaseDAO
com/fgkj/dao/CallBack
<init>
()V
Code
     

LineNumberTable
LocalVariableTable
this
,Lcom/fgkj/dao/impl/ram/Fbs9100_sysparamImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;
rs
Ljava/sql/ResultSet;
add
(Ljava/lang/Object;)Z
obj
Ljava/lang/Object;
update
!com/fgkj/dto/ram/Fbs9100_sysparam

K update db_ram_db.tb_fbs9100_sysparam set IPADDR=?,SubIPADDR=?,NetGateADDR=?,GroupVolRange=?,GroupVolSorce=?,CurrentRange=?,CurrentTyte=?,MonomerOrder=?,BackLightTime=?,MACADDR=?,LoaderCount=?,DtCardCount=?,PowerBreakChargeCurr=?,MajorBattGroupNum=?,POF_BG_Boost_Cnt=?,POF_BG_Boost_VolStop=?,POF_BG_Boost_VolStart=? where dev_id=? 
 "!
com/fgkj/db/DBUtil#$
getConn
()Ljava/sql/Connection;
&'(
    getIPADDR
()Ljava/lang/String;
*+(
getSubIPADDR
-.(
getNetGateADDR
012
getGroupVolRange
()I
465
java/lang/Integer78
valueOf
(I)Ljava/lang/Integer;
:;2
getGroupVolSorce
=>2
getCurrentRange
@A2
getCurrentTyte
CD2
getMonomerOrder
FG2
getBackLightTime
IJ(

getMACADDR
LM2
getLoaderCount
OP2
getDtCardCount
RST
getPowerBreakChargeCurr
()F
VXW
java/lang/Float7Y
(F)Ljava/lang/Float;
[\2
getMajorBattGroupNum
^_2
getPOF_BG_Boost_Cnt
abT
getPOF_BG_Boost_VolStop
deT
getPOF_BG_Boost_VolStart
gh2
    getDev_id
jlk
com/fgkj/dao/DAOHelpermn
 executeUpdate
=(Ljava/sql/Connection;Ljava/lang/String;[Ljava/lang/Object;)Z
sys
#Lcom/fgkj/dto/ram/Fbs9100_sysparam;
sql
Ljava/lang/String;
bl

Z
    updateProw
java/util/Listy
java/util/ArrayList
x v|}2
sizev€
get
(I)Ljava/lang/Object;ƒ
java/lang/StringBuilder…

,REPLACE  into db_ram_db.tb_fbs9100_sysparam(dev_id,IPADDR,SubIPADDR,NetGateADDR,GroupVolRange,GroupVolSorce,CurrentRange,CurrentTyte,MonomerOrder,BackLightTime,MACADDR,LoaderCount,DtCardCount,PowerBreakChargeCurr,MajorBattGroupNum,POF_BG_Boost_Cnt,POF_BG_Boost_VolStop,POF_BG_Boost_VolStart)  values(
‚‡    ˆ
(Ljava/lang/String;)V
‚Š‹Œ
append
(I)Ljava/lang/StringBuilder;Ž
,'
‚‹‘
-(Ljava/lang/String;)Ljava/lang/StringBuilder;“
','•
',—

,
‚™‹š
(F)Ljava/lang/StringBuilder;œ

)
‚žŸ(
toString
x¡£
修改¥
机房系统参数    §©¨
com/fgkj/dao/UinfDaoFactoryª«
Alter

I
§­®¯

CreateULog
,(ILjava/lang/String;)Lcom/fgkj/dto/User_log;v¡
j²³´
makeManualCommit
-(Ljava/sql/Connection;Ljava/util/ArrayList;)Z
¶¸·
java/lang/Boolean7¹
(Z)Ljava/lang/Boolean;»
!com/fgkj/services/User_logService
º 
º¾¿À
addPro
/(Ljava/lang/Object;)Lcom/fgkj/dto/ServiceModel;
¶ÂÃÄ
booleanValue
()Z
list
Ljava/util/List;
sql_str
Ljava/util/ArrayList;
listU

i
fs
msg
ulog
Lcom/fgkj/dto/User_log;
Ljava/lang/Boolean;
LocalVariableTypeTable
5Ljava/util/List<Lcom/fgkj/dto/ram/Fbs9100_sysparam;>;
)Ljava/util/List<Lcom/fgkj/dto/User_log;>;
 StackMapTable
replaceÖ
> REPLACE  into db_ram_db.tb_fbs9100_sysparam(dev_id) values(?)
    replacePLÙ
G REPLACE  into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd) values(?,?)
ÛÜ2
    getOp_cmd
del
    searchAll
()Ljava/util/List;
serchByCondition
$(Ljava/lang/Object;)Ljava/util/List;ã
 select distinct dev_ip,dev_id,op_cmd,IPADDR,SubIPADDR,NetGateADDR,GroupVolRange,GroupVolSorce,CurrentRange,CurrentTyte,MonomerOrder,BackLightTime ,MACADDR,LoaderCount,DtCardCount,PowerBreakChargeCurr,MajorBattGroupNum,POF_BG_Boost_Cnt,POF_BG_Boost_VolStop,POF_BG_Boost_VolStart ,db_battinf.tb_battinf.FBSDeviceName,db_battinf.tb_battinf.StationName  from db_ram_db.tb_fbs9100_sysparam,db_battinf.tb_battinf  where db_ram_db.tb_fbs9100_sysparam.dev_id=db_battinf.tb_battinf.FBSDeviceId  and db_ram_db.tb_fbs9100_sysparam.dev_id=?  å
,com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl$1
äç    è
/(Lcom/fgkj/dao/impl/ram/Fbs9100_sysparamImpl;)V
jêëì
executeQuery
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;
sendCmdToFBS9100Dev
(II)Zð
DUPDATE db_ram_db.tb_fbs9100_sysparam  SET  op_cmd=?  WHERE dev_id=? ò
?SELECT op_cmd FROM db_ram_db.tb_fbs9100_sysparam  WHERE dev_id=ôöõ
java/sql/Connection÷ø
prepareStatement
0(Ljava/lang/String;)Ljava/sql/PreparedStatement;úüû
java/sql/PreparedStatementëý
()Ljava/sql/ResultSet;ÿ



java/sql/ResultSet
Ä
next

op_cmdÿ



getInt
(Ljava/lang/String;)I
 



java/sql/SQLException
 

printStackTraceú




java/lang/Thread


sleep
(J)V




java/lang/InterruptedException
 



close
@(Ljava/sql/ResultSet;Ljava/sql/Statement;Ljava/sql/Connection;)V
cmd
dev_id
m_cmd
    m_cmd_ack
res_exe
conn
Ljava/sql/Connection;
ps
Ljava/sql/PreparedStatement;

n

e
Ljava/sql/SQLException;
 Ljava/lang/InterruptedException;
+
java/lang/String
    getCmdAck
serchByInfo
main
([Ljava/lang/String;)V
 
 6=‹

4
5
6
    setDev_id
(I)V


8àá    
:
<
;
java/lang/System
=
>
out
Ljava/io/PrintStream;

@
B
A
java/io/PrintStream
C
6
println
args
[Ljava/lang/String;
fimpl

SourceFile
Fbs9100_sysparamImpl.java
InnerClasses!

    

/

*·±



6

°



6
¬




3Í+ÀMN¸-½Y,¶%SY,¶)SY,¶,SY,¶/¸3SY,¶9¸3SY,¶<¸3SY,¶?¸3SY,¶B¸3SY,¶E¸3SY    ,¶HSY
,¶K¸3SY,¶N¸3SY,¶Q¸USY ,¶Z¸3SY,¶]¸3SY,¶`¸USY,¶c¸USY,¶f¸3S¸i6¬"#&h'Å&Ê(4ÍÍ
ÈopÅqrÊst
u
¤

‘+ÀvM»xY·zN»xY·z:,Æ
[,¹{
ž
R6§
A,¹~À:»‚Y„·†¶f¶‰¶¶%¶’¶¶)¶’¶¶,¶”¶¶/¶‰–¶¶9¶‰–¶¶<¶‰–¶¶?¶‰–¶¶B¶‰–¶¶E¶‰¶¶H¶”¶¶K¶‰–¶¶N¶‰–¶¶Q¶˜–¶¶Z¶‰–¶¶]¶‰–¶¶`¶˜–¶¶c¶˜›¶¶:-¶ W»‚Y¢·†¶f¶‰¤¶¶:²¦¸¬:        ¹°W„
,¹{
¡þº¸-¸±¸µ:»ºY·¼¶½W¶Á¬J,- ./#0)162?4¼5
)2
.6
58
P9
Z:
d0
r?
~@
‹Ap
‘
‘

ŒÅÆ 
„ÇÈ
{ÉÆ&
LÊ«6
.Ëp
.6qr
PÌr
Z
ÍΠ   
~sÏÐ
ŒÅÑ
{ÉÒÓÿ)
vxv
û
=ú

Ô
€"+ÀMÕN¸-½Y,¶f¸3S¸i6¬EFGH4""
opqrst
×
Š,+ÀMØN¸-½Y,¶f¸3SY,¶Ú¸3S¸i6¬LMN)O4,,
'op$qr)st
Ý
6
¬
S

Þß
,


°
X

àá
ˆ*+ÀMâN-¸½Y,¶f¸3S»äY*·æ¸é:°\]c'Š4**
%op"qr'ÅÆ
íî
Q Ý>6ª$€~6§6§¬6ï:¸½Y¸3SY¸3S¸i¸µ:¶Á™ƒ»‚Yñ·†¶‰¶:¸:
:    
:
6§P¹ó:        ¹ù
:
 
¹þ
™

¹
 6§$:¶
    
¸
§
:¶
„
¡ÿ¯
    ¸
¬}­°

·½À
~‘’#“*”,–/—3šR›ZcžglŸq t¡w¢}¥ˆ¦‘§›©ª«­¬°¯²±·µ½¶Â¸Ç¢Ñ»Ú½ŽÝÝ
«
Ý
«Û
«Ø
 «/®
!t3ªqrR‹sÏqi
"
#tf
$
%    wc
zW
&«²
'
(Â
'
)Ó:ý


ÿP






*¶ôúÿ
r

H
úø

,î

«’>6ª$€~6§6§¬»‚Yñ·†¶‰¶:¸:
:
:6    ¹ó:¹ù
:¹þ
™
¹
 6    §
:
 
¶
    ¸
    ¬
L|

ZÂÃÄÅ#Æ*Ç,É5Ê9É>ËCÌFÍIÎLÐWÑ`ÒjÔyÖ|فۆݏÞp’’
«
’
«
«
 «>TqrCO
"
#FL
$
%IILF
!t    
'
(
Ó)ý


ÿR






*ôúÿ





-á
6

°
ã
    
.
/
†*»
Y·
0L»Y·
1M,
2¶
3+,¶
7N²
9-¹{
¶
?±çèéêë)ì**
D
E"
F
op ÅÆ
G
H
I

ä