package?com.dao;??
??
import?java.sql.Connection;??
import?java.sql.DriverManager;??
import?java.sql.PreparedStatement;??
import?java.sql.ResultSet;??
import?java.sql.SQLException;??
import?java.util.ArrayList;??
import?java.util.HashMap;??
import?java.util.List;??
import?java.util.Map;??
??
public?class?Student2Dao?{??
????private?Connection?conn=null;??
????private?PreparedStatement?psmt=null;??
????private?ResultSet?rs=null;??
????/**?
?????*?獲得數據庫連接?
?????*/??
????private?void?openConn（）{??
????????//首先定義下連接數據的URL、用戶名、密碼??
????????String?url=“jdbc:oracle:thin:@127.0.0.1:1521:orcl“;??
????????String?user=“scott“;??
????????String?password=“tiger“;??
?????????try?{??
????????????Class.forName（“oracle.jdbc.driver.OracleDriver“）;??
????????????conn=DriverManager.getConnection（urluserpassword）;??
????????}?catch?（ClassNotFoundException?e）?{??
????????????e.printStackTrace（）;??
????????}?catch?（SQLException?e）?{??
????????????e.printStackTrace（）;??
????????}??
????}??
????/**?
?????*?獲得所有員工數據?
?????*/??
????public?List?getAllstudent2（）{??
????????List?list=new?ArrayList（）;??
????????openConn（）;??
????????String?sql=“select?*?from?student2?order?by?id?asc“;??
????????try?{??
????????????psmt=conn.prepareStatement（sql）;??
????????????rs=psmt.executeQuery（）;??
????????????while（rs.next（））{??
????????????????Map?students=new?HashMap（）;??
????????????????students.put（“stname“?rs.getString（“stname“））;??
????????????????students.put（“stsex“rs.getString（“stsex“））;??
????????????????students.put（“staddress“?rs.getString（“staddress“））;??
????????????????list.add（students）;??
????????????}??
????????}?catch?（SQLException?e）?{??
????????????e.printStackTrace（）;??
????????}??
????????return?list;??
????}???
????/**?
?????*??獲取第幾頁的數據?
?????*/??
????public?List?getAllstudent2ByPage（int?pageSizeint?pageIndex）{??
??????????List?list?=new?ArrayList（）;??
??????????String?sql=“select?*?from?（select?rownum?as?rt.*?from?“?+??
??????????????????????????????????????“（select?student2.*?from?student2?order?by?id?asc）?t?where??rownum<=“+（pageSize*pageIndex）??
??????????????????????????????????????+“）?where?r>“+pageSize*（pageIndex-1）;??
???????????try?{??
??????????????psmt=conn.prepareStatement（sql）;??
??????????????rs=psmt.executeQuery（）;??
??????????????while（rs.next（））{??
??????????????????Map?map=new?HashMap（）;??
??????????????????map.put（“stname“?rs.getString（“stname“））;??
??????????????????map.put（“stsex“rs.getString（“stsex“））;??
??????????????????map.put（“staddress“?rs.getString（“staddress“））;??
??????????????????list.add（map）;??
??????????????}??
????????}?catch?（SQLException?e）?{??
????????????e.printStackTrace（）;??
????????}??
????????return?list;??
????}??
????/**?
?????*??獲取員工的總數?
?????*??
?????*/??
????public?int?countstudent2（）{??
????????int?count=0;??
????????String?sql=“select?count（*）?from?student2“;??
????????openConn（）;??
????????try?{??
????????????psmt=conn.

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-03-11?22:33??page\
?????文件?????????529??2017-03-11?22:35??page\.classpath
?????目錄???????????0??2017-03-13?16:19??page\.myeclipse\
?????文件?????????285??2017-03-11?22:35??page\.mymetadata
?????文件????????1747??2017-03-11?22:49??page\.project
?????目錄???????????0??2017-03-11?22:35??page\.settings\
?????文件?????????500??2017-03-11?22:33??page\.settings\.jsdtscope
?????文件?????????364??2017-03-11?22:33??page\.settings\org.eclipse.jdt.core.prefs
?????文件?????????450??2017-03-11?22:35??page\.settings\org.eclipse.wst.common.component
?????文件?????????252??2017-03-11?22:35??page\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-03-11?22:35??page\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-03-11?22:35??page\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-03-11?22:46??page\WebRoot\
?????目錄???????????0??2017-03-11?22:33??page\WebRoot\meta-INF\
?????文件??????????36??2017-03-11?22:33??page\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2017-03-11?22:33??page\WebRoot\WEB-INF\
?????目錄???????????0??2017-03-11?22:40??page\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-03-11?22:40??page\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2017-03-11?22:40??page\WebRoot\WEB-INF\classes\com\dao\
?????文件????????3587??2017-03-11?22:53??page\WebRoot\WEB-INF\classes\com\dao\Student2Dao.class
?????目錄???????????0??2017-03-11?22:40??page\WebRoot\WEB-INF\lib\
?????文件?????1171446??2017-02-26?20:45??page\WebRoot\WEB-INF\lib\classes12.jar
?????文件?????????404??2017-03-11?22:35??page\WebRoot\WEB-INF\web.xml
?????文件?????????834??2017-03-11?22:33??page\WebRoot\index.jsp
?????文件????????2017??2017-03-13?11:45??page\WebRoot\pageTest.jsp
?????目錄???????????0??2017-03-11?22:39??page\src\
?????目錄???????????0??2017-03-11?22:39??page\src\com\
?????目錄???????????0??2017-03-11?22:40??page\src\com\dao\
?????文件????????3570??2017-03-11?22:53??page\src\com\dao\Student2Dao.java