Java调用存储过程小结.docVIP

学生在学习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); 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 , hyq ); CallableStatement proc = null; proc = conn.prepareCall({ call HYQ.TESTB( , ) }); proc.setString(1, 100); proc.registerOutParameter(2, Types.VARCHAR); proc.execute(); String testPrint = proc.getString(2); System.out.println(=testPrint=is=+testPrint); } catch (SQLException ex2) { ex2.printStackTrace(); } catch (Exception ex2) { ex2.printStackTrace(); }