package com.anllin.jdbc.oracle;import java.sql.*;/** * 演示用java去调用oracle的procedure * * @author anllin */public class InvokedProcedure{ public static void main(String[] args) { Connection conn = null; CallableStatement stmt = null; try { // 1.加载驱动 Class.forName("oracle.jdbc.driver.OracleDriver"); // 2.创建连接 conn = DriverManager .getConnection("jdbc:oracle:thin:@127.0.0.1:1521:myorcl", "scott", "tiger"); // 3.创建CallableStatement stmt = conn.prepareCall("{call sp_updateEmpMsg(?,?)}"); // 4.给？变量赋值 stmt.setString(1, "lisi"); stmt.setInt(2, 2000); // 5.执行 stmt.execute(); System.out.println("executed procedure successed."); } catch (Exception ex) { throw new RuntimeException("executed procudure failed.", ex); } finally { try { // 6.关闭资源 if (null != stmt) stmt.close(); if (null != conn) conn.close(); } catch (Exception ex) { throw new RuntimeException("close resources failed.", ex); } } }}
如何在java程序中调用oracle10g中的存储过程
TAG:如何在java程序中调用oracle10g中的存储过程
