初始导入

zm

2020-05-18 a18bfacbf56b401f6e0fdae8710fbca4df8cff77

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
119
120
121
122
123
Êþº¾4
U
U°    ±    ²³
°´µ    ¶
·¸<¹º
»¼½
°
¾¿
ÀÁÂ
·Ã
 
Ä    ÅÆ
ÇÈ
·É
·Ê
ËÌÍÎ
 
ÏÐÑ
 
ÒÐÓÔÐÕÖ×ØÙÚÛÙÜÝÞÐßà    áâãäå×æçè
0°éêÐëìíìß<îïðñòÝóôõö÷øùúûüýþ
ÿ

Ç

ì








    




 

dbConnectionMapper
*Lcn/autoform/fw/mapper/DbConnectionMapper;
RuntimeVisibleAnnotations
8Lorg/springframework/beans/factory/annotation/Autowired;
datasourceMapper
4Lcn/autoform/web/mapper/datasource/DatasourceMapper;
    DBTYPEMAP
Ljava/util/Map;
    Signature
5Ljava/util/Map<Ljava/lang/String;Ljava/lang/String;>;

REPLACEURL
Ljava/lang/String;
 ConstantValue
logger
Lorg/slf4j/Logger;
<init>
()V
Code
LineNumberTable
LocalVariableTable
this
0Lcn/autoform/fw/service/DatabaseMetaDateService;
getDatabaseTableName
6(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List;
dbConnectionObj
1Lcn/autoform/db/entity/DBConnectionManagerEntity;
url
user
password
schema
types
[Ljava/lang/String;
rs
Ljava/sql/ResultSet;

e
Ljava/sql/SQLException;
"Ljava/lang/ClassNotFoundException;
tenantID
dataConnectionName
listTableNames
Ljava/util/List;

dbMetaData
Ljava/sql/DatabaseMetaData;
con
Ljava/sql/Connection;
LocalVariableTypeTable
$Ljava/util/List<Ljava/lang/String;>;
 StackMapTableÁº



u
àå

J(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Ljava/lang/String;>;
getDatabaseColumnsName
H(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List;

datasource
listColumnsNames
\(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Ljava/lang/String;>;
getDatabaseColumnsInfo
G(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Map;
columnsName
sql
    listValue
rsValue
pstmt
Ljava/sql/PreparedStatement;
rsMap
GLjava/util/Map<Ljava/lang/String;Ljava/util/List<Ljava/lang/String;>;>;
ô
(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/Map<Ljava/lang/String;Ljava/util/List<Ljava/lang/String;>;>;
getColumnsInfo
Z(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List;
databaseName

columnName
list
dbName
GLjava/util/List<Ljava/util/Map<Ljava/lang/String;Ljava/lang/Object;>;>;
n(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List<Ljava/lang/String;>;
<clinit>

SourceFile
DatabaseMetaDateService.java
(Lorg/springframework/stereotype/Service;efVWZ[
java/util/ArrayList


\]





java/lang/String



java/lang/StringBuilder
 
!
-URL
"

.cn/autoform/fw/service/DatabaseMetaDateService
||replaceURL||
#

$
%
&
'
(
)
*
+
,

-

.
/
0

003
1
2

3

4

5
6
TABLE
7


%

8
9

:
;

TABLE_NAME
<
=

>
2
?f
java/sql/SQLExceptioncd
 SYSTEM ERROR!
@
A
B
 java/lang/ClassNotFoundException
C
D
COLUMN_NAME
java/util/HashMap
SELECT 
 FROM 
E
F

G
H
I
J

++++++++++

**********
K
L
M

N
 java/util/Map
DBTYPE
001
mysql
002
oracle
microsoft:sqlserver
进入方法提
jdbc:
://
DBCONNECTIONSTRING
 
O
:?characterEncoding=utf8&useSSL=true&serverTimezone=GMT%2B8
*
P
G
Q
R
S
T
com.mysql.jdbc.Driver
oracle.jdbc.driver.OracleDriver
,com.microsoft.sqlserver.jdbc.SQLServerDriver
001-URL
>jdbc:mysql://||replaceURL||?characterEncoding=utf8&useSSL=true
002-URL
 jdbc:oracle:thin:@||replaceURL||
003-URL
jdbc:sqlserver://||replaceURL||
java/lang/Object
java/util/List
java/sql/DatabaseMetaData
java/sql/Connection
/cn/autoform/db/entity/DBConnectionManagerEntity
java/sql/ResultSet
java/lang/Throwable
java/sql/PreparedStatement
(cn/autoform/fw/mapper/DbConnectionMapper
queryDBconnectionManager
W(Ljava/lang/String;Ljava/lang/String;)Lcn/autoform/db/entity/DBConnectionManagerEntity;
    getdBType
()Ljava/lang/String;
get
&(Ljava/lang/Object;)Ljava/lang/Object;
java/lang/Class
forName
%(Ljava/lang/String;)Ljava/lang/Class;
append
-(Ljava/lang/String;)Ljava/lang/StringBuilder;
toString
getdBconnectionString
replace
D(Ljava/lang/CharSequence;Ljava/lang/CharSequence;)Ljava/lang/String;
java/lang/System
out
Ljava/io/PrintStream;
java/io/PrintStream
println
(Ljava/lang/String;)V
getdBUserID
 getdBPassword
java/sql/DriverManager
 getConnection
M(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
equals
(Ljava/lang/Object;)Z
    getSchema
toUpperCase
getMetaData
()Ljava/sql/DatabaseMetaData;

getCatalog
    getTables
_(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/sql/ResultSet;
next
()Z
    getString
&(Ljava/lang/String;)Ljava/lang/String;
add
close
org/slf4j/Logger
error
*(Ljava/lang/String;Ljava/lang/Throwable;)V

getColumns
^(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/ResultSet;
prepareStatement
0(Ljava/lang/String;)Ljava/sql/PreparedStatement;
executeQuery
()Ljava/sql/ResultSet;
put
8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;
2cn/autoform/web/mapper/datasource/DatasourceMapper
getDateName
$(Ljava/lang/String;)Ljava/util/List;
(I)Ljava/lang/Object;
-(Ljava/lang/Object;)Ljava/lang/StringBuilder;
(Ljava/lang/Object;)V
((Ljava/lang/String;)Ljava/sql/ResultSet;
org/slf4j/LoggerFactory
    getLogger
%(Ljava/lang/Class;)Lorg/slf4j/Logger;!UVW
X
YZ[
X
Y\]
^_`a
bcd
ef
gA
*·
*
µ*
µ±h     #i
jk
lmg@
‰»Y·N
:
:*´+,¹:²¶¹    À
¸W²»Y· ¶¶¶¶¹    À
¶¶:²¶¶:¶:        ¸::
¶¶™¹
:
§
¶:
¹
:½
Y S:¹!

"¹#:¹$
™-%¹&¹'W§ÿæÆ
¹(
§’:²*+¹,§:²*+¹,Æ
¹(
§d:²*+¹,§S:²*+¹,Æ
¹(
§6:²*+¹,§%: Æ
¹(
§:²*+¹, ¿-°
éõø)é
    -

#
&)é
7)
E
Q
T)é
e
    

e
7
E
e
g
s
v)
e
g
ehÎ3>@BFI/KULXK]MeNlOsQ~R‚ST›V¢Y«[¶]Ì_Ö`éhîiõmøkúl
n
    b
c
h
i
#m
&k
(l
4n
7d
9e
Eh
Ji
Qm
Tk
Vl
bn
eg
gh
li
sm
vk
xl
„m
‡oiÀÎno]Œpal}qasvra    ‚gsa
¶3tuÌvwúxy
xz
(xy
9xy
Vxy
xxy
‰jk
‰{a

‰|a
}~
~€
{‚ƒ

}„…©ÿ›†‡‡ˆ‰Š‹‡‡‡‡ý)Œÿ†‡‡ˆ‰ŠBŽPBŽPŽBŽPÿ †‡‡ˆ‰ŠBŽ ÿ†‡‡ˆ‰Š^‘
’“g)
r»Y·:
:
:*´+,¹:²¶¹    À
¸W²»Y· ¶¶¶¶¹    À
¶¶:¶:    ¶:
    
¸:¹
::¶¶™¹
:§
    ¶:
-"¹.:¹$
™/¹&¹'W§ÿåÆ
¹(
§’:²*+¹,§:²*+¹,Æ
¹(
§d:²*+¹,§S:²*+¹,Æ
¹(
§6:²*+¹,§%: Æ
¹(
§:²*+¹, ¿°
ÑÝà)Ññ-ÿ

)Ñ
)
-
9
<)Ñ
Mñÿ
M

-
M
O
[
^)
M
O
MhÆ1|    ~€„‡0‰VŠY‰^ŒelŽw€‘„’‘“•¤—³™½šÑ£Ö¤Ý¨à¦â§î©ñóžÿ£
¤
¨
¦
§
©
Ÿ
! 
-£
2¤
9¨
<¦
>§
J©
M¢
O£
T¤
[¨
^¦
`§
l¨
oªiÀµno^spaelqa    lera
„Msa³vwâxyóxz
xy
!xy
>xy
`xy
rjk
r{a

r|a
r”a    
i•~
f€
c‚ƒ
    
i•„…±ÿ†‡‡‡ˆ‰Š‹‡‡‡‡üÿ†‡‡‡ˆ‰ŠBŽPBŽPŽBŽPÿ †‡‡‡ˆ‰ŠBŽ ÿ†‡‡‡ˆ‰Š^–
—˜g²]
:
:
:»0Y·1:*´+,¹:²¶¹    À
¸W²»Y· ¶¶¶¶¹    À
¶¶:    ¶:
¶:    
¸:¹
::¶¶™¹
:§
 
¶:
-"¹.:  ¹$
™ /¹&:»Y· 2¶¶3¶-¶¶:»Y·:¹4:¹5
:¹6

:¹$
™¹&¹'W§ÿå¹7W§ÿ{¹(

:Æ
¹6
§:²*+¹,Æ
¹(
§é:²*+¹,§Ø:²*+¹,Æ
¹6
§:²*+¹,Æ
¹(
§ž:²*+¹,§:²*+¹,Æ
¹6
§:²*+¹,Æ
¹(
§S:²*+¹,§B:Æ
¹6
§:²*+¹,Æ
¹(
§:²*+¹,¿°
H
T
W)
e
q
t)
H
…-
“
Ÿ
¢)
°
¼
¿)
H
Ð)
Þ
ê
í)
û
)
H
…
“
Ð
Þ),):FI)h
JR¸º¼    ½ÀÃ3ÅYÆ\ÅaÈhÉoÊz͇̃ΔϠѧӶÔÀÕËÖê×óÙþÚ
Ü
Ý
ß
à
/ä
;å
>æ
Eç
Hï
Mð
Tô
Wò
Yó
eö
j÷
qû
tù
vú
‚ü
…é
‡ê
“ï
˜ð
Ÿô
¢ò
¤ó
°ö
µ÷
¼û
¿ù
Áú
Íü
Ðë
Òì
Þï
ãð
êô
íò
ïó
ûö÷û
ùúüîï"ð)ô,ò.ó:ö?÷FûIùKúWûZýi
Ëp™aêQšaóH›~
4œw
)noaçpa    hàqa
oÙra‡Ása¶’vw 
Yxy
vxy
‡xz
¤xy
Áxy
Òxy
ïxyxy.xyKxy]jk]{a
]|a]”aZ€W‚    TžKŸ]ƒóH›„KŸ …
Gÿ  †‡‡‡‰Š¡¢‹‡‡‡‡üÿZ†‡‡‡‰Š¡¢‹‡‡‡‡‡‡ˆÿ†‡‡‡‰Š¡¢‹‡‡‡‡ÿ†‡‡‡‰Š¡¢BŽ BŽPBŽ BŽPŽBŽ BŽPÿ †‡‡‡‰Š¡¢BŽ BŽ ÿ†‡‡‡‰Š¡¢^£
¤¥gÑÎ
:
:²»Y· 8¶,¶9¶-¶¶¶*´,¹::¹;À<=¹    À
:>¶™
?:§"@¶™
A:§¶™B:»Y·:    *´+,¹:
²C¶²
¶¹    À
¸W²²
¶¹    À
¶²»Y· D¶¶E¶¹;À<F¹    ¶GH¶¶¶»Y· D¶¶E¶¹;À<F¹    ¶GH¶¶:
¶:
¶:  ¸:²¶I»Y· 2¶¶3¶-¶¶:¹4:¹J:¹$
™    ¹&¹'W§ÿå¹6

:¹(

:Æ
¹6
§:
²*+
¹,Æ
¹(
§é:
²*+
¹,§Ø:
²*+
¹,Æ
¹6
§:
²*+
¹,Æ
¹(
§ž:
²*+
¹,§:
²*+
¹,Æ
¹6
§:
²*+
¹,Æ
¹(
§S:
²*+
¹,§B:Æ
¹6
§:²*+¹,Æ
¹(
§:²*+¹,¿    °
¹
Å
È)
Ö
â
å)„
¹
ö-)!-0)„
¹A)O[^)lx{)„
¹Œ
öŒAOŒŽš)«·º)ŒŽŒh
FQ
    


(
4
 K
U
\
f
m
w
{
„
‘
™
­
Ã
ü

1
$
8
%
?
&
J
'
R
*
q
+
|
0
‡
1
‘
2
¥
4
¬
5
¯
7
¶
8
¹
?
¾
@
Å
E
È
C
Ê
D
Ö
I
Û
J
â
O
å
M
ç
N
ó
P
ö
9
ø
:
?    
@
E
C
D!
I&
J-
O0
M2
N>
PA
;C
<O
?T
@[
E^
C`
Dl
Iq
Jx
O{
M}
N‰
PŒ
>Ž
?“
@š
E
CŸ
D«
I°
J·
Oº
M¼
NÈ
OË
Ri
‘
(no

1ˆpa
8qa
?zra 
qHša
‡2œw
Êxy

çxy

øxz
xy
2xy
Cxy
`xy
}xy
Ÿxy¼xyÎjkÎ{a
ΦaΔaΧaˁ‚ȝž4š¨~Kƒ©a„J›~    ƒ4š¨ª„J›„    …
 ÿ\    †‡‡‡‡Š¡ˆ‡ ÿ
†‡‡‡‡Š¡ˆ‡ˆ‹‡‡‡‡ÿ
†‡‡‡‡Š¡ˆ‡ˆBŽ BŽPBŽ BŽPŽBŽ BŽPÿ †‡‡‡‡Š¡ˆ‡ˆBŽ BŽ ÿ
†‡‡‡‡Š¡ˆ‡ˆ^«¬f
g™a»0Y·1³¸K³*²>L¹7W²@M¹7W²N¹7W²OP¹7W²QR¹7W²ST¹7W±
h&    &
*-.,/90F1S2`3­®X
¯