java 连接oracle (备忘)

leeco

参与书目:programming with java (Julia Case Bradley & Anita C. Millspaugh)
代码在下面,要注意的几点:
运行时要加载oracle 的lib,目录:XX\oracle\ora92\jdbc\lib\classes12.jar
数据:
表名:abctable
表列:A B C
A
B
C
a
b
c
x
y
z
q
w
e
一行a b c
二行x y z
三行q w e
数据库服务名:leeco
注:代码中127.0.0.1可以改为:localhost


result:
a
x
q
b
y
w
c
z
e


import java.sql.*;
public class JDBCUpdateApp {
public static void main (String args []) throws ClassNotFoundException{
  try {
        Class.forName("oracle.jdbc.driver.OracleDriver");
    // Connect to the database
    // You must put a database name after the @ sign in the connection URL.
    // You can use either the fully specified SQL*net syntax or a short cut
    // syntax as ::. The example uses the short cut syntax.
    String url = "jdbc:oracle:thin:@127.0.0.1:1521:leeco";
    String userName = "test";
    String password = "test";
Connection conn;

conn = DriverManager.getConnection(url,userName,password);

    // Create a Statement
    Statement stmt = conn.createStatement ();
    // Select the ENAME column from the table
    ResultSet rset = stmt.executeQuery ("select * from abctable");
    // Iterate through the result and print the employee names
    while (rset.next ())
// System.out.println (rset.getString (1));
     for(int i=1;i4;i++)
       System.out.println (rset.getString (i));
             //System.out.println("\n");
  }
  
  catch (ClassNotFoundException err){
   System.err.println("class not found !");
  }
  catch (SQLException err){
   System.err.println("can not connect!");
  }
}

}

PS:写来自己备忘^_^


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u1/56746/showart_441001.html