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

LineNumberTable
LocalVariableTable
this
$Lcom/fgkj/dao/impl/BattTest_ResImpl;

getResults
&(Ljava/sql/ResultSet;)Ljava/util/List;
rs
Ljava/sql/ResultSet;
add
(Ljava/lang/Object;)Z
obj
Ljava/lang/Object;
update
del
    searchAll
()Ljava/util/List;
serchByCondition
$(Ljava/lang/Object;)Ljava/util/List;!
com/fgkj/dto/Batt_Maint_Dealarm
 #$%
getBinf
()Lcom/fgkj/dto/BattInf;
 '()
getTdata
!()Lcom/fgkj/dto/Batttestdata_inf;
 +,-
getUinf
()Lcom/fgkj/dto/User_inf;
 /01
getPage
()Lcom/fgkj/dto/Page;3
java/util/ArrayList
2 
687
com/fgkj/db/DBUtil9:
getConn
()Ljava/sql/Connection;<
 SELECT FOUND_ROWS() number>
@
¬select SQL_CALC_FOUND_ROWS distinct(db_batt_testdata.tb_batttestdata_inf.BattgroupId),StationId,StationName,StationName1,StationName2,StationName5,BattGroupName,moncapstd,monvolstd,db_batt_testdata.tb_batttestdata_inf.num,db_batt_testdata.tb_batttestdata_inf.test_starttime,db_batt_testdata.tb_batttestdata_inf.test_record_count,db_batt_testdata.tb_batttestdata_inf.test_type,db_batt_testdata.tb_batttestdata_inf.test_starttype,db_batt_testdata.tb_batttestdata_inf.test_curr,db_batt_testdata.tb_batttestdata_inf.test_cap,db_batt_testdata.tb_batttestdata_inf.max_monvol,db_batt_testdata.tb_batttestdata_inf.min_monvol,db_batt_testdata.tb_batttestdata_inf.min_monnum,db_batt_testdata.tb_batttestdata_inf.data_new from db_batt_testdata.tb_batttestdata_inf   left outer join db_battinf.tb_battinf on db_battinf.tb_battinf.BattgroupId=db_batt_testdata.tb_batttestdata_inf.BattGroupId  where db_batt_testdata.tb_batttestdata_inf.data_available=1 B
ãselect SQL_CALC_FOUND_ROWS distinct(db_batt_testdata.tb_battresdata_inf.BattgroupId),StationId,StationName,StationName1,StationName2,StationName5,BattGroupName,moncapstd,monvolstd,db_batt_testdata.tb_battresdata_inf.num,db_batt_testdata.tb_battresdata_inf.test_starttime,db_batt_testdata.tb_battresdata_inf.test_record_count,db_batt_testdata.tb_battresdata_inf.test_type,db_batt_testdata.tb_battresdata_inf.Test_devtype,db_batt_testdata.tb_battresdata_inf.test_curr,db_batt_testdata.tb_battresdata_inf.data_new  from db_batt_testdata.tb_battresdata_inf   left outer join db_battinf.tb_battinf on  db_battinf.tb_battinf.BattgroupId=db_batt_testdata.tb_battresdata_inf.BattGroupId  where db_batt_testdata.tb_battresdata_inf.data_available=1 D
±and db_batt_testdata.tb_batttestdata_inf.test_type=? and to_days(record_time)>=to_days(?) and to_days(record_time)<=to_days(?) and to_days(test_starttime)<=to_days(record_time) F
±and db_batt_testdata.tb_battresdata_inf.test_type!=? and to_days(record_time)>=to_days(?) and to_days(record_time)<=to_days(?) and to_days(test_starttime)<=to_days(record_time) H
ºand db_batt_testdata.tb_batttestdata_inf.test_type in(?,2,3) and to_days(record_time)>=to_days(?) and to_days(record_time)<=to_days(?)  and to_days(test_starttime)<=to_days(record_time) 
JLK
com/fgkj/dto/Batttestdata_infMN
getTest_type
()Ljava/lang/Integer;
PRQ
java/lang/IntegerST
intValue
()IV
java/lang/StringBuilder
XZY
java/lang/String[\
valueOf
&(Ljava/lang/Object;)Ljava/lang/String;
U^    _
(Ljava/lang/String;)V
Uabc
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
Uefg
toString
()Ljava/lang/String;i
)and db_battinf.tb_battinf.BattGroupId!=? k
(and db_battinf.tb_battinf.BattGroupId=? 
mon
com/fgkj/dto/BattInfpN
getBattGroupIdr
ø and db_batt_testdata.tb_battresdata_inf.BattgroupId in(select distinct db_battinf.tb_battinf.battgroupid  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 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 ?)t
ú and db_batt_testdata.tb_batttestdata_inf.BattgroupId in(select distinct db_battinf.tb_battinf.battgroupid  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 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 ?)v

 x
_ and (test_starttype<5 and test_type not in(2,9) and  test_starttype!=2 AND test_starttype!=3) z
2 and (test_starttype=2 and test_type not in(2) )  |
2 and (test_starttype=3 and test_type not in(2) )  
J~N
getTest_starttype
A order by db_battinf.tb_battinf.BattgroupId,test_starttime desc  ƒ
 limit ?,? 
J…†‡
getRecord_time
()Ljava/util/Date;
J‰Š‡
getRecord_time1
ŒŽ
com/fgkj/dto/User_infN
getUId‘

%
m“”g
getStationName1
m–—g
getStationName
m™šg
getStationName2
mœg
getStationName5
Ÿ¡ 
com/fgkj/dto/Page¢N
getPageCurr
Ÿ¤¥N
getPageSize
P§[¨
(I)Ljava/lang/Integer;ª
$com/fgkj/dao/impl/BattTest_ResImpl$1
©¬    ­
'(Lcom/fgkj/dao/impl/BattTest_ResImpl;)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/impl/BattTest_ResImpl$2
´¬
¸º¹
com/fgkj/dao/LimitNumberFactory»¼
GetLimtitNumber
*(Ljava/sql/Connection;Ljava/lang/String;)I¾À¿
java/util/ListÁT
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;
uinf
Lcom/fgkj/dto/User_inf;
page
Lcom/fgkj/dto/Page;
list
Ljava/util/List;
conn
Ljava/sql/Connection;
    numberSql
Ljava/lang/String;
baseSql
baseTestSql

baseResSql
testSqlH
testSqlF
testSqlT
idSqlT
idSqlF
userR
userT
start_typeA
start_typeF
start_typeT
start_typeH
endSql
limitSql
number

I
LocalVariableTypeTable
3Ljava/util/List<Lcom/fgkj/dto/Batt_Maint_Dealarm;>;
 StackMapTableð
java/sql/Connection
main
([Ljava/lang/String;)V

Exceptionsõ
java/text/ParseException

 ø
java/text/SimpleDateFormatú

yyyy-MM-dd
÷^ý

2000-01-01
÷ÿ



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


2020-01-01
m 

    å†…蒙古
m

    _
setStationName
m

_
setStationName1
m

É
setBattGroupId
J 
J

É
setTest_type
J

É
setTest_starttype




com/fgkj/actions/ActionUtil


getSimpDate
"(Ljava/util/Date;)Ljava/util/Date;
J


 
setRecord_time
(Ljava/util/Date;)V
J
"
#
 
setRecord_time1
Π
Œ
&
'É
setUId
Ÿ 
Ÿ
*
+É
setPageCurr
Ÿ
-
.É
setPageSize
  
 
1
2
3
setPage
(Lcom/fgkj/dto/Page;)V
 
5
6
7
setBinf
(Lcom/fgkj/dto/BattInf;)V
 
9
:
;
setTdata
"(Lcom/fgkj/dto/Batttestdata_inf;)V
 
=
>
?
setUinf
(Lcom/fgkj/dto/User_inf;)V


A¾
C
D
E
iterator
()Ljava/util/Iterator;
G
I
H
java/util/Iterator
J
K
next
()Ljava/lang/Object;    
M
O
N
java/lang/System
P
Q
out
Ljava/io/PrintStream;

S
U
T
java/io/PrintStream
V
W
println
(Ljava/lang/Object;)V
G
Y
Z
[
hasNext
()Z

S
]
V
^
(I)V
args
[Ljava/lang/String;
bimpl
sdf
Ljava/text/SimpleDateFormat;
date1
Ljava/util/Date;
date2

p

b
`
k
java/util/Date
serchByInfo

SourceFile
BattTest_ResImpl.java
InnerClasses!
    
    

/

*·±



6

°
!


6
¬
&


6
¬
+


6
¬
0


,


°
5


´Q+À M,¶"N,¶&:,¶*:,¶.:»2Y·4:¸5:;:    =:
?:A:C: E:G:¶I¶O »UY¸W·] ¶`¶d:
§™¶I¶O »UY¸W·] ¶`¶d:
§t¶I¶O     »UY¸W·] ¶`¶d:
§N¶I¶Oˆ »UY¸W·]¶`¶d:
§'¶I¶O¸ »UY¸W·]¶`¶d:
h:j:-¶l¶Oš»UY
¸W·]¶`¶d:
§»UY
¸W·]¶`¶d:
q:s:¶I¶Oˆ »UY
¸W·]¶`¶d:
§»UY
¸W·]¶`¶d:
¶I¶OˆŸ£u:w:y:{:¶}¶Oš»UY
¸W·]¶`¶d:
§o¶}¶O »UY
¸W·]¶`¶d:
§J¶}¶O »UY
¸W·]¶`¶d:
§%¶}¶O »UY
¸W·]¶`¶d:
€:»UY
¸W·]¶`¶d:
‚:»UY
¸W·]¶`¶d:
¶I¶Oˆ Õ
½Y¶ISY¶„SY¶ˆSY-¶lSY¶‹SY»UY·]-¶’¶`¶`¶dSY»UY·]-¶•¶`¶`¶dSY»UY·]-¶˜¶`¶`¶dSY»UY·]-¶›¶`¶`¶dSY    ¶ž¶Od¶£¶Oh¸¦SY
¶£S»©Y*·«¸®:§Ò
½Y¶ISY¶„SY¶ˆSY-¶lSY¶‹SY»UY·]-¶’¶`¶`¶dSY»UY·]-¶•¶`¶`¶dSY»UY·]-¶˜¶`¶`¶dSY»UY·]-¶›¶`¶`¶dSY    ¶ž¶Od¶£¶Oh¸¦SY
¶£S»´Y*·¶¸®:    ¸·6Æ+¹½
ž!¹½
d¹ÂÀ ¶.¸¦¶Æ°
.K

