java连接oracle实例.doc

java连接oracle实例用的oracle版本是oracle92 先将oracle的JDBC驱动包加到class中，驱动包在：$oracle_home/ora92/jdbc/bin下的ojdbc14.jar加到环境变量里。/配置文件pertiesjdbc.driver=oracle.jdbc.driver.OracleDriverjdbc.url=jdbc:oracle:thin:7:1521:xtjdbc.user=sajdbc.password=sa/连接数据库类package com.conn;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;public class Conn2 private String dbUrl=null;private String theUser=null;/用户名private String thePw =null;/密码private Connection c=null;/private Statement conn;private ResultSet rs=null;private String driver = null;public Conn2() try /ORACLE的JDBC驱动类 Properties pro = new Properties(); try pro.load(new FileInputStream(com/conn/perties); catch (FileNotFoundException e1) / TODO Auto-generated catch block e1.printStackTrace(); catch (IOException e1) / TODO Auto-generated catch block e1.printStackTrace(); System.out.println(pro.getProperty(jdbc.driver); dbUrl = pro.getProperty(jdbc.url); theUser=pro.getProperty(jdbc.user); thePw=pro.getProperty(jdbc.password); driver=pro.getProperty(jdbc.driver); Class.forName(driver).newInstance(); try c = DriverManager.getConnection(dbUrl,theUser,thePw); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); try conn=c.createStatement(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); catch (InstantiationException e) / TODO Auto-generated catch block e.printStackTrace(); catch (IllegalAccessException e) / TODO Auto-generated catch block e.printStackTrace(); catch (ClassNotFoundException e) / TODO Auto-generated catch block e.printStackTrace();public ResultSet executeQuery(String sql) rs = null; try rs = conn.executeQuery(sql); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); return rs;public void close() try conn.close(); c.close(); catch (SQLException e) / TODO Auto-generated catch block e.printStackTrace(); public static void main(Stringargs) /newjdbc.testPorpertiesFile(); ResultSet newrs; /ConnectOracle newjdbc = new ConnectOracle(); Conn2 newjdbc = new Conn2(); System.out.println(连接成功); newrs = newjdbc.executeQuery(select * from scott.dept); try System.out.println(deptno | dname | loc); while(newrs.next() System.out.print(newrs.getString(deptno)+ ); System.out.print(newrs.getString(dname)+ ); Syste