过程
create or replace procedure select_checkcontentgroup(initemgroupID in number,outunittype out number,
outgroupcode out number,outgroupname out varchar2) is
begin
select unittype,groupcode,groupname
into outunittype,outgroupcode,outgroupname
from tjs_checkcontentgroup_tab
where itemgroupid=initemgroupid;
end select_checkcontentgroup;
调用
<% CallableStatement call=null;
ManageCar manageCar=null;
try {
String sql= "begin "+ "select_auto(?,?,?,?"+");end;" ;
call=con.prepareCall(sql);
call.registerOutParameter(2,Types.VARCHAR);
call.registerOutParameter(3,Types.VARCHAR);
call.registerOutParameter(4,Types.VARCHAR);
call.setInt(1,carID);
call.executeQuery();
manageCar=new ManageCar();ManageCar是一个bean/
manageCar.setCarID(carID);
manageCar.setCarArea(call.getString(2));
manageCar.setCarNumber(call.getString(3));
manageCar.setValid(call.getString(4));
} catch (SQLException e) {}
%>
快给分!!!
create or replace procedure select_checkcontentgroup(initemgroupID in number,outunittype out number,
outgroupcode out number,outgroupname out varchar2) is
begin
select unittype,groupcode,groupname
into outunittype,outgroupcode,outgroupname
from tjs_checkcontentgroup_tab
where itemgroupid=initemgroupid;
end select_checkcontentgroup;
调用
<% CallableStatement call=null;
ManageCar manageCar=null;
try {
String sql= "begin "+ "select_auto(?,?,?,?"+");end;" ;
call=con.prepareCall(sql);
call.registerOutParameter(2,Types.VARCHAR);
call.registerOutParameter(3,Types.VARCHAR);
call.registerOutParameter(4,Types.VARCHAR);
call.setInt(1,carID);
call.executeQuery();
manageCar=new ManageCar();ManageCar是一个bean/
manageCar.setCarID(carID);
manageCar.setCarArea(call.getString(2));
manageCar.setCarNumber(call.getString(3));
manageCar.setValid(call.getString(4));
} catch (SQLException e) {}
%>
快给分!!!
create or replace procedure select_checkcontentgroup(initemgroupID in number,outunittype out number,
outgroupcode out number,outgroupname out varchar2) is
begin
select unittype,groupcode,groupname
into outunittype,outgroupcode,outgroupname
from tjs_checkcontentgroup_tab
where itemgroupid=initemgroupid;
end select_checkcontentgroup;
调用
<% CallableStatement call=null;
ManageCar manageCar=null;
try {
String sql= "begin "+ "select_checkcontentgroup(?,?,?,?"+");end;" ;
call=con.prepareCall(sql);
call.registerOutParameter(2,Types.VARCHAR);
call.registerOutParameter(3,Types.VARCHAR);
call.registerOutParameter(4,Types.VARCHAR);
call.setInt(1,carID);
call.executeQuery();
manageCar=new ManageCar();ManageCar是一个bean/
manageCar.setCarID(carID);
manageCar.setCarArea(call.getString(2));
manageCar.setCarNumber(call.getString(3));
manageCar.setValid(call.getString(4));
} catch (SQLException e) {}
%>
快给分!!!
number,ireturn out number)
as
begin
delete from t_status where f_id=fileid;
delete from t_file where f_id=fileid;
commit;
ireturn:=1;
exception
when others then
ireturn:=0;
rollback;
end;
benliuxin (本杰明)
你总要改一改才用吧。
CREATE OR REPLACE PACKAGE pkg_test
AS
TYPE myrctype IS REF CURSOR; PROCEDURE get ( p_rc OUT myrctype);
END pkg_test;
/
CREATE OR REPLACE PACKAGE BODY pkg_test
IS
PROCEDURE get ( p_rc OUT myrctype)
IS
BEGIN
open p_rc for select * from addauto;
END get;
END pkg_test;
/以上没有问题。请问我怎样在jsp 中使用这个存储过程呢?将所有的结果显示到页面。