callablestatement調(diào)用oracle存儲過程返回結(jié)果集(resultset)

1、Java(CallableStatement)調(diào)用acle存儲過程返回結(jié)果集(ResultSet)一：無返回值的存儲過程調(diào)用存儲過程：存儲過程：CREATEREPLACEPROCEDUREPRO_1(PARA1INVAR2PARA2INVAR2)ASBEGININTODBO.EMP(IDNAME)VALUES(PARA1PARA2)ENDPRO_1JavaJava代碼：代碼：packagecom.icesoft.serviceimptj

2、ava.sql.imptjava.sql.ResultSetpublicclassCallProcedureTest1publicCallProcedureTest1()super()publicstaticvoidmain(String[]args)Stringdriver=“acle.jdbc.driver.acleDriver“Stringurl=“jdbc:acle:thin:@127.0.0.1:1521:cl“Stringu

3、ser=“admin“Stringpwd=“passwd“Connectionconn=nullCallableStatementcs=nullResultSetrs=nulltryClass.fName(driver)conn=DriverManager.getConnection(urluserpwd)cs=conn.prepareCall(“callDBO.PRO_1()“)cs.setString(1“10“)cs.setStr

4、ing(2“Peter“)cs.execute()publicclassCallProcedureTest2publicCallProcedureTest2()super()publicstaticvoidmain(String[]args)Stringdriver=“acle.jdbc.driver.acleDriver“Stringurl=“jdbc:acle:thin:@127.0.0.1:1521:cl“Stringuser=“

5、admin“Stringpwd=“passwd“Connectionconn=nullCallableStatementcs=nullResultSetrs=nulltryClass.fName(driver)conn=DriverManager.getConnection(urluserpwd)cs=conn.prepareCall(“callDBO.PRO_2()“)cs.setString(1“10“)cs.registerOut

6、Parameter(2Types.VAR)cs.execute()Stringname=cs.getString(2)System.out.println(“name:“name)catch(SQLExceptione)e.printStackTrace()catch(Exceptione)e.printStackTrace()finallytryif(rs!=null)rs.close()if(cs!=null)cs.close()i