asp sql²éѯÎÊÌâ - Web ¿ª·¢ / ASP
СµÜÓöµ½Ò»¸öÎÊÌ⣺
¾ÍÊÇÔÚÊý¾Ý²éѯʱËüÌáʾ ±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£µ«ÊÇwhereºóÃæµÄ¶¼ÊÇÁ½¸ö¶¼ÊÇÊý×Ö°¡
ÎÒµÄÊý¾Ý¿âÊÇÈçÏÂͼ
ÎÒÊǶÔÕâ¸ö±í²éѯÁ½´Î ²¢ÇÒÊÇǶÌ׵ĴúÂë
HTML code:
<div id=mulu >
<ul>
<%
sql="select * from p_class where parentid=0"
set rs=conn.execute(sql)
if rs.eof then
response.Write("ûÓÐĿ¼·ÖÀ࣬Çëµ½ºǫ́Ìí¼Ó")
else
do while not rs.eof %>
<li id=big><%=rs("class")%></li>
<%
sql2="select * from p_class where parentid='"&rs("id")&"'"
set rs2=conn.execute(sql2)
if rs2.eof then
else
do while not rs2.eof
%>
<li id=small><%=rs2("class")%></li>
<%
rs2.movenext
loop
end if
rs.movenext
loop
end if
%>
</ul>
</div>
ллyan11cn
£¬Ð¡µÜ»ù´¡²»ÔõôºÃ£¬»¹Êǵúúò¹²¹
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
´ó¼ÒºÃ!ÎÒÊÇÒ»¸öѧÉú,ÏÖÔÚÊÇѧASPµÄ²»ÖªµÀÔõô»ØÊÂ,ÎÒ×Ô¼ºÊÇÓÃCMS×ö¹ýÍøÕ¾ ´úÂëÒ²ÄÜ¿´¶®Ò»µã ÏÖÔÚÏëÂò±¾Êé,Ïë·¨Óкܶà,¾ÍÊÇÏëÂòASPµÄ ÓÖ¿´µ½´ó¼Ò˵ASPÒÔºóûÓÐNETǰ¾°ºÃ,ÎÒÓÖÏëÔÙÈ¥Âò±¾ASP.NETµÄ ÎÒÖªµÀÓÐÕâÑùµÄÏë·¨ ......