学生在线考勤系统的设计与实现 - 毕业论文(6)

滁州学院本科毕业设计

from user_menu b where b.user_id = ( select a.id from user_info a

where a.userAcct='$login_user_acct$' ) ) and c.menu_status=#menu_status#

\

select count(id) from user_menu

where user_id='$userID$' and menu_id=#menu_id#

5.3.3课程安排功能实现

系统管理员可以按照学校课程安排，打开学校安排菜单栏下的课程管理选项可以对课程进行浏览、编辑，输入本学期各班级要学习的课程名称、学时、学分等以供教师、学生查看，如图5-5所示。

图5-5 课程安排页面

主要代码：

public ModelAndView doAdd(SqlMapClient sqlMap, HttpServletRequest request, HttpServletResponse response) throws Exception {

PrintWriter pw = null; try {

response.setCharacterEncoding(\ pw = response.getWriter();

7 1

滁州学院本科毕业设计

HashMap where = new HashMap(); where.put(\ SysInfo.getLoginUserId(request, response) ); String kechengmingcheng = request.getParameter(\ where.put(\ String suoshuzhuanye = request.getParameter(\ where.put(\

String renkelaoshi = request.getParameter(\ where.put(\ String xueshi = request.getParameter(\ where.put(\

String xuefen = request.getParameter(\ where.put(\

String detail = request.getParameter(\ where.put(\

sqlMap.insert(\ pw.write(\新增操作成功！'}\

5.3.4学年安排功能实现

系统管理员可以按照学校学年安排，打开学校安排菜单栏下的学年管理选项，可以对学年进行浏览、编辑，管理员后台输入学年安排以供教师、同学查看，如图5-6所示。

图5-6学年安排页面

主要代码：

public ModelAndView doAdd(SqlMapClient sqlMap, HttpServletRequest request, HttpServletResponse response) throws Exception {

PrintWriter pw = null; try {

8 1

滁州学院本科毕业设计

response.setCharacterEncoding(\ pw = response.getWriter();

HashMap where = new HashMap(); where.put(\ SysInfo.getLoginUserId(request, response) ); String xuenian = request.getParameter(\

public ModelAndView doUpdate(SqlMapClient sqlMap, HttpServletRequest request, HttpServletResponse response) throws Exception {

PrintWriter pw = null; try {

response.setCharacterEncoding(\ pw = response.getWriter();

HashMap where = new HashMap(); String xuenian = request.getParameter(\ where.put(\

String jihuaanpai = request.getParameter(\ where.put(\ String id = request.getParameter(\ where.put(\

String detail = request.getParameter(\ where.put(\

sqlMap.update(\

5.3.5出勤种类功能实现

系统管理员可以根据现实情况适当增加或者删除出勤的种类，如迟到、早退、正常等，学生的请假类型，如事假、病假等以供教师在考勤时、同学在请假时选择，如图5-7所示。

图5-7出勤种类页面

9 1

滁州学院本科毕业设计

主要代码：

public ModelAndView doAdd(SqlMapClient sqlMap, HttpServletRequest request, HttpServletResponse response) throws Exception {

PrintWriter pw = null; try {

response.setCharacterEncoding(\ pw = response.getWriter();

HashMap where = new HashMap(); where.put(\ SysInfo.getLoginUserId(request, response) ); String qingjialeixing = request.getParameter(\ where.put(\ String detail = request.getParameter(\ where.put(\

sqlMap.insert(\

5.4 考勤管理模块实现

5.4.1查看学生信息功能实现

教师、院系领导在正确输入用户名、密码登录学生考勤系统后在打开考勤管理功能菜单下的学生考勤选项后可以浏览学生信息，如图5-8所示。

图 5-8 查看学生信息页面

主要代码：

public ModelAndView handleRequest(HttpServletRequest request, HttpServletResponse response) throws Exception {

ModelAndView modelAndView = null; SqlMapClient sqlMap = null; try {

sqlMap = DBUtils.getSqlMap(this.getClass()); sqlMap.startTransaction();

public ModelAndView doGetJsonStor (SqlMapClient sqlMap, HttpServletRequest request, HttpServletResponse response) {

0 2

滁州学院本科毕业设计

PrintWriter pw = null; try {

HashMap where = new HashMap(); String kaoqinxueshengSearch = request.getParameter(\ if( kaoqinxueshengSearch != null && !kaoqinxueshengSearch.equals(\ }

String xueyuanSearch = request.getParameter(\ if( xueyuanSearch != null && !xueyuanSearch.equals(\

where.put(\

where.put(\

5.4.2管理学生出勤功能实现

教师在正确输入用户名、密码登录学生考勤系统后可以把上课迟到、旷课等的同学通过编辑该学生的信息打开下拉菜单修改学生的出勤情况。例如，默认情况下学生出勤是正常，当某同学迟到时，教师就可以更改该学生的出勤为迟到，如图5-9所示。

图 5-9 管理学生出勤页面

主要代码： public ModelAndView doUpdate(SqlMapClient sqlMap, HttpServletRequest request, HttpServletResponse response) throws Exception { PrintWriter pw = null; try {

response.setCharacterEncoding(\ pw = response.getWriter();

HashMap where = new HashMap(); sqlMap.update (\ pw.write(\修改表单成功！'}\ } catch (Exception e) {

pw.write(\修改表单失败！'}\ e.printStackTrace();

1 2