存储过程调用 实现

create or replace procedure pro_delete_SiteTemplate(templareID varchar2) is
begin
delete from SITE_TEMPLATE where PKID= templareID;
delete from channel       where TEMPLATE_ID =templareID;
end pro_delete_SiteTemplate;

 

 

/** * 删除网站模版的同时删除栏目，包括根栏目。 * @param ID String * @throws SQLException */ public void delete(String ID) throws SQLException { CallableStatement proc = null; try { proc = connection.prepareCall("{ call pro_delete_SiteTemplate(?) }"); proc.setString(1, ID); proc.execute(); } finally { proc.close(); } }