/*
在Oracle中建立存储过程
/
create or replace package page_package as
type p_cursor is ref cursor;end page_package;//创建包
//实现分页
create or replace procedure pro_page(page in number,psize in number,z_page out number,cnum out number,p_cur out page_package.p_cursor)
as
begin
select count()into cnum from userinfo;
z_page:=ceil(cnum/psize);
open p_cur for ‘select * from(select rownum rn,u.* from userinfo u where rownum<=’||pagepsize||’) where rn>’||psize(page-1);
end;
//编写java类
//Mapper接口所实现的
package com.xa.mapper;
import java.util.Map;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.ResultType;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.mapping.StatementType;
import com.xa.e