studyconn.java~3~

连接oracle的java库

package com.zp.conn;
import java.sql.DriverManager;
import java.sql.Connection;
public class StudyConn
{
  public StudyConn()
  {
  }
  public void ForNameConn()//use Class.forName
  {
   try
   {
     Class.forName("oracle.jdbc.OracleDriver");//OracleDriver is a class ,that is
     //OracleDriver.class,it implements interface Driver.class
     //jdbc:oracle:this:@host_name:port:service_name 这为Oracle瘦驱动程序连接
     String sourceURL="jdbc:oracle:thin:@901-32:1521:xianmap";
     Connection conn=DriverManager.getConnection(sourceURL,"userstoremap2","Icando41");
   }catch(java.lang.ClassNotFoundException  noclasse)
   {
     System.out.println("get a "+noclasse.getClass() +"\nwith message "+noclasse.getMessage() ) ;
   }catch(java.sql.SQLException  sqle)
    {
      System.out.println("get a "+sqle.getClass() +"\nwith message "+sqle.getMessage() );
    }

  }
  public void registerDriverConn()
  {
    try
    {
      DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
    }catch(java.sql.SQLException  sqle)
    {
      System.out.println("get a "+sqle.getClass() +"\nwith message "+sqle.getMessage() );
    }
  }
  public void setproperty()//connect to oracle db by System.setProperty()
  {
//    System.setProperties("jdbc.drivers","oracle.jdbc.OracleDriver");
  }
}