java连接oracle实例

《java连接oracle实例》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、java连接oracle实例用的oracle版本是oracle92     先将oracle的JDBC驱动包加到class中，驱动包在：$oracle_home/ora92/jdbc/bin下的ojdbc14.jar加到环境变量里。//配置文件oracle.propertiesjdbc.driver=oracle.jdbc.driver.OracleDriverjdbc.url=jdbc:oracle:thin:@192.168.2.57:1521:xtjdbc.user=sajdbc.pass

2、word=sa//连接数据库类packagecom.conn;importjava.io.FileInputStream;importjava.io.FileNotFoundException;importjava.io.IOException;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Stat

3、ement;importjava.util.Properties;publicclassConn2{privateStringdbUrl=null;privateStringtheUser=null;//用户名privateStringthePw=null;//密码privateConnectionc=null;//privateStatementconn;privateResultSetrs=null;privateStringdriver=null;publicConn2(){   try{

4、    //ORACLE的JDBC驱动类    Propertiespro=newProperties();    try{     pro.load(newFileInputStream("com/conn/oracle.properties"));    }catch(FileNotFoundExceptione1){     //TODOAuto-generatedcatchblock     e1.printStackTrace();    }catch(IOExceptione1){ 

5、    //TODOAuto-generatedcatchblock     e1.printStackTrace();    }    System.out.println(pro.getProperty("jdbc.driver"));    dbUrl=pro.getProperty("jdbc.url");    theUser=pro.getProperty("jdbc.user");    thePw=pro.getProperty("jdbc.password");    driv

6、er=pro.getProperty("jdbc.driver");   Class.forName(driver).newInstance();    try{    c=DriverManager.getConnection(dbUrl,theUser,thePw);   }catch(SQLExceptione){    //TODOAuto-generatedcatchblock    e.printStackTrace();   }    try{    conn=c.createSt

7、atement();   }catch(SQLExceptione){    //TODOAuto-generatedcatchblock    e.printStackTrace();   }}catch(InstantiationExceptione){   //TODOAuto-generatedcatchblock   e.printStackTrace();}catch(IllegalAccessExceptione){   //TODOAuto-generatedcatchblock

8、   e.printStackTrace();}catch(ClassNotFoundExceptione){   //TODOAuto-generatedcatchblock   e.printStackTrace();}}publicResultSetexecuteQuery(Stringsql){   rs=null;   try{    rs=conn.executeQuery(sql);   }catch(SQLExceptione){    //TODOAuto-generatedc