批量读取系统参数

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
Êþº¾4
·
'com/fgkj/dao/impl/Batt_DevdischargeImpl
java/lang/Object
com/fgkj/dao/BaseDAO
com/fgkj/dao/CallBack
tb_batt_devdischarge_CM
Ljava/lang/String;
tb_batt_devdischarge_CT
tb_batt_devdischarge_CU
<init>
()V
Code
 
 web_site.tb_batt_devdischarge_CM    
    

 web_site.tb_batt_devdischarge_CT    


 web_site.tb_batt_devdischarge_CU    


LineNumberTable
LocalVariableTable
this
)Lcom/fgkj/dao/impl/Batt_DevdischargeImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;%
java/util/ArrayList
$(
com/fgkj/dto/Batt_Devdischarge
'+
num-/.
java/sql/ResultSet01
getInt
(Ljava/lang/String;)I
354
java/lang/Integer67
valueOf
(I)Ljava/lang/Integer;
'9:;
setNum
(Ljava/lang/Integer;)V=
dev_id
'?@;
    setDev_idB
dev_name-DEF
    getString
&(Ljava/lang/String;)Ljava/lang/String;
'HIJ
setDev_name
(Ljava/lang/String;)VL
dev_recordtime-NOP
getTimestamp
((Ljava/lang/String;)Ljava/sql/Timestamp;
'RST
setDev_recordtime
(Ljava/util/Date;)VV
dev_vol-XYZ
getFloat
(Ljava/lang/String;)F
\^]
java/lang/Float6_
(F)Ljava/lang/Float;
'abc

setDev_vol
(Ljava/lang/Float;)Ve
dev_curr
'ghc
setDev_currj
    dev_power
'lmc
setDev_powero
note
'qrJ
setNotetvu
java/util/Listwx
add
(Ljava/lang/Object;)Z-z{|
next
()Z
~€
java/sql/SQLException
printStackTrace
rs
Ljava/sql/ResultSet;
list
Ljava/util/List;

bdischarge
 Lcom/fgkj/dto/Batt_Devdischarge;

e
Ljava/sql/SQLException;
 StackMapTableŒ
insert into web_site.tb_batt_devdischarge(dev_id,dev_name,dev_recordtime,dev_vol,dev_curr,dev_power,note) values(?,?,?,?,?,?,?)
Ž
com/fgkj/db/DBUtil‘’
getConn
()Ljava/sql/Connection;
'”•–
    getDev_id
()Ljava/lang/Integer;
'˜™š
getDev_name
()Ljava/lang/String;
'œž
getDev_recordtime
()Ljava/util/Date;
' ¡¢

getDev_vol
()Ljava/lang/Float;
'¤¥¢
getDev_curr
'§¨¢
getDev_power
'ª«š
getNote
­¯®
com/fgkj/dao/DAOHelper°±
 executeUpdate
=(Ljava/sql/Connection;Ljava/lang/String;[Ljava/lang/Object;)Z
³µ´
java/lang/Boolean6¶
(Z)Ljava/lang/Boolean;
³¸¹|
booleanValue
obj
Ljava/lang/Object;
sql
bl
Ljava/lang/Boolean;
updateÁ
update web_site.tb_batt_devdischarge set dev_id=?,dev_name=?,dev_recordtime=?,dev_vol=?,dev_curr=?,dev_power=?,note=? where num=?
delÄ
5delete from web_site.tb_batt_devdischarge where num=?
'Æǖ
getNum
    searchAll
()Ljava/util/List;Ë
mselect num,dev_id,dev_name,dev_recordtime,dev_vol,dev_curr,dev_power,note from web_site.tb_batt_devdischarge 
 
­ÎÏÐ
executeQuery
c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List;
serchByCondition
$(Ljava/lang/Object;)Ljava/util/List;Ô
com/fgkj/dto/BattInfÖ
Ø
java/lang/StringBuilderÚ
select 
×Ü J
×Þßà
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;â
.num,ä
.dev_id,æ

.dev_name,è
.dev_recordtime,ê
    .dev_vol,ì

.dev_curr,î
.dev_power,ð
.note,  ò
DISTINCTbattinf.FBSDeviceName 
×ôõš
toString÷
 from ù
¥,(select DISTINCT(FBSdeviceid),FBSDeviceName from db_battinf.tb_battinf where stationid like ? and stationname1 like ? and stationname2 like ? )  as DISTINCTbattinf,û

,ý

q where DISTINCTbattinf.FBSdeviceid=tb_batt_devdischarge_CM.dev_id and tb_batt_devdischarge_CT.dev_id=tb_batt_devdischarge_CM.dev_id and tb_batt_devdischarge_CU.dev_id=tb_batt_devdischarge_CM.dev_id and tb_batt_devdischarge_CT.record_num=web_site.tb_batt_devdischarge_CM.record_num and tb_batt_devdischarge_CU.record_num=web_site.tb_batt_devdischarge_CM.record_num  and ÿ
.dev_recordtime>=?  and 


.dev_recordtime<=(?)   
ÓÆ
3



intValue
()I

) and (tb_batt_devdischarge_CM.record_num%
×

ß

(I)Ljava/lang/StringBuilder;
 
T=0 or tb_batt_devdischarge_CM.record_num=? or tb_batt_devdischarge_CM.record_num=?) 


 ORDER BY 

    .dev_id ,

.dev_recordtime  




java/lang/String6

&(Ljava/lang/Object;)Ljava/lang/String;


%
Ó

š
getStationId
Ó

 š
getStationName1
Ó
"
#š
getStationName2
Ó
%
&ž
getBattProductDate
Ó
(
)ž
getBattProductDate1
Ó
+
,–
    getMonNum
Ó
.
/–
getMonCount
1
)com/fgkj/dao/impl/Batt_DevdischargeImpl$1

0
3 
4
,(Lcom/fgkj/dao/impl/Batt_DevdischargeImpl;)V
binf
Lcom/fgkj/dto/BattInf;
basesql
conditionSql
whereSql
number

I
roteN
endN
numSql
endSql
serchMaxAndMinNum
B
¦ SELECT COUNT(tb_batt_devdischarge_CM.record_num) AS number,MAX(tb_batt_devdischarge_CM.record_num) AS maxnum,MIN(tb_batt_devdischarge_CM.record_num) AS minnum  FROM 
D
q,(select DISTINCT(FBSdeviceid),FBSDeviceName from db_battinf.tb_battinf where stationid=? )  as DISTINCTbattinf  
F
F WHERE DISTINCTbattinf.FBSdeviceid=tb_batt_devdischarge_CM.dev_id and 
H
.dev_recordtime>=? and 
J
.dev_recordtime<=?  
L
LIMIT 1
N
)com/fgkj/dao/impl/Batt_DevdischargeImpl$2

