如何在java程序中调用oracle10g中的存储过程

凝望长空

如何在java程序中调用oracle10g中的存储过程

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("jdbcracle:thin127.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); } } } }

健康木乃伊

谢谢分享