Oracle JDBC 类

存在于 classes12.jar 中,oracle.jdbc.* 。

  1. pool 包
  2. driver 包

实例

//

OracleDataSource ds = new OracleDataSource();

ds.setURL("jdbc:oracle:thin:@127.0.0.1:1521:demo");

ds.setUser("user");

ds.setPassword("password");

 

PooledConnection pc = ds.getPooledConnection();

 

Connection cn = pc.getConnection();

 

Statement st = cn.createStatement();

 

ResultSet rs = st.executeQuery("select * from dual");

 

while(rs.next())

{

    System.out.println(rs.getString(0));

}

 

rs.close();

st.close();

cn.close();