package?cn.hyx.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;
import?cn.hyx.entity.Student;
import?cn.hyx.util.DBUtil;

public?class?StudentDAO?{
	
	private??Connection?conn?=?null;
	private??Statement?st?=?null;
	private??PreparedStatement?ps?=?null;
	private??ResultSet?rs?=?null;
		
	//學生登錄
	public?boolean?login（Student?s）{
		boolean?flog?=?false;
			
		try?{
			conn?=?DBUtil.getConnection（）;
			String?sql?=?“select?*from?t_student?where?sname?=???and?spwd?=??“;
			ps?=?conn.prepareStatement（sql）;
			ps.setString（1s.getSname（））;
			ps.setString（2s.getSpwd（））;
			rs?=?ps.executeQuery（）;
			if（rs.next（））{
				flog?=?true;
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DBUtil.close（conn?psrs）;
		}
			
		return?flog;
	}
	//增加學生
		public?boolean?addStudent（Student?s）{
			boolean?flog?=?false;
			
			try?{
				conn?=?DBUtil.getConnection（）;
				String?sql?=?“INSERT?INTO?t_student?（snamespwdsagesgendersphonesemailsaddress）?VALUES?（???????）;“;
				ps?=?conn.prepareStatement（sql）;
				ps.setString（1s.getSname（））;
				ps.setString（2?s.getSpwd（））;
				ps.setInt（3?s.getSage（））;
				ps.setString（4?s.getSgender（））;
				ps.setString（5?s.getSphone（））;
				ps.setString（6?s.getSemail（））;
				ps.setString（7?s.getSaddress（））;
				if（ps!=null）{
					int?count?=?ps.executeUpdate（）;
					if（count?>?0）{
						flog?=?true;
					}
				}
				
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}finally{
				DBUtil.close（conn?ps）;
			}
			
			return?flog;
		}
	//查詢全部學生信息
		public?List?selStudent（int?currentPage）{
			List?list?=?new?ArrayList<>（）;
			
			try?{
				conn?=?DBUtil.getConnection（）;
				String?sql?=?“select?*from?t_student?limit??10;“;
				ps?=?conn.prepareStatement（sql）;
				ps.setInt（1?（currentPage?-?1）?*?10）;
				rs?=?ps.executeQuery（）;
				//把從數據庫里得到得數據傳送到Student里面，再把Student里的數據給list
				while（rs.next（））{
					Student?s?=?new?Student（）;//實例化一個student，讓每一行數據存入一個s
					s.setSid（rs.getInt（1））;
					s.setSname（rs.getString（2））;
					s.setSpwd（rs.getString（3））;
					s.setSage（rs.getInt（4））;
					s.setSgender（rs.getString（5））;
					s.setSphone（rs.getString（6））;
					s.setSemail（rs.getString（7））;
					s.setSaddress（rs.getString（8））;
					list.add（s）;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}finally{
				DBUtil.close（conn?psrs）;
			}
			return?list;
		}
		//?按照id查詢
		public?Student?selectById（int?sid）{
			Student?s?=?new?Student（）;
			
			try?{
				conn?=?DBUtil.getConnection（）;
				String?sql?=“select?*?from?t_student?where?sid?=?“;
				ps?=?conn.prepareStatement（sql）;
				ps.setInt（1?sid）;
				rs=ps.executeQuery（）;
				while（rs.next（））{
					
					s.setSid（rs.getInt（1））;
					s.setSname（rs.getStr

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

?????文件????????963??2018-12-10?21:53??StudentManageSystem\.classpath

?????文件????????919??2018-07-18?12:05??StudentManageSystem\.project

?????文件????????567??2018-07-18?12:05??StudentManageSystem\.settings\.jsdtscope

?????文件?????????76??2018-08-07?13:03??StudentManageSystem\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2018-07-18?12:05??StudentManageSystem\.settings\org.eclipse.jdt.core.prefs

?????文件????????509??2018-07-18?12:05??StudentManageSystem\.settings\org.eclipse.wst.common.component

?????文件????????305??2018-10-12?17:00??StudentManageSystem\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2018-07-18?12:05??StudentManageSystem\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2018-07-18?12:05??StudentManageSystem\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????7253??2019-04-28?21:35??StudentManageSystem\build\classes\cn\hyx\dao\StudentDAO.class

?????文件???????3699??2019-04-28?21:35??StudentManageSystem\build\classes\cn\hyx\dao\UserDAO.class

?????文件???????2190??2019-04-28?21:35??StudentManageSystem\build\classes\cn\hyx\entity\Student.class

?????文件???????1065??2019-04-28?21:35??StudentManageSystem\build\classes\cn\hyx\entity\User.class

?????文件???????1970??2019-04-28?21:35??StudentManageSystem\build\classes\cn\hyx\servlet\ChooseServlet.class

?????文件???????1526??2019-04-28?21:35??StudentManageSystem\build\classes\cn\hyx\servlet\SetCharFilter.class

?????文件???????4287??2019-04-28?21:35??StudentManageSystem\build\classes\cn\hyx\servlet\StudentServlet.class

?????文件???????7972??2019-04-28?21:35??StudentManageSystem\build\classes\cn\hyx\servlet\UserServlet.class

?????文件???????2119??2019-04-28?21:35??StudentManageSystem\build\classes\cn\hyx\util\DBUtil.class

?????文件???????3682??2018-07-23?21:15??StudentManageSystem\sql\studentSQL.sql

?????文件???????7089??2018-07-26?23:26??StudentManageSystem\src\cn\hyx\dao\StudentDAO.java

?????文件???????3019??2018-08-07?13:03??StudentManageSystem\src\cn\hyx\dao\UserDAO.java

?????文件???????1666??2018-07-18?13:17??StudentManageSystem\src\cn\hyx\entity\Student.java

?????文件????????700??2018-07-18?13:31??StudentManageSystem\src\cn\hyx\entity\User.java

?????文件???????1541??2018-07-21?16:39??StudentManageSystem\src\cn\hyx\servlet\ChooseServlet.java

?????文件???????1282??2018-07-20?08:59??StudentManageSystem\src\cn\hyx\servlet\SetCharFilter.java

?????文件???????4687??2018-09-25?21:15??StudentManageSystem\src\cn\hyx\servlet\StudentServlet.java

?????文件??????10044??2018-10-13?14:48??StudentManageSystem\src\cn\hyx\servlet\UserServlet.java

?????文件???????1784??2018-12-10?22:21??StudentManageSystem\src\cn\hyx\util\DBUtil.java

?????文件????????685??2018-07-21?13:26??StudentManageSystem\WebContent\.project

?????文件???????1528??2018-08-21?22:01??StudentManageSystem\WebContent\AlterStu.jsp

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