getsurnamesarray.java

来自「连接oracle的java库」· Java 代码 · 共 60 行

package com.zp.callProcFunc;
//call a database function to return an array of surnames
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.CallableStatement;
import oracle.jdbc.OracleTypes;
import java.sql.Array;
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() ) ;
      System.exit(-1) ;
    }catch(java.sql.SQLException sqle)
    {
      System.out.println("get a "+sqle.getClass() +"\nwith message "+sqle.getMessage() ) ;
      System.exit(-1) ;
    }
    try
    {
      CallableStatement callFunc = connection.prepareCall(
          "{?=call get_all_surnames()}");
      //register the out parameter
      callFunc.registerOutParameter(1,OracleTypes.ARRAY ,"ARRAY_OF_SURNAME");
      //execute the function and return the result
      callFunc.execute() ;
      Array outputArray=callFunc.getArray(1) ;
      String[] surnames=(String[])outputArray.getArray() ;
      //output each surname
      for(int i=0;i<surnames.length ;i++)
      {
        System.out.println("the surname is:"+surnames[i]) ;
      }
    }catch(java.sql.SQLException  sqle)
    {
      System.out.println("get a "+sqle.getClass() +"\nwith message "+sqle.getMessage() ) ;
      System.exit(-1) ;
    }finally
    {
      try
      {
        connection.close();
      }catch(java.sql.SQLException  sqle)
      {
         System.out.println("get a "+sqle.getClass() +"\nwith message "+sqle.getMessage() ) ;
      }
    }
  }
}