sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
@rowcount int output,--×ܼǼÊý£¬¹²Óм¸ÌõÐÅÏ¢
@pagecount int output--×ÜÒ³Êý£¬¹²ÓжàÉÙÒ³
AS
declare @countsql nvarchar(50)
declare @sql nvarchar(200)
declare @subsql nvarchar(100)--not in×ÓsqlÓï¾ä
declare @tmpOrderid nvarchar(50)
--·µ»Ø×ܼǼÊý£¬²¢¸³Öµ¸øÊä³ö²ÎÊý@rowcount
set @countsql='select @totalcount=count(*) from '+@tablename
exec sp_executesql @countsql,N'@totalcount int out',@rowcount output
--ÅжÏ×Ö¶ÎÃûÊÇ·ñΪ¿Õ
if @fieldname is null or @fieldname=''
set @fieldname=' * '
--ÅжÏÊÇ·ñÅÅÐò¼°ÅÅÐò·½Ê½
if @orderid is null or @orderid=''
set @tmpOrderid=' '
else
begin
if @sort=0
set @tmpOrderid='order by '+@orderid+' desc'
else
set @tmpOrderid='order by '+@orderid+' asc'
end