java中调用存储过程

最新推荐文章于 2025-09-09 09:10:31 发布

weixin_34301132

最新推荐文章于 2025-09-09 09:10:31 发布

阅读量57

点赞数

CC 4.0 BY-SA版权

文章标签： java 数据库网络

原文链接：http://www.cnblogs.com/changming/archive/2010/07/01/2042561.html

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); //获取存储过程返回值

转载于:https://www.cnblogs.com/changming/archive/2010/07/01/2042561.html