java连接oracle的时候如何配置

Question

网上有Oracle的JDBC驱动,classes12.jar是第四种驱动,classes11.jar是第三中驱动,它们分别对应两种连接的URL.这两个驱动都可以在网上找到,要是找不到找我.运行时加上classpath参数,就设置你这两个驱动所在的路径就可以了.

Answer 1

public static void main(String[] args)
    {
        //tested with Oracle 9
        try {
          DriverManager.registerDriver
                           (new oracle.jdbc.driver.OracleDriver());
          Connection conn = DriverManager.getConnection
              ("jdbc:oracle:thin:@127.0.0.1:1521:workdb","Onega","sa");
          PreparedStatement ps =conn.prepareStatement("INSERT INTO TEMP(PARAM1,PARAM2) VALUES(?,?)");
          ps.setString(1,"aaaa");
          ps.setString(2,"adf");
          ps.addBatch();
          ps.setString(1,"2222");
         ps.setString(2,"2222");
         ps.addBatch();
         ps.executeBatch();
          Statement stmt = conn.createStatement();
          ResultSet rset = stmt.executeQuery ("Select * from TEMP");
          while (rset.next()) {
               System.out.println("Yeeeee haaa! ID = " + rset.getString(1));
          }          rset.close();
          stmt.close();
          conn.close();
        } catch (Exception e) {
             System.out.println("ERROR : " + e);
             e.printStackTrace(System.out);
        }
      }

Answer 2

D:\Java\JBuilder8\jdk1.4\bin\java.exe -classpath "G:\oracle\ora90\jdbc\lib\classes12.jar.jar;.;" myclass