java 存储过程返回列表_oracle存储过程之返回列表

package return_list;

import java.sql.CallableStatement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class Query_list {

/**

* @param args

*/

public static void main(String[] args) {

// TODO Auto-generated method stub

String driver = "oracle.jdbc.driver.OracleDriver";

String strUrl = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";

Statement stmt = null;

ResultSet rs = null;

Connection conn = null;

try {

Class.forName(driver);

conn = DriverManager.getConnection(strUrl, "scott", "tiger");

CallableStatement proc = null;

proc = conn.prepareCall("{ call scott.pro_return_list(?) }");

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

proc.execute();

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

while (rs.next()) {

System.out.println(rs.getString(1) + " :  " + rs.getString(2));

}

} catch (SQLException ex2) {

ex2.printStackTrace();

} catch (Exception ex2) {

ex2.printStackTrace();

} finally {

try {

if (rs != null) {

rs.close();

if (stmt != null) {

stmt.close();

}

if (conn != null) {

conn.close();

}

}

} catch (SQLException ex1) {

}

}

}

}