queryservlet.java

使用JSP、Servlet以及JavaBean来实现学生成绩查询系统,简单好用

package mypack;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class QueryServlet extends HttpServlet {
	private DataBase database = null;
	//初始化函数
	public void init() throws ServletException {
		database = new DataBase();
	}
    //处理get请求方法
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request, response);
	}

	//处理post方法
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		//获取用户当前会话
		HttpSession session = request.getSession();
		//获取学号
		String xuehao = request.getParameter("xuehao");
		//获取数据库连接
		Connection con = database.getConnection();
		//获取学生有关数据
		Student student = MarkDB.getMark(con, xuehao);
		//关闭数据库连接
		database.closeConnection(con);
		if(student == null){
			//跳转到出错页面
			response.sendRedirect("/markquery/source/errorpage.jsp");
			return;
		}else{
			//跳转到成绩显示页面
			session.setAttribute("student", student);
			response.sendRedirect("/markquery/source/markshow.jsp");
			return;
		}
	}
}