getsurnamesarray.java~1~

连接oracle的java库

package com.zp.callProcFunc;
//call a database function to return an array of surnames
import java.sql.Connection;
import java.sql.DriverManager;
public class GetSurnamesArray
{
  public GetSurnamesArray()
  {
  }
public static void GetSurnames()
  {
    Connection connection=null;
    String url="jdbc:oracle:thin:@901-32:1521:xianmap";
    try
    {
      Class.forName("oracle.jdbc.OracleDriver");
      connection =DriverManager.getConnection(url,"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() ) ;
    }
  }
}