java程序调用Oracle存储过程

一：编写加载oracle驱动，连接和关闭资源的工具类

import java.sql.*;

public class SQLHelper1 {

static {
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(Exception e){
e.printStackTrace();
}
}
//只能在当前类中调用
private SQLHelper1(){}

public static Connection getConnection(){
//Connection conn = null;
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
String dbname="scott";
String dbpwd="m123";
try{
return DriverManager.getConnection(url,dbname,dbpwd);

}catch(Exception e){
e.printStackTrace();
return null;
}

}
public static void close(Connection conn,PreparedStatement stmt,ResultSet rs){
try{
if(rs!=null){
rs.close();
}

}catch(Exception e){
e.printStackTrace();

}
try{
if(stmt!=null){
stmt.close();
}

}catch(Exception e){
e.printStackTrace();

}
try{
if(conn!=null){
conn.close();
}

}catch(Exception e){
e.printStackTrace();

}

}
}
二：直接调用存储过程：

//演示java程序去调用oracle的存储过程案例
import java.sql.*;

public class TestOraclePro {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub

Connection conn = null;
CallableStatement stmt = null;
//调用oracle存储过程
String sql = "{call sp_pro4(?,?)}";
try{
conn = SQLHelper1.getConnection();
stmt = conn.prepareCall(sql);
stmt.setString(1, "SMITH");
stmt.setInt(2, 10);
int rs = stmt.executeUpdate();
if(rs!=0){
System.out.println("操作成功！");

}

}catch(Exception e){
e.printStackTrace();
}finally{
SQLHelper1.close(null, stmt, conn);
}

}

}