批量读取系统参数

81041

2019-01-11 fa00382db413a8489d07983b66f0869305b51a9a

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
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
Êþº¾4
¼
,com/fgkj/dao/impl/Battalarm_data_historyImpl
java/lang/Object
com/fgkj/dao/BaseDAO
com/fgkj/dao/CallBack
<init>
()V
Code
     

LineNumberTable
LocalVariableTable
this
.Lcom/fgkj/dao/impl/Battalarm_data_historyImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;
rs
Ljava/sql/ResultSet;
add
(Ljava/lang/Object;)Z
obj
Ljava/lang/Object;
update
del
delPro
&(Ljava/lang/Object;)Ljava/lang/String;
#com/fgkj/dto/Battalarm_data_history!
java/lang/StringBuilder#
9delete from db_alarm.tb_battalarm_data_history where num=
 %    &
(Ljava/lang/String;)V
()*
getNum
()Ljava/lang/Integer;
 ,-.
append
-(Ljava/lang/Object;)Ljava/lang/StringBuilder;
 012
toString
()Ljava/lang/String;
adata_h
%Lcom/fgkj/dto/Battalarm_data_history;
sql
Ljava/lang/String;
    searchAll
()Ljava/util/List;
serchByCondition
$(Ljava/lang/Object;)Ljava/util/List;
serchByInfo=
com/fgkj/dto/Batt_Maint_Dealarm
<?@A
getBinf
()Lcom/fgkj/dto/BattInf;
<CDE
getTdata
!()Lcom/fgkj/dto/Batttestdata_inf;
<GHI

getAdata_H
'()Lcom/fgkj/dto/Battalarm_data_history;
<KLM
getMainf
()Lcom/fgkj/dto/Batt_maint_inf;
<OPQ
getUinf
()Lcom/fgkj/dto/User_inf;S
U
SELECT FOUND_ROWS() number
WYX
com/fgkj/db/DBUtilZ[
getConn
()Ljava/sql/Connection;]
select SQL_CALC_FOUND_ROWS distinct(db_alarm.tb_battalarm_data_history.BattGroupId),db_alarm.tb_battalarm_data_history.num,alm_signal_id,db_alarm.tb_battalarm_data_history.monnum,alm_value,alm_level,alm_is_confirmed,alm_confirmed_time,alm_start_time,alm_end_time,   stationname,stationname5,battgroupname from db_alarm.tb_battalarm_data_history,db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    where  alm_id in(?,?,?,?,?,?,?)  and alm_signal_id%2 in(?,?)   and alm_level in(?,?,?,?)  and alm_start_time>=? and alm_start_time<=?   and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ?  and db_battinf.tb_battinf.stationname5 like ? _
 and db_battinf.tb_battinf.battgroupid!=? and db_alarm.tb_battalarm_data_history.battgroupid=db_battinf.tb_battinf.battgroupid a
 and db_battinf.tb_battinf.battgroupid=?  and db_alarm.tb_battalarm_data_history.battgroupid=db_battinf.tb_battinf.battgroupid 
ced
com/fgkj/dto/BattInff*
getBattGroupId
hji
java/lang/Integerkl
intValue
()I
npo
java/lang/Stringq
valueOf
 s-t
-(Ljava/lang/String;)Ljava/lang/StringBuilder;v

J and 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=? x
norder by db_alarm.tb_battalarm_data_history.alm_start_time desc,db_alarm.tb_battalarm_data_history.monnum asc z
 limit ?,? 
|~}
com/fgkj/dto/Batt_maint_inf*
    getUsr_id
|‚*
getFault_type_id
|„…*
getFault_level
|‡ˆ*
 getRecord_uid
|Š‹*
getMaint_type_id
|Ž*
 getMaint_done
|‘*
getMaint_close
“”*
    getAlm_id
