¸÷λ°ïÎÒ¿´¿´ÎÒµÄËÑË÷¹¦ÄÜÄÄÀï³öÎÊÌâÁË£¿

Ùvxsò}

˵Ã÷£º¹²4¸öËÑË÷Ìõ¼þ£¬·Ö±ðΪclass1,class2£¬³ÇÊк͹ؼü×Ö
      ÆäÖÐclass1 ºÍclass2 Á½Õß²»Í¬Ê±Îª¿Õ£¬³ÇÊУ¨province,city£©ºÍ¹Ø¼ü×Ö£¨keywords£©¿ÉÒÔΪ¿Õ
´úÂëÈçÏ£¬Çë°ïÎÒ¿´¿´ÄÇÀï³öÎÊÌâÁË£¬´íÎóÌáʾΪADODB.Recordset (0x800A0BB9)²ÎÊýÀàÐͲ»ÕýÈ·£¬»ò²»ÔÚ¿ÉÒÔ½ÓÊܵķ¶Î§Ö®ÄÚ£¬»òÓëÆäËû²ÎÊý³åÍ»¡££¨Á¬½ÓÊý¾Ý¿âÕýÈ·£©»òÕßÓÐûÓÐÆäËûµÄ·½·¨¿ÉÐС£ÎÒ¾õµÃÕâÑùÌ«¸´ÔÓÁË£¬Ð»Ð»ÁË£¡
<%
set rs2=server.CreateObject("adodb.recordset")

if request("class1")="" and request("class2")<>"" then
   if request("province")="" and request("keywords")="" then
   sql="select * from  ad where class2='"&request("class2")&"'"
   else
     if request("province")<>"" and request("keywords")<>"" then
     sql="select * from  ad where class2='"&request("class2")&"' and province='"&request("province")&"' and city='"&request("city")&"' and keywords like '%"&request("keywords")&"%'"
     else
       if request("province")<>"" and request("keywords")="" then
       sql="select * from  ad where class2='"&request("class2")&"' and province='"&request("province")&"' and city='"&request("city")&"'"
       else
          if request("province")="" and request("keywords")<>"" then
          sql="select * from  ad where class2='"&request("class2")&"' and keywords like '%"&request("keywords")&"%'"
          end if
       end if
     end if
    end if
else
if request("class1")<>"" and request("class2")="" then
   if request("province")="" and request("keywords")="" then
   sql="select * from  ad where class1='"&request("class1")&"'"
   else
     if request("province")<>"" and request("keywords")<>"" then
     sql="select * from  ad where class1='"&request("class1")&"' and province='"&request("province")&"' and city='"&request("city")&"' and keywords like '%"&request("keywords")&"%'"
     else
       if request("province")<>"" and request("keywords")="" then
       sql="select * from  ad where class1='"&request("class1")&"' and province='"&request("province")&"' and city='"&request("city")&"'"
       else
          if request("province")="" and request("keywords")<>"" then
          sql="select * from  ad where class1='"&request("class1")&"' and keywords like '%"&request("keywords")&"%'"
          end if
        end if
      end if
    end if
else
if request("class1")<>"" and request("class2")<>"" then
   if request("province")="" and request("keywords")="" then
   sql="select * from  ad where class2='"&request("class2")&"' and class1='"&request("class1")&"'"
   else
      if request("province")<>"" and request("keywords")<>"" then
      sql="select * from  ad where class2='"&request("class2")&"'  and class1='"&request("class1")&"' and province='"&request("province")&"' and city='"&request("city")&"' and keywords like '%"&request("keywords")&"%'"
      else
        if request("province")<>"" and request("keywords")="" then
        sql="select * from  ad where class2='"&request("class2")&"' and class1='"&request("class1")&"' and province='"&request("province")&"' and city='"&request("city")&"'"
        else
          if request("province")="" and request("keywords")<>"" then
          sql="select * from  ad where class2='"&request("class2")&"'  and class1='"&request("class1")&"' and keywords like '%"&request("keywords")&"%'"
          end if
        end if
      end if
   end if
   end if
   end if
end if

rs2.open str,conn,1,1
%>

¾ø¶Ô±êÖÂ

ÎÒ²»¿´Õâô³¤µÄÉú³ÉSQLÓï¾äµÄ´úÂ룬Äã×Ô¼º¼ì²é×îºóÉú³ÉµÄSQLÓï¾äÓÐûÓÐÎÊÌâ¡­¡­Óöµ½ÎÊÌâÔÙÏëÔõô°ì

Î÷ɽÍñ¶ù

ÍêÈ«¿ÉÒÔÕâÑùд

if ¡­¡­ then
¡­¡­
elseif ¡­¡­ then
¡­¡­
end if

csÅ£ÈË

лл¸÷λµÄÖ¸µã£¬ÎÒÔÙÊÔÊÔ¿´

ïLß^aiqŸoºÛ

