学生信息管理系统

文末附项目源码

使用技术

servlet+jdbc+mysql

jsp+css+js

功能模块

学生端

• 信息管理

• 选课

• 考勤信息

• 请假信息管理

• 成绩信息管理

• 登录注册

老师端

• 学生信息管理

• 班级信息管理

• 教师信息管理

• 课程信息管理

• 选课信息管理

• 考勤信息管理

• 请假信息管理

• 系统管理

• 登录注册

package com.ischoolbar.programmer.servlet;



import java.io.IOException;

import java.util.HashMap;

import java.util.List;

import java.util.Map;



import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;



import net.sf.json.JSONArray;

import net.sf.json.JSONObject;

import net.sf.json.JsonConfig;



import com.ischoolbar.programmer.dao.ClazzDao;

import com.ischoolbar.programmer.model.Clazz;

import com.ischoolbar.programmer.model.Page;

/**

 * 

 * 公众号：springmeng

 *班级信息管理servlet

 */

public class ClazzServlet extends HttpServlet {

	public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException{

		doPost(request, response);

	}

	public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException{

		String method = request.getParameter(method);

		if(toClazzListView.equals(method)){

			clazzList(request,response);

		}else if(getClazzList.equals(method)){

			getClazzList(request, response);

		}else if(AddClazz.equals(method)){

			addClazz(request, response);

		}else if(DeleteClazz.equals(method)){

			deleteClazz(request, response);

		}else if(EditClazz.equals(method)){

			editClazz(request, response);

		}

	}

	private void editClazz(HttpServletRequest request,

			HttpServletResponse response) {

		// TODO Auto-generated method stub

		Integer id = Integer.parseInt(request.getParameter(id));

		String name = request.getParameter(name); 

		String info = request.getParameter(info);

		Clazz clazz = new Clazz();

		clazz.setName(name);

		clazz.setInfo(info);

		clazz.setId(id);

		ClazzDao clazzDao = new ClazzDao();

		if(clazzDao.editClazz(clazz)){

			try {

				response.getWriter().write(success);

			} catch (IOException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}finally{

				clazzDao.closeCon();

			}

		}

	}

	private void deleteClazz(HttpServletRequest request,

			HttpServletResponse response) {

		// TODO Auto-generated method stub

		Integer id = Integer.parseInt(request.getParameter(clazzid));

		ClazzDao clazzDao = new ClazzDao();

		if(clazzDao.deleteClazz(id)){

			try {

				response.getWriter().write(success);

			} catch (IOException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}finally{

				clazzDao.closeCon();

			}

		}

	}

	private void addClazz(HttpServletRequest request,

			HttpServletResponse response) {

		// TODO Auto-generated method stub

		String name = request.getParameter(name); 

		String info = request.getParameter(info);

		Clazz clazz = new Clazz();

		clazz.setName(name);

		clazz.setInfo(info);

		ClazzDao clazzDao = new ClazzDao();

		if(clazzDao.addClazz(clazz)){

			try {

				response.getWriter().write(success);

			} catch (IOException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}finally{

				clazzDao.closeCon();

			}

		}

		

	}

	private void clazzList(HttpServletRequest request,

			HttpServletResponse response) {

		// TODO Auto-generated method stub

		try {

			request.getRequestDispatcher(view/clazzList.jsp).forward(request, response);

		} catch (ServletException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (IOException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

	private void getClazzList(HttpServletRequest request,HttpServletResponse response){

		String name = request.getParameter(clazzName);

		Integer currentPage = request.getParameter(page) == null ? 1 : Integer.parseInt(request.getParameter(page));

		Integer pageSize = request.getParameter(rows) == null ? 999 : Integer.parseInt(request.getParameter(rows));

		Clazz clazz = new Clazz();

		clazz.setName(name);

		ClazzDao clazzDao = new ClazzDao();

		List<Clazz> clazzList = clazzDao.getClazzList(clazz, new Page(currentPage, pageSize));

		int total = clazzDao.getClazzListTotal(clazz);

		clazzDao.closeCon();

		response.setCharacterEncoding(UTF-8);

		Map<String, Object> ret = new HashMap<String, Object>();

		ret.put(total, total);

		ret.put(rows, clazzList);

		try {

			String from = request.getParameter(from);

			if(combox.equals(from)){

				response.getWriter().write(JSONArray.fromObject(clazzList).toString());

			}else{

				response.getWriter().write(JSONObject.fromObject(ret).toString());

			}

		} catch (IOException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

}