package?renting.bll;

/*
管理員業務處理類
*/
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?renting.bll.entity.Admin;
import?renting.dal.DBConnecter;
/**
*
*?@author?Administrator
*/
public?class?AdminManager?{
	private?PreparedStatement?getPreparedStatement（String?sql）?throws?SQLException?{
	????return?new?DBConnecter（）.getConnection（）.prepareStatement（sql）;
	}
	/*
	?*?AdminManager?login方法，用于判斷數據庫中是否有對應的賬號
	?*?*/
	public?boolean?login（Admin?admin）?throws?SQLException?{
		String?sql=“select?*?from?admin?where?id=??and?password=?“;
	????PreparedStatement?ps?=?getPreparedStatement（sql）;
	????ps.setString（1?admin.getId（））;
	????ps.setString（2?admin.getPassword（））;
	????ResultSet?rs?=?ps.executeQuery（）;
	????int?ans?=?0;
	????if（rs.next（））?{
	????	ans?=?1;
	????}????
	????rs.close（）;
	????ps.close（）;
	????if（ans?==?1）?{
	????	return?true;
	????}
	????else?return?false;
	}
	
	//判斷賬號是否存在
	public?boolean?JudgeAdminID（String?ID）?throws?SQLException?{
		String?sql?=?“select?*?from?Admin?where?id?=??“;
		PreparedStatement?ps?=?getPreparedStatement（sql）;
		ps.setString（1?ID）;
		ResultSet?rs?=?ps.executeQuery（）;
		if（rs.next（））
			return?true;
		return?false;
	}
}

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

?????文件????????607??2019-12-24?21:38??RentingSystem\.classpath

?????文件????????389??2019-12-24?21:37??RentingSystem\.project

?????文件????????642??2019-12-24?21:37??RentingSystem\.settings\org.eclipse.jdt.core.prefs

?????文件???????1748??2019-12-30?12:13??RentingSystem\bin\renting\bll\AdminManager.class

?????文件???????1306??2019-12-30?12:13??RentingSystem\bin\renting\bll\entity\Admin.class

?????文件???????2043??2019-12-30?12:13??RentingSystem\bin\renting\bll\entity\History.class

?????文件???????1078??2019-12-30?13:48??RentingSystem\bin\renting\bll\entity\Message.class

?????文件???????1506??2019-12-30?12:13??RentingSystem\bin\renting\bll\entity\Room.class

?????文件???????2721??2019-12-30?12:13??RentingSystem\bin\renting\bll\entity\Tenant.class

?????文件????????857??2019-12-30?12:13??RentingSystem\bin\renting\bll\HistoryManager$MyDefaultTableModel.class

?????文件???????4180??2019-12-30?12:13??RentingSystem\bin\renting\bll\HistoryManager.class

?????文件???????1372??2019-12-30?12:14??RentingSystem\bin\renting\bll\Login.class

?????文件???????2501??2019-12-30?15:25??RentingSystem\bin\renting\bll\MessageManager.class

?????文件???????2430??2019-12-30?12:13??RentingSystem\bin\renting\bll\people\TenantAdd.class

?????文件???????2477??2019-12-30?12:13??RentingSystem\bin\renting\bll\Register.class

?????文件???????3375??2019-12-30?12:13??RentingSystem\bin\renting\bll\RevisePwd.class

?????文件????????839??2019-12-30?14:27??RentingSystem\bin\renting\bll\RoomManager$MyDefaultTableModel.class

?????文件???????6197??2019-12-30?14:27??RentingSystem\bin\renting\bll\RoomManager.class

?????文件???????5998??2019-12-30?15:25??RentingSystem\bin\renting\bll\TenantManager.class

?????文件???????1491??2019-12-30?12:13??RentingSystem\bin\renting\dal\DBConnecter.class

?????文件???????1006??2019-12-30?19:49??RentingSystem\bin\renting\gui\Mainframe$1.class

?????文件????????912??2019-12-30?19:49??RentingSystem\bin\renting\gui\Mainframe$10.class

?????文件????????899??2019-12-30?19:49??RentingSystem\bin\renting\gui\Mainframe$11.class

?????文件????????916??2019-12-30?19:49??RentingSystem\bin\renting\gui\Mainframe$12.class

?????文件???????1052??2019-12-30?19:49??RentingSystem\bin\renting\gui\Mainframe$13.class

?????文件???????1152??2019-12-30?19:49??RentingSystem\bin\renting\gui\Mainframe$14.class

?????文件????????729??2019-12-30?19:49??RentingSystem\bin\renting\gui\Mainframe$2.class

?????文件????????919??2019-12-30?19:49??RentingSystem\bin\renting\gui\Mainframe$3.class

?????文件????????903??2019-12-30?19:49??RentingSystem\bin\renting\gui\Mainframe$4.class

?????文件????????914??2019-12-30?19:49??RentingSystem\bin\renting\gui\Mainframe$5.class

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