_xupdate12__jsp.java

学生学籍管理信息系统 jsp+javabean+servlet

/*
 * JSP generated by Resin-3.0.8 (built Tue, 08 Jun 2004 02:25:40 PDT)
 */

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

public class _xupdate12__jsp extends com.caucho.jsp.JavaPage{
  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.Application _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);
    javax.servlet.jsp.JspWriter out = pageContext.getOut();
    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 newsno=request.getParameter("sno");
    String newsname=request.getParameter("sname");
    String newzc=request.getParameter("zc");
    String newxj=request.getParameter("xj");
	String newyd=request.getParameter("yd");
	String newzx=request.getParameter("zx");
	String newby=request.getParameter("by");
    Connection con=null;
    Statement sql=null;
    ResultSet rs=null;
    
       try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          }
       catch(ClassNotFoundException e){}
       try {con=DriverManager.getConnection("jdbc:odbc:cj1");
       sql=con.createStatement();
       String condition1=
              "UPDATE \u5b66\u7c4d\u4fe1\u606f SET \u59d3\u540d = "+newsname+" where \u5b66\u53f7='"+newsno+"'" ,
              condition2=
              "UPDATE \u5b66\u7c4d\u4fe1\u606f SET \u5b66\u751f\u6ce8\u518c= "+newzc+" where \u5b66\u53f7='"+newsno+"'" ,
              condition3=
              "UPDATE \u5b66\u7c4d\u4fe1\u606f SET \u5956\u8d37\u5b66\u91d1\u60c5\u51b5 = "+newxj+" where \u5b66\u53f7='"+newsno+"'" ,
	      condition4=
	      "UPDATE \u5b66\u7c4d\u4fe1\u606f SET \u5b66\u751f\u5f02\u52a8\u60c5\u51b5 = "+newyd+" where \u5b66\u53f7='"+newsno+"'" ,
			  condition5=
			  "UPDATE \u5b66\u7c4d\u4fe1\u606f SET \u519b\u8bad\u60c5\u51b5 = "+newzx+" where \u5b66\u53f7='"+newsno+"'" ,
			  condition6=
			  "UPDATE \u5b66\u7c4d\u4fe1\u606f SET \u6bd5\u4e1a\u60c5\u51b5 = "+newby+" where \u5b66\u53f7='"+newsno+"'" ;
       sql.executeUpdate(condition1);
       sql.executeUpdate(condition2);
       sql.executeUpdate(condition3);
       sql.executeUpdate(condition4); 
       sql.executeUpdate(condition5);
       sql.executeUpdate(condition6);  
     
      out.write(_jsp_string1, 0, _jsp_string1.length);
      
       rs=sql.executeQuery("SELECT * FROM \u5b66\u7c4d\u4fe1\u606f where \u5b66\u53f7='"+newsno+"' ");
       out.print("<Table Border>");
            out.print("<TR>");
            out.print("<TH width=100>"+"\u5b66\u53f7");
            out.print("<TH width=100>"+"\u59d3\u540d");
            out.print("<TH width=100>"+"\u5b66\u751f\u6ce8\u518c");
            out.print("<TH width=120>"+"\u5956\u8d37\u5b66\u91d1\u60c5\u51b5");
            out.print("<TH width=120>"+"\u5b66\u751f\u5f02\u52a8\u60c5\u51b5");
	    out.print("<TH width=100>"+"\u519b\u8bad\u60c5\u51b5");
	    out.print("<TH width=100>"+"\u6bd5\u4e1a\u60c5\u51b5");
         out.print("</TR>");
		 
       while(rs.next())  
       { out.print("<TR>");
            out.print("<TD align=center >"+rs.getString(1)+"</TD>");
             out.print("<TD align=center>"+rs.getString(2)+"</TD>");  
             out.print("<TD align=center>"+rs.getString(3)+"</TD>"); 
             out.print("<TD align=center>"+rs.getString(4)+"</TD>");
             out.print("<TD align=center>"+rs.getString(5)+"</TD>");
			 out.print("<TD align=center>"+rs.getString(6)+"</TD>");
			 out.print("<TD align=center>"+rs.getString(7)+"</TD>");
             out.print("</TR>") ;  
          }
       out.print("</Table>");
      con.close();
     }
    catch(SQLException e)
     { }
 
      out.write(_jsp_string2, 0, _jsp_string2.length);
    } catch (java.lang.Throwable _jsp_e) {
      pageContext.handlePageException(_jsp_e);
    } finally {
      com.caucho.jsp.QJspFactory.freePageContext(pageContext);
    }
  }

  private com.caucho.java.LineMap _caucho_line_map;
  private java.util.ArrayList _caucho_depends = new java.util.ArrayList();

  public java.util.ArrayList _caucho_getDependList()
  {
    return _caucho_depends;
  }

  public void _caucho_addDepend(com.caucho.make.PersistentDependency depend)
  {
    super._caucho_addDepend(depend);
    _caucho_depends.add(depend);
  }

  public boolean _caucho_isModified()
  {
    if (_caucho_isDead)
      return true;
    if (com.caucho.util.CauchoSystem.getVersionId() != 1174304630)
      return true;
    for (int i = _caucho_depends.size() - 1; i >= 0; i--) {
      com.caucho.make.Dependency depend;
      depend = (com.caucho.make.Dependency) _caucho_depends.get(i);
      if (depend.isModified())
        return true;
    }
    return false;
  }

  public long _caucho_lastModified()
  {
    return 0;
  }

  public com.caucho.java.LineMap _caucho_getLineMap()
  {
    return _caucho_line_map;
  }

  public void destroy()
  {
      _caucho_isDead = true;
      super.destroy();
  }

  public void init(com.caucho.java.LineMap lineMap,
                   com.caucho.vfs.Path appDir)
    throws javax.servlet.ServletException
  {
    com.caucho.vfs.Path resinHome = com.caucho.util.CauchoSystem.getResinHome();
    com.caucho.vfs.MergePath mergePath = new com.caucho.vfs.MergePath();
    mergePath.addMergePath(appDir);
    mergePath.addMergePath(resinHome);
    com.caucho.loader.DynamicClassLoader loader;
    loader = (com.caucho.loader.DynamicClassLoader) getClass().getClassLoader();
    String resourcePath = loader.getResourcePathSpecificFirst();
    mergePath.addClassPath(resourcePath);
    _caucho_line_map = new com.caucho.java.LineMap("_xupdate12__jsp.java", "foo");
    _caucho_line_map.add("/xupdate12.jsp", 7, 30);
    _caucho_line_map.add(45, 67);
    com.caucho.vfs.Depend depend;
    depend = new com.caucho.vfs.Depend(appDir.lookup("xupdate12.jsp"), "8eR6YXrEmCIEeVnp26RKOw==", false);
    _caucho_depends.add(depend);
  }

  private final static char []_jsp_string2;
  private final static char []_jsp_string1;
  private final static char []_jsp_string0;
  static {
    _jsp_string2 = "\r\n</FONT>\r\n</BODY>\r\n</HTML>".toCharArray();
    _jsp_string1 = "\r\n     </FONT>\r\n     <P>\u66f4\u65b0\u540e\u7684\u8868\u7684\u8bb0\u5f55\uff1a<Font size=5>\r\n     ".toCharArray();
    _jsp_string0 = "\r\n\r\n<HTML>\r\n<BODY bgcolor=\"#FEAA51\" >\r\n<p><a href=\"xselect1.jsp\">\u67e5\u8be2</a> <a href=\"xinsert11.jsp\">\u63d2\u5165</a> <a href=\"xdelete11.jsp\">\u5220\u9664</a> <a href=\"xupdate11.jsp\">\u4fee\u6539</a></p>\r\n<Font size=5>\r\n  ".toCharArray();
  }
}