_text__jsp.java

解压在c盘

/*
 * JSP generated by Resin 2.1.16 (built Tue Feb 15 11:12:27 PST 2005)
 */

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

public class _text__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
  {
    com.caucho.jsp.QPageContext pageContext = (com.caucho.jsp.QPageContext) com.caucho.jsp.QJspFactory.create().getPageContext(this, request, response, null, true, 8192, true);
    javax.servlet.jsp.JspWriter out = (javax.servlet.jsp.JspWriter) pageContext.getOut();
    javax.servlet.ServletConfig config = getServletConfig();
    javax.servlet.Servlet page = this;
    javax.servlet.http.HttpSession session = pageContext.getSession();
    javax.servlet.ServletContext application = pageContext.getServletContext();
    response.setContentType("text/html;charset=gb2312");
    request.setCharacterEncoding("GB2312");
    try {
      pageContext.write(_jsp_string0, 0, _jsp_string0.length);
      pageContext.write(_jsp_string1, 0, _jsp_string1.length);
       
String spath="wangye/jcc.mdb";   
String dbpath = application.getRealPath(spath);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); 
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)}; DBQ="+dbpath;
Connection conn= DriverManager.getConnection(url,"",""); 
Statement stmt=conn.createStatement();


 
      pageContext.write(_jsp_string2, 0, _jsp_string2.length);
       
   int a=159;
   String b="insert into user(name,password,aaa) values('tName','tPwd',"+a+")";
   stmt.executeUpdate(b);
      pageContext.write(_jsp_string3, 0, _jsp_string3.length);
      
String sql="select * from user"; 
ResultSet rs=stmt.executeQuery(sql); 
while(rs.next()) {
      pageContext.write(_jsp_string4, 0, _jsp_string4.length);
      out.print((rs.getInt("id")));
      pageContext.write(_jsp_string5, 0, _jsp_string5.length);
      out.print((rs.getString("name")));
      pageContext.write(_jsp_string5, 0, _jsp_string5.length);
      out.print((rs.getString(3)));
      pageContext.write(_jsp_string5, 0, _jsp_string5.length);
      out.print((rs.getInt("aaa")));
      pageContext.write(_jsp_string6, 0, _jsp_string6.length);
      }
      pageContext.write(_jsp_string4, 0, _jsp_string4.length);
      rs.close(); 
stmt.close(); 
conn.close(); 

      pageContext.write(_jsp_string7, 0, _jsp_string7.length);
    } catch (java.lang.Throwable _jsp_e) {
      pageContext.handlePageException(_jsp_e);
    } finally {
      JspFactory.getDefaultFactory().releasePageContext(pageContext);
    }
  }

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

  public boolean _caucho_isModified()
  {
    if (_caucho_isDead)
      return true;
    if (com.caucho.util.CauchoSystem.getVersionId() != -2089842219)
      return true;
    for (int i = _caucho_depends.size() - 1; i >= 0; i--) {
      com.caucho.vfs.Depend depend;
      depend = (com.caucho.vfs.Depend) _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);
    mergePath.addClassPath(getClass().getClassLoader());
    _caucho_line_map = new com.caucho.java.LineMap("_text__jsp.java", "/myweb/text.jsp");
    _caucho_line_map.add(2, 1);
    _caucho_line_map.add(1, 27);
    _caucho_line_map.add(5, 29);
    _caucho_line_map.add(18, 40);
    _caucho_line_map.add(24, 45);
    _caucho_line_map.add(30, 52);
    _caucho_line_map.add(31, 54);
    _caucho_line_map.add(32, 56);
    _caucho_line_map.add(35, 58);
    com.caucho.vfs.Depend depend;
    depend = new com.caucho.vfs.Depend(appDir.lookup("text.jsp"), 1226062302000L, 871L);
    _caucho_depends.add(depend);
  }

  protected void _caucho_clearDepends()
  {
    _caucho_depends.clear();
  }

  private static byte []_jsp_string6;
  private static byte []_jsp_string7;
  private static byte []_jsp_string1;
  private static byte []_jsp_string2;
  private static byte []_jsp_string3;
  private static byte []_jsp_string4;
  private static byte []_jsp_string0;
  private static byte []_jsp_string5;
  static {
    try {
      _jsp_string6 = "\r\n\r\n<br /> \r\n".getBytes("GB2312");
      _jsp_string7 = " \r\n</body> \r\n</html> ".getBytes("GB2312");
      _jsp_string1 = " \r\n<html> \r\n<body> \r\n".getBytes("GB2312");
      _jsp_string2 = "\r\n\r\n\r\n\r\n".getBytes("GB2312");
      _jsp_string3 = "\r\n\r\n\r\n".getBytes("GB2312");
      _jsp_string4 = " \r\n\r\n".getBytes("GB2312");
      _jsp_string0 = " \r\n".getBytes("GB2312");
      _jsp_string5 = "\r\n".getBytes("GB2312");
    } catch (java.io.UnsupportedEncodingException e) {
      e.printStackTrace();
    }
  }
}