package?com.rj.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?com.rj.entity.Student;
import?com.rj.utils.DBConnection;

/**
?*?student數(shù)據(jù)訪問對象
?*?
?*?@author?Administrator
?*?
?*/
public?class?StudentDao?{
	/**
	?*?查詢?nèi)?br/>	?*?@return
	?*/
	public?static?List?queryAll（）{
		List?list=new?ArrayList（）;
		//1.取得對象連接
		Connection?conn?=DBConnection.getConn（）;
		PreparedStatement?ps=null;
		ResultSet?rs=null;
		
		try?{
			ps=conn.prepareStatement（“select?*?from?student“）;
			//執(zhí)行
			rs=ps.executeQuery（）;
			while?（rs.next（））{
				list.add（new?Student（rs.getInt（1）rs.getString（2）rs.
						getString（3）rs.getString（4）rs.getInt（5）））;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}finally{
			DBConnection.close（rs?ps?conn）;
		}
		return?list;
		
	}
	/**
	?*?根據(jù)id刪除
	?*?@param?id
	?*/
	public?static?void?delById（int?id）{
		Connection?conn?=?DBConnection.getConn（）;
		String?sql?=?“delete?from?student?where?id=?“;
		PreparedStatement?ps?=?null;
		try?{
			ps?=?conn.prepareStatement（sql）;
			//給參數(shù)賦值
			ps.setInt（1?id）;
			//?執(zhí)行
			ps.executeUpdate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DBConnection.close（null?ps?conn）;
		}
	}
	/**
	?*?根據(jù)id修改
	?*?@param?id
	?*/
	public?static?void?alterById（int?idString?stunoString?nameString?genderint?age）{
		Connection?conn?=?DBConnection.getConn（）;
		String?sql?=?“update?student?set?stuno=?name=?gender=?age=??where?id=?“;
		PreparedStatement?ps?=?null;
		try?{
			ps?=?conn.prepareStatement（sql）;
			//給參數(shù)賦值
			?ps.setString（1?stuno）;??
	?????????ps.setString（2?name）;??
	?????????ps.setString（3?gender）;??
	?????????ps.setInt（4?age）;??
	?????????ps.setInt（5?id）;?
			//?執(zhí)行
			ps.executeUpdate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DBConnection.close（null?ps?conn）;
		}
	}
	/**
	?*?增加
	?*?@param?id
	?*/
	public?void?addstudent（int?idString?stunoString?nameString?genderint?age）{
		Connection?conn?=?DBConnection.getConn（）;
		String?sql?=?“insert?into?student?values?（?????）“;
		PreparedStatement?ps?=?null;
		try?{
			ps?=?conn.prepareStatement（sql）;
			//給參數(shù)賦值
			ps.setInt（1?id）;
			ps.setString（2?stuno）;
			ps.setString（3?name）;
			ps.setString（4?gender）;
			ps.setInt（5?age）;
			//?執(zhí)行
			ps.executeUpdate（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DBConnection.close（null?ps?conn）;
		}
	}
	
	/**
	?*?根據(jù)id查詢
	?*?@param?id
	?*/
????public?static?Student?queryById（int?id）{??
????????String?sql?=?“select?*?from?student?where?id?=??“;??
????????Connection?conn?=?null;??
????????PreparedStatement?ps?=?null;??????
????????ResultSet?res?=?null;??
????????Student?student?=?null;??
??????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-05-26?09:17??rjday3\
?????文件????????1093??2018-05-26?09:17??rjday3\.classpath
?????文件????????1331??2018-05-26?09:18??rjday3\.project
?????目錄???????????0??2018-05-26?09:17??rjday3\.settings\
?????文件?????????522??2018-05-26?09:17??rjday3\.settings\.jsdtscope
?????文件?????????364??2018-05-26?09:17??rjday3\.settings\org.eclipse.jdt.core.prefs
?????文件?????????477??2018-05-26?09:17??rjday3\.settings\org.eclipse.wst.common.component
?????文件?????????414??2018-05-26?09:17??rjday3\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-05-26?09:17??rjday3\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-05-26?09:17??rjday3\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-05-27?22:17??rjday3\src\
?????目錄???????????0??2018-05-26?09:58??rjday3\src\com\
?????目錄???????????0??2018-05-26?15:20??rjday3\src\com\rj\
?????目錄???????????0??2018-05-26?15:21??rjday3\src\com\rj\dao\
?????文件????????4056??2018-05-28?14:04??rjday3\src\com\rj\dao\StudentDao.java
?????目錄???????????0??2018-05-26?10:22??rjday3\src\com\rj\entity\
?????文件?????????900??2018-05-27?20:34??rjday3\src\com\rj\entity\Student.java
?????目錄???????????0??2018-05-28?12:56??rjday3\src\com\rj\servlet\
?????文件????????1375??2018-05-27?16:23??rjday3\src\com\rj\servlet\StudentAddServlet.java
?????文件????????1371??2018-05-28?13:42??rjday3\src\com\rj\servlet\StudentAlterServlet.java
?????文件????????1112??2018-05-27?15:46??rjday3\src\com\rj\servlet\StudentDelServlet.java
?????文件????????1104??2018-05-28?13:45??rjday3\src\com\rj\servlet\StudentListServlet.java
?????文件????????1028??2018-05-28?13:00??rjday3\src\com\rj\servlet\StudentUpdServlet.java
?????文件????????1063??2018-05-28?11:14??rjday3\src\com\rj\servlet\StudentViewServlet.java
?????目錄???????????0??2018-05-26?13:58??rjday3\src\com\rj\utils\
?????文件????????1912??2018-05-26?17:13??rjday3\src\com\rj\utils\DBConnection.java
?????目錄???????????0??2018-05-28?11:56??rjday3\WebRoot\
?????文件????????1386??2018-05-27?16:23??rjday3\WebRoot\addstudent.jsp
?????文件????????1787??2018-05-28?13:19??rjday3\WebRoot\alterstudent.jsp
?????文件?????????995??2018-05-26?16:59??rjday3\WebRoot\index.jsp
?????文件?????????102??2018-05-26?10:38??rjday3\WebRoot\inner.jsp
............此處省略24個文件信息