现在将java调用oracle存储过程的示例总结如下

学生在学习jdbc的时候，会问到怎么调用存储过程，现在将java调用oracle存储过程的示例总结如下。（关于调用sqlserver的存储过程将在下次进行小结请关注）
一：无返回值的存储过程
存储过程为：
•         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");
•           &nbs