package?com.gzgs.dao;

import?java.sql.SQLException;
import?java.util.List;

import?com.gzgs.domain.Student;

/**
?*?學生信息數據訪問層dao模型
?*?
?*?@author?SDL
?*
?*/
public?interface?StudentDao?{
	int?PAGE_SIZE?=?5;?//?一頁顯示多少條記錄

	/**
	?*?查詢當頁的學生數據
	?*?
	?*?@param?currentPage
	?*?@return
	?*?@throws?SQLException
	?*/
	List?findStudentByPage（int?currentPage）?throws?SQLException;

	/**
	?*?查詢總的學生數量
	?*/

	int?findCount（）?throws?SQLException;
	
	
	/**
	?*?模糊查詢，?根據姓名或者根據性別進行查詢，或者兩者兼有。?
	?*?@param?sname
	?*?@param?sgender
	?*?@return?List
	?*?@throws?SQLException
	?*/
	List?searchStudent（String?sname??String?sgender）??throws?SQLException?;
	
	/**
	?*?添加學生
	?*?@param?student?需要添加到數據庫的學生對象
	?*?@throws?SQLException
	?*/
	void?insert（Student?student）?throws?SQLException?;
	
	/**
	?*?根據id刪除學生
	?*?@param?sid
	?*?@throws?SQLException
	?*/
	void?delete（int?sid）?throws?SQLException?;
	
	
	/**
	?*?更新學生信息
	?*?@param?student?需要更新的學生數據
	?*?@throws?SQLException
	?*/
	void?update?（Student?student?）throws?SQLException?;
	
	/**
	?*?根據ID查詢單個學生對象，用于修改學生信息的時候先獲取要被修改的學生的信息
	?*?@param?sid
	?*?@return
	?*?@throws?SQLException
	?*/
	Student?findStudentById（int?sid）??throws?SQLException?;
}

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

?????文件????8886342??2016-05-15?11:01??學生管理系統源碼+Tomcat7\apache-tomcat-7.0.52.zip

?????文件????????727??2020-05-30?10:15??學生管理系統源碼+Tomcat7\stu\.classpath

?????文件????????903??2020-05-29?14:58??學生管理系統源碼+Tomcat7\stu\.project

?????文件????????567??2020-05-29?14:58??學生管理系統源碼+Tomcat7\stu\.settings\.jsdtscope

?????文件????????670??2020-05-30?15:37??學生管理系統源碼+Tomcat7\stu\.settings\org.eclipse.jdt.core.prefs

?????文件????????106??2020-05-30?15:37??學生管理系統源碼+Tomcat7\stu\.settings\org.eclipse.ltk.core.refactoring.prefs

?????文件????????461??2020-05-29?14:58??學生管理系統源碼+Tomcat7\stu\.settings\org.eclipse.wst.common.component

?????文件????????305??2020-05-30?10:00??學生管理系統源碼+Tomcat7\stu\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2020-05-29?14:58??學生管理系統源碼+Tomcat7\stu\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2020-05-29?14:58??學生管理系統源碼+Tomcat7\stu\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????668??2020-05-31?20:09??學生管理系統源碼+Tomcat7\stu\build\classes\c3p0-config.xml

?????文件???????4185??2020-05-31?20:51??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\dao\impl\StudentDaoImpl.class

?????文件???????1205??2020-05-30?14:57??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\dao\impl\UserDaoImpl.class

?????文件????????741??2020-05-31?20:42??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\dao\StudentDao.class

?????文件????????237??2020-05-30?14:57??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\dao\UserDao.class

?????文件???????1764??2020-05-30?18:54??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\domain\PageBean.class

?????文件???????2836??2020-05-30?18:41??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\domain\Student.class

?????文件???????1139??2020-05-30?15:49??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\domain\User.class

?????文件???????2370??2020-05-31?20:45??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\service\impl\StudentServiceImpl.class

?????文件????????732??2020-05-30?14:57??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\service\impl\UserServiceImpl.class

?????文件????????617??2020-05-31?20:44??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\service\StudentService.class

?????文件????????249??2020-05-30?14:57??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\service\UserService.class

?????文件???????2707??2020-05-31?20:00??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\servlet\AddServlet.class

?????文件???????1752??2020-05-31?20:30??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\servlet\DeleteServlet.class

?????文件???????1754??2020-05-31?20:55??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\servlet\EditServlet.class

?????文件???????2382??2020-05-30?21:05??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\servlet\LoginServlet.class

?????文件???????1955??2020-05-31?19:13??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\servlet\SearchStudentServlet.class

?????文件???????1809??2020-05-30?19:57??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\servlet\StudentListPageServlet.class

?????文件???????1782??2020-05-30?19:53??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\servlet\StudentListServlet.class

?????文件???????2804??2020-05-31?20:58??學生管理系統源碼+Tomcat7\stu\build\classes\com\gzgs\servlet\UpdateServlet.class

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