Znn3bq.jpeg
²é¿´: 283  |  »Ø¸´: 1
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£

lfl_jeetoon

Í­³æ (³õÈëÎÄ̳)

[½»Á÷] º£Á¿Êý¾Ý¿âµÄ²éѯÓÅ»¯¼°·ÖÒ³Ëã·¨·½°¸

´ó¼ÒÖªµÀSQL SERVERµÄ´æ´¢¹ý³ÌÊÇÊÂÏȱàÒëºÃµÄSQLÓï¾ä£¬ËüµÄÖ´ÐÐЧÂÊÒª±Èͨ¹ýWEBÒ³Ãæ´«À´µÄSQLÓï¾äµÄÖ´ÐÐЧÂÊÒª¸ß¡£ÏÂÃæµÄ´æ´¢¹ý³Ì²»½öº¬ÓзÖÒ³·½°¸£¬»¹»á¸ù¾ÝÒ³Ãæ´«À´µÄ²ÎÊýÀ´È·¶¨ÊÇ·ñ½øÐÐÊý¾Ý×ÜÊýͳ¼Æ¡£
-- »ñȡָ¶¨Ò³µÄÊý¾Ý
CREATE PROCEDURE pagination3
@tblName   varchar(255),       -- ±íÃû
@strGetFields varchar(1000) = '*',  -- ÐèÒª·µ»ØµÄÁÐ
@fldName varchar(255)='',      -- ÅÅÐòµÄ×Ö¶ÎÃû
@PageSize   int = 10,          -- Ò³³ß´ç
@PageIndex  int = 1,           -- Ò³Âë
@doCount  bit = 0,   -- ·µ»Ø¼Ç¼×ÜÊý, ·Ç 0 ÖµÔò·µ»Ø
@OrderType bit = 0,  -- ÉèÖÃÅÅÐòÀàÐÍ, ·Ç 0 ÖµÔò½µÐò
@strWhere  varchar(1500) = ''  -- ²éѯÌõ¼þ (×¢Òâ: ²»Òª¼Ó where)
AS
declare @strSQL   varchar(5000)       -- Ö÷Óï¾ä
declare @strTmp   varchar(110)        -- ÁÙʱ±äÁ¿
declare @strOrder varchar(400)        -- ÅÅÐòÀàÐÍ

if @doCount != 0
  begin
    if @strWhere !=''
    set @strSQL = "select count(*) as Total from [" + @tblName + "] where "+@strWhere
    else
    set @strSQL = "select count(*) as Total from [" + @tblName + "]"
end  
--ÒÔÉÏ´úÂëµÄÒâ˼ÊÇÈç¹û@doCount´«µÝ¹ýÀ´µÄ²»ÊÇ0£¬¾ÍÖ´ÐÐ×ÜÊýͳ¼Æ¡£ÒÔϵÄËùÓдúÂë¶¼ÊÇ@doCountΪ0µÄÇé¿ö
else
begin

if @OrderType != 0
begin
    set @strTmp = "<(select min"
set @strOrder = " order by [" + @fldName +"] desc"
--Èç¹û@OrderType²»ÊÇ0£¬¾ÍÖ´ÐнµÐò£¬Õâ¾äºÜÖØÒª£¡
end
else
begin
    set @strTmp = ">(select max"
    set @strOrder = " order by [" + @fldName +"] asc"
end

if @PageIndex = 1
begin
    if @strWhere != ''   
    set @strSQL = "select top " + str(@PageSize) +" "+@strGetFields+ "  from [" + @tblName + "] where " + @strWhere + " " + @strOrder
     else
     set @strSQL = "select top " + str(@PageSize) +" "+@strGetFields+ "  from ["+ @tblName + "] "+ @strOrder
--Èç¹ûÊǵÚÒ»Ò³¾ÍÖ´ÐÐÒÔÉÏ´úÂ룬ÕâÑù»á¼Ó¿ìÖ´ÐÐËÙ¶È
end
else
begin
--ÒÔÏ´úÂ븳ÓèÁË@strSQLÒÔÕæÕýÖ´ÐеÄSQL´úÂë
set @strSQL = "select top " + str(@PageSize) +" "+@strGetFields+ "  from ["
    + @tblName + "] where [" + @fldName + "]" + @strTmp + "(["+ @fldName + "]) from (select top " + str((@PageIndex-1)*@PageSize) + " ["+ @fldName + "] from [" + @tblName + "]" + @strOrder + " as tblTmp)"+ @strOrder

if @strWhere != ''
    set @strSQL = "select top " + str(@PageSize) +" "+@strGetFields+ "  from ["
        + @tblName + "] where [" + @fldName + "]" + @strTmp + "(["
        + @fldName + "]) from (select top " + str((@PageIndex-1)*@PageSize) + " ["
        + @fldName + "] from [" + @tblName + "] where " + @strWhere + " "
        + @strOrder + " as tblTmp) and " + @strWhere + " " + @strOrder
