package?DA;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;



import?exception.DuplicateException;
import?exception.NotFoundException;

import?PD.Admin;

public?class?AdminDA?{
	private?static?final?String?DBDRIVER?=?“com.mysql.jdbc.Driver“;
	private?static?final?String?DBURL?=?“jdbc:mysql://localhost:3306/myktv“?;
	private?static?final?String?USERNAME?=?“root“;
	private?static?final?String?PASSWORD?=?“root“;
	
	private?static?Connection?conn;
	private?static?Statement?stmt;
	
	private?static?Admin?admin;
	private?static?String?userName;
	private?static?String?password;?
	
	
	public?static?void?initialize（）{
		
		try?{
			//加載和注冊數據庫驅動程序
			Class.forName（DBDRIVER）;
			//創建連接實例
			conn?=?DriverManager.getConnection（DBURLUSERNAMEPASSWORD）;
			//創建此連接的語句實例
			stmt?=?conn.createStatement（）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//e.printStackTrace（）;
		}
	}
	
	public?static?void?terminate（）{
		try?{
			stmt.close（）;
			conn.close（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	
	public?static?Admin?find（String?userName）throws?NotFoundException{
		String?sqlQuery?=?“SELECT?Password?FROM?AdminTable?“+
						“WHERE?UserName=‘“+userName+“‘“;
		try?{
			initialize（）;
			ResultSet?rs?=?stmt.executeQuery（sqlQuery）;
			boolean?gotIt?=?rs.next（）;
			if（gotIt）{
				password?=?rs.getString（“Password“）;
				admin?=?new?Admin（userNamepassword）;
			}
			else?{
				throw?（new?NotFoundException（“admin?not?found!“））;
			}
			rs.close（）;
			terminate（）;
		}?catch?（SQLException?e）?{
			
			e.printStackTrace（）;
		}
		
		return?admin;
	}
	
	
	
	public?static?void?addNew?（Admin?admin）throws?DuplicateException?{
		userName?=?admin.getUserName（）;
		password?=?admin.getPassword（）;
		
		String?sqlInsert?=?“INSERT?INTO?AdminTable?“+
						“（UserNamePassword）“+
						“VALUES（‘“+userName+“‘‘“+password+“‘）“;
		try?{
			find（userName）;
			throw?（new?DuplicateException?（“user?exists!“））;
		}?catch?（NotFoundException?e1）?{
		
			try?{
				initialize（）;
				stmt.executeUpdate（sqlInsert）;
				terminate（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}
	
	public?static?void?update（Admin?admin）throws?NotFoundException{
		userName?=?admin.getUserName（）;
		password?=?admin.getPassword（）;
		
		String?sqlUpdate?=?“UPDATE?AdminTable?“+
						“SET?UserName=‘“+userName+“‘“+
						“Password=‘“+password+“‘“;
		
		try?{
			find（userName）;//see?if?this?admin?already?exists?in?the?database
			initialize（）;
			stmt.executeUpdate（sqlUpdate）;
			terminate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	
	public?static?void?delete（Admin?admin）?throws?NotFoundException{
		userName?=?admin.getUserName（）;
		password?=?admin.getPassword（）;
		
		String?sqlDelete?=?“DELETE?FROM?A

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

?????文件???????1245??2010-10-15?10:41??MyKTV\.classpath

?????文件????????381??2010-09-28?08:42??MyKTV\.project

?????文件???????3561??2010-10-27?08:52??MyKTV\bin\DA\AdminDA.class

?????文件???????9061??2010-10-27?08:52??MyKTV\bin\DA\SongDA.class

?????文件???????6939??2010-10-27?08:52??MyKTV\bin\DA\StarDA.class

?????文件????????426??2010-10-27?08:51??MyKTV\bin\exception\DuplicateException.class

?????文件????????423??2010-10-27?08:51??MyKTV\bin\exception\NotFoundException.class

?????文件???????1900??2010-10-27?08:51??MyKTV\bin\mainframe\AddNewframe$1.class

?????文件???????3145??2010-10-27?08:51??MyKTV\bin\mainframe\AddNewframe$2.class

?????文件????????725??2010-10-27?08:51??MyKTV\bin\mainframe\AddNewframe$3.class

?????文件???????7323??2010-10-27?08:51??MyKTV\bin\mainframe\AddNewframe.class

?????文件???????2110??2010-10-27?08:56??MyKTV\bin\mainframe\ChangePasswordframe$1.class

?????文件????????773??2010-10-27?08:56??MyKTV\bin\mainframe\ChangePasswordframe$2.class

?????文件???????3351??2010-10-27?08:56??MyKTV\bin\mainframe\ChangePasswordframe.class

?????文件????????728??2010-10-27?08:51??MyKTV\bin\mainframe\DemandedSongTable$1.class

?????文件???????1685??2010-10-27?08:51??MyKTV\bin\mainframe\DemandedSongTable.class

?????文件???????1708??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$1.class

?????文件???????1023??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$10.class

?????文件???????1374??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$11.class

?????文件???????1164??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$12.class

?????文件???????1210??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$13.class

?????文件???????1210??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$14.class

?????文件???????1206??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$15.class

?????文件???????1206??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$16.class

?????文件???????1209??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$17.class

?????文件???????1210??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$18.class

?????文件???????1472??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$19.class

?????文件???????1020??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$2.class

?????文件???????1306??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$20.class

?????文件???????1020??2010-10-31?08:35??MyKTV\bin\mainframe\DemandPane$3.class

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