package?com.yuanyuren.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?com.yuanyuren.model.Eduadmin;
import?com.yuanyuren.model.Pagebean;
import?com.yuanyuren.model.Student;

public?class?Eduadmindao?{

public?Eduadmin?login（Connection?conEduadmin?eduadmin）throws?Exception{
		
		Eduadmin?result?=?null;
		String?sql?=?“select?*?from?school?where?e_number?=???and?password?=??“;
		PreparedStatement?p?=?con.prepareStatement（sql）;
	????p.setString（1?eduadmin.getE_number（））;
		p.setString（2?eduadmin.getPassword（））;
		ResultSet?rs?=?p.executeQuery（）;
		if（rs.next（））?{
		????result?=?new?Eduadmin（）;
			result.setE_number（rs.getString（“e_number“））;
			result.setPassword（rs.getString（“password“））;

		}
		return?result;
	}



/*
?*?查看評價分頁
?*/

public?ResultSet?Fenye1（Connection?conPagebean??pagebeancom.yuanyuren.model.Comment?commentHttpServletRequest?request?HttpServletResponse?response）throws?Exception{
	
	?String??name?=?（String）?request.getSession（）.getAttribute（“s_number“）;
	//JOptionPane.showMessageDialog（nullname）;
	StringBuffer?p?=?new?StringBuffer（“select?*?from??comment“）;
	if（comment?!=?null&&comment.getKcname（）!=?null）
?????{
????	p.append（“??and?comment.kcname?like?‘%“?+?comment.getKcname（）+“%‘“）;
????}
	
	if（comment?!=?null&&comment.getKcteacher（）!=?null）
????{
???	p.append（“??and?comment.kcteacher?like?‘%“?+?comment.getKcteacher（）+“%‘“）;
???}
	if（pagebean?!=?null?）?{
		p.append（“?limit?“?+?pagebean.getStart（）+““+pagebean.getRows（））;
	}
	PreparedStatement?pstmt=con.prepareStatement（p.toString（）.replaceFirst（“and““where“））;
????return?pstmt.executeQuery（）;
}



/*
?*?查看評價頁面數
?*/

public??int?Total1（Connection?con?com.yuanyuren.model.Comment?commentHttpServletRequest?request?HttpServletResponse?response）throws?Exception{
??
	//String??name?=?（String）?request.getSession（）.getAttribute（“s_number“）;
	//JOptionPane.showMessageDialog（nullname）;
	StringBuffer?p?=?new?StringBuffer（“select?count（*）?as?total?from?comment?“）;
	if（comment?!=?null&&comment.getKcname（）!=?null）
????{
???	p.append（“??and?comment.kcname?like?‘%“?+?comment.getKcname（）+“%‘“）;
???}
	
	if（comment?!=?null&&comment.getKcteacher（）!=?null）
????{
???	p.append（“??and?comment.kcteacher?like?‘%“?+?comment.getKcteacher（）+“%‘“）;
???}
	PreparedStatement?pstmt=con.prepareStatement（p.toString（）.replaceFirst（“and““where“））;
	ResultSet?rs=?pstmt.executeQuery（）;
	if（rs.next（））
	{
		return?rs.getInt（“total“）;
	}
	else?{
		return?0;
	}
}
}

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

?????文件????????463??2019-07-18?21:13??JiaoPing\.classpath

?????文件????????908??2019-07-12?17:21??JiaoPing\.project

?????文件????????567??2019-07-12?17:21??JiaoPing\.settings\.jsdtscope

?????文件????????364??2019-07-12?17:21??JiaoPing\.settings\org.eclipse.jdt.core.prefs

?????文件????????476??2019-07-12?17:21??JiaoPing\.settings\org.eclipse.wst.common.component

?????文件????????305??2019-07-13?15:48??JiaoPing\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2019-07-12?17:21??JiaoPing\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2019-07-12?17:21??JiaoPing\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3815??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\dao\Eduadmindao.class

?????文件???????8693??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\dao\Studentdao.class

?????文件???????4168??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\dao\Subjectdao.class

?????文件???????9109??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\dao\Teacherdao.class

?????文件???????3871??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\model\Comment.class

?????文件???????1680??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\model\Eduadmin.class

?????文件????????912??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\model\Pagebean.class

?????文件???????2575??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\model\Student.class

?????文件???????2665??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\model\Subject.class

?????文件???????1365??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\model\tcomment.class

?????文件???????2352??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\model\Teacher.class

?????文件???????1041??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\util\Dateutil.class

?????文件???????1524??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\util\Json.class

?????文件???????1713??2019-08-26?21:38??JiaoPing\build\classes\com\yuanyuren\util\mysql.class

?????文件????????938??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\util\Reponse.class

?????文件???????3016??2019-08-26?21:38??JiaoPing\build\classes\com\yuanyuren\web\AddUpdateServlet.class

?????文件???????2914??2019-08-26?21:38??JiaoPing\build\classes\com\yuanyuren\web\AddUpdateStudentServlet.class

?????文件???????2891??2019-08-26?21:38??JiaoPing\build\classes\com\yuanyuren\web\AddUpdateTeacherServlet.class

?????文件???????2088??2019-08-26?21:38??JiaoPing\build\classes\com\yuanyuren\web\DeleteStudntServlrt.class

?????文件???????2091??2019-08-26?21:38??JiaoPing\build\classes\com\yuanyuren\web\DeleteTeacherServlet.class

?????文件???????3095??2019-08-26?21:38??JiaoPing\build\classes\com\yuanyuren\web\E_PJListServlet.class

?????文件???????1789??2019-08-22?20:59??JiaoPing\build\classes\com\yuanyuren\web\GetkcteacherServlet.class

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