package?com.zky.hm.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.Vector;

import?com.zky.hm.entity.Admin;
import?com.zky.hm.entity.Grade;
import?com.zky.hm.entity.Room;
import?com.zky.hm.entity.RoomState;
import?com.zky.hm.entity.RoomType;
import?com.zky.hm.util.*;

public?class?AdminDao?{
	
	public?ArrayList?getGradeList（）{
		DBUtil?dbUtil=new?DBUtil（）;
		Connection?conn;
		conn=dbUtil.getConn（）;
		
		ArrayList?list=new?ArrayList（）;
		String?sql=“select?*from?tb_grade“;
		try{
			PreparedStatement?pstmt=conn.prepareStatement（sql）;
			ResultSet??rs=pstmt.executeQuery（）;
			while（rs.next（））{
				Grade?grade=new?Grade（）;
				grade.setGradeId（rs.getInt（“gradeId“））;
				grade.setGradeName（rs.getString（“gradeName“））;
				grade.setGradeDesc（rs.getString（“gradeDesc“））;
				list.add（grade）;
			}				
		}catch（Exception?e）{
			e.printStackTrace（）;
		}finally{
			dbUtil.closeConn（conn）;
		}	
		return?list;
	}

	public?Admin?checkLogon（Admin?admin）?{
		DBUtil?dbUtil=new?DBUtil（）;
		Connection?conn=dbUtil.getConn（）;
		Admin?adminResult=null;
		String?sql=“select?*from?tb_admin?where?adminName=??and?password=??and?gradeId=?“;
		try{
			PreparedStatement?pstmt=conn.prepareStatement（sql）;
			pstmt.setString（1?admin.getAdminName（））;
			pstmt.setString（2?admin.getPassword（））;
			pstmt.setInt（3?admin.getGrade（）.getGradeId（））;
			ResultSet??rs=pstmt.executeQuery（）;
			while（rs.next（））{
				adminResult=new?Admin（）;
				adminResult.setAdminId（rs.getInt（“adminId“））;
				adminResult.setAdminName（rs.getString（“adminName“））;
				adminResult.setPassword（rs.getString（“password“））;
				adminResult.setGradeId（rs.getInt（“gradeId“））;
				adminResult.setGrade（admin.getGrade（））;
			}				
		}catch（Exception?e）{
			e.printStackTrace（）;
		}finally{
			dbUtil.closeConn（conn）;
		}	
		return?adminResult;
	}

	public?static?int?modifyPassword（Admin?admin）?{
		int?flag=-1;
		DBUtil?dbUtil=new?DBUtil（）;
		Connection?conn=dbUtil.getConn（）;
		String?sql=“update?tb_admin?set?password=??where?adminId=?“;
		try{
			PreparedStatement?pstmt=conn.prepareStatement（sql）;
			pstmt.setString（1?admin.getPassword（））;
			pstmt.setInt（2?admin.getAdminId（））;
			flag=pstmt.executeUpdate（）;
			
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
		finally{
			dbUtil.closeConn（conn）;
		}
		
		return?flag;
	}

	public?static?int?addAdmin（Admin?admin）?{
		//?TODO?Auto-generated?method?stub
		int?flag=-1;
		DBUtil?dbUtil=new?DBUtil（）;
		Connection?conn=dbUtil.getConn（）;
		String?sql=“insert?tb_admin?values?（null???）“;
		try{
			PreparedStatement?pstmt=conn.prepareStatement（sql）;
			pstmt.setString（1?admin.getAdminName（））;
			pstmt.setString（2?admin.getPassword（））;
			pstmt.setInt（3?admin.getGrade（）.getGradeId（））;
			flag=pstmt.executeUpdate（）;
			
		}catch（Exception?e）{
			e.printStack

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-11-02?16:17??賓館管理系統\
?????文件?????1387520??2017-10-19?20:19??賓館管理系統\201415036李倩梅.doc
?????目錄???????????0??2017-10-19?21:42??賓館管理系統\hotelManager\
?????文件?????????377??2017-09-17?17:34??賓館管理系統\hotelManager\.classpath
?????文件?????????388??2017-09-17?17:25??賓館管理系統\hotelManager\.project
?????目錄???????????0??2017-10-19?21:42??賓館管理系統\hotelManager\.settings\
?????文件?????????629??2017-09-17?17:25??賓館管理系統\hotelManager\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2017-10-19?21:42??賓館管理系統\hotelManager\bin\
?????目錄???????????0??2017-10-19?21:42??賓館管理系統\hotelManager\bin\com\
?????目錄???????????0??2017-10-19?21:42??賓館管理系統\hotelManager\bin\com\zky\
?????目錄???????????0??2017-10-19?21:42??賓館管理系統\hotelManager\bin\com\zky\hm\
?????目錄???????????0??2017-10-19?21:42??賓館管理系統\hotelManager\bin\com\zky\hm\dao\
?????文件????????6782??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\dao\AdminDao.class
?????文件????????1589??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\dao\CustomerDao.class
?????文件????????6536??2017-10-11?17:46??賓館管理系統\hotelManager\bin\com\zky\hm\dao\OrderDao.class
?????文件????????7929??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\dao\RoomDao.class
?????目錄???????????0??2017-10-19?21:42??賓館管理系統\hotelManager\bin\com\zky\hm\entity\
?????文件????????1492??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\entity\Admin.class
?????文件????????1391??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\entity\Customer.class
?????文件????????1106??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\entity\Grade.class
?????文件????????1758??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\entity\Order.class
?????文件????????1968??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\entity\Room.class
?????文件????????1121??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\entity\RoomState.class
?????文件????????1296??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\entity\RoomType.class
?????目錄???????????0??2017-10-19?21:42??賓館管理系統\hotelManager\bin\com\zky\hm\util\
?????文件????????1836??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\util\DBUtil.class
?????文件????????1053??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\util\DateUtil.class
?????文件????????2557??2017-10-13?18:42??賓館管理系統\hotelManager\bin\com\zky\hm\util\StringDay.class
?????文件?????????774??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\util\StringDigit.class
?????文件?????????659??2017-10-11?15:28??賓館管理系統\hotelManager\bin\com\zky\hm\util\StringUtil.class
?????目錄???????????0??2017-10-19?21:42??賓館管理系統\hotelManager\bin\com\zky\hm\view\
............此處省略106個文件信息