_scores_0edit__jsp.java

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

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

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

public class _scores_0edit__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);
      
	
	  dbcon.getcon();
	  ResultSet rs;
          rs=dbcon.stmt.executeQuery("Select  count(Distinct class_Id) classlen from classes");
	  rs.next();
	  int classlen=rs.getInt("classlen");
	  String class_Id[]=new String[classlen];
	  String class_Name[]=new String[classlen];
	  rs=dbcon.stmt.executeQuery("Select * from classes");
	  
      out.write(_jsp_string3, 0, _jsp_string3.length);
      
	  for(int i=0;i<class_Name.length;i++)
          {
            rs.next();
            class_Id[i]=rs.getString("class_Id");
            class_Name[i]=rs.getString("class_Name");
          
      out.write(_jsp_string4, 0, _jsp_string4.length);
      out.print((class_Id[i]));
      out.write(_jsp_string5, 0, _jsp_string5.length);
      out.print((class_Name[i]));
      out.write(_jsp_string6, 0, _jsp_string6.length);
      
	  }  
	  rs=dbcon.stmt.executeQuery("Select  count(Distinct arrangeId) arrangelen from arrangeld");
	  rs.next();
	  int arrangelen=rs.getInt("arrangelen");
	  String ArrangeId[]=new String[arrangelen];
	  String LessonName[]=new String[arrangelen];
	  String Class_Name[]=new String[arrangelen];
	  rs=dbcon.stmt.executeQuery("Select * from arrangeld,lessons,classes "
	                             +"where arrangeld.LessonId=lessons.LessonId "
	                             +"and arrangeld.class_Id=classes.class_Id");
	  
      out.write(_jsp_string7, 0, _jsp_string7.length);
      
	  for(int i=0;i<ArrangeId.length;i++)
          {
            rs.next();
            ArrangeId[i]=rs.getString("ArrangeId");
            LessonName[i]=rs.getString("LessonName");
            Class_Name[i]=rs.getString("Class_Name");
          
      out.write(_jsp_string4, 0, _jsp_string4.length);
      out.print((ArrangeId[i]));
      out.write(_jsp_string8, 0, _jsp_string8.length);
      out.print((ArrangeId[i]));
      out.write(')');
      out.print((LessonName[i]));
      out.write(':');
      out.print((Class_Name[i]));
      out.write(_jsp_string6, 0, _jsp_string6.length);
      
	  }
	  
      out.write(_jsp_string9, 0, _jsp_string9.length);
        
   String strsmt=request.getParameter("smt");
   if(strsmt==null)
   {

      out.write(_jsp_string10, 0, _jsp_string10.length);
      
   }
   else
   {

          String strtxt=request.getParameter("text1");
          String Class_Id=request.getParameter("Class_Id");
           String ArrangeId1=request.getParameter("ArrangeId");
	  dbcon.getcon();
	  String strsql1="Select * from Arrangeld,Classes,Lessons,Terms,students,scores " 
	        +"where students.Student_Id='"+strtxt+"' " 
		+"and Arrangeld.LessonId=Lessons.LessonId "
		+"and Arrangeld.TermId=Terms.TermId "
		+"and Arrangeld.Class_Id=Classes.Class_Id "
		+"and scores.Student_Id=students.student_Id "
		+"and Arrangeld.arrangeId=scores.arrangeId "
	     
	     +"or Class_Name='"+strtxt+"' " 
		+"and Arrangeld.LessonId=Lessons.LessonId "
		+"and Arrangeld.TermId=Terms.TermId "
		+"and Arrangeld.Class_Id=Classes.Class_Id "
		+"and scores.Student_Id=students.student_Id "
	        +"and Arrangeld.arrangeId=scores.arrangeId "
	        
	     +"or classes.class_Id='"+Class_Id+"' "
		+"and Arrangeld.LessonId=Lessons.LessonId "
		+"and Arrangeld.TermId=Terms.TermId "
		+"and Arrangeld.Class_Id=Classes.Class_Id "
		+"and scores.Student_Id=students.student_Id "
	        +"and Arrangeld.arrangeId=scores.arrangeId "
	        
	     +"or TermName='"+strtxt+"' " 	
		+"and Arrangeld.LessonId=Lessons.LessonId "
		+"and Arrangeld.TermId=Terms.TermId "
		+"and Arrangeld.Class_Id=Classes.Class_Id "
		+"and scores.Student_Id=students.student_Id "
	        +"and Arrangeld.arrangeId=scores.arrangeId "
	        
	     +"or Lessons.LessonId='"+strtxt+"' "
		+"and Arrangeld.LessonId=Lessons.LessonId "
		+"and Arrangeld.TermId=Terms.TermId "
		+"and Arrangeld.Class_Id=Classes.Class_Id "
		+"and scores.Student_Id=students.student_Id "
	        +"and Arrangeld.arrangeId=scores.arrangeId "
	        
	     +"or LessonName='"+strtxt+"' "
		+"and Arrangeld.LessonId=Lessons.LessonId "
		+"and Arrangeld.TermId=Terms.TermId "
		+"and Arrangeld.Class_Id=Classes.Class_Id "
		+"and scores.Student_Id=students.student_Id "
                +"and Arrangeld.arrangeId=scores.arrangeId "
                
             +"or Teacher='"+strtxt+"' "
		+"and Arrangeld.LessonId=Lessons.LessonId "
		+"and Arrangeld.TermId=Terms.TermId "
		+"and Arrangeld.Class_Id=Classes.Class_Id "
		+"and scores.Student_Id=students.student_Id "
                +"and Arrangeld.arrangeId=scores.arrangeId "
             
              +"or arrangeld.arrangeId='"+ArrangeId1+"' "
		+"and Arrangeld.LessonId=Lessons.LessonId "
		+"and Arrangeld.TermId=Terms.TermId "
		+"and Arrangeld.Class_Id=Classes.Class_Id "
		+"and scores.Student_Id=students.student_Id "
                +"and Arrangeld.arrangeId=scores.arrangeId ";
	        
       	    rs=dbcon.stmt.executeQuery(strsql1); 
	 
      out.write(_jsp_string11, 0, _jsp_string11.length);
      
	   while(rs.next())
	   {