利用JDBC备份和还原MYSQL数据库

利用JDBC连接数据库,不依耐mysql的shell命令, 适合b/s 服务器备份

package com.keertech.util.backup;


/**
 * 备份数据库和还原接口
 * @author 吴浩
 * @version 1.0
 * 2011-6-30
 */
@SuppressWarnings（“serial“）
public interface IBackup {
	
	/**
	 * 创建数据库脚本
	 */
     public void createSqlscript（String filePath） throws Exception;
     
     /**
      * 执行数据库脚本
      */
     public void executSqlscript（String filePath） throws Exception;
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        383  2010-07-06 09:29  DbBackup\.classpath

     文件        384  2011-06-29 16:39  DbBackup\.project

     文件        302  2010-07-07 14:30  DbBackup\bin\com\keertech\util\backup\Db2Backup.class

     文件        254  2010-07-06 13:52  DbBackup\bin\com\keertech\util\backup\IBackup.class

     文件       8015  2010-07-07 14:30  DbBackup\bin\com\keertech\util\backup\MySqlBackup.class

     文件        311  2010-07-07 14:29  DbBackup\bin\com\keertech\util\backup\OracleBackup.class

     文件        320  2010-07-07 14:26  DbBackup\bin\com\keertech\util\backup\SqlServerBackup.class

     文件       2005  2010-07-08 08:50  DbBackup\bin\com\keertech\util\publics\AppendMessage.class

     文件       1697  2010-07-07 14:30  DbBackup\bin\com\keertech\util\publics\DbConfig.class

     文件       1513  2010-07-07 14:30  DbBackup\bin\com\keertech\util\publics\DbConnection.class

     文件       5618  2010-07-08 09:56  DbBackup\bin\com\keertech\util\publics\PublicMethod.class

     文件       1608  2010-07-07 14:28  DbBackup\bin\com\keertech\util\publics\TableColumn.class

     文件       1238  2010-07-07 14:30  DbBackup\bin\com\keertech\util\test\MySqlTest.class

     文件     709922  2008-10-21 04:02  DbBackup\mysql-connector-java-5.1.7-bin.jar

     文件        432  2010-07-06 13:52  DbBackup\src\com\keertech\util\backup\IBackup.java

     文件       7312  2010-07-07 14:30  DbBackup\src\com\keertech\util\backup\MySqlBackup.java

     文件       2105  2010-07-08 08:50  DbBackup\src\com\keertech\util\publics\AppendMessage.java

     文件       1442  2010-07-07 14:30  DbBackup\src\com\keertech\util\publics\DbConfig.java

     文件       1158  2010-07-07 14:30  DbBackup\src\com\keertech\util\publics\DbConnection.java

     文件       4840  2010-07-08 09:56  DbBackup\src\com\keertech\util\publics\PublicMethod.java

     文件       1459  2010-07-07 14:28  DbBackup\src\com\keertech\util\publics\TableColumn.java

     文件       1086  2010-07-08 11:03  DbBackup\src\com\keertech\util\test\MySqlTest.java

     目录          0  2010-07-08 11:02  DbBackup\bin\com\keertech\util\backup

     目录          0  2010-07-08 11:02  DbBackup\bin\com\keertech\util\publics

     目录          0  2010-07-08 11:02  DbBackup\bin\com\keertech\util\test

     目录          0  2010-07-08 11:03  DbBackup\src\com\keertech\util\backup

     目录          0  2010-07-08 11:02  DbBackup\src\com\keertech\util\publics

     目录          0  2010-07-08 11:04  DbBackup\src\com\keertech\util\test

     目录          0  2010-07-08 11:02  DbBackup\bin\com\keertech\util

     目录          0  2010-07-08 11:02  DbBackup\src\com\keertech\util

............此处省略10个文件信息