电池放电参数设置批量

81041

2019-01-05 fdc45803b0b4468508316efc5cfd90af9c63e9c9

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
Êþº¾4
"
+com/fgkj/dao/impl/ram/Fbs9100_battparamImpl
java/lang/Object
com/fgkj/dao/BaseDAO
com/fgkj/dao/CallBack
<init>
()V
Code
     

LineNumberTable
LocalVariableTable
this
-Lcom/fgkj/dao/impl/ram/Fbs9100_battparamImpl;

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_battparam
æ replace into db_ram_db.tb_fbs9100_battparam(dev_id,dev_ip,STD_CAP,STD_RES,BattGroupCount,EachGroupBattCount,MonomerVol,GroupVol,BattTemp,FloatChargeVol,FloatChargeCurr,OnlineVolLow,GroupConnType) values(?,?,?,?,?,?,?,?,?,?,?,?,?)
 "!
com/fgkj/db/DBUtil#$
getConn
()Ljava/sql/Connection;
&'(
    getDev_id
()I
*,+
java/lang/Integer-.
valueOf
(I)Ljava/lang/Integer;
012
    getDev_ip
()Ljava/lang/String;
45(

getSTD_CAP
78(

getSTD_RES
:;(
getBattGroupCount
=>(
getEachGroupBattCount
@AB
 getMonomerVol
()F
DFE
java/lang/Float-G
(F)Ljava/lang/Float;
IJB
getGroupVol
LMB
getBattTemp
OPB
getFloatChargeVol
RSB
getFloatChargeCurr
UVB
getOnlineVolLow
XY(
getGroupConnType
[]\
com/fgkj/dao/DAOHelper^_
 executeUpdate
=(Ljava/sql/Connection;Ljava/lang/String;[Ljava/lang/Object;)Z
bparam
$Lcom/fgkj/dto/ram/Fbs9100_battparam;
sql
Ljava/lang/String;
bl

Z
updatePLh
ï replace into db_ram_db.tb_fbs9100_battparam(dev_id,op_cmd,dev_ip,STD_CAP,STD_RES,BattGroupCount,EachGroupBattCount,MonomerVol,GroupVol,BattTemp,FloatChargeVol,FloatChargeCurr,OnlineVolLow,GroupConnType) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)
jk(
    getOp_cmd
    updatePron
java/util/Listp
java/util/ArrayList
o mst(
sizemvwx
get
(I)Ljava/lang/Object;z
java/lang/StringBuilder|
Óreplace into db_ram_db.tb_fbs9100_battparam(dev_id,op_cmd,dev_ip,STD_CAP,STD_RES,BattGroupCount,EachGroupBattCount,MonomerVol,GroupVol,BattTemp,FloatChargeVol,FloatChargeCurr,OnlineVolLow,GroupConnType)  values(
y~    
(Ljava/lang/String;)V
y‚ƒ
append
(I)Ljava/lang/StringBuilder;…

,
y‡‚ˆ
-(Ljava/lang/String;)Ljava/lang/StringBuilder;Š
,'Œ
',
yŽ‚
(F)Ljava/lang/StringBuilder;‘

)
y“”2
toString
o–˜
修改š
电池参数    œž
com/fgkj/dao/UinfDaoFactoryŸ 
Alter

I
œ¢£¤

CreateULog
,(ILjava/lang/String;)Lcom/fgkj/dto/User_log;m–
[§¨©
makeManualCommit
-(Ljava/sql/Connection;Ljava/util/ArrayList;)Z
«­¬
java/lang/Boolean-®
(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
6Ljava/util/List<Lcom/fgkj/dto/ram/Fbs9100_battparam;>;
)Ljava/util/List<Lcom/fgkj/dto/User_log;>;
 StackMapTable
del
    searchAll
()Ljava/util/List;
serchByCondition
$(Ljava/lang/Object;)Ljava/util/List;Ï

½ select distinct dev_id, dev_ip,op_cmd,STD_CAP,STD_RES,BattGroupCount,EachGroupBattCount,MonomerVol,GroupVol,BattTemp,FloatChargeVol,FloatChargeCurr,OnlineVolLow,GroupConnType  ,db_battinf.tb_battinf.DeviceName,StationName,StationName1,StationName2,StationName3,StationName5,StationId  from db_ram_db.tb_fbs9100_battparam,db_battinf.tb_battinf   where dev_id=? and db_ram_db.tb_fbs9100_battparam.dev_id=db_battinf.tb_battinf.fbsdeviceid limit 1 Ñ
-com/fgkj/dao/impl/ram/Fbs9100_battparamImpl$1
ÐÓ    Ô
0(Lcom/fgkj/dao/impl/ram/Fbs9100_battparamImpl;)V
[Ö×Ø
executeQuery
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;
sendCmdToBattparam
(II)ZÜ
Þ
5UPDATE db_ram_db.tb_fbs9100_battparam  SET  op_cmd=? à
 WHERE dev_id=? â
@SELECT op_cmd FROM db_ram_db.tb_fbs9100_battparam  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
sql_end
res_exe
conn
Ljava/sql/Connection;
ps
Ljava/sql/PreparedStatement;

n

e
Ljava/sql/SQLException;
 Ljava/lang/InterruptedException;

java/lang/String
    getCmdAck
serchByInfo

SourceFile
Fbs9100_battparamImpl.java
InnerClasses!

    

/

*·±



6

°



6
¬




Ÿ+ÀMN¸- ½Y,¶%¸)SY,¶/SY,¶3¸)SY,¶6¸)SY,¶9¸)SY,¶<¸)SY,¶?¸CSY,¶H¸CSY,¶K¸CSY    ,¶N¸CSY
,¶Q¸CSY,¶T¸CSY,¶W¸)S¸Z6¬#&'c(—'œ)4ŸŸ
š`a—bcœde
f

ª+ÀMgN¸-½Y,¶%¸)SY,¶i¸)SY,¶/SY,¶3¸)SY,¶6¸)SY,¶9¸)SY,¶<¸)SY,¶?¸CSY,¶H¸CSY    ,¶K¸CSY
,¶N¸CSY,¶Q¸CSY,¶T¸CSY ,¶W¸)S¸Z6¬-01n2¢1§34ªª
¥`a¢bc§de
l
p

]+ÀmM»oY·qN»oY·q:,Æ
',¹r
ž
6§
 ,¹uÀ:»yY{·}¶%¶€„¶†¶i¶€‰¶†¶/¶†‹¶†¶3¶€„¶†¶6¶€„¶†¶9¶€„¶†¶<¶€„¶†¶?¶„¶†¶H¶„¶†¶K¶„¶†¶N¶„¶†¶Q¶„¶†¶T¶„¶†¶W¶€¶†¶’:-¶•W»yY—·}¶%¶€™¶†¶’:²›¸¡:        ¹¥W„
,¹r
¡þî¸-¸¦¸ª:»¯Y·±¶²W¶¶¬J78 9:#;)<6=??•@õ=úA

C
D
&E
0;
>J
JK
WLp
]
]

