一:无返回值的存储过程
存储过程为:
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......
阅读全文