package?com.cdd.backUp;

import?java.sql.*;
import?java.util.*;

public?class?BackupData?{
????public?Connection?Con（）?{
????????try?{
????????????Class.forName（“net.sourceforge.jtds.jdbc.Driver“）;
????????????Connection?Con?=?DriverManager.getConnection（
????????????????????“jdbc:jtds:sqlserver://localhost:1433;DatabaseName=master“
????????????????????“sa“?““）;
????????????return?Con;
????????}?catch?（Exception?e）?{
????????????return?null;
????????}
????}
????
????//?獲取所有數據庫名稱
????
public?List?getDatabase（）?{
????List?list?=?new?ArrayList（）;?//?定義List集合對象
????Connection?con?=?Con（）;?//?獲取數據庫連接
????Statement?st;?//?定義Statement對象
????try?{
????????st?=?con.createStatement（）;?//?實例化Statement對象
????????ResultSet?rs?=?st.executeQuery（“select?name?from?dbo.sysdatabases“）;?//?指定查詢所有數據庫方法
????????while?（rs.next（））?{?//?循環遍歷查詢結果集
????????????list.add（rs.getString（1））;?//?將查詢數據添加到List集合中
????????}
????}?catch?（Exception?e）?{
????????e.printStackTrace（）;
????}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????289??2015-08-28?13:53??.classpath
?????文件?????????379??2015-08-28?13:53??.project
?????文件?????????629??2015-08-28?13:53??.settings\org.eclipse.jdt.core.prefs
?????文件????????2418??2015-08-28?13:53??bin\com\cdd\backUp\BackupData.class
?????文件?????????762??2015-08-28?13:53??bin\com\cdd\backUp\BackUpframe$1.class
?????文件?????????732??2015-08-28?13:53??bin\com\cdd\backUp\BackUpframe$2.class
?????文件????????3592??2015-08-28?13:53??bin\com\cdd\backUp\BackUpframe.class
?????文件??????294726??2015-08-28?13:53??lib\jtds-1.2.2.jar
?????文件????????1643??2015-08-28?13:53??src\com\cdd\backUp\BackupData.java
?????文件????????3351??2015-08-28?13:53??src\com\cdd\backUp\BackUpframe.java