修改

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
79
80
81
82
83
84
85
86
87
88
89
Êþº¾4
¿
'com/fgkj/dao/impl/ram/Fbs9600_stateImpl
java/lang/Object
com/fgkj/dao/BaseDAO
com/fgkj/dao/CallBack
<init>
()V
Code
     

LineNumberTable
LocalVariableTable
this
)Lcom/fgkj/dao/impl/ram/Fbs9600_stateImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;
java/util/ArrayList
 
com/fgkj/dto/ram/Fbs9600_state
 
num
java/sql/ResultSet !
getInt
(Ljava/lang/String;)I
#%$
java/lang/Integer&'
valueOf
(I)Ljava/lang/Integer;
)*+
setNum
(Ljava/lang/Integer;)V-
dev_ip/01
    getString
&(Ljava/lang/String;)Ljava/lang/String;
345
    setDev_ip
(Ljava/lang/String;)V7
dev_id
9:+
    setDev_id<
op_cmd
>?+
    setOp_cmdA
 dev_workstate
CD+
setDev_workstateF
dev_alarmstate
HI+
setDev_alarmstateK
 dev_commcount
MN+
setDev_commcountP
dev_errcommcount
RS+
setDev_errcommcountUWV
java/util/ListXY
add
(Ljava/lang/Object;)Z[\]
next
()Z
_a`
java/sql/SQLExceptionb

printStackTrace
rs
Ljava/sql/ResultSet;
list
Ljava/util/List;
fstate
 Lcom/fgkj/dto/ram/Fbs9600_state;

e
Ljava/sql/SQLException;
 StackMapTablem
Žinsert into db_ram_db.tb_Fbs9600_state(dev_ip,dev_id,op_cmd,dev_workstate,dev_alarmstate,dev_commcount,dev_errcommcount) values(?,?,?,?,?,?,?)
oqp
com/fgkj/db/DBUtilrs
getConn
()Ljava/sql/Connection;
uvw
    getDev_ip
()Ljava/lang/String;
yz{
    getDev_id
()Ljava/lang/Integer;
}~{
    getOp_cmd
€{
getDev_workstate
ƒ„{
getDev_alarmstate
†‡{
getDev_commcount
‰Š{
getDev_errcommcount
ŒŽ
com/fgkj/dao/DAOHelper
 executeUpdate
=(Ljava/sql/Connection;Ljava/lang/String;[Ljava/lang/Object;)Z
’”“
java/lang/Boolean&•
(Z)Ljava/lang/Boolean;
’—˜]
booleanValue
obj
Ljava/lang/Object;
fs
sql
Ljava/lang/String;
bl
Ljava/lang/Boolean;
update¢
?update db_ram_db.tb_Fbs9600_state set op_cmd=?   where dev_id=?
    updateProU¥¦§
iterator
()Ljava/util/Iterator;©«ª
java/util/Iterator\¬
()Ljava/lang/Object;
#®¯°
intValue
()I²
java/lang/StringBuilder´
-update db_ram_db.tb_Fbs9600_state set op_cmd=
±¶    5
±¸¹º
append
-(Ljava/lang/Object;)Ljava/lang/StringBuilder;¼
  
±¾¹¿
-(Ljava/lang/String;)Ljava/lang/StringBuilder;Á
  where dev_id=
±ÃÄw
toString
WÇ
启动É
的设备内阻测试    ËÍÌ
com/fgkj/dao/UinfDaoFactoryÎÏ
Increase

I
ËÑÒÓ

CreateULog
,(ILjava/lang/String;)Lcom/fgkj/dto/User_log;©ÕÖ]
hasNext
ŒØÙÚ
makeManualCommit
-(Ljava/sql/Connection;Ljava/util/ArrayList;)ZÜ
!com/fgkj/services/User_logService
Û 
Ûßàá
addPro
/(Ljava/lang/Object;)Lcom/fgkj/dto/ServiceModel;
sql_str
Ljava/util/ArrayList;
listU
msg
ulog
Lcom/fgkj/dto/User_log;

Z
LocalVariableTypeTable
2Ljava/util/List<Lcom/fgkj/dto/ram/Fbs9600_state;>;
)Ljava/util/List<Lcom/fgkj/dto/User_log;>;
delî
2delete from db_ram_db.tb_Fbs9600_state where num=?
ðñ{
getNum
searchByUid
$(Ljava/lang/Object;)Ljava/util/List;õ
com/fgkj/dto/User_inf÷
ù
sselect  distinct tb_Fbs9600_state.num,dev_ip,dev_id,op_cmd,dev_workstate,dev_alarmstate,dev_commcount,dev_errcommcount,  db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FbsDeviceName  from db_ram_db.tb_Fbs9600_state   left outer join db_battinf.tb_battinf ON tb_fbs9600_state.dev_id=db_battinf.tb_battinf.FBSDeviceId   where  tb_fbs9600_state.dev_id in(select distinct db_battinf.tb_battinf.FBSDeviceId  from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId    and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id   and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid   and db_user.tb_user_inf.uid=? ) û
* and tb_fbs9600_state.dev_id like '%9600%'ý
) or tb_fbs9600_state.dev_id like '%9616%'
ÿ



java/lang/String&

&(Ljava/lang/Object;)Ljava/lang/String;
ô

{
getUId

)com/fgkj/dao/impl/ram/Fbs9600_stateImpl$1


        


,(Lcom/fgkj/dao/impl/ram/Fbs9600_stateImpl;)V
Œ

 

executeQuery
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;
uinf
Lcom/fgkj/dto/User_inf;
baseSql
F9600sql
F9616sql
serchByCondition




getPage
()Lcom/fgkj/dto/Page;

 SELECT FOUND_ROWS() number


select SQL_CALC_FOUND_ROWS distinct tb_Fbs9600_state.num,dev_ip,dev_id,op_cmd,dev_workstate,dev_alarmstate,dev_commcount,dev_errcommcount, db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FbsDeviceName,COUNT(DISTINCT BattGroupId) as cnt  from db_ram_db.tb_Fbs9600_state left outer join db_battinf.tb_battinf ON tb_fbs9600_state.dev_id=db_battinf.tb_battinf.FBSDeviceId  where 

  dev_errcommcount=0  
 
  dev_errcommcount>0  
"
  dev_errcommcount>=0  
$
 and dev_id in(select distinct db_battinf.tb_battinf.FBSDeviceId  from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId    and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id   and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid   and db_user.tb_user_inf.uid=? ) 
&
" GROUP BY tb_fbs9600_state.dev_id 
(
 limit ?,? 

*
,
+
com/fgkj/dto/Page
-{
getPageCurr

*
/
0{
getPageSize
2
)com/fgkj/dao/impl/ram/Fbs9600_stateImpl$2

1
    
Œ
5
6

executeQueryLimit

8
:
9
com/fgkj/dao/LimitNumberFactory
;
<
GetLimtitNumber
*(Ljava/sql/Connection;Ljava/lang/String;)IU
>
?°
size

*
A
B+

setPageAllU
D
E
F
get
(I)Ljava/lang/Object;

H
I
J
setPage
(Lcom/fgkj/dto/Page;)V
page
Lcom/fgkj/dto/Page;
conn
Ljava/sql/Connection;
    numberSql
comSqlT
comSqlF
comSqlA

stationSql
groupSql
limitSql
number
X
java/sql/Connection
sendCmdToFBS9600Dev
(II)Z
\
AUPDATE db_ram_db.tb_fbs9600_state  SET  op_cmd=?  WHERE dev_id=? 
^
<SELECT op_cmd FROM db_ram_db.tb_fbs9600_state  WHERE dev_id=
±
`¹
a
(I)Ljava/lang/StringBuilder;
W
c
d
e
prepareStatement
0(Ljava/lang/String;)Ljava/sql/PreparedStatement;
g
i
h
java/sql/PreparedStatement
 
