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 block
			e.printStackTrace();
		}finally
		{
			//关闭资源
			try {
				cs.close();
				ct.close();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
	}

}