package com.srie.db.pro;

import java.sql.CallableStatement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

public class CallPro {

    public static void main(String[] args) {

        Connection conn = null;

        try {

            Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

            String url = "jdbc:oracle:thin:@aaa";

            String user = "a";

            String password = "a";

            conn = DriverManager.getConnection(url, user, password);

            String sql = "{call pro_getchart(?)}";

            CallableStatement statement = conn.prepareCall(sql);

            statement.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR);

            statement.execute();

            ResultSet rs = null;

            // 方法1：

            //rs = ((oracle.jdbc.OracleCallableStatement) statement).getCursor(1);

            // 方法2：

            rs = (ResultSet) statement.getObject(1);

            while (rs.next()) {

                System.out.println(rs.getString(1));

            }

            conn.close();

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            try {

                if (conn != null && !conn.isClosed()) {

                    conn.close();

                }

            } catch (Exception e2) {

                e2.printStackTrace();

            }

        }

    }

}