用java调用oracle存储过程总结

1、收：一：无返回过收：一：无返回过INEND 然后呢，在java packageimport import public class publicTestProcedureOne()publicicvoidmain(StringargsStringdriver=StringstrUrl=jdbc:oracle:thin:127.0.0.1:1521:hyqSement stmt = ResultSet rs = null; ement cstmt =tryconn DriverManager.getConnection(strUrl,hyq,hyqement proc =proc=conn.pr

2、epareCall(callHYQ.TESTA(?,?); proc.setString(1, 100); ement proc =proc=conn.prepareCall(callHYQ.TESTA(?,?); proc.setString(1, 100); catch(Exception y if(rs!= catch(SQLException ex1)二：有返回值的过程（非列表TESTTB,里面两个字段（I_ID，I_NAME）当然了，这就先要求要OUTENDOPARA2FROMTESTTBWHEREOUTENDOPARA2FROMTESTTBWHEREI_ID=在javapackag

3、epublic class publicTestProcedureTWO()publicicvoidmain(StringargsString driver = oracle.jdbc.driver.OracleDriver; Sement stmt = ResultSet rs = null; try conn =DriverManager.getConnection(strUrl,hyq,hyq); ement proc = null;proc=conn.prepareCall(callHYQ.TESTB(?,?); proc.setString(1, 100); proc.registe

4、rOutParameter(2,Types.VARCHAR); String=catch(SQLException catch(Exception tryif(rs!= catch(SQLException ex1)tryif(rs!= catch(SQLException ex1)注意，这里的proc.getString(2)中的数2 并非任意的，而是和过程中的列对应的，如果 out 是在第一个位置，那就是 proc.getString(1)，如果是第三个位置，就是proc.getString(3)，当然也可以同时有多个返回值，那就是再多加几个out三：返回列表由于CREATEORREPLA

5、CEPACKAGETESTPACKAGE TYPE Test_CURSOR IS REF CURSOR;end 2，建CREATEORREPLACEPROCEDURETESTC(p_CURSORTESTPACKAGE.Test_CURSOR) OPENp_CURSORFORSELECT*FROMHYQ.TESTTB; END TESTC;OPENp_CURSORFORSELECT*FROMHYQ.TESTTB; END TESTC; 在javaimport java.sql.*;import java.io.Writer;importjava.sql.PreparedSimport java.

6、sql.ResultSet;import public class publicTestProcedureTHREE()publicicvoidmain(StringargsString driver = oracle.jdbc.driver.OracleDriver; Sement stmt = ResultSetrs=Connectionconn = tryconn DriverManager.getConnection(strUrl, hyq, ement proc =proc = conn.prepareCall( call hyq.testc(?) ); rs= ln( + rs.g

7、etString(1) catch(SQLException catch(Exception ln( + rs.getString(1) catch(SQLException catch(Exception y if(rs!= if(conn!=null) catch(SQLException ex1)四。Hibernate 调过 createorreplaceprocedurebatchUpdateStudent(p_agein createorreplaceprocedurebatchUpdateStudent(p_ageinnumber)as updateSTUDENTsetAGE=AGE+1wheretx= String procedure = call batchUpdateStudent(?) ; (1,0); /把参数设为 0 来过CREATE procedureselectAllUsers DYNAMIC RESULT SETS 1 DECLAREtemp_cursor1CURSOR WITHRETURNTOSELECT*FROM test; OPEN temp_cursor1;ame=Test ?=callselectAllUsers()callselectAllUsers() 也可以写成callselectAllUsers