M
3
serchByInfo
main
([Ljava/lang/String;)V

Exceptions
U
java/text/ParseException
W
java/text/SimpleDateFormat
Y

yyyy-MM-dd

VÜ
\

2000-01-01

V
^
_
`
parse
$(Ljava/lang/String;)Ljava/util/Date;
b

2020-01-01
Ó
e
42070450
Ó
g
hJ
setStationId
j
+湖北省-鄂州市-东方世纪城-设备1
Ó
l
mJ
setStationName
Ó
o
pJ
setStationName1
Ó
r
sJ
setBattProducer
Ó
u
v;
setMonCount

x
z
y
com/fgkj/actions/ActionUtil
{
|
getSimpDate
"(Ljava/util/Date;)Ljava/util/Date;
Ó
~
T
setBattProductDate
Ó

‚T
setBattProductDate1


„ÑÒt
†
‡
ˆ
iterator
()Ljava/util/Iterator;
Š
Œ
‹
java/util/Iterator{

()Ljava/lang/Object;

"com/fgkj/dto/Batt_Devdischarge_all    
‘
“
’
java/lang/System
”
•
out
Ljava/io/PrintStream;

—
™
˜
java/io/PrintStream
š
›
println
(Ljava/lang/Object;)V
Š

ž|
hasNextt
 
¡

size

—
£
š
¤
(I)V
args
[Ljava/lang/String;
bimpl
sdf
Ljava/text/SimpleDateFormat;
date1
Ljava/util/Date;
date2

b
$Lcom/fgkj/dto/Batt_Devdischarge_all;
LocalVariableTypeTable
6Ljava/util/List<Lcom/fgkj/dto/Batt_Devdischarge_all;>;
¦
³
java/util/Date

SourceFile
Batt_DevdischargeImpl.java
InnerClasses!
    
 
 
 

 
Q
*·*µ*µ*µ±

 !
"#

I»$Y·&M§‚»'Y·)N-+*¹,¸2¶8-+<¹,¸2¶>-+A¹C¶G-+K¹M¶Q-+U¹W¸[¶`-+d¹W¸[¶f-+i¹W¸[¶k-+n¹C¶p,-¹sW+¹y
šÿ{§N-¶},°
“–~B!"#"$1%=&I'X(g)v+‚,Š!“.—0›24 !‚ƒ
•„…w†‡—ˆ‰Šütû~K~
wx
¿Q+À'M‹N¸-½Y,¶“SY,¶—SY,¶›SY,¶ŸSY,¶£SY,¶¦SY,¶©S¸¬¸²:¶·¬"6789(:>;C8K<4Q !Qº»
L†‡I¼
K½¾
¿x
»Q+À'MÀN¸-½Y,¶“SY,¶—SY,¶›SY,¶ŸSY,¶£SY,¶¦SY,¶©S¸¬¸²:¶·¬@AB(C>DCBKE4Q !Qº»
L†‡I¼
K½¾
Âx
ƒ%+À'MÃN¸-½Y,¶ÅS¸¬¸²:¶·¬IJKL4% !%º»
 †‡¼
½¾
ÈÉ
[ÊL+¸
»
Y·Ì¸ÍM,°PQR  !¼

„…
ÑÒ
÷ ¼+ÀÓMÕN»×YÙ·Û*´¶Ýá¶Ý*´¶Ýã¶Ý*´¶Ýå¶Ý*´¶Ýç¶Ý*´¶Ýé¶Ý*´¶Ýë¶Ý*´¶Ýí¶Ý*´¶Ýï¶Ý*´¶Ýá¶Ý*´¶Ýã¶Ý*´¶Ýå¶Ý*´¶Ýç¶Ý*´¶Ýé¶Ý*´¶Ýë¶Ý*´¶Ýí¶Ý*´¶Ýï¶Ý*´¶Ýá¶Ý*´¶Ýã¶Ý*´¶Ýå¶Ý*´¶Ýç¶Ý*´¶Ýé¶Ý*´¶Ýë¶Ý*´¶Ýí¶Ý*´¶Ýï¶Ýñ¶Ý¶ó:»×Yö·Û*´¶Ýø¶Ý*´¶Ýú¶Ý*´¶Ý¶ó:»×Yü·Û*´¶Ýþ¶Ý*´¶Ý
¶Ý¶ó:,¶
¶
66è6        £    6§    pš     l6§    l`6»×Y
·Û¶
    
¶Ý¶ó:
»×Y
·Û*´¶Ý
¶Ý*´¶Ý
¶Ý¶ó:»×Y¸
·Û¶Ý¶Ý
¶Ý¶Ý¶óN-¸½Y»×Y
·Û,¶
¶Ý
¶Ý¶óSY»×Y
·Û,¶
¶Ý
¶Ý¶óSY»×Y
·Û,¶
!¶Ý
¶Ý¶óSY,¶
$SY,¶
'SY,¶
*SY,¶
-S»
0Y*·
2¸Í:°vZ[\]q^Ñ_
1`
6\
;b
hd
qi
Šd
k
˜l
›m
 n
§o
ªp
­q
µr
¼s
¿t
Èx
âz{/}Ÿ~´}¹®„ ¼ !¼º»
·
5
6´¼

;

7

h
T
8


-
9

˜
$
:
;
›
!
<
;
 

=
;    
âÚ
>
 
±
?
¹„…Š#ÿ
­

Ó








@Ò
ås+ÀÓM»×Y
A·Û*´¶Ý
C¶Ý
E¶Ý*´¶Ý
G¶Ý*´¶Ý
I¶Ý
K¶Ý¶óN-¸½Y,¶
SY,¶
$SY,¶
'S»
MY*·
O¸Í:°&    ²³´µ"¶<·B³F¹pÌ4s !sº»
n
5
6F-¼
p„…

PÒ
6

°
Ñ !º»
    
Q
R
S

T
–    §»
Y·ÌL»
VY
X·
ZM,
[¶
]N,
a¶
]:»ÓY·
c:
d¶
f
i¶
kÕ¶
nÕ¶
q¸2¶
t-¸
w¶
}¸
w¶
€+¶
ƒ:¹
…
:§¹
‰
À
Ž:²
¶
–¹
œ
šÿå²
¹
Ÿ
¶
¢±JÕÖ×Ø$Ù-Ú5Û=ÜDÝKÞTß]àgáoâ‡ãâ™å¦çR§
¥
¦Ÿ
§!
”
¨
©Œ
ª
«$ƒ
¬
«-z
5
6o8„…‡
­
®
¯
o8„
°Š#ÿ{    
±

V
²
²Ót
Š
´
µ
¶
0
M