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

  Oracle ±íµÄÓï¾ä
  create table student(sid int,sname varchar(20),sno int)
Ò»£ºÎÞ·µ»ØÖµµÄ´æ´¢¹ý³Ì
 create or replace procedure proc_student(para1 Integer, para2 varchar2, para3 Integer)
 is
BEGIN
 insert into student(sid,snam,sno) values (para1,para2,para3);
end ;
 
 
 
 
public class TestProcedureOne {
 public static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
 public static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
 public static final String USERNAEM = "system";
 public static final String PASSWORD = "123";
 public static void main(String[] args)
{
  ResultSet rs = null;
  Connection conn = null;
  CallableStatement proc = null;
  try {
   Class.forName(DRIVER);
   conn = DriverManager.getConnection(URL, USERNAEM, PASSWORD);
   proc = conn.prepareCall("{call system.testc(?,?,?)}");//ÕâÀï²»ÊÇPreparedStatement½Ó¿Ú£¬¶øÊǵ÷Óô洢¹ý³ÌµÄ½Ó¿Ú
   proc.setInt(1, 1);
   proc.setString(2, "zhangsan");
   proc.setInt(3, 2);//ÕâÀïµÄ²ÎÊýÊǸù¾ÝsqlÓï¾äµÄ˳ÐòÀ´µÄ
   proc.execute();
  } catch (SQLException ex2) {
   ex2.printStackTrace();
  } catch (Exception ex2) {
   ex2.printStackTrace();
  } finally {
   try {
    if (rs != null) {
     rs.close();
     if (proc != null) {
      proc.close();
     }
     if (conn != null) {
      conn.close();
     }
    }
   } catch (SQLException ex1) {
   }
  }
 }
}
¶þ£ºÓзµ»ØÖµµÄ´æ´¢¹ý³Ì£¨·ÇÁÐ±í£©
  crea