1

81041

2018-12-17 299f3a8a31cf05127b708b4985b8b0f4236a027b

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
Êþº¾2
#
,com/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl
java/lang/Object
com/fgkj/dao/BaseDAO
com/fgkj/dao/CallBack
<init>
()V
Code
     

LineNumberTable
LocalVariableTable
this
.Lcom/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;
rs
Ljava/sql/ResultSet;
add
(Ljava/lang/Object;)Z
#com/fgkj/dto/ram/Fbs9100s_dfu_state
} REPLACE into db_ram_db.tb_fbs9100s_dfu_state (dev_id,dfu_file,dfu_wr_stat,dfu_data_blocknum,dfu_file_len) values (?,?,?,?,?)

com/fgkj/db/DBUtil !
getConn
()Ljava/sql/Connection;
#$%
    getDev_id
()I
')(
java/lang/Integer*+
valueOf
(I)Ljava/lang/Integer;
-./
getDfu_file
()Ljava/lang/String;
12%
getDfu_wr_stat
45%
getDfu_data_blocknum
78%
getDfu_file_len
:<;
com/fgkj/dao/DAOHelper=>
 executeUpdate
=(Ljava/sql/Connection;Ljava/lang/String;[Ljava/lang/Object;)Z
obj
Ljava/lang/Object;
dfu
%Lcom/fgkj/dto/ram/Fbs9100s_dfu_state;
sql
Ljava/lang/String;
bl

Z
addProI
com/fgkj/dto/BattInfK
û REPLACE into db_ram_db.tb_fbs9100s_dfu_state(dev_id,dfu_wr_stat,dfu_data_blocknum)  SELECT  DISTINCT fBSDeviceId,1,1 FROM db_battinf.tb_battinf  where fBSDeviceId not in(select DISTINCT dev_id from db_ram_db.tb_fbs9100s_dfu_state where dfu_en=true)  M
 and stationid=? O
 and stationname1=? Q
 and stationname2=? S
 and stationname5=? 
HUVW
getNum
()Ljava/lang/Integer;
'YZ%
intValue\
java/lang/StringBuilder
^`_
java/lang/String*a
&(Ljava/lang/Object;)Ljava/lang/String;
[c    d
(Ljava/lang/String;)V
[fgh
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
[jk/
toString
Hmn/
getStationName
binf
Lcom/fgkj/dto/BattInf;
sql0
sql1
sql2
sql5
 StackMapTable
serchInserStation
$(Ljava/lang/Object;)Ljava/util/List;y

rSELECT  DISTINCT fBSDeviceId,fBSDeviceName,stationId,stationname,stationname1,stationname2,stationname3,stationname5 ,db_ram_db.tb_fbs9100_state.dev_id,db_ram_db.tb_fbs9100_state.dev_version from db_battinf.tb_battinf,db_ram_db.tb_fbs9100_state  where db_battinf.tb_battinf.fBSDeviceId=db_ram_db.tb_fbs9100_state.dev_id  and db_battinf.tb_battinf.station_install=1  and {
  stationid=? }
  stationname1=? 
  stationname2=? 
  stationname5=? ƒ
  order by fBSDeviceId …
.com/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl$1
„‡    ˆ
1(Lcom/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl;)V
:Š‹Œ
executeQuery
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;
endSql
list
Ljava/util/List;
judgeStation’
java/util/List”

 select distinct dev_id,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationname3 from db_ram_db.tb_fbs9100_state,db_battinf.tb_battinf   where db_ram_db.tb_fbs9100_state.dev_id=db_battinf.tb_battinf.fBSDeviceId  and dev_workstate=0 and dev_id in(–
‘˜™%
size›
?)
?,‘Ÿ ¡
get
(I)Ljava/lang/Object;£
  order by dev_id¥
.com/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl$2
¤‡
devSql
object
[Ljava/lang/Object;

i

I
listAll
LocalVariableTypeTable
%Ljava/util/List<Ljava/lang/Integer;>;©
update²
hupdate db_ram_db.tb_fbs9100s_dfu_state set dfu_en=true,dfu_wr_stat=1, dfu_data_blocknum=1 where dev_id=?
    updateProµ
java/util/ArrayList
´ ¸
dupdate db_ram_db.tb_fbs9100s_dfu_state set dfu_en=true,dfu_wr_stat=1, dfu_data_blocknum=1,dfu_file='º
'  where dev_id=
[¼g½
(I)Ljava/lang/StringBuilder;
´¿Á
升级Ã
设备    ÅÇÆ
com/fgkj/dao/UinfDaoFactoryÈ«
Increase
ÅÊËÌ

CreateULog
,(ILjava/lang/String;)Lcom/fgkj/dto/User_log;‘¿
:ÏÐÑ
makeManualCommit
-(Ljava/sql/Connection;Ljava/util/ArrayList;)ZÓ
!com/fgkj/services/User_logService
Ò 
ÒÖG×
/(Ljava/lang/Object;)Lcom/fgkj/dto/ServiceModel;
listU
sql_str
Ljava/util/ArrayList;
msg
ulog
Lcom/fgkj/dto/User_log;
7Ljava/util/List<Lcom/fgkj/dto/ram/Fbs9100s_dfu_state;>;
)Ljava/util/List<Lcom/fgkj/dto/User_log;>;
del
    searchAll
()Ljava/util/List;ä
U select distinct db_ram_db.tb_fbs9100s_dfu_state.dev_id,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationId,db_battinf.tb_battinf.fBSDeviceName ,sysVersion_new,softVersion_new,sysVersion_dev,softVersion_dev,dfu_file,dfu_en,dfu_wr_stat,dfu_data_blocknum,dfu_data_blocklen,dfu_file_len ,db_ram_db.tb_fbs9100_state.dev_version from  db_ram_db.tb_fbs9100s_dfu_state,db_battinf.tb_battinf,db_ram_db.tb_fbs9100_state  where db_ram_db.tb_fbs9100s_dfu_state.dev_id=db_battinf.tb_battinf.fBSDeviceId   and db_ram_db.tb_fbs9100s_dfu_state.dev_id=db_ram_db.tb_fbs9100_state.dev_id  and dfu_en=1æ
.com/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl$3
å‡
serchByConditionê
A select * from db_ram_db.tb_fbs9100s_dfu_state   where dev_id in(ì
.com/fgkj/dao/impl/ram/Fbs9100s_dfu_stateImpl$4
ë‡
serchByInfo
main
([Ljava/lang/String;)V

 6=
H 
Hõö÷
setNum
(Ljava/lang/Integer;)Vù
    å¹¿è¥¿çœ
Hûüd
setStationName

þáâ‘




iterator
()Ljava/util/Iterator;



java/util/Iterator


next
()Ljava/lang/Object;    




java/lang/System
 

out
Ljava/io/PrintStream;




java/io/PrintStream


println
(Ljava/lang/Object;)V




hasNext
()Z





(I)V
args
[Ljava/lang/String;
fimpl


SourceFile
Fbs9100s_dfu_stateImpl.java
InnerClasses!
 
    

/

*·±



6

°



¥G+ÀMN¸-½Y,¶"¸&SY,¶,SY,¶0¸&SY,¶3¸&SY,¶6¸&S¸96¬D4GG?@
BAB?CDDEF
G

£    ¹+ÀHMJNL:N:P:R:,¶T¶Xª%<Sj»[Y-¸]·b¶e¶iN§J»[Y-¸]·b¶e¶iN§3»[Y-¸]·b¶e¶iN§»[Y-¸]·b¶e¶iN§¬¸-½Y,¶lS¸96¬J!"&'()*D,X-[/o0r2†3‰56 8¢;¶<\    ¹¹?@
´op±CD­qD©rD¥sD¡tD¶EFu&ÿD
H^^^^^

vw

Õ
Ù+ÀHMxNz:|:~:€:,¶T¶Xª%<Sj»[Y-¸]·b¶e¶iN§J»[Y-¸]·b¶e¶iN§3»[Y-¸]·b¶e¶iN§»[Y-¸]·b¶e¶iN§
°‚:»[Y-¸]·b¶e¶iN-¸½Y,¶lS»„Y*·†¸‰:        °R@AHIJKLDNXO[QoRrT†U‰WX Z¢\¦]º^Öwf
ÙÙ?@
ÔopÑCDÍqDÉrDÅsDÁtD¦3DÖŽ    u&ÿD
H^^^^^

w

·Ã+À‘M“N•:,¹—
½:,Æi,¹—
ž`6§O,¹—
d »[Y¸]·bš¶e¶i:§»[Y¸]·bœ¶e¶i:,¹žS„
,¹—
¡ÿ¬»[Y-¸]·b¶e¶iN¢:»[Y-¸]·b¶e¶iN-¸»¤Y*·¦¸‰:°F{|~$‚*ƒ7„M…P†fˆs‚‹•Œ™­ŽÀ¡\    ÃÃ?@
¾Ž»CD·§D¬¨©'Zª«™*DÀ¬­
¾Ž®u"ÿ*
‘^^¯
%ú

°
€"+ÀM±N¸-½Y,¶"¸&S¸96¬¥¦§¨4""?@
ABCDEF
³

½
¶+À‘M»´Y·¶N»´Y·¶:,Ɔ,¹—
ž}6§l,¹žÀ:»[Y··b¶,¶e¹¶e¶"¶»¶i:¶¾W»[YÀ·b¶"¶»¶e¶i:²Ä¸É:    -    ¹ÍW„
,¹—
¡ÿ¸¸Î6»ÒY·Ô-¶ÕW¬>¬­ ®¯#°)±6²Y³aµ|¶†·°»§¼³½p¶¶?@
±Ž ©Ø ÙÚ&wª«6YABY6CD|ÛD†    ÜÝ    §EF­±ŽÞ ©Øßuÿ)
‘‘´
ûhú

à
6
¬
Á?@

áâ
\ãL+¸
»åY*·ç¸‰M,°ÅÌë CD
Ž
èw

·Ã+À‘MéN•:,¹—
½:,Æi,¹—
ž`6§O,¹—
d »[Y¸]·bš¶e¶i:§»[Y¸]·bœ¶e¶i:,¹žS„
,¹—
¡ÿ¬»[Y-¸]·b¶e¶iN¢:»[Y-¸]·b¶e¶iN-¸»ëY*·í¸‰:°Fïðòóõ$ö*÷7øMùPúfüsöÿ•
™

­
À
\    ÃÃ?@
¾Ž»CD·§D¬¨©'Zª«™*DÀ¬­
¾Ž®u"ÿ*
‘^^¯
%ú

îw
6

°

"?@
    ïð

-p»
Y·ñL»´Y·¶M,ò¸&¹ÍW»HY·óN-¸&¶ô-ø¶ú+¶ý:¹ÿ
:§¹

À:²
    ¶
¹

šÿå²
    ¹—
¶
±2
%
&
'
*$
+,
,2
B8
CP
DX
Cb
Fo
G>p

h

`Ž$Lop88¬PAB­
88¬ÞuÿD

‘H‘

 
!
""„¤åë