首页 > 技术文章 > ssh 调用存储过程

qingmaple 2014-11-18 14:59 原文

*****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();
    }

 

****

推荐阅读