Êþº¾ 4x 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
|
publicclass/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:// ? /lixian A C lixian 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 publicclass/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_addtime limit 1000 H(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/List; where tagid= order by addtime tagid table_addtime1 £ order by delltime
|
table_base ¦
|
order by ¨ ziduan serch query ((Ljava/lang/String;)Ljava/sql/ResultSet;
|
® ¯ ¬ findForResultSet QueryStr set Ljava/sql/ResultSet; delete (Ljava/lang/String;)I
|
¶ · ´ 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 Í 1 Ï æ°æ®åºæ°
|
Ñ Ó Ò frame/Index1 Ô Õ baowen_show 9(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V » × ¾ Ø ()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 1 (
|
, '4 ) VALUES (
|
,6 .7 ,(Ljava/lang/String;)Ljava/lang/StringBuffer;9 ,; ? )= ?,? æ°æ®æå
¥æ°æ®åº...
|
, 3 »B CD prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; FHG java/sql/PreparedStatement IJ setString (ILjava/lang/String;)V FL ë ù F à
|
, tbname zhi succ ptmt lenth Ljava/lang/StringBuffer; e1 fast_alert_dbaseX update Z set \ where ^ =? ` =?b =?, insert_fast (Ljava/lang/String;I)V f
|
3i Fk l ) addBatch Fn op executeBatch ()[Ir æ°æ®åå
¥æ°æ®åºåºé 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 $ % & * ¤ + ¨ , - ´ . µ / ¹ 1 } ~ ¤ ~ µ ~ ÷ zH kP x ( / *· ± | }
N » Y· &*¶ ,¶ 2¸ L+° |
|
8 9 } ? *¸ L+° |
|
? @ } a » Y· &*¶ ,¶ ,+¶ ,¶ 2¸ M,° |
|
I J } f $» Y· &*¶ ,¶ ,+¶ ,¶ ,¶ 2¸ M,° |
|
N " O } $ $ " y -» Y· &*¶ ,¶ ,,¶ ,¶ ,+¶ ,¶ ,¶ 2¸ N-° |
|
S + T } * - - - + ¡ a » Y· &*¶ ,¢¶ ,+¶ ,¶ 2¸ M,° |
|
X Y } ¤ t (» Y· &*¶ ,¥¶ ,,¶ ,§¶ ,+¶ ,¶ 2¸ N-° |
|
a & b } * ( ( ( © & ª ? *¸ L+° |
|
h i } ª « ¬ ? *¸ L+° |
|
o p } ° ± ² ³ ´ / *¸ µ¬ | u } ¯ ¬ º 0² HÇ
|
¸¸ e°L² Hìï¹ º M,*¹ À L§ M,¶ w+° & ) x | & { | }
& * . } * 0 ! Å ² Æ Ç * ~ ÿ ! È x Ê Ë º 3*Ìθ Ð<² H¹ Ö M,*¹ Ù <² H¹ Ü ,¹ ß § M,¶ â¬
|
) , z | &
|
# ) - 1 } * 3
|
) ã ä Æ Ç - ~ ÿ , ! z · ´ » 4<² H¹ Ö M² H¹ å ,*¹ é <² H¹ Ü ,¹ ß § M,¶ ⬠* - z | & ¡ ¢ £ ¤ $ ¥ * § . ¨ 2 « } * 4 2 ã ì Æ Ç . ~ ÿ - ! 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 *+ ÷
|
9>6:+¾6»,Y» Y.· &*¶ ,0¶ ,¶ 2·2:6§ Ld #» Y+2¸ · &3¶ ,¶ 2¶5W§ » Y+2¸ · &8¶ ,¶ 2¶5W¡ÿ³6§ $d :¶5W§ <¶5W¡ÿÛ>Ìθ в H¶@¹A :² H¹ å §
|
:¶ â6§ `,2¹E §
|
: ¶ â¡ÿà¹K 6² H¹ Ü ¹M §
|
:¶ â >»,Y·N: ¬ º Ò Õ z â ñ ô z z | $ ð ñ ò ó õ , ö 2 ø ; ù X ú [ û x ö ÿ ¦ ÿ ° º
|
É Ò × Ü â ñ ö û "!'$,%.(7) } 9O 9 ©& 9P& 7Q ä 4 ã ì 1R -S ì , T / S ì
+ ì × U ß & ì ö ~ " ~ h ÿ 2 !))F, ( ÿ + !))F, zü Q zÿ ! !))F, z V+ Ù
|
9>6:+¾6»,Y» YW· &*¶ ,Y¶ ,¶ 2·2:6§ xd &» Y[· &+2¶ ,]¶ ,¶ 2¶5W§ Id #» Y+2¸ · &_¶ ,¶ 2¶5W§ » Y+2¸ · &a¶ ,¶ 2¶5W¡ÿ¶@Ìθ в H¶@¹A :² H¹ å §
|
:¶ â6§ `,2¹E §
|
: ¶ â¡ÿà¹K >² H¹ Ü ¹M 6§
|
:¶ â»,Y·N:¬ º Ò Õ z â ñ ô z#& z | 1 2 3 4 6 ,7 29 ;: [; g< = > ¤7 ®B ºE ÉG ÒH ×I ÜN âP ñQ öR ûNV WX Y Z#](^-a6c } 9O 9 ©& 9P& 7 ã ì 4Q ä 1R -S ì , T / ì × U ß & ì ö ~ ( ~ d ÿ 2 !))F, +( ÿ - !))F, zü Q zÿ ' !))F, z cd Ú W²e¶gÌθ в H¹ å ² Hh¹A M,*¹j ,¹m W² H¹ Ü ,¹M § N» Yq· &*¶ ,¶ 2¸ e± > A z | *
|
h k l "m )n 0o 8p >q Br Vt } * Ws Wt ì " u B ~ ÷ A z v w
|
