java调用oracle存储过程案例

package test;


public class CallStatementTest {
	public static void main(String[] args) {
		/*// TODO Auto-generated method stub
		 * 直接调用存储过程
		Connection conn = null;
		CallableStatement cs = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL", "SCOTT", "tiger");
			cs = conn.prepareCall("{call params_emp(?,?)}");
			cs.setString(1, "FORD");
			cs.setFloat(2, 7777f);
			cs.execute();
			System.out.println("执行了……");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				cs.close();
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			
		}*/
		
		//调用包体里面的存储过程
		String sql ="{call mypackage1.pro1(?,?)}";
		String parameters[] = {"KING","6666"};
		SQLHelper.executeProcedure(sql, parameters);
		System.out.println("执行了……");
		
		/*String sql1="update emp set sal=? where ename=?";
		String sql2="update emp set comm=? where ename=?";
		String sql[]={sql1,sql2};
		String params[][]={{"9080","SMITH"},{"3452","WARD"}};
		SQLHelper.executeUpdate2(sql, params);*/
	}

}