Javaµ÷ÓÃOracle´æ´¢¹ý³Ì

µÚÒ»ÖÖÇé¿ö£ºÎÞ·µ»ØÖµ.
      create or replace procedure test_a(param1 in varchar2,param2 in varchar2) as
       begin
            insert into test value(param1,param2);
     end;
    Javaµ÷ÓôúÂë:
package com.test;
import java.sql.*;
import java.io.*;
import java.sql.*;
public class TestProcA
{
   public TestProcA(){
   }
  
   public static void main(String []args)
   {
        
        ResultSet rs = null;
        Connection conn = null;
        CallableStatement proc = null;
         
        try{
        Class.forName("oracle.jdbc.driver.OracleDriver");
          conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:test", "test", "test");
           proc = conn.prepareCall("{ call test_a(?,?) }");
          proc.setString(1, "1001");
          proc.setString(2, "TestA");
          proc.execute();
        }catch(Exception e){
     e.printStackTrace();
}finally{
           try{
       if(null!=rs){
                 rs.close();
          if(null!=proc){