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