java 存储过程和触发器(24 )+

《java 存储过程和触发器(24 )+》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Firstofall,alwaysdothis:setserveroutputonsize10000calldbms_java.set_output(10000);IfyougetsomethinglikethisERRORatline1:ORA-29549:classSCOTT.HelloWorldhaschanged,JavasessionstateclearedORA-06512:at"SCOTT.HELLO",line0ORA-06512:atline1dothisagaincalldbms_java.set_output(10000);

2、JavaStoredProcedures©Dr.PhilipCannata1DataManagementHelloWorldmethodcreateorreplaceandcompilejavasourcenamedmyProcedureMethodsaspublicclassmyProcedureMethods{publicstaticvoidhelloWorld(){System.out.println("Helloworld!");}}/JavaMethodsinOracle©Dr.PhilipCannata2DataManagementh

3、wstoredprocedurethatcallsthehelloWorldjavamethod.createorreplaceprocedurehwaslanguagejavaname'myProcedureMethods.helloWorld()';/StoredProceduretoCallJavaMethod©Dr.PhilipCannata3DataManagementsetserveroutputonsize10000calldbms_java.set_output(10000);exechwExecuteStoredProcedur

4、e©Dr.PhilipCannata4DataManagementSimpleJDBCmethodcreateorreplaceandcompilejavasourcenamedmyProcedureMethodsasimportjava.util.*;importjava.sql.*;publicclassmyProcedureMethods{publicstaticvoidhelloWorld(){System.out.println("Helloworld!");}publicstaticvoidsimpleJDBC()throwsSQLE

5、xception{Connectionconn=DriverManager.getConnection("jdbc:oracle:kprb:@");PreparedStatementpstatement=conn.prepareStatement("createorreplaceviewempV1asselect*fromemp");pstatement.executeQuery();System.out.println("CreatedviewempV1.");}}/JavaMethodsinOracle©Dr.PhilipCannata5Da

6、taManagementsjdbcstoredprocedurethatcallsthesimpleJDBCjavamethodcreateorreplaceproceduresjdbcaslanguagejavaname'myProcedureMethods.simpleJDBC()';/StoredProceduretoCallJavaMethod©Dr.PhilipCannata6DataManagementsetserveroutputonsize10000calldbms_java.set_output(10000);execsjdbc

7、ExecuteStoredProcedure©Dr.PhilipCannata7DataManagementJDBCmethodwithanargumentcreateorreplaceandcompilejavasourcenamedmyProcedureMethodsasimportjava.util.*;importjava.sql.*;publicclassmyProcedureMethods{publicstaticvoidhelloWorld(){System.out.println("Helloworld!");}publicsta

8、ticvoidsimpleJDBC()throwsSQLException{Connectionconn=DriverManager.g