java中调用存储过程

1. 获得数据库连接常量，配置文件中取得

      url = jdbc\:oracle\:thin\:@(DESCRIPTION \=(ADDRESS \= (PROTOCOL \= TCP)(HOST \= xxx.xxx.xxx.xxx) (PORT \= 1521))(ADDRESS \= (PROTOCOL \= TCP)(HOST \= 132.194.32.2) (PORT \= 1521))(load_balance\= on) (failover \= on)(CONNECT_DATA \=(SERVICE_NAME \= ora92)))) driver = oracle.jdbc.driver.OracleDriver userName =   xxx password  =  xxx

2. 初始化数据库连接

/** * 初始化数据库连接 */ protected void initial(){ Properties prop = new Properties(); InputStream stream = null; try { stream = getClass().getResourceAsStream("/configure.properties"); prop.load(stream); } catch (IOException e) { logger.info("Load configuer.properties ERROR!"); e.printStackTrace(); } finally{ try { stream.close(); } catch (IOException e) { e.printStackTrace(); } } driver = prop.getProperty("driver"); url = prop.getProperty("url"); userName = prop.getProperty("userName"); password = prop.getProperty("password"); try { Class.forName(driver).newInstance(); conn = DriverManager.getConnection(url,userName,password); } catch (ClassNotFoundException e) { logger.info("connect HUAWEI DateBase ERROR! ClassNotFoundException!"); e.printStackTrace(); } catch (InstantiationException e) { logger.info("connect HUAWEI DateBase ERROR!"); e.printStackTrace(); } catch (IllegalAccessException e) { logger.info("connect HUAWEI DateBase ERROR!"); e.printStackTrace(); } catch (SQLException e) { logger.info("connect HUAWEI DateBase ERROR!"); e.printStackTrace(); } } 

3. 调用存储过程

public Object execute(Object object) { this.initial(); int resultCode = 1; String sheetFlowNo = ""; CustomerInfo customerInfo = new CustomerInfo(); StringBuffer mainSheetParam = new StringBuffer(); StringBuffer specialParam=new StringBuffer(); String extern=""; try{ // conn.setAutoCommit(false); proc = conn.prepareCall("{ call p_bc_GetSerialNo(?)}"); proc.registerOutParameter(1, oracle.jdbc.OracleTypes.VARCHAR); proc.execute(); sheetFlowNo = proc.getString(1); }catch(SQLException e1){ // try { // conn.rollback(); // } catch (SQLException e) { // e.printStackTrace(); // } e1.printStackTrace(); }catch(Exception e2){ // try { // conn.rollback(); // } catch (SQLException e) { // e.printStackTrace(); // } e2.printStackTrace(); }finally{ try { if(rs!=null){ rs.close(); //rs = null; } if(proc != null){ proc.close(); } if(conn != null){ conn.close(); //conn = null; } } catch (SQLException e) { logger.info("HUAWEI DateBase close ERROR!"); e.printStackTrace(); } }

附注：

proc为 java.sql.CallableStatement 类型变量；

proc = conn.prepareCall("{ call p_bc_GetSerialNo(?)}");                // 调用存储过程 proc.registerOutParameter(1, oracle.jdbc.OracleTypes.VARCHAR); //注册返回值类型 proc.execute();                                                                                //执行存储过程 sheetFlowNo = proc.getString(1);                                                   //获取存储过程返回值