| commit | author | age | ||
| a18bfa | 1 | Êþº¾ 4U |
| Z | 2 | U ° ± ² ³ |
| 3 | ° ´ µ ¶ | |
| 4 | · ¸ < ¹ º | |
| 5 | » ¼ ½ | |
| 6 | ° | |
| 7 | ¾ ¿ | |
| 8 | À Á Â | |
| 9 | · Ã | |
| 10 | ||
| 11 | Ä Å Æ | |
| 12 | Ç È | |
| 13 | · É | |
| 14 | · Ê | |
| 15 | Ë Ì Í Î | |
| 16 | ||
| 17 | Ï Ð Ñ | |
| 18 | ||
| 19 | Ò Ð Ó Ô Ð Õ Ö × Ø Ù Ú Û Ù Ü Ý Þ Ð ß à á â ã ä å × æ ç è | |
| 20 | 0 ° é ê Ð ë ì í ì ß < î ï ð ñ ò Ý ó ô õ ö ÷ ø ù ú û ü ý þ | |
| 21 | ÿ | |
| 22 | Ç ì | |
| 23 | ||
| 24 | 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;>; | |
| 25 | 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; | |
| 26 | 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; | |
| 27 | 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 | |
| 28 | 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> | |
| 29 | SourceFile DatabaseMetaDateService.java (Lorg/springframework/stereotype/Service; e f V W Z [ java/util/ArrayList \ ] java/lang/String java/lang/StringBuilder ! -URL " .cn/autoform/fw/service/DatabaseMetaDateService ||replaceURL|| # $%& '() *+ , -. /0 003 12 3 4 56 TABLE 7 % 89 :; | |
| 30 | TABLE_NAME <= >2 ? f java/sql/SQLException c d SYSTEM ERROR!@ AB java/lang/ClassNotFoundException CD COLUMN_NAME java/util/HashMap SELECT FROM EF GH IJ | |
| 31 | ++++++++++ | |
| 32 | **********K LM N java/util/Map DBTYPE 001 mysql 002 oracle microsoft:sqlserver 进入方法提 jdbc: :// DBCONNECTIONSTRING O :?characterEncoding=utf8&useSSL=true&serverTimezone=GMT%2B8 *P GQR ST 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; | |
| 33 | 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 | |
| 34 | 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; ! U V W X Y Z [ X Y \ ] ^ _ ` a b c d e f g A *· *µ *µ ± h # i j k l m g @ » Y· N::*´ +,¹ :² ¶ ¹ À | |
| 35 | ¸ W² » Y· ¶ ¶ ¶ ¶ ¹ À | |
| 36 | ¶ ¶ :² ¶ ¶ :¶ : ¸ :: | |
| 37 | ¶ ¶ ¹ : | |
| 38 | § | |
| 39 | ¶ : | |
| 40 | ¹ :½ | |
| 41 | Y S: ¹ ! | |
| 42 | " ¹ # : ¹ $ - %¹ & ¹ ' W§ÿæÆ | |
| 43 | ¹ ( § :² *+¹ , § :² *+¹ , Æ | |
| 44 | ¹ ( § d:² *+¹ , § S:² *+¹ , Æ | |
| 45 | ¹ ( § 6:² *+¹ , § %: Æ | |
| 46 | ¹ ( § :² *+¹ , ¿-° | |
| 47 | é õ ø ) é -#& ) é7 )EQT ) ée e 7Ee gsv )ege h Î 3 > @ B F I / K U L X K ] M e N l O s Q ~ R S T V ¢ Y « [ ¶ ] Ì _ Ö ` é h î i õ m ø k ú l n b c h i# m& k( l4 n7 d9 eE hJ iQ mT kV lb ne gg hl is mv kx l m o i À Î n o ] p a l } q a s v r a g s a | |
| 48 | ¶ 3 t u Ì v w ú x y x z ( x y 9 x y V x y x x y j k { a | a } ~ ~ { } © ÿ ý ) ÿ B P B P B P ÿ B ÿ ^ g ) r» Y· :::*´ +,¹ :² ¶ ¹ À | |
| 49 | ¸ W² » Y· ¶ ¶ ¶ ¶ ¹ À | |
| 50 | ¶ ¶ :¶ : ¶ : | |
| 51 | ||
| 52 | ¸ :¹ :: ¶ ¶ ¹ : § | |
| 53 | ¶ : -"¹ . : ¹ $ /¹ & ¹ ' W§ÿåÆ | |
| 54 | ¹ ( § :² *+¹ , § :² *+¹ , Æ | |
| 55 | ¹ ( § d:² *+¹ , § S:² *+¹ , Æ | |
| 56 | ¹ ( § 6:² *+¹ , § %: Æ | |
| 57 | ¹ ( § :² *+¹ , ¿° | |
| 58 | Ñ Ý à ) Ñ ñ - ÿ ) Ñ )-9< ) ÑM ñ ÿM -M O[^ )MOM h Æ 1 | ~ 0 V Y ^ e l w ¤ ³ ½ Ñ £ Ö ¤ Ý ¨ à ¦ â § î © ñ ó ÿ £ ¤ ¨ ¦ § © ! - £2 ¤9 ¨< ¦> §J ©M ¢O £T ¤[ ¨^ ¦` §l ¨o ª i À µ n o ^ s p a e l q a l e r a | |
| 59 | M s a ³ v w â x y ó x z x y ! x y > x y ` x y r j k r { a r | a r a i ~ f c i ± ÿ ü ÿ B P B P B P ÿ B ÿ ^ g ² ]:::» 0Y· 1:*´ +,¹ :² ¶ ¹ À | |
| 60 | ¸ W² » Y· ¶ ¶ ¶ ¶ ¹ À | |
| 61 | ¶ ¶ : ¶ : | |
| 62 | ¶ : | |
| 63 | ¸ :¹ :: ¶ ¶ ¹ : § | |
| 64 | ||
| 65 | ¶ : -"¹ . : ¹ $ /¹ & :» Y· 2¶ ¶ 3¶ -¶ ¶ :» Y· :¹ 4 :¹ 5 :¹ 6 :¹ $ ¹ & ¹ ' W§ÿå¹ 7 W§ÿ{¹ ( :Æ | |
| 66 | ¹ 6 § :² *+¹ , Æ | |
| 67 | ¹ ( § é:² *+¹ , § Ø:² *+¹ , Æ | |
| 68 | ¹ 6 § :² *+¹ , Æ | |
| 69 | ¹ ( § :² *+¹ , § :² *+¹ , Æ | |
| 70 | ¹ 6 § :² *+¹ , Æ | |
| 71 | ¹ ( § S:² *+¹ , § B:Æ | |
| 72 | ¹ 6 § :² *+¹ , Æ | |
| 73 | ¹ ( § :² *+¹ , ¿° HTW )eqt ) H -¢ )°¼¿ ) HÐ )Þêí )û | |
| 74 | ) H ÐÞ ), ):FI ) h J R ¸ º ¼ ½ À à 3 Å Y Æ \ Å a È h É o Ê z Ì Í Î Ï Ñ § Ó ¶ Ô À Õ Ë Ö ê × ó Ù þ Ú Ü Ý ß à/ ä; å> æE çH ïM ðT ôW òY óe öj ÷q ût ùv ú ü é ê ï ð ô¢ ò¤ ó° öµ ÷¼ û¿ ùÁ úÍ üÐ ëÒ ìÞ ïã ðê ôí òï óû ö ÷ û | |
| 75 | ù ú ü î ï" ð) ô, ò. ó: ö? ÷F ûI ùK úW ûZ ý i Ë p a ê Q a ó H ~ 4 w ) n o a ç p a h à q a | |
| 76 | o Ù r a Á s a ¶ v w Y x y v x y x z ¤ x y Á x y Ò x y ï x y x y . x y K x y ] j k ] { a ] | a ] a Z W T K ] ó H K G ÿ ¡ ¢ ü ÿ Z ¡ ¢ ÿ ¡ ¢ ÿ ¡ ¢ B B P B B P B B P ÿ ¡ ¢ B B ÿ ¡ ¢ ^ £ ¤ ¥ g Ñ Î::² » Y· 8¶ ,¶ 9¶ -¶ ¶ ¶ *´ ,¹ : :¹ ; À <=¹ À | |
| 77 | :>¶ | |
| 78 | ?:§ "@¶ | |
| 79 | A:§ ¶ B:» Y· : *´ +,¹ : | |
| 80 | ² C¶ ² | |
| 81 | ¶ ¹ À | |
| 82 | ¸ W² ² | |
| 83 | ¶ ¹ À | |
| 84 | ¶ ² » Y· D¶ ¶ E¶ ¹ ; À <F¹ ¶ GH¶ ¶ ¶ » Y· D¶ ¶ E¶ ¹ ; À <F¹ ¶ GH¶ ¶ : | |
| 85 | ¶ : | |
| 86 | ¶ : ¸ :² ¶ I» Y· 2¶ ¶ 3¶ -¶ ¶ :¹ 4 :¹ J :¹ $ ¹ & ¹ ' W§ÿå¹ 6 :¹ ( :Æ | |
| 87 | ¹ 6 § : | |
| 88 | ² *+ | |
| 89 | ¹ , Æ | |
| 90 | ¹ ( § é: | |
| 91 | ² *+ | |
| 92 | ¹ , § Ø: | |
| 93 | ² *+ | |
| 94 | ¹ , Æ | |
| 95 | ¹ 6 § : | |
| 96 | ² *+ | |
| 97 | ¹ , Æ | |
| 98 | ¹ ( § : | |
| 99 | ² *+ | |
| 100 | ¹ , § : | |
| 101 | ² *+ | |
| 102 | ¹ , Æ | |
| 103 | ¹ 6 § : | |
| 104 | ² *+ | |
| 105 | ¹ , Æ | |
| 106 | ¹ ( § S: | |
| 107 | ² *+ | |
| 108 | ¹ , § B:Æ | |
| 109 | ¹ 6 § :² *+¹ , Æ | |
| 110 | ¹ ( § :² *+¹ , ¿ ° ¹ÅÈ )Öâå ) ¹ö - )!-0 ) ¹A )O[^ )lx{ ) ¹ ö AO )«·º ) h F Q | |
| 111 | ( 4 K U \ f m w { Ã ü 1$8%?&J'R*q+|012¥4¬5¯7¶8¹?¾@ÅEÈCÊDÖIÛJâOåMçNóPö9ø:? @ECD!I&J-O0M2N>PA;C<O?T@[E^C`DlIqJxO{M}NP>?@ECD«I°J·OºM¼NÈOËR i ( n o | |
| 112 | 1 p a 8 q a ? z r a q H a 2 w Ê x y | |
| 113 | ç x y | |
| 114 | ø x z | |
| 115 | x y | |
| 116 | 2 x y | |
| 117 | C x y | |
| 118 | ` x y | |
| 119 | } x y | |
| 120 | x y ¼ x y Î j k Î { a Î ¦ a Î a Î § a Ë È 4 ¨ ~ K © a J ~ 4 ¨ ª J ÿ \ ¡ ÿ ¡ ÿ | |
| 121 | ¡ B B P B B P B B P ÿ ¡ B B ÿ | |
| 122 | ¡ ^ « ¬ f g a» 0Y· 1³ ¸ K³ *² >L¹ 7 W² @M¹ 7 W² N¹ 7 W² OP¹ 7 W² QR¹ 7 W² ST¹ 7 W± h & & | |
| 123 | * - . , / 9 0 F 1 S 2 ` 3 ® X ¯ | |
