Êþº¾ 47 #com/backup/DataBaseBackUpThread_SQL java/lang/Object DataBase_Backup_Table Ljava/lang/String; ConstantValue tb_database_backup <init> ()V Code
|
|
LineNumberTable LocalVariableTable this %Lcom/backup/DataBaseBackUpThread_SQL; createBackupTable (Lcom/sql/MysqlConnPool;)V vCREATE TABLE IF NOT EXISTS `tb_database_backup` ( `num` int(11) NOT NULL AUTO_INCREMENT, `database_name` varchar(64) NOT NULL, `table_name` varchar(64) NOT NULL, `backup_en` int(11) NOT NULL DEFAULT '0', `backup_flag` int(11) NOT NULL DEFAULT '0', `note` varchar(64) NOT NULL DEFAULT 'ä¿ç', PRIMARY KEY (`num`)) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; com/sql/Sql_Mysql
|
com/sql/MysqlConnPool getConn ()Ljava/sql/Connection;
|
|
! (Ljava/sql/Connection;)V # web_site
|
% & ' sqlMysqlUseDB (Ljava/lang/String;)V
|
) * + sqlMySqlExecute (Ljava/lang/String;)Z
|
- / . java/lang/Exception 0 printStackTrace
|
2 3 close_con conn_pool Lcom/sql/MysqlConnPool; sql_str sql Lcom/sql/Sql_Mysql; e Ljava/lang/Exception; StackMapTable = java/lang/String ? java/lang/Throwable inseartBackupTable *(Lcom/sql/MysqlConnPool;Ljava/util/List;)V Signature F(Lcom/sql/MysqlConnPool;Ljava/util/List<Lcom/backup/DatabaseTable;>;)V E java/util/ArrayList
|
D H J I java/util/List K L get (I)Ljava/lang/Object; N com/backup/DatabaseTable
|
P Q R checkTableIsExist 4(Lcom/sql/MysqlConnPool;Lcom/backup/DatabaseTable;)Z T java/lang/StringBuilder V _INSERT INTO `tb_database_backup`(database_name,table_name,backup_en,backup_flag,note) VALUES ('
|
S X
|
'
|
M Z [ \ getDatabase_name ()Ljava/lang/String;
|
S ^ _ ` append -(Ljava/lang/String;)Ljava/lang/StringBuilder; b ', '
|
M d e \ getTable_name g ', '0', '0', '');
|
S i j \ toString
|
D l m n add (Ljava/lang/Object;)Z H p q r size ()I
|
t u v makeManualCommit (Ljava/util/ArrayList;)Z list Ljava/util/List; al_sql_strs Ljava/util/ArrayList; i I LocalVariableTypeTable ,Ljava/util/List<Lcom/backup/DatabaseTable;>; )Ljava/util/ArrayList<Ljava/lang/String;>; D SELECT num FROM web_site.tb_database_backup WHERE database_name =' ' AND table_name='
'
|
sqlMysqlQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; java/sql/ResultSet next ()Z
|
/ java/sql/SQLException close pool table Lcom/backup/DatabaseTable; isExist Z rs Ljava/sql/ResultSet; Ljava/sql/SQLException; searchAllDataBaseAndTable )(Lcom/sql/MysqlConnPool;)Ljava/util/List; E(Lcom/sql/MysqlConnPool;)Ljava/util/List<Lcom/backup/DatabaseTable;>; ¢ SHOW DATABASES ¤ database ¦ § ¨ getString &(Ljava/lang/String;)Ljava/lang/String; ª information_schema
|
< ¬ n equals ¯ mysql ± performance_schema ³ sys
|
µ ¶ + isSpecialChar
|
M
|
M ¹ º ' setDatabase_name H l ½ ¿ ESELECT table_name FROM information_schema.tables WHERE table_schema='
|
M Á Â Ã clone ()Lcom/backup/DatabaseTable; Å
|
table_name
|
M Ç È ' setTable_name sql_database_str dbs db sql_table_str obj searAllTableState Ð k SELECT num,database_name,table_name,backup_en,backup_flag,note FROM tb_database_backup Where backup_en=1 Ò num Ô Õ Ö getInt (Ljava/lang/String;)I
|
M Ø Ù Ú setNum (I)V Ü database_name Þ backup_en
|
M à á Ú
|
setBack_en ã backup_flag
|
M å æ Ú setBackup_flag è note
|
M ê ë ' setNote DataBaseBackUp_StartTime (Lcom/sql/MysqlConnPool;F)V
|
ï ð ' sqlMysqlExecute mVersionnum F UpdateDataBaseState 4(Lcom/sql/MysqlConnPool;Lcom/backup/DatabaseTable;)V ö 6 UPDATE web_site.tb_database_backup SET backup_en =
|
M ø ù r
|
getBack_en
|
S û _ ü (I)Ljava/lang/StringBuilder; þ WHERE database_name=' ' AND table_name = ' [ \/:*?"<>|]
|
java/util/regex/Pattern
|
compile -(Ljava/lang/String;)Ljava/util/regex/Pattern;
|
matcher 3(Ljava/lang/CharSequence;)Ljava/util/regex/Matcher;
|
java/util/regex/Matcher find str regEx p Ljava/util/regex/Pattern; m Ljava/util/regex/Matcher; main ([Ljava/lang/String;)V 127.0.0.1
|
|
(Ljava/lang/String;II)V
|
"
|
$ &(' java/lang/System )* out Ljava/io/PrintStream;
|
,.- java/io/PrintStream /0 println (Ljava/lang/Object;)V
|
2 @ A args [Ljava/lang/String;
|
SourceFile DataBaseBackUpThread_SQL.java !
|
|
/ *· ± Ý 8L» Y*¶ · M,"¶ $,+¶ (W§ N-¶ ,,¶ 1§ :,¶ 1¿,¶ 1± - # * 2 ! " # # % * $ , % 0 & 3 % 7 ' * 8 4 5 5 6 ) 7 8 9 : ; ÿ < -K > @ A B C «» Y*¶ · M» DY· FN6§ U*+¹ G À M¸ O @-» SYU· W+¹ G À M¶ Y¶ ]a¶ ]+¹ G À M¶ c¶ ]f¶ ]¶ h¶ kW+¹ o ¡ÿ¦+¹ o ),"¶ $,-¶ sW§ :¶ ,,¶ 1§ :,¶ 1¿,¶ 1± w - w N . / 0 1 , 2 6 3 e 2 i 0 w 7 8 9 ; < > = > £ ? ¦ > ª @ > « 4 5 « w x 7 8 y z ` { | 9 : } « w ~ y ; , þ Dû Nÿ " H D -M > Q R 3 °=» SY· W+¶ Y¶ ]¶ ]+¶ c¶ ]¶ ]¶ hN» Y*¶ · ::-¶ :¹ M=§ H:¶ Æ ¹ §
|
:¶ ¶ 1§ >:Æ ¹ §
|
:¶ ¶ 1¿Æ ¹ §
|
:¶ ¶ 1 ¬ ? K N Z a d ? U s z ¢ v I J L # J ' M 4 N 7 P ? R I S K U P V U X Z Z a [ f \ k _ s W u X z Z [ \ _ ` X Z [ ¤ \ © _ ® a f
|
° 5 ° ® ' 6 4 | 7 8 7 y P 9 f 9 9 ¤ 9 ; a
|
ÿ N M < U G >ÿ M < > ÿ M < N B á
|
N» DY· FL¡M» Y*¶ · N» DY· F:-,¶ :§ w£¹ ¥ ©¶ « f£¹ ¥ ®¶ « U£¹ ¥ °¶ « D£¹ ¥ ²¶ « 3£¹ ¥ ¸ ´ $» MY· ·:£¹ ¥ ¶ ¸¹ » W¹ ÿ
¼:6§ s» SY¾· W¹ G À M¶ Y¶ ]¶ ]¶ h:-¶ :§ 6¹ G À M¶ À:Ĺ ¥ ¶ ƶ c¸ ´ +¹ » W¹ ÿƹ o ¡ÿ§ :¶ -¶ 1§ : -¶ 1 ¿-¶ 1+° .1 8? $ j k l m o ' p * q ; r L s ] t n u } v w x p ¨ | ¬ } ² ~ » Ò ~ × ß â ó
}. 3 8 ? A E H L p N 4 5 F w x C É 7 7 8 . Ê x ' Ë ¬ Ì ¯ { | ó " Í 3 9 } F w ~ . Ê ~ ; G
|
ÿ * H < H û sý </2 ÿ H < H M > Î B Ô ·» DY· FLÏM» Y*¶ · N-"¶ $-,¶ :§ i» MY· ·:ѹ Ó ¶ ×Û¹ ¥ ¶ ¸Ä¹ ¥ ¶ Æݹ Ó ¶ ßâ¹ Ó ¶ äç¹ ¥ ¶ é+¹ » W¹ ÿ§ :¶ -¶ 1§ :-¶ 1¿-¶ 1+° ¡ ¨ ^ $ ' 0 > ¡ L ¢ Z £ h ¤ v ¥ ¦ ¨ © ¡ « ¨ ª ª « ® ¬ ± « µ H · 4 5 ¯ w x ¬ 6 7 8 $ s 0 ] Ë 9 } ¯ w ~ ; 7 ÿ ' H < û eÿ H < M > ì í é 9¼M» Y*¶ · N-"¶ $-,¶ î§ :¶ -¶ 1§ :-¶ 1¿-¶ 1± $ + 2 ¶ · ¹ º » ¼ $ ¾ + ½ - ¾ 1 ¿ 4 ¾ 8 À 4 9 5 9 ñ ò 6 6 * 7 8 9 ; ÿ < M > ó ô % g» SYõ· W+¶ ÷¶ úý¶ ]+¶ Y¶ ]ÿ¶ ]¶ ]+¶ c¶ ]¶ ]¶ hM» Y*¶ · N-,¶ î§ :¶ -¶ 1§ :-¶ 1¿-¶ 1± C H K C R Y > È É Ê ! Ë 3 È 7 Ì C Ï H Ð M Ñ R Ó Y Ò [ Ó _ Ô b Ó f Õ 4 g 5 g Í 7 0 6 C $ 7 8 M 9 ; ÿ K M < M > ¶ + h L+¸M,*¶ N-¶¬ Þ ß à á * %» Y · L+¸!+¸#M²%,¶++,¸1± æ è é ê ë $ ì %34 5 w x } w ~ 5 6
|
