javaµ÷ÓÃoracle´æ´¢¹ý³Ì

//¿´¿´ÈçºÎ±àдһЩ¸´ÔӵĴ洢¹ý³Ì
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
ΪÁËÑéÖ¤£¬ÎÒÏÈ´´½¨Ò»ÕŲâÊÔ±í
create table mytest(myid varchar2(30),myname varchar2(50));
´æ´¢¹ý³ÌΪ£º
create or replace PROCEDURE mytest2(id in varchar2,name in varchar2)  as
begin
   insert into mytest (myid,myname) values(id, name);
end;
/
È»ºóÄØ£¬ÔÚjavaÀïµ÷ÓÃʱ¾ÍÓÃÏÂÃæµÄ´úÂ룺
package com.hyq.src;
import java.sql.*;
import java.sql.ResultSet;
public class TestProcedureOne {
  public TestProcedureOne() {
  }
  public static void main(String[] args ){
    String driver = "oracle.jdbc.driver.OracleDriver";
    String strUrl = "jdbc:oracle:thin:@127.0.0.1:1521:HUAYU";
    Statement stmt = null;
    ResultSet rs = null;
    Connection conn = null;
    //CallableStatement:ÓÃÓÚÈ¥µ÷Óô洢¹ý³Ì
    CallableStatement cstmt = null;
    try {
      Class.forName(driver);
      conn =  DriverManager.getConnection(strUrl, "scott", "tiger");
      CallableStatement proc = null;
      proc = conn.prepareCall("{ call mytest2(?,?)}");
 //¸ø?ºÅ¸³Öµ
      proc.setString(1, "100");
      proc.setString(2, "user1");
 //Ö´Ðд洢¹ý³Ì
      proc.execute();
    }
    catch (Exception ex2) {
 ex2.printStackTrace();    
    }
    finally{
      //¹Ø±Õ×ÊÔ´..
    }
  }
}
µ±È»ÁË£¬Õâ¾ÍÏÈÒªÇóÒª½¨ÕűíTESTTB,ÀïÃæÁ½¸ö×ֶΣ¨I_ID£¬I_NAME£©¡£
¶þ£ºÓзµ»ØÖµµÄ´æ´¢¹ý³Ì£¨·ÇÁÐ±í£©
´æ´¢¹ý³ÌΪ£º
CREATE OR REPLACE PROCEDURE mytest3(id in varchar2,name out varchar2)  as
BE