*****8
CREATE OR REPLACE PROCEDURE jxzd_jb_js ( zcid in varchar2,cpxh in varchar2) //上面是存储过程的定义,下面是调用 public void call(String procedureName,String zcbh,String cpxh) throws Exception{ Connection conn=dao.getConnection(); StringBuffer sql=new StringBuffer("{call "+procedureName+"(?,?)}"); CallableStatement cs=conn.prepareCall(sql.toString()); //CallableStatement cs=conn.prepareCall("{call jxzd_jb_js(?,?)}"); cs.setString(1, zcbh); cs.setString(2, cpxh); cs.execute(); conn.close(); }
****