帮我看看吧,jsp连接ora9i报错儿,在线等...

没有这个ExecuteQuery方法,应该写成executeQuery

解决方案 »

  1.   

    来晚了。最好找个能自动弹出方法的IDE，就不会出这种错了。
      

  2.   

    -_-！谢谢两位了。
    不过又有了新的问题，下面就是新的错儿，是不是需要oracle9i的JDBC支持啊？
    --------------------------------------------------------------------------------
    exception javax.servlet.ServletException: oracle.jdbc.driver.OracleDriver
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:673)
    org.apache.jsp.sho9_jsp._jspService(sho9_jsp.java:79)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:285)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:232)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    root cause java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
    org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1366)
    org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1213)
    org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:184)
    org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:110)
    java.lang.ClassLoader.loadClassInternal(Unknown Source)
    java.lang.Class.forName0(Native Method)
    java.lang.Class.forName(Unknown Source)
    org.apache.jsp.sho9_jsp._jspService(sho9_jsp.java:43)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:285)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:232)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      

  3.   

    找个oracle驱动包classes12.jar，放在lib目录下/
      

  4.   


    谢谢楼上的，不过这个我试了后，又出现新的问题了-_-!-------------------------------------------------------------
    exception javax.servlet.ServletException: Io ??: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:673)
    org.apache.jsp.sho9_jsp._jspService(sho9_jsp.java:79)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:285)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:232)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    root cause java.sql.SQLException: Io ??: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999297)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
    oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
    oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
    oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
    oracle.jdbc.driver.OracleConnection.(OracleConnection.java:361)
    oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442)
    oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321)
    java.sql.DriverManager.getConnection(Unknown Source)
    java.sql.DriverManager.getConnection(Unknown Source)
    org.apache.jsp.sho9_jsp._jspService(sho9_jsp.java:49)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:285)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:232)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      

  5.   


    哼哼-_# 继续顶！
    这又是为什么啊？放出代码，大家帮我看看吧，估计代码没多大错误吧，楼上是最近的报错儿信息。大家帮忙，谢谢！<%@ page contentType="text/html;charset=gb2312"%>
    <%@ page import="java.sql.*"%><%
    Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
    String url="jdbc:oracle:thin:@localhost:1521:oracle01";String user="system";
    String password="manager";Connection conn= DriverManager.getConnection(url,user,password);Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);String sql="select * from test";
    ResultSet rs=stmt.executeQuery(sql);while(rs.next())
    {
    %>
      A: <%=rs.getString(1)%>
      <p></p>
      B: <%=rs.getString(2)%>
    <%
    }
    %><%out.print("显示成功!");%>
    <%
    rs.close();
    stmt.close();
    conn.close();
    %>
      

  6.   

    用你的帐号测试看看能不能连接oracle!
      

  7.   

    谢谢!
    能，sqlplus里能，也能Manager Console里的表数据编辑器里看到记录，该开的服务也都开了。继续顶!
      

  8.   

    不要以system身份登录,另建一个用户,将test表建再新用户下试试,另外检查你服务是不是1521端口
      

  9.   

    是驱动程序版本过低了，换一个高版本的，到ORACLE公司去下载
      

  10.   

    看看你的oracle服务名是否正确