java程序去调用orcale存储过程

//演示java程序去调用orcale存储过程package com.hl;import java.sql.*;public class TestOraclePro { public static void main(String[] args) {// TODO Auto-generated method stub         Connection ct=null;         CallableStatement cs=null;//加载驱动try {Class.forName("oracle.jdbc.driver.OracleDriver");ct=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:MYORA1","scott","tiger");       //创建CallableStatement cs=ct.prepareCall("{call sp_pro3(?,?)}");//给？赋值cs.setString(1, "SMITH");cs.setInt(2, 22);//执行cs.execute();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{//关闭资源try {cs.close();ct.close();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}