SSH框架调用存储过程
SSH要在DAO 类中实现调用存储过程create or replace package fengyepackage as
type fenye_cursor is ref cursor;
end;
create or replace procedure paging (p_table in varchar2,p_term in varchar2,p_pagesize in number,p_pageindex in number,tiaojian in varchar2,fengye out fengyepackage.fenye_cursor) as
p_begin number(2);
p_end number(2);
v_sql varchar2(200);
begin
p_begin :=(p_pageindex-1)*p_pagesize;
p_end :=p_pageindex*p_pagesize;
if p_term is null then
v_sql:='select * from (select e.*,rownum rn from (select * from '||p_table||'where '||tiaojian||')e where rownum<='||p_end||') where rn>'||p_begin;
else
v_sql:='select * from (select e.*,rownum rn from (select * from '||p_table||' where '||tiaojian||' '||p_term||')e where rownum<='||p_end||') where rn>'||p_begin;
end if;
open fengye for v_sql;
close fengye;
end;
以上是存储过程,如果在dao层中调用,并且获得返回的集合,而且可是使用hiebernate的懒加载来实现关系类的查询
补充:Java , Web 开发