package?lee;

import?java.sql.*;
/**
?*?Description:
?*?
Copyright?（C）?2008-2010?Yeeku.H.Lee
?*?
This?program?is?protected?by?copyright?laws.
?*?
Program?Name:
?*?
Date:
?*?@author??Yeeku.H.Lee?kongyeeku@163.com
?*?@version??1.0
?*/
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）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2010-06-26?18:25??WEB-INF\classes\
?????目錄???????????0??2010-06-26?21:27??WEB-INF\classes\lee\
?????文件????????2966??2010-06-26?21:27??WEB-INF\classes\lee\DbDao.class
?????文件????????2836??2010-06-26?22:13??WEB-INF\classes\lee\LoginServlet.class
?????目錄???????????0??2010-06-14?19:25??WEB-INF\lib\
?????目錄???????????0??2010-06-15?17:10??WEB-INF\src\
?????目錄???????????0??2010-06-26?21:10??WEB-INF\src\lee\
?????文件????????2659??2008-05-22?23:05??WEB-INF\src\lee\DbDao.java
?????文件????????2041??2010-06-26?22:13??WEB-INF\src\lee\LoginServlet.java
?????文件????????1449??2010-06-24?08:38??WEB-INF\web.xml
?????文件?????????587??2008-05-22?23:09??login.jsp