end
end   
exec (@strSQL)
GO
¡¡¡¡ÉÏÃæµÄÕâ¸ö´æ´¢¹ý³ÌÊÇÒ»¸öͨÓõĴ洢¹ý³Ì£¬Æä×¢ÊÍÒÑдÔÚÆäÖÐÁË¡£

Óиö¸½¼þÊǹØÓÚ±¾¹ý³ÌµÄÏêϸ˵Ã÷¡£
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

lfl_jeetoon

Í­³æ (³õÈëÎÄ̳)

×Ô¼º¶¥Ò»Ï¡£
2Â¥2007-12-05 14:39:56
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ lfl_jeetoon µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ²ÄÁϹ¤³Ì281»¹Óе÷¼Á»ú»áÂð +29 xaw. 2026-04-11 30/1500 2026-04-13 00:20 by 1005715100
[¿¼ÑÐ] 327Çóµ÷¼Á +5 ʰ¹âÈÎȾ 2026-04-06 5/250 2026-04-12 02:29 by Çï¶¹²ËÑ¿
[¿¼ÑÐ] 280Çóµ÷¼Á +7 ÙâÙâÒ¹Ò¹ 2026-04-09 10/500 2026-04-12 00:33 by À¶ÔÆË¼Óê
[¿¼ÑÐ] Çóµ÷¼Á +18 MAXâê㯠2026-04-09 20/1000 2026-04-11 23:31 by zhen¡«
[¿¼ÑÐ] 290Çóµ÷¼Á +13 luoziheng 2026-04-10 13/650 2026-04-11 23:15 by labixiaoqiao
[¿¼ÑÐ] 270Çóµ÷¼Á +14 ÑîÀÖ369 2026-04-11 14/700 2026-04-11 20:16 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 266Çóµ÷¼Á£¬Ò»Ö¾Ô¸¹þ¹¤³Ìµç×ÓÐÅÏ¢£¬±¾¿Æ»ñ¶àÏî¹ú½±ºÍÊ¡½± +8 lumine1 2026-04-06 8/400 2026-04-11 18:35 by ÄæË®³Ë·ç
[¿¼ÑÐ] µ÷¼ÁÇóÖú +6 ¹ûÈ»ÓÐÎÒ 2026-04-11 7/350 2026-04-11 16:22 by Ã÷Ô´ËʱÓÐ
[¿¼ÑÐ] »¯Ñ§308·ÖÇóµ÷¼Á +22 ÄãºÃÃ÷ÌìÄãºÃ 2026-04-07 24/1200 2026-04-11 11:14 by ChemPharm
[¿¼ÑÐ] 0854µ÷¼Á +8 950824he@ 2026-04-09 8/400 2026-04-11 10:11 by zhq0425
[¿¼ÑÐ] ÖÐҩѧµ÷¼Á ³õÊÔ324 +4 Ñó¸Ê¾Õ¡¢ 2026-04-10 6/300 2026-04-11 09:41 by gong120082
[¿¼ÑÐ] 085402ͨÐŹ¤³Ìµ÷¼Á£¬ÓÐ4Ïîѧ¿Æ¾ºÈü¹ú½±£¨µçÈü¹ú¶þ£©£¬Ë¶Ê¿Ñо¿Éúµ÷¼Á×Ô¼öÐÅ¡£ +5 mÓÀo²»vÑÔoÆúm 2026-04-09 5/250 2026-04-11 09:33 by zhq0425
[¿¼ÑÐ] ÉúÎïѧ308·ÖÇóµ÷¼Á£¨Ò»Ö¾Ô¸»ª¶«Ê¦´ó£©×ö¹ý·Ö×ÓʵÑé +8 ÏàÐűػá¹ââÍòÕ 2026-04-07 9/450 2026-04-10 21:03 by zhouxiaoyu
[¿¼ÑÐ] ÖпÆÔº×Ü·Ö315Çóµ÷¼Á +8 lallalh 2026-04-09 8/400 2026-04-10 19:30 by dick_runner
[¿¼ÑÐ] 282£¬µçÆø¹¤³Ìרҵ£¬Çóµ÷¼Á£¬²»Ìôרҵ +9 jggshjkkm 2026-04-10 9/450 2026-04-10 14:55 by ÄæË®³Ë·ç
[¿¼ÑÐ] 083200 ³õÊÔ305·Ö Çóµ÷¼Á Ôݲ»¿¼ÂÇ¿çרҵ +15 Claireyyyy 2026-04-09 15/750 2026-04-09 16:11 by zhuimr
[¿¼ÑÐ] 353Çóµ÷¼Á +8 Çç¿ÕÍòÀïair 2026-04-07 8/400 2026-04-09 00:18 by GouQ
[¿¼ÑÐ] 296Çóµ÷¼Á +3 Íô£¡£¿£¡ 2026-04-08 3/150 2026-04-08 22:00 by zhouyuwinner
[¿¼ÑÐ] 266µ÷¼Á +8 daya sun 2026-04-07 9/450 2026-04-08 20:27 by yutian743
[¿¼ÑÐ] 081200-11408-367ѧ˶Çóµ÷¼Á +4 1_2_3111 2026-04-06 4/200 2026-04-07 08:13 by jp9609
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û