j
()Ljava/sql/ResultSet;ú

n
p
o
java/lang/Thread
q
r
sleep
(J)V

ta
u
java/lang/InterruptedException
o
w
x
y
close
@(Ljava/sql/ResultSet;Ljava/sql/Statement;Ljava/sql/Connection;)V
cmd
m_cmd
    m_cmd_ack
res_exe
ps
Ljava/sql/PreparedStatement;

n
 Ljava/lang/InterruptedException;
serchByInfo
„
com/fgkj/dto/BattInf
†
Bselect db_battinf.tb_battinf.battgroupid,db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.StationName5,db_battinf.tb_battinf.FBSDeviceId,db_battinf.tb_battinf.FBSDeviceIp,FbsDeviceName,db_battinf.tb_battinf.BattGroupName,db_battinf.tb_battinf.GroupIndexInFBSDevice,db_battinf.tb_battinf.MonCount,db_battinf.tb_battinf.MonVolStd,db_battinf.tb_battinf.MonCapStd,db_ram_db.tb_fbs9600_state.dev_ip,db_ram_db.tb_fbs9600_state.dev_id,db_ram_db.tb_fbs9600_state.op_cmd,db_ram_db.tb_fbs9600_state.dev_commcount,db_ram_db.tb_fbs9600_state.dev_errcommcount   FROM db_battinf.tb_battinf  LEFT OUTER JOIN db_ram_db.tb_fbs9600_state  on db_ram_db.tb_fbs9600_state.dev_id=db_battinf.tb_battinf.FBSDeviceId  where db_battinf.tb_battinf.StationName1 like ? and db_battinf.tb_battinf.StationName LIKE ?  and db_battinf.tb_battinf.battgroupid=? 
ˆ

