文章列表
CREATE OR REPLACE
PROCEDURE PAGING (TableName IN VARCHAR,Fields IN VARCHAR DEFAULT '*',OrderField IN VARCHAR,sqlWhere VARCHAR,pageSize IN
INT,pageIndex IN INT DEFAULT 1,totalPage OUT INT,totalRecord OUT INT,RS OUT RESULTSET.RS)
AS
tsql varchar(4000);
doPageIndex int:=pageIndex;--当前页码
StartRecord in ...
CREATE PROCEDURE PageDiv(
IN tableName varchar(100),
IN filedsNames varchar(500),
IN pageSize int,
IN pageIndex int,
IN strWhere varchar(500),
IN sortName varchar(500)
)
BEGIN
/*
**************过程简介**************
MYSQL5.0通用分页存储过程
作者：范景及 EMAIL：123idgf@163.com
日期：2009-03-08，妇女节完成哒，嘿嘿^^V
说明：该过程实现了 ...
--调用方法：exec upPageDiv kucun,'id,ItemCode,ItemName','ItemCode asc','id>0',20,1,?,?
Create Procedure [dbo].[upPageDiv]
@TableName varchar(200), --表名
@Fields varchar(5000)='*', --字段名(默认为*)
@OrderField varchar(5000), --排序字段(必须!支持多字段)
@sqlWhere varchar(5000 ...