ASPÖÐÊ®´ó³£ÓóÌÐò´úÂë.£ºµÚÎå½Ú¡´ÎÒµÄÐĵáµ
ÀûÓÃASP´òÔìÍøÕ¾ÂÛ̳DIY(3)
¡¡¡¡2¡¢¹¹½¨ÎÄÕÂÏÔʾģ¿é
¡¡¡¡Ç°Ãæ˵¹ý£¬Ò»Æ¬¾ßÌåµÄÎÄÕÂÊÇ·ÖÊôÔÚ¿´°åºÍÖ÷Ìå֮ϵġ£Òò´ËÏÔʾÎÄÕÂÒ²Òª¾¹ý¿´°åÁбíºÍÖ÷ÌåÁбíÕâÁ½Ò³Ãæºó£¬²ÅÄܵõ½Ìض¨Ö÷ÌâÏÂÎÄÕµÄÁÐ±í¡£
¡¡¡¡£¨1£©°åÁбíµÄÏÔʾҳÃ棺
£¼ html£¾
£¼ head£¾
£¼ title£¾¿´°åÁÐ±í£¼ /title£¾
£¼ meta http-equiv="Content-Type"content="text/html; charset=GB2312"£¾
£¼ /head£¾
¡¡¡¡£¨2£©´ò¿ªÁ¬½Ó£¬ÏÔʾ¿´°åÁбí
£¼ %Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft AccessDriver (*.mdb)};dbq=" & Server.MapPath("bbssystem.mdb")
sql = "select * from ¿´°åÁбí"
set rs=conn.execute(sql)
%£¾
¡¡¡¡×¢£º¼òµ¥µÄSQL²éѯ£¬°ÑËùÓеĿ´°åÓйØѶϢ´«»Øµ½¼Í¼¼¯RSÖС£ÏÂÃæµÄÈÎÎñ¾ÍÊÇÏÔʾ¼Í¼¼ÇµÃÄÚÈÝ£¬²¢ÔÚÏàÓ¦µÄ¿´°åÃû³ÆÉϽ¨Á¢ÏÔʾ¿´°åÖ÷ÌâµÄÁ¬½Ó¡£
£¼ body bgcolor="#FFFFFF"£¾
£¼ h2 align="center"£¾¿´°åÁÐ±í£¼/h2£¾
£¼ table width="60%" border="0"cellspacing="0" cellpadding="0"align="center"£¾
£¼ tr bgcolor="#FFFFCC"£¾
£¼ td height="35" width="25%"£¾¿´°åÃû³Æ£¼/td£¾
£¼ td height="35" width="21%"£¾°åÖ÷£¼/td£¾
£¼ td height="35" width="23%"£¾Ö÷ÌâÊý£¼/td£¾
£¼ td height="35" width="31%"£¾°åÖ÷µÇ½£¼/td£¾
£¼ /tr£¾
¡¡¡¡×¢£ºÕâ¶ùÒ»²¿·ÖÊÇÏÔʾ³ö±í¸ñÖÐÿһÁеıêÌ⣬Õâ¶ùÎÒûÓÐÓÃÒ»¸öͳһµÄº¯ÊýÀ´ÏÔʾRS¼Í¼¼ÇµÄÄÚÈÝ£¬ÒòΪÕâÑù¿ÉÒÔ¶Ô±í¸ñµÄÍâ¹ÛºÍ·ç¸ñ×ö¸ü¶àµÄ¿ØÖÆ£¬Ê¹ÓÃÆðÀ´ËäÈ»ÓеãÂé·³£¬µ«ÊÇÈ´¸üΪÁé»î¡£
£¼ %
do
boardid=rs("id")
boardname=rs("Ãû³Æ")
boardmanager=rs("°åÖ÷")
response.write "£¼ tr£¾£¼ td£¾£¼a href=qBoard.asp?boardid="& boardid& "&boardname=" & boardname& "£¾" & boardname &"£¼ /a£¾£¼ /td£¾"
¡¡¡¡×¢£ºÕâÒ»ÐÐÊÇÖص㣬µ±µã»÷Á˸÷¸ö°åµÄÃû³Æºó£¬¿ÉÒÔÁ¬½Óµ½ÏÔʾ¿´°åÖ÷ÌâµÄÒ³Ãæ¡£³ÌÐò´úÂë¿´ÆðÀ´ÓеãÂé·³£¬ÎÒ·Ö½âÁ˸øÄã½²£¬Äã¾Í»áÃ÷°×ÁË¡£ÔÚµã»÷Ö®ºó£¬ä¯ÀÀÆ÷ÇëÇóʹÓõÄÊÇqBoard.aspÒ³Ã棬²¢´øÓÐÒ»¸ö²ÎÊýboardid£¬´ú±íÒªÏÔʾ¿´°åµÄIDºÅ£¬ÔÚÇëÇóÒ³ÃæºÍ²ÎÊýÖ®¼äÓÃÎʺţ¨£¿£©·Ö¸ô¡£BoardidÊÇÇ°ÃæÉ趨Á˵ıäÁ¿£¬ÆäÖаüº¬µÄ¾ÍÊǶÔÓ¦¿´°åµÄIDºÅ¡£Õâ¸öÁ¬½ÓÖл¹´øÓÐÁíÍâÒ»¸ö²ÎÊýboardname£¬ÓÃÀ´°Ñ¿´°åÃû³Æ´«µÝ¸øqBoard.aspÒ³Ãæ¡£ÔÚ¶à¸ö²ÎÊý¼äʹÓÃ"&"À´·Ö¸ô¡£Õâ¸ö²ÎÊý²»ÊDZØÐëµÄ£¬´«µÝ¹ýÈ¥ÊÇΪ
Ïà¹ØÎĵµ£º
VBSÀ³¬³öIntegerÀàÐ͵ÄÈ¡Öµ·¶Î§£¬¸ÃÀàÐ͵ÄÈ¡Öµ·¶Î§Îª-32,768 µ½ 32,767 Ö®¼äµÄÕûÊý¡£
³ö´íµÄ¸ùÔ´£º
ÔÚASPÀÓÐʱºòΪÁË·ÂÖ¹×¢È룬ËùÒÔÔÚ½ÓÊÕ²ÎÊýµÄʱºòÖ±½ÓʹÓÃCintº¯Êý°Ñ½Ó¹ýÀ´µÄ²ÎÊýת»»ÎªInteger£¨Êý×Ö£©ÀàÐÍ£¬Õâ¾Í´æÔÚÒ»¸öDZÔÚÎÊÌ⣬µ±Ò³Ãæ½ÓÊÕµÄij¸ö²ÎÊý£¨Request("xxx")£©³¬¹ýÈ¡Öµ·¶Î§Ê±£¨¿É¼òµ¥Àí½âΪ5λÊý×Ö£ ......
×î½ü°ï±ðÈË´¦ÀíÏÂÊý¾Ý,·¢ÏÖÌí¼ÓÊý¾Ýʱ,¾ÍÌáʾ"ASP ²»ÄܸüС£Êý¾Ý¿â»ò¶ÔÏóΪֻ¶Á¡£",´ÓÍøÉÏÕÒÁË,ҲûÓнâ¾öÎÒµÄÎÊÌâ.
1¡¢·þÎñÆ÷µÄÊý¾ÝĿ¼mdbÎļþËùÔÚµÄĿ¼£¬ÊÇÖ»¶ÁµÄ
2¡¢Êý¾Ý¿âÔÚ±¾µØµÄȨÏÞ£¬È¥Ö»¶ÁȨÏÞ£¬ÔÙÉÏ´«
3¡¢ÓпÉÄÜÄãÊÇ´ÓÖ»¶ÁĿ¼Òƶ¯µ½¿É¶ÁĿ¼µÄ£¬ËùÒÔÒ»¶¨²»ÄÜÕâôÓã¬ÏÈϵ½±¾µØ£¬ÔÙÉÏ´«£¬¿É½â¾ö´ËÀàÎÊ ......
½«ÒÔÏ´úÂë·Åµ½Ò»¸öµ¥¶ÀµÄÒ³Ãæcheckcode.asp
<%
Option Explicit
Response.buffer=true
Call Com_CreatValidCode("validateCode")
Sub Com_CreatValidCode(pSN)
' ½ûÖ¹»º´æ
Response.Expires = -9999
Response.AddHeader "Pragma","no-cache"
Response.AddHeader "cache-ctrol","no-cache"
Response.ContentTy ......
ÍøÒ³ÖÆ×÷ÖУ¬ÎªÁË·½±ãÈÕºóÐ޸ĻòÐ×÷¿ª·¢£¬³£³£Òª¶ÔÒ³Ãæ½øÐÐÏàÓ¦µÄ×¢ÊÍ£¬ÄãÍøÒ³½á¹¹ÇåÎú£¬¿É¶ÁÐÔÔöÇ¿¡£ÒÔϽéÉܼ¸ÖÖ³£ÓõÄ×¢ÊÍ·½·¨£º
Ò»¡¢HTMLµÄ×¢ÊÍ·½·¨
<!-- html×¢ÊÍ:START -->
ÄÚÈÝ
<!-- html×¢ÊÍ:END -->
¶þ¡¢CSSµÄ×¢ÊÍ·½·¨
<style type="text/css">
/* css×¢ÊÍ*/
</style>
ÔÚµ¥¶À ......
ÓÃASPÖÆ×÷ÕÅÑï¸öÐԵĵ÷²éϵͳ(1)
¡¡¡¡Ëæ×ÅÍøÂçµÄÆÕ¼°£¬ÍøÉϵ÷²éÍùÍùÄÜ´ïµ½½ÏºÃµÄЧ¹û¡£ÔÚ×Ô¼ºµÄ¸öÈËÕ¾µãÉÏ·ÅÒ»¸öȤζÎÊÌâµ÷²é°å£¬×ÅʵÄÜΪÍøÕ¾ÌíÉ«²»ÉÙ£»¿öÇÒͨ¹ýµ÷²é½á¹ûÄãÄܸü¶à¸ü׼ȷÁ˽âÍøÓѶÔ×Ô¼ºÕ¾µãµÄ¿´·¨¡£×÷ΪWebmaster£¬Èç¹ûÄãµÄÍøÕ¾Ò²ÐèÒª¾Íij¸öÖ÷Ìâ½øÐе÷²é£¬¶øÄãÓÖÌÖÑáʹÓñðÈËÃâ·ÑÌṩµÄµ÷²é ......