資源簡介
基于JSP的學生考勤管理系統(MySQL版)
1.包含源程序,數據庫腳本。代碼和數據庫腳本都有詳細注釋。
2.課題設計僅供參考學習使用,可以在此基礎上進行擴展完善。
開發環境:
MyEclipse 8,MySLQ 5.0,JDK1.7,Tomcat 5.5
涉及技術點:
MVC模式、JSP、JDBC、HTML、JavaScript、CSS、JQUERY、文件上傳等
程序功能:
1.學生:請假申請、請假查看、考勤信息查看。
2.老師:請假審批、考勤管理、考勤統計查詢。
2.管理員:請假管理、考勤管理、考勤統計查詢、老師信息管理、學生信息管理、課程信息管理、系統設置。

代碼片段和文件信息
package?com.biyeseng.action;
import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.*;
import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?com.biyeseng.db.DBManager;
/**
?*?添加管理員
?*?@author?win7
?*
?*/
public?class?AddAdminAction?extends?HttpServlet?{
/**
?*?Constructor?of?the?object.
?*/
public?AddAdminAction()?{
super();
}
/**
?*?Destruction?of?the?servlet.?
?*/
public?void?destroy()?{
super.destroy();?//?Just?puts?“destroy“?string?in?log
//?Put?your?code?here
}
/**
?*?The?doPost?method?of?the?servlet.?
?*
?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?post.
?*?
?*?@param?request?the?request?send?by?the?client?to?the?server
?*?@param?response?the?response?send?by?the?server?to?the?client
?*?@throws?ServletException?if?an?error?occurred
?*?@throws?IOException?if?an?error?occurred
?*/
public?void?doPost(HttpServletRequest?request?HttpServletResponse?response)
throws?ServletException?IOException?{
response.setContentType(“text/html“);
PrintWriter?out?=?response.getWriter();
String?userName=request.getParameter(“userName“);
String?userPw=request.getParameter(“userPw“);
?
DBManager?dbm?=?new?DBManager();
String?sql?=?“insert?into?admin(userNameuserPw)?values(‘“+userName+“‘‘“+userPw+“‘)“;
Statement?stat?=?null;
Connection?conn=null;
try?{
conn=dbm.getConnection();
stat?=?conn.createStatement();
System.out.println(sql);
stat.execute(sql);
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}?finally?{
try?{
if(stat!=null)
stat.close();
if(conn!=null)
conn.close();
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
response.sendRedirect(“admin/list.jsp“);
out.flush();
out.close();
}
/**
?*?Initialization?of?the?servlet.?
?*
?*?@throws?ServletException?if?an?error?occurs
?*/
public?void?init()?throws?ServletException?{
//?Put?your?code?here
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????3942??2016-09-29?17:34??數據庫文件\xskq.sql
?????文件????????622??2016-09-29?17:33??readme.txt
?????文件????????840??2015-10-23?12:46??代碼\xskq\.classpath
?????文件????????286??2016-09-22?10:39??代碼\xskq\.myme
?????文件???????1277??2015-04-27?15:33??代碼\xskq\.project
?????文件???????1040??2015-03-30?15:53??代碼\xskq\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????86??2015-03-10?11:46??代碼\xskq\.settings\org.eclipse.core.resources.prefs
?????文件????????629??2015-04-28?10:53??代碼\xskq\.settings\org.eclipse.jdt.core.prefs
?????文件???????2270??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\AddAdminAction.java
?????文件???????2446??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\AddKaoAction.java
?????文件???????2323??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\AddKeAction.java
?????文件???????2600??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\AddQingAction.java
?????文件???????2503??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\AddStuAction.java
?????文件???????2503??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\AddTeaAction.java
?????文件???????2291??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\DelAdminAction.java
?????文件???????2267??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\DelKaoAction.java
?????文件???????2263??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\DelKeAction.java
?????文件???????2271??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\DelQingAction.java
?????文件???????2267??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\DelStuAction.java
?????文件???????2267??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\DelTeaAction.java
?????文件???????4368??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\LoginAction.java
?????文件???????2314??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\ModAdminAction.java
?????文件???????2485??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\ModKaoAction.java
?????文件???????2365??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\ModKeAction.java
?????文件???????2625??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\ModQingAction.java
?????文件???????2544??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\ModStuAction.java
?????文件???????2545??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\ModTeaAction.java
?????文件???????2452??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\action\SpQingAction.java
?????文件???????4259??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\db\DBManager.java
?????文件????????799??2016-09-22?10:55??代碼\xskq\src\com\biyeseng\filter\CharsetFilter.java
............此處省略491個文件信息
評論
共有 條評論