checkpasswordservlet.java

数据结构考试 网站（jsp）

package com.dsexam;

import java.io.*;
import java.sql.*;

import javax.sql.*;
import javax.naming.*;
import javax.servlet.*;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class checkPasswordServlet extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	/**
	 * Constructor of the object.
	 */
	public checkPasswordServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @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 doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		HttpSession session = request.getSession(true);
		String strSNumber = (String)session.getAttribute("snumber");
		String strPassword = request.getParameter("password");
		int topic_number;
		try {
			InitialContext initCtx = new InitialContext();
			DataSource db = (DataSource) initCtx.lookup("java:comp/env/jdbc/dstester");
			Connection conn = db.getConnection();
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("select * from results where snumber='"+ strSNumber + "' and password='" + strPassword + "'");
			
			String strFowardURL;
			if (rs.next()) {
				topic_number = rs.getInt(2);
				strFowardURL = "/testPage.jsp?topicnumber=" + topic_number
						+ "&snumber=" + strSNumber;
			} else
				strFowardURL = "/error.jsp?err_no=2";
			rs.close();
			stmt.close();
			conn.close();

			ServletContext context = getServletContext();
			RequestDispatcher dispatcher = context.getRequestDispatcher(strFowardURL);
			dispatcher.forward(request, response);

		} catch (Exception e) {
			System.out.println("抛出异常:  "+e.getMessage());
		}

	}

	/**
	 * The doPost method of the servlet. <br>
	 * 
	 * 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 {
		doGet(request, response);
	}

	/**
	 * Initialization of the servlet. <br>
	 * 
	 * @throws ServletException
	 *             if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}