package?package1;
import?java.sql.*;
public?class?DbDao?
{
	//該JavaBean做成單例模式
	private?static?DbDao?op;
	private?Connection?conn;
	private?String?driver;
	private?String?url;
	private?String?username;
	private?String?pass;
	//構造器私有
	private?DbDao（）
	{
	}
	//構造器私有
	private?DbDao（String?driverString?urlString?usernameString?pass）
		throws??Exception
	{
		this.driver?=?driver;
		this.url?=?url;
		this.username?=?username;
		this.pass?=?pass;?
		Class.forName（driver）;
		conn?=?DriverManager.getConnection（urlusernamepass）;
	}
	//下面是各個成員屬性的setter和getter方法
	public?void?setDriver（String?driver）?{
		this.driver?=?driver;?
	}
	public?void?setUrl（String?url）?{
		this.url?=?url;?
	}
	public?void?setUsername（String?username）?{
		this.username?=?username;?
	}
	public?void?setPass（String?pass）?{
		this.pass?=?pass;?
	}
	public?String?getDriver（）?{
		return?（this.driver）;?
	}
	public?String?getUrl（）?{
		return?（this.url）;?
	}
	public?String?getUsername（）?{
		return?（this.username）;?
	}
	public?String?getPass（）?{
		return?（this.pass）;?
	}
	//獲取數據庫連接
	public?void?getConnection（）?throws?Exception
	{
		if?（conn?==?null）
		{
			Class.forName（this.driver）;
			conn?=?DriverManager.getConnection（urlusername
				this.?pass）;
		}
	}
	//實例化JavaBean的入口
	public?static?DbDao?instance（）
	{
		if?（op?==?null）
		{
			op?=?new?DbDao（）;
		}
		return?op;
	}
	//實例化JavaBean的入口
	public?static?DbDao?instance（String?driverString?url
		String?username?String?pass）?throws?Exception
	{
		if?（op?==?null）
		{
			op?=?new?DbDao（driverurlusernamepass）;
		}
		return?op;
	}
	//插入記錄
	public?boolean?insert（String?sql）?throws?Exception
	{
		getConnection（）;
		Statement?stmt?=?this.conn.createStatement（）;
		if?（stmt.executeUpdate（sql）?!=?1）
		{
			return?false;
		}
		return?true;
	}
	//執行查詢
	public?ResultSet?query（String?sql）?throws?Exception
	{
		getConnection（）;
		Statement?stmt?=?this.conn.createStatement（）;
		return?stmt.executeQuery（sql）;
	}
	//執行刪除
	public?void?delete（String?sql）?throws?Exception
	{
		getConnection（）;
		Statement?stmt?=?this.conn.createStatement（）;
		stmt.executeUpdate（sql）;
	}
	//執行更新
	public?void?update（String?sql）?throws?Exception
	{
		getConnection（）;
		Statement?stmt?=?this.conn.createStatement（）;
		stmt.executeUpdate（sql）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????302??2018-12-16?17:00??java同學通訊錄\同學通訊錄\.classpath

?????文件????????391??2019-01-14?16:58??java同學通訊錄\同學通訊錄\.project

?????文件???????2986??2019-01-14?16:58??java同學通訊錄\同學通訊錄\bin\package1\DbDao.class

?????文件???????4250??2019-01-15?08:19??java同學通訊錄\同學通訊錄\bin\package1\Delete.class

?????文件???????4226??2019-01-15?10:16??java同學通訊錄\同學通訊錄\bin\package1\Display.class

?????文件???????4478??2019-01-15?08:00??java同學通訊錄\同學通訊錄\bin\package1\Features.class

?????文件???????3433??2019-01-14?21:38??java同學通訊錄\同學通訊錄\bin\package1\Initialization.class

?????文件???????5898??2019-01-15?08:51??java同學通訊錄\同學通訊錄\bin\package1\Insert.class

?????文件???????4509??2019-01-15?08:09??java同學通訊錄\同學通訊錄\bin\package1\Modify.class

?????文件???????5542??2019-01-15?08:55??java同學通訊錄\同學通訊錄\bin\package1\Modify1.class

?????文件???????4414??2019-01-15?08:18??java同學通訊錄\同學通訊錄\bin\package1\Query.class

?????文件???????4178??2019-01-15?08:55??java同學通訊錄\同學通訊錄\bin\package1\Query1.class

?????文件????????382??2019-01-14?16:58??java同學通訊錄\同學通訊錄\bin\package1\Snippet.class

?????文件???????4419??2019-01-15?08:58??java同學通訊錄\同學通訊錄\bin\package1\Statistics.class

?????文件?????108285??2018-11-03?13:30??java同學通訊錄\同學通訊錄\image\background.jpg

?????文件??????17755??2018-11-01?19:15??java同學通訊錄\同學通訊錄\image\cover.png

?????文件?????709922??2017-10-31?20:22??java同學通訊錄\同學通訊錄\lib\mysql-connector-java-5.1.7-bin.jar

?????文件?????983911??2018-12-09?09:35??java同學通訊錄\同學通訊錄\mysql-connector-java-5.1.38.jar

?????文件???????2435??2018-12-17?20:59??java同學通訊錄\同學通訊錄\src\package1\DbDao.java

?????文件???????3285??2019-01-15?08:19??java同學通訊錄\同學通訊錄\src\package1\Delete.java

?????文件???????3048??2019-01-15?10:16??java同學通訊錄\同學通訊錄\src\package1\Display.java

?????文件???????5943??2019-01-15?08:00??java同學通訊錄\同學通訊錄\src\package1\Features.java

?????文件???????2813??2019-01-14?21:38??java同學通訊錄\同學通訊錄\src\package1\Initialization.java

?????文件???????6566??2019-01-15?08:51??java同學通訊錄\同學通訊錄\src\package1\Insert.java

?????文件???????3433??2019-01-15?08:09??java同學通訊錄\同學通訊錄\src\package1\Modify.java

?????文件???????5534??2019-01-15?08:55??java同學通訊錄\同學通訊錄\src\package1\Modify1.java

?????文件???????3363??2019-01-15?08:18??java同學通訊錄\同學通訊錄\src\package1\Query.java

?????文件???????4312??2019-01-15?08:55??java同學通訊錄\同學通訊錄\src\package1\Query1.java

?????文件????????819??2018-12-17?19:55??java同學通訊錄\同學通訊錄\src\package1\Save.java

?????文件?????????99??2018-12-16?16:14??java同學通訊錄\同學通訊錄\src\package1\Snippet.java

............此處省略13個文件信息