getresultset.java

来自「此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作」· Java 代码 · 共 41 行

package procedures;

import java.sql.*;
import connections.*;
import oracle.jdbc.driver.*;
import java.util.*;

public class GetResultSet {
  public static void main(String[] args) {
    Connection conn = null;
    CallableStatement stmt = null;

    try {
      conn = ConnectionFactory.getConnection();
      String sql = "{ ? = call list_tracks(?) }";
      stmt = conn.prepareCall(sql);

      // Use OracleTypes.CURSOR as the OUT parameter type
      stmt.registerOutParameter(1, OracleTypes.CURSOR);
      stmt.setInt(2, Integer.parseInt(args[0]));

      // Execute the function and get the return object from the call
      stmt.executeQuery();
      ResultSet rset = (ResultSet) stmt.getObject(1);

      while (rset.next()) {
        System.out.print(rset.getString(1) + " ");
        System.out.print(rset.getString(2) + " ");
        System.out.println(rset.getString(3) + " ");
      } 
    } catch (Exception e) {
      System.out.println("GetResultSet failed");
      e.printStackTrace();
    } 
    finally {
      ConnectionFactory.close(stmt);
      ConnectionFactory.close(conn);
    } 
  } 
}