package?com.zxcollege.hr.login.dao;

import?com.zxcollege.hr.login.model.User;
import?java.sql.*;

/*
?*?DAO類，專門訪問數據庫
?*?
?*?包含CRUD操作：create、read、update、delete，增刪改查
?*?
?*/
public?class?LoginDao?{
	//查找用戶
	
	public?boolean?findUser（User?user）?{
		//寫具體訪問數據庫的代碼
		//return?true;
		boolean?succ=false;
		Connection?conn=null;
		try?{
			Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;
			conn=DriverManager.getConnection（“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=“?“sa““sql2000“）;
			PreparedStatement?pst?=?conn.prepareStatement（“select?*?from?users?where?username=??and?password=?“）;
			System.out.println（user.getUsername（）.trim（））;
			System.out.println（user.getPassword（）.trim（））;
			pst.setString（1?user.getUsername（）.trim（））;
			pst.setString（2?user.getPassword（）.trim（））;
			
			ResultSet?rs?=?pst.executeQuery（）;		
			
			succ=rs.next（）;
			
			conn.close（）;
			
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
		return?succ;
		
	}
	

}

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

????..A.SHR?????????9??2009-06-23?17:27??login界面\Desktop_2.ini

????..A.SHR?????????9??2009-06-23?17:27??login界面\Desktop_1.ini

?????文件????????411??2010-03-12?10:57??login界面\service\LoginService.java

????..A.SHR?????????9??2009-06-23?17:27??login界面\service\Desktop_2.ini

????..A.SHR?????????9??2009-06-23?17:27??login界面\service\Desktop_1.ini

?????文件????????451??2010-03-12?10:36??login界面\model\User.java

????..A.SHR?????????9??2009-06-23?17:27??login界面\model\Desktop_2.ini

????..A.SHR?????????9??2009-06-23?17:27??login界面\model\Desktop_1.ini

?????文件???????2583??2010-03-12?11:47??login界面\frame\Loginframe.java

????..A.SHR?????????9??2009-06-23?17:27??login界面\frame\Desktop_2.ini

????..A.SHR?????????9??2009-06-23?17:27??login界面\frame\Desktop_1.ini

?????文件???????1213??2010-03-12?11:59??login界面\dao\LoginDao.java

?????文件???????1183??2010-03-12?11:44??login界面\dao\Teacher_LoginDao.java

????..A.SHR?????????9??2009-06-23?17:27??login界面\dao\Desktop_2.ini

????..A.SHR?????????9??2009-06-23?17:27??login界面\dao\Desktop_1.ini

????..A.SHR?????????9??2009-06-23?17:26??寵物醫院系統\Desktop_1.ini

????..A.SHR?????????9??2009-06-23?17:26??寵物醫院系統\Desktop_2.ini

?????文件?????856064??2009-05-07?15:46??寵物醫院系統\寵物醫院項目答辯.ppt

?????文件?????300606??2009-04-22?21:58??寵物醫院系統\794ff76e3e3013d780cb4af8.jpg

?????文件??????19220??2008-11-12?17:13??寵物醫院系統\1416433.gif

?????文件??????18559??2008-11-12?17:13??寵物醫院系統\1418293.gif

?????文件???????1773??2008-11-12?17:13??寵物醫院系統\1418597.gif

?????文件??????19876??2008-11-12?17:13??寵物醫院系統\1418603.gif

?????文件???????1538??2008-11-12?17:13??寵物醫院系統\1418708.gif

?????文件??????34506??2008-11-12?17:13??寵物醫院系統\1441609.gif

?????文件???????7461??2008-11-12?17:13??寵物醫院系統\1524603.gif

?????文件??????94473??2009-04-13?22:59??寵物醫院系統\4835746dg5d202de56c32.jpg

?????文件?????141006??2009-04-20?22:27??寵物醫院系統\0014800114580.jpg

?????文件?????133244??2009-04-22?22:05??寵物醫院系統\f7aa85dcce0373b5cd1166cb.jpg

?????文件??????66311??2009-04-20?22:27??寵物醫院系統\ff49d703082216743812bbe9.jpg

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