package?dao;

import?java.sql.*;

public?class?LoginDao?{

	Connection?conn;

	public?LoginDao（）?{

		conn?=?MyConnection.getConn（）;
	}

	//?檢查給定賬戶名、密碼的登陸賬戶是否存在
	public?boolean?checkLoginUser（String?login_name?String?password）?{

		boolean?flag?=?false;

		PreparedStatement?pstmt?=?null;

		try?{
			String?sql?=?“select?*?from?employee?where?name=??and?password=?“;
			pstmt?=?conn.prepareStatement（sql）;

			pstmt.setString（1?login_name）;
			pstmt.setString（2?password）;

			ResultSet?rs?=?pstmt.executeQuery（）;

			if?（rs.next（））?{

				flag?=?true;
			}
		}?catch?（SQLException?e）?{
			System.out.println（“檢索登陸賬戶異常：“?+?e.getMessage（））;
		}

		return?flag;
	}

	public?void?closeConn（）?{
		try?{
			if?（conn?!=?null）?{

				conn.close（）;
			}
		}?catch?（SQLException?e）?{
			System.out.println（“關連接異常：“?+?e.getMessage（））;
		}
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-03-16?13:17??0901-12-馬金鵬-任務？\
?????目錄???????????0??2011-03-16?13:15??0901-12-馬金鵬-任務？\pet_majinpeng\
?????文件?????????434??2011-03-09?14:48??0901-12-馬金鵬-任務？\pet_majinpeng\.classpath
?????目錄???????????0??2011-02-28?16:23??0901-12-馬金鵬-任務？\pet_majinpeng\.myeclipse\
?????文件?????????312??2011-03-14?15:21??0901-12-馬金鵬-任務？\pet_majinpeng\.mymetadata
?????文件????????1231??2011-03-02?20:07??0901-12-馬金鵬-任務？\pet_majinpeng\.project
?????目錄???????????0??2011-03-16?13:15??0901-12-馬金鵬-任務？\pet_majinpeng\.settings\
?????文件?????????334??2011-02-28?16:23??0901-12-馬金鵬-任務？\pet_majinpeng\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2011-03-16?13:15??0901-12-馬金鵬-任務？\pet_majinpeng\src\
?????目錄???????????0??2011-03-16?13:15??0901-12-馬金鵬-任務？\pet_majinpeng\src\dao\
?????文件?????????927??2011-03-09?15:02??0901-12-馬金鵬-任務？\pet_majinpeng\src\dao\LoginDao.java
?????文件?????????687??2011-03-09?14:45??0901-12-馬金鵬-任務？\pet_majinpeng\src\dao\MyConnection.java
?????文件?????????436??2011-03-16?13:08??0901-12-馬金鵬-任務？\pet_majinpeng\src\dao\VetDao.java
?????目錄???????????0??2011-03-16?13:15??0901-12-馬金鵬-任務？\pet_majinpeng\src\entity\
?????文件?????????341??2011-02-28?16:46??0901-12-馬金鵬-任務？\pet_majinpeng\src\entity\Employee.java
?????文件?????????743??2011-02-28?16:45??0901-12-馬金鵬-任務？\pet_majinpeng\src\entity\Owners.java
?????文件????????1168??2011-03-16?11:15??0901-12-馬金鵬-任務？\pet_majinpeng\src\entity\Pets.java
?????文件?????????578??2011-03-16?11:18??0901-12-馬金鵬-任務？\pet_majinpeng\src\entity\Specialties.java
?????文件?????????655??2011-03-16?11:20??0901-12-馬金鵬-任務？\pet_majinpeng\src\entity\Vets.java
?????文件?????????650??2011-02-28?16:39??0901-12-馬金鵬-任務？\pet_majinpeng\src\entity\Visits.java
?????目錄???????????0??2011-03-16?13:15??0901-12-馬金鵬-任務？\pet_majinpeng\src\filter\
?????文件?????????826??2011-03-14?13:52??0901-12-馬金鵬-任務？\pet_majinpeng\src\filter\EncodingFilter.java
?????文件????????1104??2011-03-14?14:49??0901-12-馬金鵬-任務？\pet_majinpeng\src\filter\RightFilter.java
?????目錄???????????0??2011-03-16?13:15??0901-12-馬金鵬-任務？\pet_majinpeng\src\servlet\
?????文件????????1986??2011-03-14?14:53??0901-12-馬金鵬-任務？\pet_majinpeng\src\servlet\LoginServlet.java
?????文件?????????784??2011-03-13?17:47??0901-12-馬金鵬-任務？\pet_majinpeng\src\servlet\QuitServlet.java
?????文件?????????795??2011-03-16?13:08??0901-12-馬金鵬-任務？\pet_majinpeng\src\servlet\VetServlet.java
?????目錄???????????0??2011-03-16?13:15??0901-12-馬金鵬-任務？\pet_majinpeng\WebRoot\
?????文件????????1863??2011-03-14?15:22??0901-12-馬金鵬-任務？\pet_majinpeng\WebRoot\index.jsp
?????目錄???????????0??2011-03-16?13:15??0901-12-馬金鵬-任務？\pet_majinpeng\WebRoot\meta-INF\
?????文件??????????39??2011-02-28?16:23??0901-12-馬金鵬-任務？\pet_majinpeng\WebRoot\meta-INF\MANIFEST.MF
............此處省略35個文件信息