– 查询功能树数据
DROP PROCEDURE IF EXISTS FunctionGet_SP;
create procedure FunctionGet_SP (
in PageIndex int(11), – 页码
in PageSize int(11), – 每页记录数
in _Sort varchar(32), – 排序字段
out RecordCount int(11) – 总记录数
)
begin
set @stmt = concat('select SQL_CALC_FOUND_ROWS ID,ParentID,Flag,Name,FunctionType,Href,Sort, Icon,IsEnable,CreateBy,CreateTime,UpdateBy,UpdateTime from Function where IsEnable = 1 order by ',_Sort,' limit ?,?');prepare s1 from @stmt;set @s1 = PageSize*(PageIndex-1);set @s2 = PageSize*PageIndex;execute s1 using @s1,@s2;-- 获取影响的行数SET @cnt = FOUND_ROWS(); -- 输出影响函数SELECT @cnt INTO RecordCount; deallocate prepare s1;
end;
需要加上SQL_CALC_FOUND_ROWS