Xº» 
P¼½
G¾»&
¿ 6úÀaú6bc
Ác
&
Âà   
JdÄÅ
XºÆ
G¾ÇÈÿ)
mom
û
    ú

É
6
¬
P

ÊË
,


°
U

ÌÍ
ˆ*+ÀMÎN-¸½Y,¶%¸)S»ÐY*·Ò¸Õ:°YZ_'„4**
%`a"bc'º»
ÙÚ
…ô>6ª$6786§96§¬Û:6»yYÝ·}¶†߶†¶’:¸½Y¸)SY¸)S¸Z¸ª:¶¶™‚»yYá·}¶€¶’:¸:    
:

:6§O    ¹ã:
 
¹é
:¹î
™ó¹õ 6§$:  ¶ùþ¸
§
:  ¶
„
¡ÿ°
    ¸
    ¬•ÄÇúÎÔ×
Ž#‰Š‹Œ#*Ž,0‘3’<“A”F’K•j–r˜{™˜„š‰›Œœ•  ¡©¢³¤Á¦Ä§ÇªÉ¬Î°Ô±Ù³Þè¶ñ¸˜ôô
  
ô
 ò
 ï
 0Ä
c3Á
eK©bcjŠdĉh

    Œe


b’V
 É

 Ù

 È=ý


ÿh 







«äêï
qúH
úø

Ú

ª‘>6ª$6786§96§¬»yYá·}¶€¶’:¸:
:
:6    ¹ã:¹é
:¹î
™ó¹õ 6    §
:
 
¶ù¸
        ¬
L{~úZ½¾¿À#Á*Â,Ä5Å9Ä>ÆCÇFÈIÉLËWÌ`ÍjÏxÑ{Ԁօ؎Ùp‘‘
  
‘
 
 Œ
 >SbcCN

FK

IHLE
e    €


È)ý


ÿQ






äêï

ú

Í
6

°
Ý


 
!

Ð