package?com.artisan.dao;

import?com.artisan.model.Admin;

import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;

public?class?AdminDao?extends?baseDao?{
	/**
	?*?管理員登陸
	?*/
	public?Admin?login（Admin?admin）{
		String?sql?=?“select?*?from?s_admin?where?name=??and?password=?“;
		Admin?adminRst?=?null;
		try?{
			PreparedStatement?prst?=?con.prepareStatement（sql）;//把sql語句傳給數(shù)據(jù)庫操作對象
			prst.setString（1?admin.getName（））;
			prst.setString（2?admin.getPassword（））;
			ResultSet?executeQuery?=?prst.executeQuery（）;
			if（executeQuery.next（））{
				adminRst?=?new?Admin（）;
				adminRst.setId（executeQuery.getInt（“id“））;
				adminRst.setName（executeQuery.getString（“name“））;
				adminRst.setPassword（executeQuery.getString（“password“））;
				adminRst.setCreateDate（executeQuery.getString（“createDate“））;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?adminRst;
	}
	public?String?editPassword（Admin?adminString?newPassword）{
		String?sql?=?“select?*?from?s_admin?where?id=??and?password=?“;
		PreparedStatement?prst?=?null;
		int?id?=?0;
		try?{
			prst?=?con.prepareStatement（sql）;
			prst.setInt（1?admin.getId（））;
			prst.setString（2?admin.getPassword（））;
			ResultSet?executeQuery?=?prst.executeQuery（）;
			if（!executeQuery.next（））{
				String?retString?=?“舊密碼錯誤！“;
				return?retString;
			}
			id?=?executeQuery.getInt（“id“）;
		}?catch?（SQLException?e1）?{
			//?TODO?Auto-generated?catch?block
			e1.printStackTrace（）;
		}//把sql語句傳給數(shù)據(jù)庫操作對象
		String?retString?=?“修改失敗“;
		String?sqlString?=?“update?s_admin?set?password?=???where?id?=??“;
		try?{
			prst?=?con.prepareStatement（sqlString）;
			prst.setString（1?newPassword）;
			prst.setInt（2?id）;
			int?rst?=?prst.executeUpdate（）;
			if（rst?>?0）{
				retString?=?“密碼修改成功！“;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}//把sql語句傳給數(shù)據(jù)庫操作對象
		return?retString;
	}
}