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（“com.mysql.jdbc.Driver“）;?//?加載數據庫驅動
????????}?catch?（ClassNotFoundException?e）?{
????????????JOptionPane.showMessageDialog（null
????????????????????“數據庫驅動加載失敗，請將MySQL驅動配置到構建路徑中。\n“?+?e.getMessage（））;
????????}
????}
????
????/**
?????*?獲得數據庫連接的方法
?????*?@return?Connection
?????*/
????public?static?Connection?getConn（）?{
????????try?{
????????????Connection?conn?=?null;?//?定義數據庫連接
????????????String?url?=?“jdbc:mysql://localhost:3306/db_database?useUnicode=true&characterEncoding=utf-8“;?//?數據庫db_database的URL
????????????String?username?=?“root“;?//?數據庫的用戶名
????????????String?password?=?“111“;?//?數據庫密碼
????????????conn?=?DriverManager.getConnection（url?username?password）;?//?建立連接
????????????return?conn;?//?返回連接

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????378??2010-10-19?14:24??.classpath
?????文件?????????379??2010-12-31?14:15??.project
?????文件?????????124??2011-01-30?10:53??程序使用說明.txt
?????文件?????????629??2010-10-19?13:57??.settings\org.eclipse.jdt.core.prefs
?????文件????????1664??2011-02-14?10:44??bin\com\zzk\DAO.class
?????文件?????????794??2011-02-14?10:44??bin\com\zzk\UpdateMySQLPictureframe$1.class
?????文件????????2431??2011-02-14?10:44??bin\com\zzk\UpdateMySQLPictureframe$2.class
?????文件????????2851??2011-02-14?10:44??bin\com\zzk\UpdateMySQLPictureframe$3.class
?????文件?????????766??2011-02-14?10:44??bin\com\zzk\UpdateMySQLPictureframe$4.class
?????文件????????2664??2011-02-14?10:44??bin\com\zzk\UpdateMySQLPictureframe$5.class
?????文件????????3394??2011-02-14?10:44??bin\com\zzk\UpdateMySQLPictureframe.class
?????文件???????83300??2011-01-04?16:49??database\db_database.sql
?????文件??????802721??2013-11-15?08:43??lib\mysql-connector-java-5.1.20-bin.jar
?????文件????????1256??2010-10-20?09:00??src\com\zzk\DAO.java
?????文件????????8504??2010-10-19?15:52??src\com\zzk\UpdateMySQLPictureframe.java