%

ƒ
Š
‹w
getStationName1

ƒ

Žw
getStationName

ƒ

‘{
getBattGroupId
“
)com/fgkj/dao/impl/ram/Fbs9600_stateImpl$3

’
    
binf
Lcom/fgkj/dto/BattInf;
main
([Ljava/lang/String;)V

 
›
com/fgkj/dto/ram/Fbs9100_state

š 

š)

šR
ô 
ô
¡
¢+
setUId


¤òó    
¦
¨
§
java/lang/System
©
ª
out
Ljava/io/PrintStream;

¬
®
­
java/io/PrintStream
¯
°
println
(I)V

¬
²
¯
³
(Ljava/lang/Object;)V
args
[Ljava/lang/String;
fi
 Lcom/fgkj/dto/ram/Fbs9100_state;

f
µ
    searchAll
()Ljava/util/List;

SourceFile
Fbs9600_stateImpl.java
InnerClasses!

    

/

*·±




O£»Y·M§ˆ»Y·N-+¹¸"¶(-+,¹.¶2-+6¹¸"¶8-+;¹¸"¶=-+@¹¸"¶B-+E¹¸"¶G-+J¹¸"¶L-+O¹¸"¶Q,-¹TW+¹Z
šÿu§N-¶^,°
™œ_B "#$"%.&='L([)j*y+ˆ,"™.0¡24££cd
›ef}ghijküUû„K_
XY
·Q+ÀMlN¸n-½Y,¶tSY,¶xSY,¶|SY,¶SY,¶‚SY,¶…SY,¶ˆS¸‹¸‘:¶–¬679!:C9K;4QQ™š
L›hIœKžŸ
 Y
’,+ÀM¡N¸n-½Y,¶|SY,¶xS¸‹¸‘:¶–¬?@BCB&D4,,™š
'›h$œ&žŸ
£Y

