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

public?class?DAO?{
????private?static?DAO?dao?=?new?DAO（）;?//?聲明DAO類的靜態(tài)實(shí)例
????
????/**
?????*?構(gòu)造方法，加載數(shù)據(jù)庫驅(qū)動(dòng)
?????*/
????public?DAO（）?{
????????try?{
????????????Class.forName（“net.sourceforge.jtds.jdbc.Driver“）;?//?加載數(shù)據(jù)庫驅(qū)動(dòng)
????????}?catch?（ClassNotFoundException?e）?{
????????????JOptionPane.showMessageDialog（null?“數(shù)據(jù)庫驅(qū)動(dòng)加載失敗，請(qǐng)將JTDS驅(qū)動(dòng)配置到構(gòu)建路徑中。\n“
????????????????????+?e.getMessage（））;
????????}
????}
????
????/**
?????*?獲得數(shù)據(jù)庫連接的方法
?????*?
?????*?@return?Connection
?????*/
????public?static?Connection?getConn（）?{
????????try?{
????????????Connection?conn?=?null;?//?定義數(shù)據(jù)庫連接
????????????String?url?=?“jdbc:jtds:sqlserver://localhost:1433/db_database“;?//?數(shù)據(jù)庫db_database的URL
????????????String?username

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件?????????358??2010-09-04?08:53??.classpath
?????文件?????????379??2010-12-31?14:15??.project
?????文件?????????104??2011-01-30?10:52??程序使用說明.txt
?????文件?????????629??2010-09-04?08:49??.settings\org.eclipse.jdt.core.prefs
?????文件????????1740??2011-02-14?10:44??bin\com\zzk\DAO.class
?????文件?????????824??2011-02-14?10:44??bin\com\zzk\ReadPictureFromSQLServerframe$1.class
?????文件????????2717??2011-02-14?10:44??bin\com\zzk\ReadPictureFromSQLServerframe$2.class
?????文件????????2747??2011-02-14?10:44??bin\com\zzk\ReadPictureFromSQLServerframe.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
?????文件????????4335??2010-10-19?17:52??src\com\zzk\ReadPictureFromSQLServerframe.java