package?dao;
import?java.sql.SQLException;
import?entity.Student;
/**
*?學生數據訪問類
*?@author?BeanSoft@126.com
*?@version?0.1?2007-12-21
*/
public?class?StudentDAO?{
/**
*?根據用戶名和密碼找到用戶對象。
*?@param?username?用戶名
*?@param?password?密碼
*?@return?找到的用戶對象，找不到返回null
*/
public?Student?findStudent（String?username?String?password）?{
try?{
Class.forName（“com.mysql.jdbc.Driver“）;
}?catch?（ClassNotFoundException?e）?{
e.printStackTrace（）;
}
java.sql.Connection?conn?=?null;//數據庫連接
java.sql.PreparedStatement?pstmt?=?null;//數據庫表達式
java.sql.ResultSet?rs?=?null;//結果集
String?sql?=?“select?*?from?Student?where?username?=???and?password=??“;//SQL
try?{
conn?=?java.sql.DriverManager.getConnection（“jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=GBK“?“root“?null）;
pstmt?=?conn.prepareStatement（sql）;
pstmt.setString（1?username）;
pstmt.setString（2?password）;
rs?=?pstmt.executeQuery（）;
if（rs?!=null?&&?rs.next（））?{
//?讀到數據，生成實體類
Student?student?=?new?Student（）;
student.setId（rs.getInt（1））;
student.setUsername（rs.getString（“username“））;
student.setPassword（rs.getString（“password“））;
student.setAge（rs.getInt（“age“））;
System.out.println（rs.getString（“username“））;
return?student;
}
}?catch?（SQLException?e）?{
e.printStackTrace（）;
}?finally?{
//?6.?釋放資源，建議放在finally語句中確保都被關閉掉了
try?{
rs.close（）;
}?catch?（SQLException?e）?{}
try?{
pstmt.close（）;
}?catch?（SQLException?e）?{}
try?{
conn.close（）;
}?catch?（SQLException?e）?{}
}
return?null;
}
}

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

?????文件????????894??2007-12-22?21:43??實現用戶登陸\login.html

?????文件?????703265??2008-03-05?17:27??實現用戶登陸\mysql-connector-java-5.1.6-bin.jar

?????文件????????308??2007-12-22?21:51??實現用戶登陸\result.jsp

?????文件????????455??2009-08-07?16:08??實現用戶登陸\userLogin\.classpath

?????文件????????300??2009-08-07?16:02??實現用戶登陸\userLogin\.mymetadata

?????文件???????1227??2009-08-07?16:18??實現用戶登陸\userLogin\.project

?????文件???????1586??2009-08-07?16:41??實現用戶登陸\userLogin\src\dao\StudentDAO.java

?????文件????????930??2009-08-07?16:09??實現用戶登陸\userLogin\src\entity\Student.java

?????文件???????2236??2009-08-07?16:07??實現用戶登陸\userLogin\src\filters\TomcatFormFilter.java

?????文件???????1518??2009-08-07?16:41??實現用戶登陸\userLogin\src\servlets\LoginServlet.java

?????文件????????834??2009-08-07?16:02??實現用戶登陸\userLogin\WebRoot\index.jsp

?????文件????????926??2009-08-07?16:32??實現用戶登陸\userLogin\WebRoot\login.html

?????文件?????????39??2009-08-07?16:02??實現用戶登陸\userLogin\WebRoot\meta-INF\MANIFEST.MF

?????文件????????889??2009-08-07?16:17??實現用戶登陸\userLogin\WebRoot\result.jsp

?????文件???????2560??2009-08-07?16:41??實現用戶登陸\userLogin\WebRoot\WEB-INF\classes\dao\StudentDAO.class

?????文件???????1088??2009-08-07?16:09??實現用戶登陸\userLogin\WebRoot\WEB-INF\classes\entity\Student.class

?????文件???????1628??2009-08-07?16:08??實現用戶登陸\userLogin\WebRoot\WEB-INF\classes\filters\TomcatFormFilter$Request.class

?????文件???????1616??2009-08-07?16:08??實現用戶登陸\userLogin\WebRoot\WEB-INF\classes\filters\TomcatFormFilter.class

?????文件???????1844??2009-08-07?16:41??實現用戶登陸\userLogin\WebRoot\WEB-INF\classes\servlets\LoginServlet.class

?????文件?????703265??2009-08-07?16:08??實現用戶登陸\userLogin\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.6-bin.jar

?????文件???????1042??2009-08-07?16:08??實現用戶登陸\userLogin\WebRoot\WEB-INF\web.xml

?????文件??????65024??2009-08-07?16:00??實現用戶登陸\用戶登陸.doc

?????目錄??????????0??2009-08-07?16:43??實現用戶登陸\userLogin\WebRoot\WEB-INF\classes\dao

?????目錄??????????0??2009-08-07?16:43??實現用戶登陸\userLogin\WebRoot\WEB-INF\classes\entity

?????目錄??????????0??2009-08-07?16:43??實現用戶登陸\userLogin\WebRoot\WEB-INF\classes\filters

?????目錄??????????0??2009-08-07?16:43??實現用戶登陸\userLogin\WebRoot\WEB-INF\classes\servlets

?????目錄??????????0??2009-08-07?16:43??實現用戶登陸\userLogin\WebRoot\WEB-INF\classes

?????目錄??????????0??2009-08-07?16:43??實現用戶登陸\userLogin\WebRoot\WEB-INF\lib

?????目錄??????????0??2009-08-07?16:43??實現用戶登陸\userLogin\src\dao

?????目錄??????????0??2009-08-07?16:43??實現用戶登陸\userLogin\src\entity

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