senquiry_director.java

一个JSP写的学生选课系统

package test;

import java.io.*;
import javax.servlet.http.*;
import javax.servlet.ServletException;
import javax.sql.DataSource;
import javax.naming.*;
import java.sql.*;
import java.util.*;

public class senquiry_director extends HttpServlet
{
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	throws ServletException, IOException
    {
		
		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html;charset=gb2312");
		DbBean dbBean = new DbBean();
		String sql;
		String mode = request.getParameter("mode");
		String pwd = request.getParameter("pwd");
		String name = request.getParameter("name");
		HttpSession session = request.getSession();

		if (mode.equals("student"))
			sql = "select password,sid,majority from student where sid = '"+name+"'";
		else
			sql = "select password from admin where aid = '"+name+"'";

		try
		{
		   ResultSet rs = dbBean.getRs(sql);
		  
		   if (rs.next() && rs.getString(1).equals(pwd))
		   {
			   if (mode.equals("student"))
			   {
				   session.setAttribute("g_sid", rs.getString(2));
				   session.setAttribute("g_majority", rs.getString(3));
				   response.sendRedirect("student.jsp");
			   }
			   else
				   response.sendRedirect("manage.jsp");
		   }
		   PrintWriter out = response.getWriter();
		   out.print("输入错误");
		   out.print("<form action = login.html method = post><input type = submit value = 返回 /input></form>");
		}
		catch (Exception e)
		{
		}		
	}

	public void doGet(HttpServletRequest request,HttpServletResponse response)
	throws ServletException, IOException
       {
			doPost(request,response);
	}
}