%*.    2
6:>BFRh w!"#³$Ä%Ú&ë'

*
+
    ,
-
).
,/
B3
F:
JA
XB
nC
qD
‡G
•J
™L
N
¡P
¥Q
°R
ÆS
ÕT
ëU
úVWX5\9]O_S`icwd{e‚fšg¡hi9lAdF•I–M—T˜l™sšë›–Ì!Í0ÎNÐ
QQ
LÊË
GÌÍAÎÏ;ÐÑ5ÒÓ%,ÔÕ*'Ö×.#ØÙ    2ÚÙ
6ÛÙ:ÜÙ>ÝÙ BÞÙFßÙ
LàÙ
    HáÙ
FâÙ
JãÙ
™œäÙ
˜åÙ
¡”æÙ
¥çÙ9èÙS
þéÙ!0êëì
%,Ôíîõÿk
 mJŒŸ¾ïXXXXXXX$%&#ý*XXý.XXÿA
 mJŒŸ¾ïXXXXXXXXXXXXXXX$$ÿ!
 mJŒŸ¾ïXXXXXXXXXXXý
XXûÎü5
    ñòó
ô[ 
»
Y·öL»÷Yù·ûM,ü¶þN,
¶þ:»mY·
:
¶

¶

¸¦¶
 »JY·
:¸¸¦¶
¸¦¶
-¸
¶
¸
¶
!»ŒY·
$:긦¶
%»ŸY·
(:¸¦¶
)2¸¦¶
,» Y·
/:        ¶
0    ¶
4    ¶
8    ¶
<+    ¶
@:
 
¹
B
:§¹
F
À :²
L¶"¶
R¹
X
šÿâ²
L
¹½
¶
\±vÔÕÖ×"Ù+Ú3Û;ÜDëMìXíaîjïtñ}òˆô‘õšö¤ø­ù´ú»ûÂýÉÿÑ
éô
þ
z

_
`

a
ú
b
có
d
e"ê
f
e+áÌÍM¿ÎÏ}ÐÑ‘{
gÓ­_ÊË    Ñ;ÔÕ
é
hËì
Ñ;Ôí
î/ÿÝ 
i
÷
j
jmJŒŸ ¾
G

l
6

°
    

m
n
o©´