Ãâ·ÑÄÚÈÝ:
sql="Select BellID,SongName,SingerName,Price,AvailabilityDate,SpName,Region,DownloadsNumber,DownloadsDate,YearMonth from DownloadsData where"
if music<>"" then sql=sql&" SongName like '%"&music&"%' AND"
if m_name<>"" then sql=sql&" SingerName like '%"&m_name&"%' AND"
if spname<>"" then sql=sql&" SpName like '%"&spname&"%' AND"
if region<>"" then sql=sql&" Region like '%"&region&"%' AND"
if date1<>"" and date2="" then sql=sql&" YearMonth ='"&date1&"-"&day1&"' AND"
if date2<>"" and date1="" then sql=sql&" YearMonth ='"&date2&"-"&day1&"' AND"
if date1<>"" and date2<>"" then sql=sql&" YearMonth >= '"&date1&"-"&day1&"' AND YearMonth <= '"&date2&"-"&day1&"' AND"
DownloadsDate>'"&month1&"' AND"
if right(sql,5)="WHERE" then sql=left(sql,clng(len(sql))-5) '½â¾öËùÓвÎÊý¶¼Îª¿ÕµÄÇé¿ö
if right(sql,3)="AND" then sql=left(sql,clng(len(sql))-3) 'È¥µô²ÎÊý×îºóµÄand


ÓÃÕâ¸ö°É?ÎÒ¿´±ÈÄãµÄÒªºÃ¿´Ã÷°×µÄ¶à,ҲûÓÐÄãµÄÂé·³
ÏëÔõô²éѯ¾ÍÔõô²éѯ
ÕâÖ»ÊÇÒ»ÖÖ·½·¨

ÎÞÃñ

Ôõô¶¼²»ÕÒ±¾ÖÊÁªÏµÄØ¡­¡­SQLÓï¾ä²»¶Ô²»»áÌáʾÕâ¸ö´íÎó¡£

É­ÁÖµÄÑÛÀá

´íÎóÌáʾÈÔΪADODB.Recordset (0x800A0BB9)²ÎÊýÀàÐͲ»ÕýÈ·£¬»ò²»ÔÚ¿ÉÒÔ½ÓÊܵķ¶Î§Ö®ÄÚ£¬»òÓëÆäËû²ÎÊý³åÍ»¡£
Õâ¸öÎÊÌâÓ¦¸Ã²»ÊÇÄãµÄ´úÂëÎÊÌâ
ÄãÓ¦¸Ã¼ì²éÒ»ÏÂÊý¾Ý¿âÁ¬½ÓÕýÈ·²»£¿
ÓÐûÓаüº¬conn.asp£¨Êý¾Ý¿âÁ¬½ÓÎļþ£©£¿
conn.aspÑù±¾£º
<%dim conn,connstr
set conn = server.createobject("adodb.connection")
connstr= "provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source = " & Server.MapPath("****.mdb")
if err then
err.clear
else
conn.open connstr
end if
Sub closeconn()
    conn.close
    set conn=nothing
end sub
on error resume next%>

ÂäÆÈС×Ó

ÎÒ°ÑËÑË÷Óï¾ä¸Ä³ÉÏÂÃæµÄ´úÂëÁË£¬¿É»¹ÊDz»ÐУ¬´íÎóÌáʾÈÔΪADODB.Recordset (0x800A0BB9)²ÎÊýÀàÐͲ»ÕýÈ·£¬»ò²»ÔÚ¿ÉÒÔ½ÓÊܵķ¶Î§Ö®ÄÚ£¬»òÓëÆäËû²ÎÊý³åÍ»¡£
ŪÁ˼¸ÌìÁË£¬ÔÙ´ÎÂé·³¸÷λ°ïÎÒ¿´¿´°É£¬Õâ´ÎÔö¼ÓÁËÒ»¸öËÑË÷Ìõ¼þaudit:
str="where audit='1'"
  if len(request("class1"))<>0 then
  str=str&"and class1='"&request("class1")&"'"
  end if
  if len(request("class2"))<>0 then
  str=str&"and class2='"&request("class2")&"'"
  end if
  if request("province")<>"0" then
  str=str&"and province='"&request("province")&"' and city='"&request("city")&"'"
  end if
  if len(request("keywords"))<>0 then
  str=str&"and  keywords like '%"&request("keywords")&"%'"
  end if
  set rs2=server.CreateObject("adodb.recordset")
  sql="select * from ad" &str
  rs2.open sql,conn,1,1

¤´Çã³Ç¨KÁµ

ÏÈ°ÑÒªËÑË÷µÄËĸö¹Ø¼ü½ÓÊÕ¹ýÀ´.ÔÙÓÃIFÅжÏдSQLÓï¾ä.´úÂë¼òµ¥Ã÷ÁË,ÄãÄÇÑùÌ«ÂÒÁË!

ïLß^aiqŸoºÛ

ÎÒÊÔÊÔ£¬Ð»Ð»6Â¥ÁË£¡