–—*
getAlm_signal_id
|(
|e
|›œ*
getMaster_audit
|žŸ*
getAppoint_uid
¡¢£
getAlm_start_time
()Ljava/util/Date;
¥¦£
getAlm_start_time1¨

%
cª«2
getStationName1
c­®2
getStationName
c°±2
getStationName2
c³´2
getStationName5
¶¸·
com/fgkj/dto/User_inf¹*
getUId
<»¼½
getPage
()Lcom/fgkj/dto/Page;
¿ÁÀ
com/fgkj/dto/PageÂ*
getPageCurr
¿ÄÅ*
getPageSize
hÇqÈ
(I)Ljava/lang/Integer;Ê
.com/fgkj/dao/impl/Battalarm_data_historyImpl$1
ÉÌ    Í
1(Lcom/fgkj/dao/impl/Battalarm_data_historyImpl;)V
ÏÑÐ
com/fgkj/dao/DAOHelperÒÓ
executeQueryLimit
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;
Õ×Ö
com/fgkj/dao/LimitNumberFactoryØÙ
GetLimtitNumber
*(Ljava/sql/Connection;Ljava/lang/String;)IÛÝÜ
java/util/ListÞl
sizeÛàáâ
get
(I)Ljava/lang/Object;
¿äåæ

setPageAll
(Ljava/lang/Integer;)V
bmd
!Lcom/fgkj/dto/Batt_Maint_Dealarm;
binf
Lcom/fgkj/dto/BattInf;
tdata
Lcom/fgkj/dto/Batttestdata_inf;
adata_H
mainf
Lcom/fgkj/dto/Batt_maint_inf;
uinf
Lcom/fgkj/dto/User_inf;
    numberSql
conn
Ljava/sql/Connection;
baseSql
idSqlT
idSqlF
userSql
endSql
limitSql
list
Ljava/util/List;
number

I
LocalVariableTypeTable
3Ljava/util/List<Lcom/fgkj/dto/Batt_Maint_Dealarm;>;
 StackMapTable

com/fgkj/dto/Batttestdata_inf

java/sql/Connection
main
([Ljava/lang/String;)V

Exceptions


java/text/ParseException
 
¿ 
¿

æ
setPageCurr
¿

æ
setPageSize

java/text/SimpleDateFormat


yyyy-MM-dd

%


2000-01-01





parse
$(Ljava/lang/String;)Ljava/util/Date;


2020-01-01
| 
ÐÙ
|
#
$æ
    setUsr_id
ÐÚ
|
'
(æ
setFault_type_id
ÐÛ
|
+
,æ
setFault_level
ÐÜ
|
/
0æ
 setRecord_uid
ÐÝ
|
3
4æ
setMaint_type_id
ÐÞ
|
7
8æ
 setMaint_done
Ðß
|
;
<æ
setMaint_close
Ðà
|
?
@æ
setMaster_id
|
B
Cæ
setNum
|
E
Fæ
setBattGroupId
|
H
Iæ
setMaster_audit
|
K
Læ
setAppoint_uid
 

O
Pæ
    setAlm_id

R
Sæ
setAlm_signal_id

U
Væ
setAlm_cleared_type

X
Z
Y
com/fgkj/actions/ActionUtil
[
\
getSimpDate
"(Ljava/util/Date;)Ljava/util/Date;

^
_
`
setAlm_start_time
(Ljava/util/Date;)V

b
c
`
setAlm_start_time1
c 
c
f
g&
setStationName
c
i
j&
setStationName1
c
l
m&
setStationName2
c
o
p&
setStationName3
c
r
s&
setStationName5
c
E
¶ 
¶
w
xæ
setUId
< 
<
{
|
}
setPage
(Lcom/fgkj/dto/Page;)V
<

€


setAdata_H
((Lcom/fgkj/dto/Battalarm_data_history;)V
<
ƒ
„
…
setMainf
 (Lcom/fgkj/dto/Batt_maint_inf;)V
<
‡
ˆ
‰
setBinf
(Lcom/fgkj/dto/BattInf;)V
<
‹
Œ

setUinf
(Lcom/fgkj/dto/User_inf;)V


;:Û
‘
’
“
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
args
[Ljava/lang/String;
bimpl

p
Lcom/fgkj/dto/Page;
sdf
Ljava/text/SimpleDateFormat;
date1
Ljava/util/Date;
date2
adata

b
«
¸
java/util/Date

SourceFile
Battalarm_data_historyImpl.java
InnerClasses!


    

/

*·±



6

°
 


6
¬
%


6
¬
*


6
¬
/


k+ÀM» Y"·$,¶'¶+¶/N-°345*
3456
78
,


°
9

9:
6

°
>

;:
_++À<M,¶>N,¶B:,¶F:,¶J:,¶N:R:T:    ¸V:
\:^:`: -¶b¶gš» Y¸m·$¶r¶/:§» Y¸m·$ ¶r¶/:u:» Y¸m·$¶r¶/:w:y:» Y¸m·$¶r¶r¶/:
½Y¶{SY¶€SY¶ƒSY¶†SY¶‰SY¶ŒSY¶SY¶’SY¶•SY    ¶˜SY
¶™SY¶šSY¶SY ¶ SY¶¤SY» Y§·$-¶©¶r§¶r¶/SY» Y§·$-¶¬¶r§¶r¶/SY» Y§·$-¶¯¶r§¶r¶/SY» Y§·$-¶²¶r§¶r¶/SY-¶bSY¶µSY,¶º¶¾¶gd,¶º¶Ã¶gh¸ÆSY,¶º¶ÃS»ÉY*·Ë¸Î:
    ¸Ô6Æ+¹Ú
ž!¹Ú
d¹ßÀ<¶º¸Æ¶ã°Ò4bc
defg"h&i*j/k3„7…;†E‡[ˆ^‰tŒxŽ™’š–›±µž¼ŸÄ Ì¡Ô¢Ü£ä¤í¥ö¨ÿ©
«
¬
­
#®
,°
5±
>²
Z³
v´
’µ
®¹
¶º
¿¼
ݽ
å¾
í
òë
ûí
î(ðÀ++
&çè
!éêëìí4îï"    ðñ&56*
ò6    /
üóô
3
øõ67
ôö6;
ð÷6 x
³ø6’
™ù6–
•ú6
ò9ûü
û0ýþÿ

ò9û


rÿ^
<c
|¶nn
nnnÿ
³
<c
|¶nn
nnnnnnÛ
    




    G
§»
Y·
L»¿Y·
M,¸Æ¶
 ,è¸Æ¶
»
Y
·
N-
¶
:-
¶
:»|Y·
 :
!¸Æ¶
"
%¸Æ¶
&
)¸Æ¶
*
-¸Æ¶
.
1¸Æ¶
2
5¸Æ¶
6
9¸Æ¶
:
=¸Æ¶
>¸Æ¶
A¸Æ¶
D¸Æ¶
G¸Æ¶
J»Y·
M:¸Æ¶
N¸Æ¶
Qd¸Æ¶
T¸
W¶
]¸
W¶
a»cY·
d:R¶
eR¶
hR¶
kR¶
nR¶
q¸Æ¶
t»¶Y·
u:        ê¸Æ¶
v»<Y·
y:
 
,¶
z
¶
~
¶
‚
¶
†
    ¶
Š+
¶
Ž:¹

: § ¹
”
À<:²
š¶º¶
  ¹
¦
šÿⱺ.óôõö"

-
6
?
H
S
^
i
t
    

Š
•
 
©
²
»
Ä
Í
Ö
ß
é
ó
ý



 




 
"
!
)
"
2
%
;
&
F
'
O
(
U
)
\
*
c
+
j
,
q
-
y
.
‘
/
œ
.
¦
1„ 
§
ª
«
Ÿ
¬

—
­
®-
z
¯
°6
q
±
²?
h
³
²H
_îïÍÚ
´4
¡éê
;lðñ    
OXçè

y.ûü
‘
µèÿ

y.û


2ÿ
…
¶
¿

·
·|c¶<Û
•
¹
º
»

É