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,里面兩個(gè)字段（I_ID，I_NAME）當(dāng)然了，這就先要求要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)中的數(shù)2 并非任意的，而是和過程中的列對應(yīng)的，如果 out 是在第一個(gè)位置，那就是 proc.getString(1)，如果是第三個(gè)位置，就是proc.getString(3)，當(dāng)然也可以同時(shí)有多個(gè)返回值，那就是再多加幾個(gè)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 調(diào)過 createorreplaceprocedurebatchUpdateStudent(p_agein createorreplaceprocedurebatchUpdateStudent(p_ageinnumber)as updateSTUDENTsetAGE=AGE+1wheretx= String procedure = call batchUpdateStudent(?) ; (1,0); /把參數(shù)設(shè)為 0 來過CREATE procedureselectAllUsers DYNAMIC RESULT SETS 1 DECLAREtemp_cursor1CURSOR WITHRETURNTOSELECT*FROM test; OPEN temp_cursor1;ame=Test ?=callselectAllUsers()callselectAllUsers() 也可以寫成callselectAllUsers