Êþº¾ 4
|
(
|
¡ ¢ £ ¤ ¥
|
¦
|
§ ¨
|
©
|
ª « ¬ ® ¬ ¯ ° ± ² ³ ² ´ ¬ µ
|
¶
|
· ¸ ¹
|
º » ¼ ½ ¾ ¿ À
|
Á Â Ã
|
Ä
|
Å
|
Æ Ç
|
È Ä
|
É Ê
|
Ë Ì
|
Í Î
|
Ï
|
Ð
|
Ñ Ò
|
Ó Ô
|
Õ Ö
|
×
|
Ø Ù
|
Ú Û
|
· Ü Ý Þ ß à á â ã ä DATABSE_TYPE_MYSQL Ljava/lang/String; ConstantValue DATABSE_TYPE_POSTGRE DATABSE_TYPE_ORACLE DATABSE_TYPE_SQLSERVER MYSQL_SQL POSTGRE_SQL
|
ORACLE_SQL SQLSERVER_SQL MYSQL_ALLTABLES_SQL POSTGRE__ALLTABLES_SQL ORACLE__ALLTABLES_SQL SQLSERVER__ALLTABLES_SQL MYSQL_ALLCOLUMNS_SQL POSTGRE_ALLCOLUMNS_SQL ORACLE_ALLCOLUMNS_SQL SQLSERVER_ALLCOLUMNS_SQL <init> ()V Code LineNumberTable LocalVariableTable this +Lorg/jeecg/common/util/dynamic/db/SqlUtils; dbTypeIsMySQL (Ljava/lang/String;)Z dbType MethodParameters dbTypeIsOracle dbTypeIsSQLServer dbTypeIsPostgre dbTypeIf ((Ljava/lang/String;[Ljava/lang/String;)Z type correctTypes [Ljava/lang/String; StackMapTable k
|
getFullSql 5(Ljava/lang/String;Ljava/util/Map;)Ljava/lang/String; sql params Ljava/util/Map; Y(Ljava/lang/String;Ljava/util/Map;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; value key Ljava/lang/Object; orderColumn orderBy
|
sqlBuilder Ljava/lang/StringBuilder; ¨ å æ getCountSql &(Ljava/lang/String;)Ljava/lang/String; createPageSqlByDBType :(Ljava/lang/String;Ljava/lang/String;II)Ljava/lang/String;
|
beginIndex I endIndex page rows beginNum sqlParam [Ljava/lang/Object; createPageSqlByDBKey dbKey dynamicSourceEntity 3Lorg/jeecg/common/system/vo/DynamicDataSourceModel; getAfterSelectInsertPoint (Ljava/lang/String;)I selectIndex selectDistinctIndex getAllTableSql 9(Ljava/lang/String;[Ljava/lang/Object;)Ljava/lang/String; getAllColumnSQL
|
SourceFile SqlUtils.java Y Z java/lang/String )org/jeecg/common/util/dynamic/db/SqlUtils mysql *org/jeecg/common/constant/DataBaseConstant 1 g h oracle 2 sqlserver 3
|
postgresql 4 ç a n s java/lang/StringBuilder SELECT t.* FROM ( è é ) t æ ê ë
|
WHERE 1=1 ì í î ï ð å ñ ò ó ô õ ö ÷ ø ù ú a AND ( è û = N' ') ORDER BY DESC ASC ü ý .SELECT COUNT(1) "total" FROM ( %s ) temp_count java/lang/Object þ ÷ ÿ ` a ,select * from ( {0}) sel_tab00 limit {1},{2} f a 3select * from ( {0}) sel_tab00 limit {2} offset {1} ü ÿ d a bselect * from (select row_.*,rownum rownum_ from ({0}) row_ where rownum <= {1}) where rownum_>{2} e a ÿ select * from ( select row_number() over(order by tempColumn) tempRowNumber, * from (select top {1} tempColumn = 0, {0}) t ) tt where tempRowNumber > {2} ý ý select select distinct
|
a Sselect distinct table_name from information_schema.columns where table_schema = {0} Pselect distinct colstable.table_name as table_name from user_tab_cols colstable 8SELECT distinct c.relname AS table_name FROM pg_class c 8select distinct c.name as table_name from sys.objects c `select column_name from information_schema.columns where table_name = {0} and table_schema = {1} =select column_name from all_tab_columns where table_name ={0} Hselect table_name from information_schema.columns where table_name = {0} (select name from syscolumns where id={0} java/util/Iterator java/util/Map equalsIgnoreCase append -(Ljava/lang/String;)Ljava/lang/StringBuilder; size ()I keySet ()Ljava/util/Set; java/util/Set iterator ()Ljava/util/Iterator; hasNext ()Z next ()Ljava/lang/Object; get &(Ljava/lang/Object;)Ljava/lang/Object; valueOf &(Ljava/lang/Object;)Ljava/lang/String; #org/apache/commons/lang/StringUtils
|
isNotBlank -(Ljava/lang/Object;)Ljava/lang/StringBuilder; toString ()Ljava/lang/String; format (I)Ljava/lang/String; java/text/MessageFormat java/lang/Integer substring 4org/jeecg/common/util/dynamic/db/DataSourceCachePool getCacheDynamicDataSourceModel G(Ljava/lang/String;)Lorg/jeecg/common/system/vo/DynamicDataSourceModel; 1org/jeecg/common/system/vo/DynamicDataSourceModel getDbType toLowerCase indexOf
|
isNotEmpty ! ( G H I J H I K H I L H I
|
M H I , N H I / O H I 2 P H I 6 Q H I ? R H I A S H I @ T H I B U H I C V H I E W H I D X H I F Y Z [ / *· ± \ ] ^ _ ` a [ = *½ YSYS¸ ¬ \ 2 ] b H c b d a [ = *½ YSY S¸ ¬ \ 6 ] b H c b e a [ = *½ Y
|
SY S¸ ¬ \ : ] b H c b f a [ = *½ Y SY S¸ ¬ \ > ] b H c b g h [ '+M,¾>6 ¢ ,2:*¶ ¬§ÿæ¬ \ E F G E % J ] i H ' b H ' j k l þ mø c b j n o [ < *+¸ ° \ V ] p H q r c p q n s [ ¼» Y· :¶ *¶ ¶ W+Æ +¹ ¡ ¶ W+¹ ¹ :¹ @¹ :+¹ ¸ :¸ ¶ ¶ ¶ ¶ !¶ W§ÿ¼,¸ .-¸ '"¶ ,¶ #¶ $-¶ $§ %¶ W¶ &° \ 2 e f g ( h 0 i P j ] k e l n o p ¶ s ] H ] $ t H P 1 u v ¼ p H ¼ q r ¼ w H ¼ x H ³ y z l 2 ý = { |û Cú k {ÿ } ~ } } { { } c p q w x [ 8 '½ (Y*S¸ )° \ } ] p H c p [ e d h6½ (:+S¸ *S ¸ *S*¸ + ,¸ -L§ a*¸ . /¸ -L§ O d h6 `6¸ 0S¸ 0S*¸ 1 2¸ -L§ *¸ 3 ++¸ 4¶ 5S6¸ -L+° \ N # * 5 < G N T ] f m x ] R N E T ?
b H p H l ý 5 ý 0ù c b p [ z *¸ 7:¶ 8:+ ¸ 9° \ « ¬ ] > H p H b H c p
|
[ #*¶ :;¶ <<*¶ :=¶ <= § `¬ \ ±
|
² ³ ] # p H
|
l ÿ } ÿ } c p [ 5*¸ > /*¸ +
|
?+¸ -°*¸ 1 @°*¸ . A°*¸ 3 B°° \ *
|
· ¸ ¹ º » ¼ & ½ ) ¾ 0 ¿ 3 Â ] 5 b H 5 q l c b q [ ¥ A*¸ > ;*¸ +
|
C+¸ -°*¸ 1
|
D+¸ -°*¸ .
|
E+¸ -°*¸ 3
|
F+¸ -°° \ *
|
Æ Ç È É Ê # Ë * Ì 1 Í 8 Î ? Ñ ] A b H A q l c b q
|
