_success__jsp.java

试题库自动组卷系统试题库自动组卷系统试题库自动组卷系统试题库自动组卷系统试题库自动组卷系统试题库自动组卷系统

/*
 * JSP generated by Resin-3.1.1 (built Mon, 07 May 2007 09:32:40 PDT)
 */

package _jsp._user;
import javax.servlet.*;
import javax.servlet.jsp.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.Date;

public class _success__jsp extends com.caucho.jsp.JavaPage
{
  private static final java.util.HashMap<String,java.lang.reflect.Method> _jsp_functionMap = new java.util.HashMap<String,java.lang.reflect.Method>();
  private boolean _caucho_isDead;
  
  public void
  _jspService(javax.servlet.http.HttpServletRequest request,
              javax.servlet.http.HttpServletResponse response)
    throws java.io.IOException, javax.servlet.ServletException
  {
    javax.servlet.http.HttpSession session = request.getSession(true);
    com.caucho.server.webapp.WebApp _jsp_application = _caucho_getApplication();
    javax.servlet.ServletContext application = _jsp_application;
    com.caucho.jsp.PageContextImpl pageContext = com.caucho.jsp.QJspFactory.allocatePageContext(this, _jsp_application, request, response, null, session, 8192, true, false);
    javax.servlet.jsp.JspWriter out = pageContext.getOut();
    final javax.el.ELContext _jsp_env = pageContext.getELContext();
    javax.servlet.ServletConfig config = getServletConfig();
    javax.servlet.Servlet page = this;
    response.setContentType("text/html;charset=GB2312");
    request.setCharacterEncoding("GB2312");
    try {
      out.write(_jsp_string0, 0, _jsp_string0.length);
      
	String gestnam = (String) session.getAttribute("name");
	String gestpsw = (String) session.getAttribute("password");
	if("".equals(gestnam)||gestnam==null & "".equals(gestpsw)||gestpsw==null)
	{
	response.sendRedirect("..//index.jsp"); 
	}

      out.write(_jsp_string1, 0, _jsp_string1.length);
      admin.dbcont dbcon;
      dbcon = (admin.dbcont) pageContext.getAttribute("dbcon");
      if (dbcon == null) {
        dbcon = new admin.dbcont();
        pageContext.setAttribute("dbcon", dbcon);
      }
      out.write(_jsp_string2, 0, _jsp_string2.length);
      
	String arrangeId=request.getParameter("arrangeId");
	int i=0;
	int j=0;
	 String sql="select timuid,anster,timu,beizhu,Q1,Q2,Q3,Q4 from students A,arrangeld B,lessons C,Terms D,timu E where A.class_id=B.class_id "
	           +" and C.lessonid=B.lessonid "
			   +" and D.TermId=B.TermId "
			   +" and E.lessonid=B.lessonid "
			   +" and arrangeId='"+arrangeId+"'"
	           +" and student_id='"+gestnam+"'";
	 dbcon.getcon();
	 ResultSet rs=dbcon.stmt.executeQuery(sql);
	 
	
      out.write(_jsp_string3, 0, _jsp_string3.length);
      
	   while(rs.next()){
	   int timuid=rs.getInt("timuid");
	   i++;
	    String anster = request.getParameter(String.valueOf(i));
	    String rightanster=rs.getString("anster");
	    if(anster==null) anster="x";
	    if(rightanster.equals(anster)){
	    j++; //\u9009\u62e9\u6b63\u786e\u7684\u8bdd\u8bb0\u5f55\u6b63\u786e\u9898\u76ee\u6570\u91cf
	    }
     
      out.write(_jsp_string4, 0, _jsp_string4.length);
      out.print((i));
      out.write('\u3001');
      out.print((rs.getString("timu")));
      out.write(_jsp_string5, 0, _jsp_string5.length);
      out.print((rs.getString("beizhu")));
      out.write(_jsp_string6, 0, _jsp_string6.length);
      out.print((rightanster));
      out.write(_jsp_string7, 0, _jsp_string7.length);
      
	  if(anster.equals("A")){
	  
      out.write(_jsp_string8, 0, _jsp_string8.length);
      out.print((i));
      out.write(_jsp_string9, 0, _jsp_string9.length);
      out.print((rs.getString("Q1")));
      out.write(_jsp_string10, 0, _jsp_string10.length);
      out.print((i));
      out.write(_jsp_string11, 0, _jsp_string11.length);
      out.print((rs.getString("Q2")));
      out.write(_jsp_string12, 0, _jsp_string12.length);
      out.print((i));
      out.write(_jsp_string13, 0, _jsp_string13.length);
      out.print((rs.getString("Q3")));
      out.write(_jsp_string14, 0, _jsp_string14.length);
      out.print((i));
      out.write(_jsp_string15, 0, _jsp_string15.length);
      out.print((rs.getString("Q4")));
      out.write(_jsp_string16, 0, _jsp_string16.length);
      
	   }
	   else if(anster.equals("B")){
	   
      out.write(_jsp_string17, 0, _jsp_string17.length);
      out.print((i));
      out.write(_jsp_string18, 0, _jsp_string18.length);
      out.print((rs.getString("Q1")));
      out.write(_jsp_string19, 0, _jsp_string19.length);
      out.print((i));
      out.write(_jsp_string20, 0, _jsp_string20.length);
      out.print((rs.getString("Q2")));
      out.write(_jsp_string21, 0, _jsp_string21.length);
      out.print((i));
      out.write(_jsp_string13, 0, _jsp_string13.length);
      out.print((rs.getString("Q3")));
      out.write(_jsp_string19, 0, _jsp_string19.length);
      out.print((i));
      out.write(_jsp_string15, 0, _jsp_string15.length);
      out.print((rs.getString("Q4")));
      out.write(_jsp_string22, 0, _jsp_string22.length);
      
	   }
	   else if(anster.equals("C")){
	   
      out.write(_jsp_string17, 0, _jsp_string17.length);
      out.print((i));
      out.write(_jsp_string18, 0, _jsp_string18.length);
      out.print((rs.getString("Q1")));
      out.write(_jsp_string19, 0, _jsp_string19.length);
      out.print((i));
      out.write(_jsp_string11, 0, _jsp_string11.length);
      out.print((rs.getString("Q2")));
      out.write(_jsp_string23, 0, _jsp_string23.length);
      out.print((i));
      out.write(_jsp_string24, 0, _jsp_string24.length);
      out.print((rs.getString("Q3")));
      out.write(_jsp_string25, 0, _jsp_string25.length);
      out.print((i));
      out.write(_jsp_string15, 0, _jsp_string15.length);
      out.print((rs.getString("Q4")));
      out.write(_jsp_string22, 0, _jsp_string22.length);
      
	   }
	   else if(anster.equals("D")){
	   
      out.write(_jsp_string17, 0, _jsp_string17.length);
      out.print((i));
      out.write(_jsp_string18, 0, _jsp_string18.length);
      out.print((rs.getString("Q1")));
      out.write(_jsp_string19, 0, _jsp_string19.length);
      out.print((i));
      out.write(_jsp_string11, 0, _jsp_string11.length);
      out.print((rs.getString("Q2")));
      out.write(_jsp_string23, 0, _jsp_string23.length);
      out.print((i));
      out.write(_jsp_string13, 0, _jsp_string13.length);
      out.print((rs.getString("Q3")));
      out.write(_jsp_string19, 0, _jsp_string19.length);
      out.print((i));
      out.write(_jsp_string26, 0, _jsp_string26.length);
      out.print((rs.getString("Q4")));
      out.write(_jsp_string27, 0, _jsp_string27.length);
      
	   }
	  else{
	  
      out.write(_jsp_string28, 0, _jsp_string28.length);
      out.print((i));
      out.write(_jsp_string18, 0, _jsp_string18.length);