修改

81041

2019-01-09 eb8bc83b3eba5e679fe773b8639c95ed235cae95

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…

3REPLACE  into db_ram_db.tb_fbs9100_sysparam(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)  values(
‚‡    ˆ
(Ljava/lang/String;)V
‚Š‹Œ
append
(I)Ljava/lang/StringBuilder;Ž

,
‚‹‘
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
“”2
    getOp_cmd–
,'˜
','š
',
‚œ‹
(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(?,?)
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:,Æ
h,¹{
ž
_6§
N,¹~À:»‚Y„·†¶f¶‰¶¶’¶‰•¶¶%¶—¶¶)¶—¶¶,¶™¶¶/¶‰¶¶9¶‰¶¶<¶‰¶¶?¶‰¶¶B¶‰¶¶E¶‰•¶¶H¶™¶¶K¶‰¶¶N¶‰¶¶Q¶›¶¶Z¶‰¶¶]¶‰¶¶`¶›¶¶c¶›ž¶¶ :-¶£W»‚Y¥·†¶f¶‰§¶¶ :²©¸¯:        ¹³W„
,¹{
¡þ­¸-¸´¸¸:»½Y·¿¶ÀW¶Ä¬J,- ./#0)162?4É5
62
;6
B8
]9
g:
q0
?
‹@
˜Ap
ž
ž

™ÈÉ 
‘ÊË
ˆÌÉ&
Yͮ6
;Îp
;6qr
]Ïr
g
ÐÑ    
‹sÒÓ
™ÈÔ
ˆÌÕÖÿ)
vxv
û
Jú

×
€"+À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

ä