package?cc.zte.dao;

import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?cc.zte.db.DBManager;
import?cc.zte.entity.Admin;
import?cc.zte.entity.Appointment;
import?cc.zte.entity.CurAppointment;
import?cc.zte.entity.Doctor;

public?class?AdminDao?extends?DBManager?{

	
		/*登陸查詢*/
	public?boolean?checked（Admin?admin）{		
		String?sql?=?“select?aid?from?admin?where?uname?=???and?upwd?=??“;//查詢是否有此條記錄
		this.setSql（sql）;
		
		List??param?=?new?ArrayList（）;
		param.add（admin.getUname（））;
		param.add（admin.getUpwd（））;
		this.setParam（param）;
		
	
		try?{
			rs?=?this.executeQuery（）;
			if（rs.next（））{
				?return?true;//如果有該記錄那么返回真，允許用戶登錄。
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block			
			e.printStackTrace（）;
			return?false;//系統出現異常的時候返回假。
		}finally{

			this.closeAll（conn?pstmt?rs）;
			
		}
		
		return?false;//如果沒有該記錄那么返回假，不允許用戶登錄。
	}
	
	
	/*添加醫師前查看數據庫是否有重復編號*/
	public?boolean?chackedDocDid（Doctor?doctor）{
		String?sql?=?“select?name?from?doctor?where?did?=?“;//查詢是否有此條記錄有記錄就返回假，不允許用戶注冊；
		this.setSql（sql）;
		
		List??param?=?new?ArrayList（）;
		param.add（doctor.getDid（））;
		this.setParam（param）;
		try?{
			rs?=?this.executeQuery（）;
			if（rs.next（））{
				System.out.println（“dao用戶被占用“）;
				?return?false;//如果有該記錄那么返回假，允許用戶注冊（該賬戶沒有被占用）。
			}else{
				System.out.println（“用戶可以使用“）;
				return?true;	//允許用戶注冊
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block			
			e.printStackTrace（）;
			return?false;//系統出現異常的時候返回假，不允許用戶注冊。
		}finally{
			
			this.closeAll（conn?pstmt?rs）;	
			
		}
	}
	
	/*增加醫生*/
	public?boolean?insertDoctor（Doctor?doctorAppointment?appointment?CurAppointment?curAppointment）{
		
		String?sql1?=?“insert??into?Doctor?values（?????????）“;
		List?param1?=?new?ArrayList（）;
		param1.add（doctor.getDid（））;
		param1.add（doctor.getName（））;
		param1.add（doctor.getPassword（））;
		param1.add（doctor.getAge（））;
		param1.add（doctor.getSex（））;
		param1.add（doctor.getLevel（））;
		param1.add（doctor.getSection（））;
		param1.add（doctor.getSpecial（））;
		param1.add（doctor.getPhone（））;
		
		
		String?sql2?=?“insert?into?Appointment?values（???????????????）“;
		String?sql3?=?“insert?into?CurAppointment?values（???????????????）“;
		List?param2?=?new?ArrayList（）;
		param2.add（appointment.getDid（））;
		param2.add（appointment.getSuna（））;
		param2.add（appointment.getSunp（））;
		param2.add（appointment.getMona（））;
		param2.add（appointment.getMonp（））;
		param2.add（appointment.getTuea（））;
		param2.add（appointment.getTuep（））;
		param2.add（appointment.getWeda（））;
		param2.add（appointment.getWedp（））;
		param2.add（appointment.getThua（））;
		param2.add（appointment.getThup（））;
		param2.add（appointment.getFria（））;
		param2.add（appointment.getFrip（））;
		param2.add（appointment.getSata（））;
		param2.add（appo

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

?????文件????????432??2010-12-19?16:21??Hospital\.classpath

?????文件????????960??2010-12-27?00:59??Hospital\.myeclipse\profiler\Main.xml

?????文件????????297??2010-12-26?14:39??Hospital\.mymetadata

?????文件???????1414??2010-12-19?16:40??Hospital\.project

?????文件????????500??2010-12-19?16:13??Hospital\.settings\.jsdtscope

?????文件????????224??2010-12-19?16:18??Hospital\.settings\org.eclipse.core.resources.prefs

?????文件????????330??2010-12-19?16:13??Hospital\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2010-12-19?16:13??Hospital\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2010-12-19?16:13??Hospital\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????3145728??2010-12-30?13:14??Hospital\SQL\Hospital.mdf

?????文件????1048576??2010-12-30?13:14??Hospital\SQL\Hospital_log.ldf

?????文件??????12301??2010-12-29?15:18??Hospital\SQL\hospital_sql.sql

?????文件???????5902??2010-12-28?20:39??Hospital\src\cc\zte\dao\AdminDao.java

?????文件????????910??2010-12-21?13:10??Hospital\src\cc\zte\dao\AdminDao.java.bak

?????文件????????107??2010-12-20?14:52??Hospital\src\cc\zte\dao\AppointmentDao.java

?????文件????????110??2010-12-20?14:53??Hospital\src\cc\zte\dao\CurAppointmentDao.java

?????文件???????7751??2010-12-29?03:33??Hospital\src\cc\zte\dao\DoctorDao.java

?????文件????????104??2010-12-20?14:54??Hospital\src\cc\zte\dao\HistoryDao.java

?????文件????????103??2010-12-25?17:45??Hospital\src\cc\zte\dao\OrdersDao.java

?????文件??????11032??2010-12-28?21:11??Hospital\src\cc\zte\dao\PatientDao.java

?????文件???????2491??2010-12-19?16:22??Hospital\src\cc\zte\db\DBManager.java

?????文件????????761??2010-12-20?14:23??Hospital\src\cc\zte\entity\Admin.java

?????文件???????3033??2010-12-20?14:45??Hospital\src\cc\zte\entity\Appointment.java

?????文件???????3045??2010-12-20?14:42??Hospital\src\cc\zte\entity\CurAppointment.java

?????文件???????2307??2010-12-28?14:05??Hospital\src\cc\zte\entity\Doctor.java

?????文件???????2290??2010-12-29?01:30??Hospital\src\cc\zte\entity\History.java

?????文件???????1549??2010-12-26?23:16??Hospital\src\cc\zte\entity\Orders.java

?????文件???????2011??2010-12-21?20:55??Hospital\src\cc\zte\entity\Patient.java

?????文件???????1025??2010-12-20?15:57??Hospital\src\cc\zte\filter\CharSet.java

?????文件???????1022??2010-12-23?21:01??Hospital\src\cc\zte\service\AdminService.java

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