dbconnectioninternal.java~3~

连接oracle的java库

package com.zp.conn;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
public class DBConnectionInternal
{
  public static void DBInternalConn()
  {
   String sql="select object_name,object_type from user_objects";
   String objName,objType;
   System.out.println("step 1.getting default connection") ;
   try
   {
    // Connection con = new oracle.jdbc.OracleDriver().defaultConnection();
    String url="jdbc:oracle:kprb:@";
    Connection con=DriverManager.getConnection(url) ;
     System.out.println("step 2.creating sql statement") ;
     Statement stmt=con.createStatement() ;
     System.out.println("step 3.executing sql statement") ;
     ResultSet query=stmt.executeQuery(sql) ;
     System.out.println("step 4.printing result.") ;
     while(query.next() )
     {
       objName=query.getString(1) ;
       objType=query.getString(2) ;
       System.out.println("          *"+objType+" "+objName) ;
     }
     System.out.println("step 5.closing jdbc objects") ;
     query.close();
     stmt.close() ;
     con.close() ;
   }catch(java.sql.SQLException  sqle)
   {
     System.out.println("get a "+sqle.getClass() +"\nwith message "+sqle.getMessage() ) ;
   }
  }
}