student.java

在线考试系统

package com.gton.servlet.student;


import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import com.gton.bean.db.DataBean;
import com.gton.bean.util.DB_Conn;
import com.gton.bean.Bean.*;

public class student extends HttpServlet
{
    DataBean ju=new DataBean();
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException
{
	res.setContentType("text/html;charset=GB2312");
	PrintWriter out=res.getWriter();
	req.setCharacterEncoding("Gb2312");
   

	String name=req.getParameter("name");
	name = new String(name.getBytes("ISO8859-1"));
	String number=(String)req.getParameter("number");
	testBean b=new testBean();
	

	String  n=ju.checkStudentLogin(name, number);
	
	if(n.equals("1"))//用户存在
	{
		 String rtn=ju.call_procedure_chouti(number);
		 if(rtn.equals("1")){//试卷自动生成！
			 RequestDispatcher d = req.getRequestDispatcher("./student/Welcome.jsp");
			 d.forward(req, res);
         }else if(rtn.equals("9")){//"该生已经在考试！"
        	 RequestDispatcher d = req.getRequestDispatcher("./student/exist.jsp");
 	         d.forward(req, res);
         }else if(rtn.equals("0")){//数据库连接失败!
        	 RequestDispatcher d = req.getRequestDispatcher("./student/failure.jsp");
 	         d.forward(req, res);
         }
		 
	}
	else{// 用户不存在
			RequestDispatcher d = req.getRequestDispatcher("./student/studentLogin_no.jsp");
	        d.forward(req, res);
		}


  }
}