資源簡介
此項(xiàng)目為學(xué)校的教評系統(tǒng)，開發(fā)工具為Eclipse,數(shù)據(jù)庫為Mysql,開發(fā)語言為JAVA，框架為最基礎(chǔ)的Servlet。實(shí)現(xiàn)了學(xué)生進(jìn)行選課、退課、進(jìn)行教評；教師能夠查看學(xué)生對自己的評價(jià)結(jié)果以及對其他教師進(jìn)行評價(jià)；教務(wù)處人員能夠發(fā)布課程，對教評結(jié)果進(jìn)行綜合整理，對教師和學(xué)生個(gè)人信息進(jìn)行修改等功能。這一項(xiàng)目是一個(gè)功能較為完善的教評系統(tǒng)，下載后導(dǎo)入Eclipse即可使用。
代碼片段和文件信息
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;
}
/*
?*?查看評價(jià)分頁
?*/
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（）;
}
/*
?*?查看評價(jià)頁面數(shù)
?*/
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;
}
}
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件????????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.xm
?????文件?????????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個(gè)文件信息
評論
共有 條評論
川公網(wǎng)安備 51152502000135號