修改

81041

2019-01-15 253879d0d562db0290a67160d30d3f15e8e7bf09

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
Q
*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(?,?)
readPLß
Breplace 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;
2
java/lang/String
    getCmdAck
serchByInfo
main
([Ljava/lang/String;)V
 
 6=‹

;
<
=
    setDev_id
(I)V


?çè    
A
C
B
java/lang/System
D
E
out
Ljava/io/PrintStream;

G
I
H
java/io/PrintStream
J
=
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#1)263?5É6
63
;7
B9
]:
g;
q1
@
‹A
˜Bp
ž
ž

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

×
€"+ÀMØN¸-½Y,¶f¸3S¸i6¬FGHI4""
opqrst
Ú
Š,+ÀMÛN¸-½Y,¶f¸3SY,¶’¸3S¸i6¬MNO)P4,,
'op$qr)st
Ý

Ð
Á+ÀvM»xY·zN»xY·z:,Ƌ,¹{
ž‚6§q,¹~À:»‚YÞ·†¶f¶‰¶¶’¶‰ž¶¶ :-¶£W»‚Yෆ¶f¶‰ⶏ¶ :²©¸¯:        ¹³W„
,¹{
¡ÿŠ¸-¸´¸¸:»½Y·¿¶ÀW¶Ä¬FTU VW#X)Y6Z?[YZ^\e^€_Š`”X¢e®f»gpÁÁ
¼ÈÉ ´ÊË«ÌÉ&|Í®6^Îp^6qr€ÏrŠ
ÐÑ    ®sÒÓ¼ÈÔ«ÌÕÖÿ)
vxv
ûmú

ä
6
¬
k

åæ
,


°
p

çè
ˆ*+ÀMéN-¸½Y,¶f¸3S»ëY*·í¸ð:°tu{'¢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
-®²
.
/Â
.
0Ö:ý


ÿP






1¹û



r
H
úø

3õ

«’>6ª$€~6§6§¬»‚Yø·†¶‰¶ :¸:
:
:6    ¹ú:¹

:¹

™

¹
 6    §
:
 
¶
¸
     ¬
L|
ZÚÛÜÝ#Þ*ß,á5â9á>ãCäFåIæLèWé`êjìyî|ñó†õöp’’
$®
’
%®
&®
'®>TqrCO
)
*FL
+
,IILF
(t    
.
/
Ö)ý


ÿR






1û







4è
6

°
û
    
5
6
†*»
Y·
7L»Y·
8M,
9¶
:+,¶
>N²
@-¹{
¶
F±ÿ




)
**
K
L"
M
op ÈÉ
N
O
P

ë