java调用oracle存储过程

一：无返回值的存储过程
存储过程为：
create or replace procedure adddept(deptno number,dname varchar2,loc varchar2)
as
  begin
    insert into dept values(deptno,dname,loc);
end;
然后呢，在java里调用时就用下面的代码：
public class TestProcedure {
 Connection conn=null ;
 CallableStatement cstmt=null ;
 PreparedStatement pstmt=null ;
 String url="jdbc:oracle:thin:@localhost:1521:mydb";
 String driver="oracle.jdbc.driver.OracleDriver";
 String name="";
 public TestProcedure() {
  try {
   Class.forName(driver);
   conn=DriverManager.getConnection(url,"scott","tiger");
   cstmt=conn.prepareCall("{call adddept(?,?,?)}");
   cstmt.setInt(1,13);
   cstmt.setString(2,"间谍部2");
   cstmt.setString(3,"ningbo2");
   cstmt.executeUpdate();
     System.out.println("success");
   }
  catch (Exception e){e.printStackTrace();}
  finally{
   cstmt.close();
   conn.close();
   }
  }
 }
dept表为oracle数据库方案scott中的一个表
二：有返回值的存储过程（非列表）
存储过程为：
CREATE OR REPLACE PROCEDURE TESTB(PARA1 IN VARCHAR2,PARA2 OUT VARCHAR2) AS
BEGIN
SELECT INTO PARA2 from TESTTB WHERE I_ID= PARA1;
END TESTB;
在java里调用时就用下面的代码：
package com.hyq.src;
public class TestProcedureTWO {
 public TestProcedureTWO() {
 }
 public static void main(String[] args ){
  String driver = "oracle.jdbc.driver.OracleDriver";
  String strUrl = "jdbc:oracle:thin:@127.0.0.1:1521:hyq";
  Statement stmt = null;
  ResultSet rs = null;
  Connection conn = null;
  try {
   Class.forName(driver);
   conn = DriverManager.getConnection(strUrl, " hyq "