jdbcÖе÷ÓÃoracle´æ´¢¹ý³Ì

1¡¢´´½¨±í£º
     create table stud(
             sid int,
            sname varchar2(50)
     )
     ²¢²åÈëÒ»ÌõÊý¾Ý
     insert into stud values(1,'Tom')
2¡¢´´½¨´æ´¢¹ý³Ì
 
    --´´½¨´æ´¢¹ý³Ì
    create or replace procedure pro_select_name(
            v_sid in stud.sid%type,
            v_sname out stud.sname%type
     )
     --ÉùÃ÷Çø
     is
     --Ö´ÐÐÌå
     begin
              select sname into v_sname from stud where sid = v_sid;
      
     --Òì³£´¦Àí
     exception
            when others then
            dbms_output.put_line(sqlcode||sqlerrm);
     end;
3¡¢jdbcÖе÷ÓÃ
 
     import java.sql.CallableStatement;
     import java.sql.Connection;
     import java.sql.DriverManager;
     import java.sql.Types;
     public class TestPro {
 
            public void test(){
            Connection con = null;
            CallableStatement cst = null;
            try{