_example__jsp.java

来自「公司企业网站管理系统中文豪华版」· Java 代码 · 共 146 行

/*
 * JSP generated by Resin-3.0.19 (built Mon, 15 May 2006 04:50:47 PDT)
 */

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

public class _example__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, false);
    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);
       
/************************************************************ 
********* \u76f4\u63a5\u8fde\u63a5Access\u6570\u636e\u5e93\uff0c\u4e0d\u9700\u8981\u8bbe\u7f6e\u6570\u636e\u6e90 
********* Date: 2006.5 
********* Author:  
********* \u6709\u4efb\u4f55\u95ee\u9898\u6b22\u8fce\u63d0\u51fa\u6307\u6b63 www.ITstudy.cn 
************************************************************/ 

// ***************** \u6570\u636e\u5e93\u8fde\u63a5\u4ee3\u7801\u3000\u5f00\u59cb ***************** 
//\u5f02\u5e38\u5904\u7406\u8bed\u53e5 
try 
{ 
//\u4ee5\u4e0b\u51e0\u9879\u8bf7\u81ea\u884c\u4fee\u6539 
String spath="WEB-INF\\basic.mdb";   //\u6ce8\u610f\u7531\u7f51\u7ad9\u6839\u5230\u6587\u4ef6\u7684\u8def\u5f84 
String dbpath = application.getRealPath(spath); //\u8f6c\u5316\u6210\u7269\u7406\u8def\u5f84 
String dbname = ""; //Acess \u6570\u636e\u5e93\u7528\u6237\u540d\uff0c\u6ca1\u6709\u5219\u4e3a\u7a7a 
out.print(dbpath);
String user = ""; //Acess \u6570\u636e\u5e93\u5bc6\u7801\uff0c\u6ca1\u6709\u5219\u4e3a\u7a7a 
//\u6570\u636e\u5e93\u8fde\u63a5\u5b57\u7b26\u4e32  
String url ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;  
//\u52a0\u8f7d\u9a71\u52a8\u7a0b\u5e8f 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
//\u5efa\u7acb\u8fde\u63a5 
Connection conn= DriverManager.getConnection(url);  
//\u521b\u5efa\u8bed\u53e5\u5bf9\u8c61 
Statement stmt=conn.createStatement 
(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
// **** \u6570\u636e\u5e93\u8fde\u63a5\u4ee3\u7801\u3000\u7ed3\u675f ********* 

//*********** \u6d4b\u8bd5\u6570\u636e\u4ee3\u7801\u5f00\u59cb ******************************* 
//\u8bf7\u5728\u6570\u636e\u5e93\u4e2d\u5efa\u7acbtSiteConfig\u8868\uff0c\u8868\u4e2d\u5efa\u7acb\u4e24\u4e2a\u5b57\u6bb5uid\u548cpwd,\u7c7b\u578b\u4e3a\u6587\u672c\u578b 
String sql = "select * from cplb"; 
ResultSet rs = stmt.executeQuery(sql); 
out.print("<br>\u606d\u559c\u4f60\uff01\u6570\u636e\u5e93\u8fde\u63a5\u6210\u529f\uff01"); 
while(rs.next()) 
{ 
out.print("\u7528\u6237\u540d:" + rs.getInt(2)); 

} 
//*********** \u6d4b\u8bd5\u6570\u636e\u4ee3\u7801\u7ed3\u675f ******************************* 
rs.close(); //\u5173\u95ed\u8bb0\u5f55\u96c6\u5bf9\u8c61 
stmt.close(); //\u5173\u95ed\u8bed\u53e5\u5bf9\u8c61 
conn.close(); //\u5173\u95ed\u8fde\u63a5\u5bf9\u8c61 

}catch(Exception e){ 
 out.print("\u6570\u636e\u5e93\u8fde\u63a5\u9519\u8bef\uff01,\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<br>"); 
 out.print(e.getMessage()); 
} 

    } catch (java.lang.Throwable _jsp_e) {
      pageContext.handlePageException(_jsp_e);
    } finally {
      com.caucho.jsp.QJspFactory.freePageContext(pageContext);
    }
  }

  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);
    com.caucho.jsp.JavaPage.addDepend(_caucho_depends, depend);
  }

  public boolean _caucho_isModified()
  {
    if (_caucho_isDead)
      return true;
    if (com.caucho.util.CauchoSystem.getVersionId() != 7932908523769947432L)
      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 void destroy()
  {
      _caucho_isDead = true;
      super.destroy();
  }

  public void init(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);
    com.caucho.vfs.Depend depend;
    depend = new com.caucho.vfs.Depend(appDir.lookup("basic/example.jsp"), 146725443239945058L, false);
    com.caucho.jsp.JavaPage.addDepend(_caucho_depends, depend);
  }

  private final static char []_jsp_string0;
  static {
    _jsp_string0 = " \r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"> \r\n".toCharArray();
  }
}