jdbcÖе÷ÓÃoracle ·µ»ØÓαêÀàÐ͵Ĵ洢¹ý³Ì

1¡¢´´½¨±í£º
     create table stud(
            sid int,
            sname varchar2(50)
     )
     ²¢²åÈëÒ»ÌõÊý¾Ý
     insert into stud values(1,'Tom')
2¡¢Í¨¹ý°ü¶¨ÒåÒ»¸öÓαê
 
     create or replace package pack_stud
     is
     --ÉùÃ÷Ò»¸öÓαêÀàÐÍ
            type cur is ref cursor;
     end;
3¡¢´´½¨´æ´¢¹ý³Ì
     create or replace procedure pro_select_stud(
            my_cur out pack_stud.cur
     )
     is
     begin
            open my_cur for select * from stud;
     end;
4¡¢jdbcÖе÷ÓÃ
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import oracle.jdbc.driver.OracleTypes;
 
public class TestProCur {
 public void test(){
  Connection con = null;
  ResultSet rs = null;
  CallableStatement cst = null;
  try{
         Class.forName("oracle.jdbc.driver.OracleDriver");
         //ÏÂÃæµÄtanÊÇÊý¾Ý¿âÃû£¬Ä¬ÈÏÊÇorcl£¬loveÊÇ·ÃÎÊÃÜÂ룬ĬÈÏÊÇtiger,
         //1521ÊǶ˿ںţ¬Ä¬ÈÏÊÇ1521
        con = DriverManager.getConnection   ("jdbc:oracle:thin:@192.168.1.103:1521:tan","scott","love");
        String sql = "{call  pro_select_stud(?)}";
       &nbs