package?gem.student.dao;

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

import?gem.student.entity.Student;
import?gem.student.util.DBConnection;

//方法：訪問數據庫中的數據，讀、寫
public?class?StudentDao?{
	//?要寫哪些方法，設計，實現
	//?保存學生數據的方法
	//?OR-MappingO:Student對象，
	public?void?save（Student?student）?{
		//?try-catch-finally
		Connection?conn?=?null;
		PreparedStatement?prep?=?null;
		try?{
			//?1、聯接
			conn?=?DBConnection.getDBConnection（）;
			//?2、SQL
			String?sql?=?“insert?into?student（namesnopasswordsexpolitybirthdaybrief）“
					+?“values（???????）“;
			//?3
			prep?=?conn.prepareStatement（sql）;
			//?4：設置參數值，setXxx（1值）?getXxx（““）
			prep.setString（1?student.getName（））;
			prep.setString（2?student.getSno（））;
			prep.setString（3?student.getPwd（））;
			prep.setInt（4?student.getSex（））;
			prep.setInt（5?student.getPolity（））;
			//?student.getBirthday（）的日期類型是java.util.Date
			//?setDate中的方法的第二個參數要求的日期類型是java.sql.Date
			prep.setDate（6?new?java.sql.Date（student.getBirthday（）.getTime（）））;

			prep.setString（7?student.getBrief（））;
			//?5、執行
			prep.executeUpdate（）;
		}?catch?（ClassNotFoundException?|?SQLException?e）?{
			//?處理異常：轉換為你的應用程序的異常再拋出
			//?異常信息寫到日志文件中
			//?編譯期異常，運行期異常
			throw?new?RuntimeException（e）;
		}
		//?6、close
		finally?{
			try?{
				if?（prep?!=?null）
					prep.close（）;
				if?（conn?!=?null）
					conn.close（）;
			}?catch?（SQLException?e）?{
				throw?new?RuntimeException（e）;
			}
		}
	}

	//?id不變修改方法
	public?void?update（Student?student）?{
	}

	//?刪除調用delete（new?int[]{34363839}）;
	
	public?void?delete（String[]?ids）?{
		Connection?conn?=?null;
		PreparedStatement?prep?=?null;

		try?{
			//?1
			conn?=?DBConnection.getDBConnection（）;
			//?2
			String?sql?=?“delete??from?student?where?id=?“;
			//?3
			prep?=?conn.prepareStatement（sql）;
			//?4
			for（String?id:ids）?{
				prep.setInt（1?Integer.parseInt（id））;
				prep.executeUpdate（）;
			}
			//?5
			
			//?7
		}?catch?（Exception?e）?{
			throw?new?RuntimeException（e）;
		}?finally?{
			try?{
				if（prep!=null）?{
					prep.close（）;
				}
				if（conn?!=?null）?{
					conn.close（）;
				}
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
				throw?new?RuntimeException（e）;
			}

		}
	
	}

	
	

	//?根據學號來獲得學生對象如果學號不存在，返回null
	public?Student?getStudentBySno（String?sno）?{
		Connection?conn?=?null;
		PreparedStatement?prep?=?null;
		ResultSet?rs?=?null;
		Student?s?=?null;
		try?{
			//?1
			conn?=?DBConnection.getDBConnection（）;
			//?2
			String?sql?=?“select?*?from?student?where?sno=?“;
			//?3
			prep?=?conn.prepareStatement（sql）;
			//?4
			prep.setString（1?sno）;
			//?5
			rs?=?prep.executeQuery（）;//?從數據庫取到一條記錄
			//?6:處理查詢結果
			//?將這條記錄中的數據?==?》?s對象中

			if?（

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

?????文件???????1069??2015-11-05?10:26??studentweb\.classpath

?????文件???????1043??2015-10-31?13:59??studentweb\.project

?????文件????????503??2015-10-31?13:59??studentweb\.settings\.jsdtscope

?????文件????????364??2015-10-31?13:59??studentweb\.settings\org.eclipse.jdt.core.prefs

?????文件????????482??2015-10-31?13:59??studentweb\.settings\org.eclipse.wst.common.component

?????文件????????345??2015-10-31?13:59??studentweb\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-10-31?13:59??studentweb\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-10-31?13:59??studentweb\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????7748??2015-11-09?10:48??studentweb\build\classes\gem\student\dao\StudentDao.class

?????文件???????2050??2015-11-09?09:29??studentweb\build\classes\gem\student\dao\test\StudentDaoTest.class

?????文件???????2710??2015-11-05?10:27??studentweb\build\classes\gem\student\entity\Student.class

?????文件???????2193??2015-11-09?11:42??studentweb\build\classes\gem\student\service\StudentService.class

?????文件???????1205??2015-11-05?10:27??studentweb\build\classes\gem\student\util\DBConnection.class

?????文件???????2963??2015-11-05?10:27??studentweb\build\classes\gem\student\web\AddStudentServlet.class

?????文件???????9038??2015-11-09?10:48??studentweb\src\gem\student\dao\StudentDao.java

?????文件????????857??2015-11-09?09:29??studentweb\src\gem\student\dao\test\StudentDaoTest.java

?????文件???????1826??2015-10-21?11:07??studentweb\src\gem\student\entity\Student.java

?????文件???????1632??2015-11-09?11:42??studentweb\src\gem\student\service\StudentService.java

?????文件????????709??2015-10-21?11:10??studentweb\src\gem\student\util\DBConnection.java

?????文件???????2533??2015-11-02?09:12??studentweb\src\gem\student\web\AddStudentServlet.java

?????文件?????????60??2015-10-31?14:15??studentweb\WebContent\common\date\arrow_down.gif

?????文件?????????61??2015-10-31?14:15??studentweb\WebContent\common\date\arrow_up.gif

?????文件???????4206??2015-10-31?14:15??studentweb\WebContent\common\date\date.js

?????文件???????5867??2015-10-31?14:15??studentweb\WebContent\common\date\selectDate.jsp

?????文件???????8192??2015-10-31?14:15??studentweb\WebContent\common\date\Thumbs.db

?????文件???????2223??2015-10-31?14:15??studentweb\WebContent\common\validatecode\generate.jsp

?????文件???????2861??2015-10-31?14:15??studentweb\WebContent\css\demo.css

?????文件?????????39??2015-10-31?13:59??studentweb\WebContent\meta-INF\MANIFEST.MF

?????文件???????2989??2015-10-31?15:22??studentweb\WebContent\student\add.html

?????文件???????1662??2015-10-31?14:15??studentweb\WebContent\student\detail.html

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