Oracle中存储过程的介绍﹝5﹞.ppt

Oracle中存储过程的介绍;PL/SQL简介（过程化SQL语言）;使用PL/SQL块的优点;存储过程（Procedure）;在项目开发中使用存储过程的好处;建立存储过程;调用存储过程;过程参数;无参数的过程;带输入参数的过程（IN关键字，默认参数模式是输入参数）需要为输入参数提供数据值。;带输出参数的过程（OUT 关键字，需要使用变量接收输出参数的数据值）;带输入输出参数（IN OUT）在调用之前需要定义变量输入值，调用结束之后使用变量输出数据。;存储过程中可以使用异常处理;JAVA中调用Oracle存储过程;package com.hyq.src;import java.sql.*;import java.sql.ResultSet;public class TestProcedureOne {?? public TestProcedureOne() {?? }?? 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;???? CallableStatement cstmt = null;???? try {?????? Class.forName(driver);?????? conn =?? DriverManager.getConnection(strUrl, hyq , hyq );?????? CallableStatement proc = null;?????? proc = conn.prepareCall({ call HYQ.TESTA(?,?) });?????? proc.setString(1, 100);?????? proc.setString(2, TestOne);?????? proc.execute();???? }???? catch (SQLException ex2) {?????? ex2.printStackTrace();???? }???? catch (Exception ex2) {?????? ex2.printStackTrace();???? }?;??? finally{?????? try {???????? if(rs != null){?????????? rs.close();?????????? if(stmt!=null){???????????? stmt.close();?????????? }?????????? if(conn!=null){???????????? conn.close();?????????? }???????? }?????? }?????? catch (SQLException ex1) {?????? }???? }?? }} ;带返回值的存储过程;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.registerOutParame