Êþº¾ 4r DataBase/DatabaseManagement java/lang/Object adressandport Ljava/lang/String; dbClassName dbUrl dbUser dbPwd dbName second conn Ljava/sql/Connection; sql Ljava/sql/PreparedStatement; <clinit> ()V Code java/lang/StringBuilder databaseadress system
|
PbuliClass/GetTxt getTxt 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
|
! # " java/lang/String $ % valueOf &(Ljava/lang/Object;)Ljava/lang/String;
|
' ( ) <init> (Ljava/lang/String;)V + :
|
- . / append -(Ljava/lang/String;)Ljava/lang/StringBuilder; 1 databaseport
|
3 4 5 toString ()Ljava/lang/String; 7 9 com.mysql.jdbc.Driver ; = jdbc:mysql:// ? /hxzkflow A C hxzkflow E G I L N dbPass P
|
|
R T S java/lang/Class U V forName %(Ljava/lang/String;)Ljava/lang/Class;
|
R X Y Z newInstance ()Ljava/lang/Object; \ 5?useUnicode=true&characterEncoding=utf-8&useSSL=false
|
^ ` _ java/sql/DriverManager a b getConnection M(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection; d .æ°æ®åºè¿æ¥åºé,请æ£æ¥æ°æ®åºå¯ç
|
f h g PbuliClass/ShowMessage i ) zidingyi
|
k m l java/lang/ClassNotFoundException n printStackTrace p 6请å°MySQLçJDBC驱å¨å
å¤å¶å°libæ件夹ä¸ã
|
r t s java/lang/System u v exit (I)V
|
x m y java/lang/Exception { java/sql/SQLException LineNumberTable LocalVariableTable e Ljava/sql/SQLException; "Ljava/lang/ClassNotFoundException; Ljava/lang/Exception; StackMapTable
|
( this LDataBase/DatabaseManagement; get_alldate_indatabase $(Ljava/lang/String;)Ljava/util/List; select * from
|
findForList database_name list Ljava/util/List; get_moudata_indatabase table_AandD 6(Ljava/lang/String;Ljava/lang/String;)Ljava/util/List; order by id tablename sj
|
table_base H(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List;
|
order by ziduan serch query ((Ljava/lang/String;)Ljava/sql/ResultSet;
|
£ ¤ ¡ findForResultSet QueryStr set Ljava/sql/ResultSet; delete (Ljava/lang/String;)I « æ°æ®åºæ° éæ©æ ç¾
|
¯ ± ° Method/BaoWenShow ² ³ show 9(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V
|
µ ¶ © update ¸ æ°æ®æ²¡æè¿æ¥æå... º ¼ » java/sql/Connection ½ ¾ createStatement (II)Ljava/sql/Statement; À  Á java/sql/Statement à ¡ executeQuery rs stmt Ljava/sql/Statement; È java/sql/ResultSet insert (Ljava/lang/String;)Z º Ì ½ Í ()Ljava/sql/Statement; À Ï Ð Ê execute º Ò Ó commit À Õ Ö close
|
z m result Z º Û Ü Ý setAutoCommit (Z)V À ß à © executeUpdate I ã java/util/ArrayList
|
â Ç æ ç è getMetaData ()Ljava/sql/ResultSetMetaData; ê ì ë java/sql/ResultSetMetaData í î getColumnCount ()I Ç ð ñ ò getString (I)Ljava/lang/String;
|
! ô õ ö isEmpty ()Z
|
! ø ù 5 trim û ý ü java/util/List þ ÿ add (Ljava/lang/Object;)Z Ç ö next æ°æ®åºæä½åºéï¼
|
f ) zidingyi_24 Ç Õ metaData Ljava/sql/ResultSetMetaData; colCount row i str LocalVariableTypeTable "Ljava/util/List<Ljava/util/List;>; $Ljava/util/List<Ljava/lang/String;>; get_columname '(Ljava/lang/String;)[Ljava/lang/String; ê ò getColumnName get table column err... dataname columname [Ljava/lang/String; data
|
columnName
|
insertfast ;(Ljava/lang/String;[Ljava/lang/String;[Ljava/lang/String;)Z" java/lang/StringBuffer$ INSERT & (
|
! ') ) VALUES (
|
!+ ., ,(Ljava/lang/String;)Ljava/lang/StringBuffer;. ,0 ? )2 ?,
|
! 3 º5 67 prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; 9;: java/sql/PreparedStatement <= setString (ILjava/lang/String;)V 9? à î 9 Õ
|
! tbname zhi succ ptmt lenth Ljava/lang/StringBuffer; e1 fast_alert_dbaseK update M set O where Q =? S =?U =?,
|
WYX zhuce/ZhuCeMan Z ö isGood insert_fast (Ljava/lang/String;I)V^ 9` a ) addBatch 9c de executeBatch ()[I
|
gih Method/About_tb_track j create_tb_trackl æ°æ®åå
¥æ°æ®åºåºé sqls datafrom pst
|
SourceFile DatabaseManagement.java !
|
s º» Y¸ ¸ · &*¶ ,0¸ ¶ ,¶ 2³ 68³ :» Y<· &² 6¶ ,>¶ ,¶ 2³ @B³ D³ F³ HJ¸ ³ KM¸ ³ O² HÇ P² :¸ Q¶ WW» Y² @¸ · &[¶ ,¶ 2² K² O¸ ]³ H§ "Kc¸ e§ K*¶ jo¸ e¸ q§ K*¶ w± v z R £ k R ´ x | R & + E J N R ! \ " f # l $ v % & ' + ¤ , ¨ - . ´ / µ 0 ¹ 2 } ~ ¤ ~ µ ~ ÷ zH kP x ( / *· ± | }
N » Y· &*¶ ,¶ 2¸ L+° |
|
: ; } ? *¸ L+° |
|
A B } a » Y· &*¶ ,¶ ,+¶ ,¶ 2¸ M,° |
|
K L } t (» Y· &*¶ ,¶ ,,¶ ,¶ ,+¶ ,¶ 2¸ N-° |
|
T & U } * ( ( ( & ? *¸ L+° |
|
[ \ } ¡ ? *¸ ¢L+° |
|
b c } ¥ ¦ § ¨ © ; *ª¬¸ ®*¸ ´¬ |
|
h i } ¤ ¡ º 0² HÇ
|
·¸ e°L² Hìï¹ ¹ M,*¹ ¿ L§ M,¶ w+° & ) x | & o p q s x y & z * { . } } * 0 ! Ä § Å Æ * ~ ÿ ! Ç x É Ê º 3*ª¬¸ ®<² H¹ Ë M,*¹ Î <² H¹ Ñ ,¹ Ô § M,¶ ׬
|
) , z | &
|
# ) - 1 } * 3
|
) Ø Ù Å Æ - ~ ÿ , ! z ¶ © Ç <*ª¬¸ ®<² H¹ Ë M² H¹ Ú ,*¹ Þ <² H¹ Ñ ,¹ Ô § M,¶ ׬
|
2 5 z | *
|
|
$ , 2 6 : } * <
|
2 Ø á Å Æ 6 ~ ÿ 5 ! z á » âY· äL*¸ ¢M,¹ å N-¹ é 6§ M» âY· ä:6§ .,¹ ï :Æ ¶ ó
|
¶ ÷:¹ ú W¤ÿÑ+¹ ú W,¹ ÿ°§ N» Y*¸ · &¶ ,¶ 2¸,¹ § N-¶ ×+° r u x z | R ¦ § © ª « ¬ ( . ® 8 ¯ E ° L ± V ` ³ i « r µ v ¶ º » ½ À } f
|
Ä § ^
|
V á ( A + 5 á 8 v ~ ~ ( A B ÿ ! û Ç ê ý ûü !ú ù ÿ ! û Ç xH z l lL» Y· &*¶ ,¶ 2¸ ¢MN,¹ å N-¹ é 6½ !L6§ -¹ :+dS¤ÿç§ :¸,¹ §
|
:¶ ×+° O R z Z ` c z | B Æ Ç È Ê Ë ' Ì - Í 3 Ï = Ð E Í O Ò T Ó Z × ` Ø e Ù j Ü } \ l j V Ä § T
|
' ( á 0 á = T ~ e ~ 4 ÿ 3 ! Ç ê ÿ ! Ç ê zH z ù
|
;>6:+¾6»!Y» Y#· &*¶ ,%¶ ,¶ 2·':6§ Ld #» Y+2¸ · &(¶ ,¶ 2¶*W§ » Y+2¸ · &-¶ ,¶ 2¶*W¡ÿ³6§ $d /¶*W§ 1¶*W¡ÿÛ¶3ª¬¸ ®² H¶3¹4 :² H¹ Ú §
|
:¶ ×6§ `,2¹8 §
|
: ¶ סÿà¹> 6² H¹ Ñ ¹@ §
|
:¶ × >»!Y·A: ¬ ¼ Ô × z ä ó ö z " z | $ å æ ç è ê , ë 2 í ; î X ï [ ð x ë ô ö ÷ ø ù ¦ ô ° ý ¼ ÿ Ë Ô Ù Þ ä ó ø ý $).0 9 } ;B ; ;C 9D Ù 6 Ø á 3E /F á , G / S á
+ á Ù H á & á ø ~ $ ~ h ÿ 2 ! 9! ( ÿ - ! 9! zü Q zÿ ! ! 9! z I Î
|
?>6:+¾6»!Y» YJ· &*¶ ,L¶ ,¶ 2·':6§ xd &» YN· &+2¶ ,P¶ ,¶ 2¶*W§ Id #» Y+2¸ · &R¶ ,¶ 2¶*W§ » Y+2¸ · &T¶ ,¶ 2¶*W¡ÿ¸V ¶3ª¬¸ ®² H¶3¹4 :² H¹ Ú §
|
:¶ ×6§ `,2¹8 §
|
: ¶ סÿà¹> >² H¹ Ñ ¹@ 6§
|
:¶ ×»!Y·A:¬ À Ø Û z è ÷ ú z ), z | ! & ' ( ) + ,, 2. ;/ [0 g1 2 3 ¤, ®6 ´7 À: Ï< Ø= Ý> âC èE ÷F üGC KLM"N&O)R.S3V<W } ?B ? ?C = Ø á :D Ù 7E 3F á , G / á Ý H å & á ü ~ . ~ O ÿ 2 ! 9! +( ú Z zü Q zÿ ' ! 9! z [\ ü Z*ª¬¸ ®² H¹ Ú ² H]¹4 M,*¹_ ,¹b W² H¹ Ñ ,¹@ § N ¸f» Yk· &*¶ ,¶ 2¸ e± 9 < z | 2 \ _ ` a $b +c 3d 9e =f Bg Ei Yk } * Zm Zn á o = ~ | zÿ ! z ÿ ! p q
|
