package?com.zzk;
import?java.sql.*;
import?javax.swing.JOptionPane;

public?class?DAO?{
????private?static?DAO?dao?=?new?DAO（）;?//?聲明DAO類的靜態實例
????
????/**
?????*?構造方法，加載數據庫驅動
?????*/
????public?DAO（）?{
????????try?{
????????????Class.forName（“net.sourceforge.jtds.jdbc.Driver“）;?//?加載數據庫驅動
????????}?catch?（ClassNotFoundException?e）?{
????????????JOptionPane.showMessageDialog（null?“數據庫驅動加載失敗，請將JTDS驅動配置到構建路徑中。\n“
????????????????????+?e.getMessage（））;
????????}
????}
????
????/**
?????*?獲得數據庫連接的方法
?????*?
?????*?@return?Connection
?????*/
????public?static?Connection?getConn（）?{
????????try?{
????????????Connection?conn?=?null;?//?定義數據庫連接
????????????String?url?=?“jdbc:jtds:sqlserver://localhost:1433/db_database“;?//?數據庫db_database的URL
????????????String?username?=?“sa“;?//?數據庫的用戶名
????????????String?password?=?““;?//?數據庫密碼
????????????conn?=?DriverManager.getConnection（url?username?password）;?//?建立連接
????????????return?conn;?//?返回連接
????????}?catch?（Ex

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????358??2010-10-19?14:28??.classpath
?????文件?????????379??2010-12-31?14:15??.project
?????文件?????????104??2011-01-30?10:53??程序使用說明.txt
?????文件?????????629??2010-10-19?13:57??.settings\org.eclipse.jdt.core.prefs
?????文件????????1740??2011-02-14?10:44??bin\com\zzk\DAO.class
?????文件?????????814??2011-02-14?10:44??bin\com\zzk\UpdateSQLServerPictureframe$1.class
?????文件????????2463??2011-02-14?10:44??bin\com\zzk\UpdateSQLServerPictureframe$2.class
?????文件????????2883??2011-02-14?10:44??bin\com\zzk\UpdateSQLServerPictureframe$3.class
?????文件?????????790??2011-02-14?10:44??bin\com\zzk\UpdateSQLServerPictureframe$4.class
?????文件????????2692??2011-02-14?10:44??bin\com\zzk\UpdateSQLServerPictureframe$5.class
?????文件????????3450??2011-02-14?10:44??bin\com\zzk\UpdateSQLServerPictureframe.class
?????文件?????1048576??2011-01-04?16:51??database\db_database_Data.MDF
?????文件?????1048576??2011-01-04?16:51??database\db_database_Log.LDF
?????文件??????294726??2012-03-01?17:11??lib\jtds-1.2.2.jar
?????文件??????286907??2003-08-05?09:23??lib\msbase.jar
?????文件???????67228??2003-08-05?09:23??lib\mssqlserver.jar
?????文件???????59074??2003-08-05?09:23??lib\msutil.jar
?????文件????????1348??2010-09-04?08:43??src\com\zzk\DAO.java
?????文件????????8524??2010-10-19?15:52??src\com\zzk\UpdateSQLServerPictureframe.java