问一个入门级的问题JDBC

Question

Error: 500
Location: /Mytest/aa.jsp
Internal Servlet Error:org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
C:\tomcat\work\localhost_8080%2FMytest\_0002faa_0002ejspaa_jsp_2.java:114: ')' expected.
                 Connection con =DriverManager.getConnection(jdbc:odbc:testjdbc);
                                                                 ^
1 error, 1 warning at org.apache.jasper.compiler.Compiler.compile(Compiler.java:254)
at org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java:453)
at org.apache.jasper.servlet.JasperLoader12.loadJSP(JasperLoader12.java:146)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:424)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:152)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:164)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:309)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:382)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:387)
at org.apache.tomcat.core.Handler.service(Handler.java:263)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:371)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:786)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:732)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:407)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:534)

Answer 1

不好意思,错误信息贴错了.
不过我自己已经解决问题了,因为我用的是jdk1.4,所以Statement在两个包中都含有这里不明确,
因此我将Statement stmt = con.createStatement();一句改为:java.sql.Statement stmt=con.createStatement();就OK了,另外的一外错误是笔误,我误将ResultSet写为RecordSet了,改正即可.

Answer 2

手头还有50分尚未送出,求一个jdbc连接oracle数据库的完整的例子,谢谢.

Answer 3

import java.sql.*;...
private Connection getConnection() throws SQLException
{
   /**
    * use oracle thin driver      
    * you need to modify the url and username and password
    */
   String url="jdbc:oracle:thin:@:myOracleServerName:1521:myOracleSID";
   String username ="system";
   String password ="manager";  try{
      DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
      connection = DriverManager.getConnection(url,username,password);
   }catch(SQLException se){
     throw se;
   }
   if(connection ==null)
      System.out.println("connection failed! try again!");
   else
      System.out.println("connection successful!");   return connection;
}
...

Answer 4

try    {    
            //加载一个Oracle驱动
            DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
            //使用OCI8连接到数据库
            conn=DriverManager.getConnection("jdbc:oracle:oci8:@DatabaseName"+,"user","password");
        }catch(SQLException e)    {    //捕捉SQL违例
            System.out.println("Ora8iConnect在连接oracle8数据库时捕获");
            while (e!=null)
            {    System.out.println("SQLState:"+e.getSQLState());
                System.out.println("Message :"+e.getMessage());
                System.out.println("Vendor  :"+e.getErrorCode());
                e=e.getNextException();
                System.out.println(" ");
            }
            conn=null;
        }        try    {    
            Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 
            //orcl为你的数据库的SID 
            String url="jdbc:oracle:thin:@localhost:1521:orcl"; 
            Connection conn= DriverManager.getConnection(url,"user","password"); 
        }catch(SQLException e)    {    //捕捉SQL违例
            System.out.println("Ora8iConnect在连接oracle8数据库时捕获");
            while (e!=null)
            {    System.out.println("SQLState:"+e.getSQLState());
                System.out.println("Message :"+e.getMessage());
                System.out.println("Vendor  :"+e.getErrorCode());
                e=e.getNextException();
                System.out.println(" ");
            }
            conn=null;
        }