î    º+ÀUM»Y·N»Y·:,¹¤
:§y¹¨
À:¶|¶­ 2»±Y³·µ¶|¶·»¶½À¶½¶x¶·¶Â:-¶ÅW»±YÆ·µ¶x¶·ȶ½¶Â:²Ê¸Ð:¹TW¹Ô
šÿƒ¸n-¸×6»ÛY·Ý¶ÞW¬BHI JK-L9MON\MaOhRƒST—K¡XªY·Zf
ºº™š
µef ­âã¤äf-jghaœƒå
æ窞èéµeê¤äëkRÿ!
UU©ÿF
UU©ÿ.
UU©
ìY
ƒ%+ÀMíN¸n-½Y,¶ïS¸‹¸‘:¶–¬^_`a4%%™š
 ›hœžŸ
òó
ÙM+ÀôMöNø:ú:ü:»±Y¸þ·µ¶½¶½¶ÂN-¸n½Y,¶
S»
Y*·
¸
:°"efgqrs.uJRMM™š
H

EœA
=
9
Jef

ó
ç
J+ÀM,¶
N¸n:
:ö:
:
:
:    
!:
,¶ˆ¶­š»±Y¸þ·µ¶½¶Â:§I,¶ˆ¶­ »±Y¸þ·µ    ¶½¶Â:§%,¶ˆ¶­d »±Y¸þ·µ
¶½¶Â:
#:»±Y¸þ·µ¶½¶Â:
%:
': »±Y¸þ·µ¶½ ¶½¶Â:½Y,¶ïSY-¶
)¶­d-¶
.¶­h¸"SY-¶
.S»
1Y*·
3¸
4:¸
76Æ-¹
=
ž#-¸"¶
@¹
=
d¹
CÀ-¶
G°j—˜
™š›œ£"¤'¥,¦6§L¨Z©pª«•®š´°¶µ¸ººÕ¼
Ø
Ù
'Ú
0Û
GÝ¢
J
J™š

E›h

@
K
L
;
M
N
6
O
2œ
-
"
(
P'
#
Q    ,

R
š°
Sµ•
Tº
U 
;ef
2
VÏé

;eêkaÿO

*
Wÿÿÿÿÿÿ#!ÿ±

*
WÿÿÿÿÿÿÿÿÿU


Y
Z
V â>6ª(QS(!R6§T6§¬6
[:¸n½Y¸"SY¸"S¸‹¸‘:¶–™ƒ»±Y
]ᵦ
_¶Â:¸n:
:    
:
6§O¹
b:        ¹
f
:
 
¹Z
™
;¹ 6§$:¶^
k¸
m§
:¶
s„
¡ÿ°
    ¸
v¬ƒ²µ_¼ÂÅ
t~ãäå æ'ç.è0ê3ë8îWï_ñiòmñrówôzõ}öƒùŽú—û¡ý¯ÿ²
µ
·
¼
    Â

Ç
ÌöÖ
ß
Žââ
zÏ
â7Ïà
{ÏÝ
|Ï3¯
}è8ªœW‹žŸwh
M
Nze
~
    }bcd
€V
€Ï·ijÇi
k:ý 


ÿR





ÿ’
W
g
q_H
túø

‚ó
Àb+À
ƒM
…N-¸n½Y»±Y
‡·µ,¶
‰¶½
‡¶½¶ÂSY»±Y
‡·µ,¶
Œ¶½
‡¶½¶ÂSY,¶
S»
’Y*·
”¸
:°

    
_
:4bb™š
]
•
–    Yœ_ef    
—
˜

.q»
Y·
™L»
šY·
œM,¸"¶
,¸"¶
ž»ôY·
ŸN-ê¸"¶
 +-¶
£:²
¥¹
=
¶
«¹¤
:§¹¨
À:²
¥¶
±¹Ô
šÿå±2
>
B
C
D 
K(
L2
M9
NF
O^
Pf
Op
R>q
´
µi
¶
a›
·(I

98ef^
¸hé
98eêkÿR
¹

šôU©

º
»
,


°

V

¼
½
¾

1
’