jdbc调用oracle存储过程.docVIP

jdbc 如何调用oracle的存储过程 2009-09-30 17:07 jdbc 如何调用oracle的存储过程：/blog/404615? （ oracle 存储过程及jdbc调用大全，ok）/course/3_program/java/javashl/2008516/117018.html? （复合类型参数，存储过程的jdbc调用，较深入，未细看）摘要： create or replace procedure sp_value( id1 in number, id2 out number ) as begin ? id2 := id1*200; end; -----------------调用(有简单返回值)---------------- Connection conn = null; CallableStatement cstmt = null; conn = DriverManager.getConnection(url, user, password); String procedure = {call sp_value(?,?)}; cstmt = conn.prepareCall(procedure); --------------------JDBC获取存储过程中的值------------------- //学号、姓名、班级编号 cstmt.setString(1, 2000); //注册输出参数 cstmt.registerOutParameter(2, java.sql.Types.INTEGER); cstmt.executeUpdate(); //从输出参数中获取值 int value = cstmt.getInt(2); System.out.println(返回： +value); 利用spring的jdbcTemplate调用存储过程?假如我们有P_GET_TOPIC_NUM这一个存储过程,有两个参数,第一个参数userId是传进去的,第二个参数是传出来的,举例如下: Java代码? public?int?getUserTopicNum(final?int?userId)?{?? ????String?sql?=?{call?P_GET_TOPIC_NUM(?,?)};?? ???????Object?execute(String?callString,?CallableStatementCallback?action)接口(//使用?? ????Object?obj?=?getJdbcTemplate().execute(sql,new?CallableStatementCallback(){?? ????????public?Object?doInCallableStatement(CallableStatement?cs)?throws?SQLException,?DataAccessException?{?? ????????????cs.setInt(1,userId);?? ????????????cs.registerOutParameter(2,?Types.INTEGER);?? ????????????cs.execute();?? ????????????return?new?Integer(cs.getInt(2));?? ????????}????? ????});?? ????return?((Integer)obj).intValue();?? }?