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語句傳給數據庫操作對象
			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語句傳給數據庫操作對象
		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語句傳給數據庫操作對象
		return?retString;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-08-02?21:59??完整源碼\
?????目錄???????????0??2020-08-02?21:58??完整源碼\StudentInfo\
?????文件?????????497??2018-04-20?20:39??完整源碼\StudentInfo\.classpath
?????文件?????????387??2018-03-17?11:37??完整源碼\StudentInfo\.project
?????目錄???????????0??2020-08-02?21:58??完整源碼\StudentInfo\.settings\
?????文件?????????598??2018-03-17?11:37??完整源碼\StudentInfo\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2020-08-02?21:58??完整源碼\StudentInfo\bin\
?????目錄???????????0??2020-08-02?21:58??完整源碼\StudentInfo\bin\com\
?????目錄???????????0??2020-08-02?21:58??完整源碼\StudentInfo\bin\com\artisan\
?????目錄???????????0??2020-08-02?21:58??完整源碼\StudentInfo\bin\com\artisan\dao\
?????文件????????2634??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\dao\AdminDao.class
?????文件????????5109??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\dao\AttendanceDao.class
?????文件?????????699??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\dao\baseDao.class
?????文件????????3279??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\dao\ClassDao.class
?????文件????????4625??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\dao\CourseDao.class
?????文件????????4841??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\dao\SelectedCourseDao.class
?????文件????????5117??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\dao\StudentDao.class
?????文件????????5029??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\dao\TeacherDao.class
?????目錄???????????0??2020-08-02?21:58??完整源碼\StudentInfo\bin\com\artisan\model\
?????文件????????1113??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\model\Admin.class
?????文件????????1164??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\model\Attendance.class
?????文件????????1610??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\model\Course.class
?????文件?????????893??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\model\SelectedCourse.class
?????文件????????1361??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\model\Student.class
?????文件?????????994??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\model\StudentClass.class
?????文件????????1534??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\model\Teacher.class
?????文件????????1718??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\model\UserType.class
?????目錄???????????0??2020-08-02?21:58??完整源碼\StudentInfo\bin\com\artisan\util\
?????文件?????????911??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\util\Chooser$1.class
?????文件?????????850??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\util\Chooser$2.class
?????文件????????1722??2018-04-20?20:39??完整源碼\StudentInfo\bin\com\artisan\util\Chooser$3.class
............此處省略239個文件信息