修改

81041

2019-01-10 806c2b696a30c7c89b34e4f6a607283ff8339a6e

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
Êþº¾4
¡
#com/fgkj/dao/impl/FboDataUploadImpl
java/lang/Object
<init>
()V
Code
    
LineNumberTable
LocalVariableTable
this
%Lcom/fgkj/dao/impl/FboDataUploadImpl;
 uploadFboData
o(Lcom/fgkj/dto/User_inf;ILcom/fgkj/fbo/FboDataInf;Ljava/util/ArrayList;[Ljava/lang/String;Ljava/lang/Boolean;)Z
    Signature
‡(Lcom/fgkj/dto/User_inf;ILcom/fgkj/fbo/FboDataInf;Ljava/util/ArrayList<Lcom/fgkj/fbo/FboData;>;[Ljava/lang/String;Ljava/lang/Boolean;)Z

com/fgkj/db/DBUtil
getConn
()Ljava/sql/Connection;
$db_batt_testdata.tb_batttestdata_inf

com/fgkj/db/Upload
getBattTestRecordCountNew
+(ILjava/lang/String;Ljava/sql/Connection;)I
!#"
java/util/Calendar$%
getInstance
()Ljava/util/Calendar;    ')(
com/fgkj/fbo/FboDataInf*+
 TestStartTime
Lcom/fgkj/fbo/FboDateTime;    -/.
com/fgkj/fbo/FboDateTime01
year

I
!345
set
(II)V    -781
month    -:;1
day    -=>1
hour    -@A1
minute    -CD1
second    'FG1
DataTypeI
java/lang/StringBuilderK
$`db_batt_testdata`.`tb_BattTestData_
HMN
(Ljava/lang/String;)V
HPQR
append
(I)Ljava/lang/StringBuilder;T
` 
HVQW
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
HYZ[
toString
()Ljava/lang/String;]
(`db_batt_testdata`.`tb_BattTestDataStop__
)`db_batt_testdata`.`tb_BattTestData_FBO` a
CREATE TABLE IF NOT EXISTS c
(( `num` BIGINT NOT NULL AUTO_INCREMENT, e
&`BattGroupId` INT NOT NULL DEFAULT 0, g
,`test_record_count` INT NOT NULL DEFAULT 0, i
$`test_type` INT NOT NULL DEFAULT 0, k
+`data_new` BOOLEAN NOT NULL DEFAULT false, m
1`data_available` BOOLEAN NOT NULL DEFAULT false, o
%`record_num` INT NOT NULL DEFAULT 0, q
B`test_starttime` DATETIME NOT NULL DEFAULT '1982-01-01 00:00:00', s
?`record_time` DATETIME NOT NULL DEFAULT '1982-01-01 00:00:00', u
(`test_timelong` INT NOT NULL DEFAULT 0, w
&`group_vol` FLOAT NOT NULL DEFAULT 0, y
&`test_curr` FLOAT NOT NULL DEFAULT 0, {
%`test_cap` FLOAT NOT NULL DEFAULT 0, }
"`mon_num` INT NOT NULL DEFAULT 0, 
$`mon_vol` FLOAT NOT NULL DEFAULT 0, 
5INDEX index_test_record_count (`test_record_count`), ƒ
PRIMARY KEY (`num`));
…‡†
com/fgkj/dao/DAOHelperˆ‰
executeCreateTable
*(Ljava/sql/Connection;Ljava/lang/String;)Z‹
DROP TABLE IF EXISTS 
%CREATE TEMPORARY TABLE IF NOT EXISTS 
‘
java/lang/Boolean’“
booleanValue
()Z
•—–
java/util/ArrayList˜™
get
(I)Ljava/lang/Object;›
com/fgkj/fbo/FboData    šžŸ

m_TestTime
Lcom/fgkj/fbo/FboTestTime;    ¡=¢
com/fgkj/fbo/FboTestTime    ¡@    ¡C    š¦§¨
    SingleVol
[F?¹™™™™™š    '¬­1
BattSum¯
INSERT INTO ±

 ³
(BattGroupId, µ
test_record_count, ·
test_type, ¹

data_new, »
data_available, ½
record_num, ¿
test_starttime, Á
 record_time, Ã
test_timelong, Å
group_vol, Ç
test_curr, É

test_cap, Ë
    mon_num, Í
mon_vol)Ï
 VALUES 
ÑÓÒ
java/lang/StringÔÕ
valueOf
&(Ljava/lang/Object;)Ljava/lang/String;×
, Ù

(
HÛQÜ
(Z)Ljava/lang/StringBuilder;Þ

'
!àáâ
getTime
()Ljava/util/Date;ä
yyyy-MM-dd HH:mm:ss
æèç
com/fgkj/dto/Coméê
get_DTF
6(Ljava/util/Date;Ljava/lang/String;)Ljava/lang/String;ì
', î
java/util/Date
í        šñòó

SumVoltage

F
HõQö
(F)Ljava/lang/StringBuilder;    šøù¨

SubCurrent    šûü¨
SubCapþ

)
•




size
()I
Ñ
Ô

(I)Ljava/lang/String;@¬ 
•    


 (BattGroupId, 
•

 

add
(Ljava/lang/Object;)Z


<INSERT INTO TB_BattTestData_Inf   (BattGroupId, test_record_count, test_type, record_time_interval, data_new, data_available, record_num, test_starttime, test_starttype, record_time, test_timelong, test_stoptype,group_vol, test_curr, test_cap, max_monnum, max_monvol, min_monnum, min_monvol, upload_usr_id)  VALUES (    '

1
SaveInterval    '

1
Device    '

1
StopType    '



    SMaxIndex
[I    '

 ¨
SMaxVol    '
"
#

    SMinIndex    '
%
&¨
SMinVol

(
*
)
com/fgkj/dto/User_inf
+
,
getUId
()Ljava/lang/Integer;
H
.Q
/
-(Ljava/lang/Object;)Ljava/lang/StringBuilder;
1
) 
3
+UPDATE  TB_BattTestData_Inf  SET test_type=
5
record_time_interval=
7
    data_new=
9
data_available=
;
record_num=
=
test_starttime='
?
test_starttype=
A
 record_time='
C
test_timelong=
E
test_stoptype=
G

group_vol=
I

test_curr=
K
    test_cap=
M
max_monnum=
O
max_monvol=
Q
min_monnum=
S
min_monvol=
U
upload_usr_id=
W
 WHERE BattGroupId=
Y
 AND test_record_count=
[
    mon_vol) 
]
 SELECT 
_
 BattGroupId, 
a
mon_vol 
c
 FROM 
…
e
f
g
makeManualCommit
-(Ljava/sql/Connection;Ljava/util/ArrayList;)Z

i
k
j
java/lang/Exception
l
printStackTrace

n
o
p
close
@(Ljava/sql/ResultSet;Ljava/sql/Statement;Ljava/sql/Connection;)V
uinf
Lcom/fgkj/dto/User_inf;
bg_id
data_inf
Lcom/fgkj/fbo/FboDataInf;
al_fbo_data
Ljava/util/ArrayList;
row_data
[Ljava/lang/String;
bl
Ljava/lang/Boolean;

upload_res

Z
conn
Ljava/sql/Connection;
testRecordCount
ald
Ljava/util/Calendar;
    data_type
tb_name
Ljava/lang/String;
tb_stop_name
tmp_tb_name
sql_str
test_time_long
tmp_data
Lcom/fgkj/fbo/FboData;
cnt
sn

n
test_ah

D

al_sql_str
sql_str1
sql_str2

e
Ljava/lang/Exception;
LocalVariableTypeTable
-Ljava/util/ArrayList<Lcom/fgkj/fbo/FboData;>;
)Ljava/util/ArrayList<Ljava/lang/String;>;
 StackMapTable
y
œ
java/sql/Connection
ž
java/lang/Throwable

SourceFile
FboDataUploadImpl.java!


/

*·±


     A    †6¸:¸6¸ :        Ð,´&´,`¶2    ,´&´6¶2    ,´&´9¶2    ,´&´<¶2    ,´&´?¶2     ,´&´B¶26
ý,´EŸ6
»HYJ·L¶OS¶U¶X:»HY\·L¶OS¶U¶X:^: »HY`·L¶Ub¶Ud¶Uf¶Uh¶Uj¶Ul¶Un¶Up¶Ur¶Ut¶Uv¶Ux¶Uz¶U|¶U~¶U€¶U‚¶U¶X:¸„W»HY`·L¶Ub¶Ud¶Uf¶Uh¶Uj¶Ul¶Un¶Up¶Ur¶Ut¶Uv¶Ux¶Uz¶U|¶U~¶U€¶U‚¶U¶X:¸„W»HYŠ·L ¶U¶X:¸„W»HYŒ·L ¶Ub¶Ud¶Uf¶Uh¶Uj¶Ul¶Un¶Up¶Ur¶Ut¶Uv¶Ux¶Uz¶U|¶U~¶U€¶U‚¶U¶X:¸„W6
:6§¶Žš§-¶”Àš:´œ´ 6<h´œ´£`6<h´œ´¤`6ž>6§/´¥0©˜œ´¥-d¶”Àš´¥0Q„
,´«¡ÿλHY®·L ¶U°¶U²¶U´¶U¶¶U¸¶Uº¶U¼¶U¾¶UÀ¶U¶UĶUƶUȶUʶU̶UζU¶X:6§óž»HY¸Ð·LÖ¶U¶X:»HY¸Ð·LضU¶OÖ¶U¶OÖ¶U
¶OÖ¶U¶ÚÖ¶U¶ÚÖ¶U`¶OÖ¶UݶU    ¶ßã¸å¶Uë¶UݶU»íY·ïã¸å¶Uë¶U¶OÖ¶U´ð¶ôÖ¶U´÷0¶ôÖ¶U´ú0¶ôÖ¶U`¶OÖ¶U´¥0¶ôý¶U¶X:„
,´«¡ÿ
¸„6-¶ÿž »HY`dh-¶ÿl¸
·L¶XS„
-¶ÿ¡ý趎™7-¶ÿž0™+6´ú09
k‡o9´÷Q»•Y·
:»HY®·L¶U
    ¶U´¶U¶¶U¸¶Uº¶U¼¶U¾¶UÀ¶U¶UĶUƶUȶUʶU̶UζU¶X:6§óž»HY¸Ð·LÖ¶U¶X:»HY¸Ð·LضU¶OÖ¶U¶OÖ¶U
¶OÖ¶U¶ÚÖ¶U¶ÚÖ¶U-¶ÿ¶OÖ¶UݶU    ¶ßã¸å¶Uë¶UݶU»íY·ïã¸å¶Uë¶U¶OÖ¶U´ð¶ôÖ¶U´÷0¶ôÖ¶U´ú0¶ôÖ¶U`¶OÖ¶U´¥0¶ôý¶U¶X:„
,´«¡ÿ
¶
W»HY
·L¶OÖ¶U¶OÖ¶U
¶OÖ¶U,´
<h¶OÖ¶U¶ÚÖ¶U¶ÚÖ¶U-¶ÿ¶OÖ¶UݶU    ¶ßã¸å¶Uë¶U,´
¶OÖ¶UݶU»íY·ïã¸å¶Uë¶U¶OÖ¶U,´
¶OÖ¶U´ð¶ôÖ¶U´÷0¶ôÖ¶U´ú0¶ôÖ¶U,´
.`¶OÖ¶U,´
0¶ôÖ¶U,´
!.`¶OÖ¶U,´
$0¶ôÖ¶U*¶
'¶
-
0¶U¶X: 
»HY
2·L
¶OÖ¶U
4¶U,´
<h¶OÖ¶U
6¶U¶ÚÖ¶U
8¶U¶ÚÖ¶U
:¶U-¶ÿ¶OÖ¶U
<¶U    ¶ßã¸å¶Uë¶U
>¶U,´
¶OÖ¶U
@¶U»íY·ïã¸å¶Uë¶U
B¶U¶OÖ¶U
D¶U,´
¶OÖ¶U
F¶U´ð¶ôÖ¶U
H¶U´÷0¶ôÖ¶U
J¶U´ú0¶ôÖ¶U
L¶U,´
.`¶OÖ¶U
N¶U,´
0¶ôÖ¶U
P¶U,´
!.`¶OÖ¶U
R¶U,´
$0¶ôÖ¶U
T¶U*¶
'¶
-°¶U
V¶U¶O
X¶U¶O¶X:¶
W»HY®·L¶U°¶U
    ¶U´¶U¶¶U¸¶Uº¶U¼¶U¾¶UÀ¶U¶UĶUƶUȶUʶU
Z¶U
\¶U
^¶U´¶U¶¶U¸¶Uº¶U¼¶U¾¶UÀ¶U¶UĶUƶUȶUʶU
`¶U
b¶U ¶U¶X:¶
W¸
d6§#:¶
h6

¸
m§:

¸
m¿

¸
m¬®    Y    \
i®    f    p
Š
"      !("5#B$P%^&l'o(y)|+“,œ-¥,ª.®1·2¼3Á4Æ5Ë6Ð7Õ8Ú9ß:ä;é<î=ó>ø?ý@
A
B
C
1
E
G
'H
,I
1J
6K
;L
@M
EN
JO
OP
TQ
YR
^S
cT
hU
mV
rW
wX
|Y
G
†[
Ž]
¡`
¥_
©b
²c
·d
¼e
Áf
Æg
Ëh
Ði
Õj
Úk
ßl
äm
én
îo
óp
øq
ýrstbwvyz{%|-}0€;‚EƒJ„RƒU…Z†b…eˆj‰pŠ€‹™‰¥½‘̒֓à”–—˜)šM›iœz‡ž‘Ÿ¥ ·¡Ë¢æ£öšû–©    ª¨§¬­4{@±O²T´Wµa¶m·w¹€º”»£¼­½·¾Æ¿ÚºßÀåÁêÂÄÅ;ÆQÇ^ÈhÉ|ʎˢ̽ÍÍÄÒÀÞÏæÑðÛôÜùÝþÞßà áâã ä%å)æ.ç5è:é?êLëQìXí]îbïqðvñ{ò€ó‡ôŒõ”ö™÷£ø¨ù²ú·ûÂüÇýÐþÕÿà
å

Ñ




%
/
    4

:
>
C
 I
M
R
X
_
d
j
w
|
‚
‰
Ž
”
£
¨
®
³
¸
¾
 Å
!Ê
"Ð
#Ø
$Ý
%ã
&í
'ò
(ø
)
*
+ 
,
-
.#
/,
01
17
2B
3G
4M
5V
6[
7a
8h
9m
:s
;w
<‚
‡
>
@¢
A­
B¼
CË
DÚ
Eð
Fû
G    

H    
I    (
J    >
K    C
@    H
L    P
N    Y
P    ^
Q    c
R    f
U    p
S    r
U    y
V    |
U    ƒ
W
    †
q
r    †
s1
    †
t
u    †
v
w    †
x
y    †
z
{    ƒ
|
}    ~
~
    t
€1    o

‚    o    
ƒ1
“ó
„
…ªÜ
†
…®Ø
‡
… 
C
ˆ
…=
‰1:
Š
‹"
Œ1m8
1ü
Ž1aø

€Ù
‘
wâü
Ž1T
’
…    H
“
…    ^
”
•
–    †
v
—€Ù
‘
˜
™áÿ|
(
'•
š

›
!
ÿ
¨
(
'•
š

›
!
ÑÑÑÑ
š

ü?
(úüh
ûÔú5úþ¤•
ûÔÿ±
(
'•
š

›
!
ÑÑÑÑ
š•ÑÿÔ
(
'•
š

›
!
ÑÑÑ

iS


Ÿ