µÄ²Ù×÷³ÉΪÁËÐÅÏ¢´¦ÀíµÄºËÐÄ,×Ô´ÓMicrosoftÍƳöASP¼¼Êõºó,ÓÉÓÚËüÔÚ´´½¨¶¯Ì¬½»»¥Ê½Õ¾µãÉϵÄÇ¿´ó¹¦Äܼ°Æä´úÂë±àдµÄ¼ò±ãÐÔ¡¢ÃæÏò¶ÔÏóµÄÉè¼Æ,ºÜ¿ìÔÚInternet.IntranetÍøÕ¾Éϵõ½Á˹㷺µÄÓ¦ÓÃ,ÓÈÆäÊÇÉæ¼°µ½Êý¾Ý¿â²Ù×÷µÄÍøÕ¾Ó¦ÓÃϵͳ¸üÊÇÇãÏòÓÚ²ÉÓÃASP¼¼Êõ.ASP³ÉΪÐí¶à¼ÆËã»úרҵÈËÊ¿Éè¼ÆÍøվʱµÄÊ×Ñ¡¼¼Êõ.ÏÖ¼òµ¥½éÉÜÔÚASPÏÂÊý¾Ý¿âÁ¬½ÓµÄÏà¹Ø֪ʶ¡£
¡ó»ù±¾ÔÀí¡¡
ÔÚASPÖÐ,ÓÃÀ´´æÈ¡Êý¾Ý¿âµÄ¶ÔÏóͳ³ÆADO¶ÔÏó(ActiveXDataObjects),ÕâÊÇÒ»ÏîÈÝÒ×ʹÓò¢ÇÒ¿ÉÀ©Õ¹µÄ½«Êý¾Ý¿â·ÃÎÊÌí¼Óµ½WebÒ³µÄ¼¼Êõ,¿ÉÒÔʹÓÃËüÈ¥±àд½ô´Õ¼òÃ÷µÄ½Å±¾ÒÔ±ãÁ¬½Óµ½ODBC(OpenDatabaseConnectivity)¼æÈݵÄÊý¾Ý¿âºÍOLEDB¼æÈݵÄÊý¾ÝÔ´.ÔÚASPÖÐ,ÓÐ7¸ö¶ÔÏó,ÆäÖÐÓëÊý¾Ý¿âÓйصÄÖ÷ÒªÓÐ3ÖÖ¶ÔÏó:Connection,RecordsetºÍCommand,ÆäÖÐConnection¸ºÔð´ò¿ª»òÁ¬½ÓÊý¾Ý¿â,Recordset¸ºÔð´æÈ¡Êý¾Ý±í,Command¶¨Òå¶ÔÊý¾ÝÔ´½øÐвÙ×÷µÄÃüÁî¡£Èç¹ûÖ»ÒÀ¿¿Õâ3¸ö¶ÔÏó»¹ÊÇÎÞ·¨´æÈ¡Êý¾Ý¿âµÄ,»¹±ØÐë¾ßÓÐÊý¾Ý¿â´æÈ¡µÄÇý¶¯³ÌÐò:OLEDBÇý¶¯³ÌÐòºÍODBCÇý¶¯³ÌÐò.¶ÔÓÚÈκÎÒ»ÖÖÊý¾Ý¿â¶¼±ØÐëÓÐÏà¶ÔÓ¦µÄOLEDBÇý¶¯³ÌÐòºÍODBCÇý¶¯³ÌÐò,ADO¶ÔÏó²ÅÄܶÔÊý¾Ý¿â½øÐдæÈ¡¡£ADO¶ÔÏó±ØÐëÓë¸÷ÖÖÇý¶¯³ÌÐòÏà½áºÏ²ÅÄÜ´æÈ¡¸÷ÖÖÀàÐÍÊý¾Ý¿â,²»Í¬µÄÊý¾Ý¿âÐèÒª²»Í¬µÄÇý¶¯³ÌÐò¡£¿ÉÒԷdz£·½±ãµØÔÚ"¿ØÖÆÃæ°å"ÖÐ"ODBCDataSource(32Bit)"ÖлñµÃ±¾»úÇý¶¯³ÌÐòµÄÐÅÏ¢[4]¡£
¡óÊý¾Ý¿âÁ¬½Ó¡¡
·ÃÎÊÊý¾Ý¿âÐÅÏ¢µÄµÚÒ»²½ÊÇ´´½¨Êý¾Ý¿âÔ´²¢ºÍÊý¾Ý¿âÔ´½¨Á¢Á¬½Ó.ADOÌṩÁËConnection¶ÔÏó,¿ÉÒÔʹÓøöÔÏó½¨Á¢ºÍ¹ÜÀíÓ¦ÓóÌÐòºÍODBCÊý¾Ý¿âÖ®¼äµÄÁ¬½Ó.Connection¶ÔÏó¾ßÓи÷ÖÖÊôÐԺͷ½·¨,¿ÉÒÔʹÓÃËüÃÇ´ò¿ªºÍ¹Ø±ÕÊý¾Ý¿âÁ¬½Ó,²¢ÇÒ·¢³ö²éѯÇëÇóÀ´¸üÐÂÐÅÏ¢.Òª½¨Á¢Êý¾Ý¿âÁ¬½Ó,Ê×ÏÈÓ¦´´½¨Connection¶ÔÏóµÄʵÀý.ÔÚʵ¼ÊÓ¦ÓÃÖв»Í¬Êý¾Ý¿âµÄÁ¬½Ó·½·¨ÓÐËù²»Í¬,ËüÃÇÐèÒª½¨Á¢²»Í¬µÄConnection,µ«Èç¹û½¨Á¢Connectionºó,ʹÓÃRecordset¶ÔÏó´æÈ¡Êý¾ÝµÄ·½·¨È´»ù±¾ÏàËÆ.ÒÔTest.mdbΪÀýÁ¬½Ó,»ù±¾²½ÖèÈçÏÂ:
(1)¡¡´´½¨Êý¾Ý¿âÔ´¡¡Êý¾Ý¿âÔ´Ãû,¼´DSN(DataSourceName)ÊÇÁ¬½ÓODBCºÍÊý¾Ý¿âµÄÇÅÁº,ODBCͨ¹ýDSNÀ´ÕÒµ½Òª·ÃÎʵÄÊý¾Ý¿â.¿ÉÒÔͨ¹ý"32λODBC"¶ÔÆä½øÐйÜÀí.
(2)¡¡´´½¨Êý¾Ý¿âÁ´½ÓASPÎļþÖÐÈç¹ûÒª·ÃÎÊÊý¾Ý,±ØÐëÊ×ÏÈ´´½¨ÓëÊý¾Ý¿âµÄÁ´½Ó,ÆäÓï·¨ÈçÏÂ:
setTconn=ServercreateObject("ADOBD.CONNECTION").´´½¨ÁËÁ´½Ó¶ÔÏóTConnTConn.Open"dns","username","password".´ò¿ªÁ´½Ó¡£
(3)¡¡´´½¨Êý¾Ý¶ÔÏó¡¡RecordSet±£´æµÄÊÇÊý¾Ý¿âÃüÁî½á¹û¼¯,²¢±êÓÐÒ»¸öµ±Ç°¼Ç¼.sql="SELECT3FROMtest".ÉèSQLÓï¾äSetRecordSet=TConn.Execute(sql).´´½¨²¢´ò¿ªÁ˶ÔÏó,TConnÊÇ´´½¨µÄÁ´½Ó¶ÔÏóSetRecordSet=TConn.Execute(sql).½«±ítestÖеÄËùÓмǼ±£´æµ½RecordSet¡£
(4)¡¡²Ù×÷Êý¾Ý¿â¡¡¿ÉÒÔÀûÓÃExecute·½·¨Ö´ÐÐÊý¾Ý²åÈë¡¢Ð޸ġ¢É¾³ýµÈ²Ù×÷,ËüµÄ²ÎÊýÊÇÒ»¸ö±ê×¼µÄSQLÓï¾ä´®,Èç:
Ö´ÐвåÈë²Ù×÷:Sql1="INSERTINTOtest(×Ö·û´®ÐÐ)values(×Ö·ûÖµ´®ÐÐ)".SQLÓï¾äTConn.Execute(sql1).
Ö´ÐÐÐ޸IJÙ×÷:Sql2="UPDATEtestSET(×Ö·û´®ÐÐ)=(×Ö·ûÖµ´®ÐÐ)".SQLÓï¾äTConn.Execute(sql2).
¡ó¹Ø±ÕÊý¾Ý¶ÔÏóºÍÁ´½Ó¡¡ÔÚʹÓÃÁËADO¶ÔÏóÖ®ºó,Ò»¶¨Òª¼Çס¹Ø±ÕËü,ÒòΪËüʹÓÃÁË·þÎñÆ÷µÄ×ÊÔ´.ͨ¹ýµ÷Ó÷½·¨closeʵÏֹرÕ,È»ºóÔÙÊÍ·ÅËü.
TConn.Close[5]
¿¼ÂÇÒÔÉϸ÷·½ÃæÒòËØ£¬ËùÒÔÎÒÑ¡ÔñÁËDreamweaver½áºÏASP¼¼Êõ¼Ü¹¹±¾ÍøÕ¾¡£
2ÍøÕ¾½á¹¹Éè¼Æ
2.1Ò³Ãæ²¼¾Ö
ÍøÕ¾Ö÷Ò³²ÉÓþ²¡¢¶¯Ïà½áºÏµÄ·½Ê½£¬¼´¾²Ì¬µÄÖ÷»ÃæºÍ¶¯Ì¬µÄͼƬÏà½áºÏ£¬ÌåÏְ༶µÄ²ª²ªÉúÆø£¬ÍøÕ¾²¼¾ÖÓ¦¸ÃÒÔÇáËÉ¡¢¼ò½àµÄ·ç¸ñΪÖ÷£¬Í¬Ê±Ê¹ÓÃÒ»¶¨µÄͼÐκͶàýÌåÔªËØ£¬½«Õû¸öÍøÒ³·Ö³ÉËĸö²¿·Ö£¨Èçͼ1£©
µÚÒ»²¿·Ö
µÚ¶þ²¿·Ö
µÚÈý²¿·Ö
µÚËIJ¿·Ö
ͼ1Ò³Ãæ²¼¾Ö
µÚÒ»²¿·ÖÖ÷ÒªÓÃÀ´·ÅÖÃÍøÕ¾µÄ±ê־ͼƬ£»µÚ¶þ²¿·ÖÓëµÚËIJ¿·ÖÖ÷ÒªÓÃÀ´·ÅÖÃһЩ¹¦ÄÜÁ´½Ó£»µÚÈý²¿·ÖÊÇÖ÷Ì岿·Ö£¬·ÅÖð༶ÐÅÏ¢¡¢ÁôÑÔ¡¢¹«¸æÄ£¿éµÈ[6]¡£
2.2ÍøÕ¾½á¹¹¼°¹¦ÄÜ
ÍøÕ¾µÄ¾ßÌå½á¹¹Èçͼ2Ëùʾ£¬ÔÚÊ×Ò³ÉϹ²ÓÐ7¸ö´óµÄ¹¦Äܲ˵¥£¬Ã¿¸ö²Ëµ¥Á´½ÓÒ»¸ö¹¦ÄÜÒ³Ã棬ÿ¸öÒ³ÃæʵÏÖ²»Í¬¹¦ÄÜ¡£
ͼ2
³ä·ÖÀûÓÃASPµÄÇ¿´ó¹¦ÄÜ£¬ÔÚÍøÕ¾ÖÐÌṩÁôÑÔ²¾¡¢¹«¸æÀ¸µÈ½»Á÷³¡Ëù£¬ÎªÍ¬Ñ§ÃÇÕ¹¿ªÐÅÏ¢½»Á÷Ìṩ·½±ã¡£
2.3Êý¾Ý¿âÉè¼Æ
±¾ÍøÕ¾²ÉÓõÄÊý¾Ý¿âÊÇMicrosoftAccess£¬½¨Á¢¿âÎļþ£¬°üº¬Èçϼ¸¸ö±íÎļþ£º
claimÍøÕ¾¹«¸æÐÅÏ¢±í
loginfoÀ´·ÃµÇ½ʱ¼äÐÅÏ¢±í
mssgÁôÑÔÐÅÏ¢±í£»
photoͼƬÄÚÈÝ˵Ã÷ÐÅÏ¢±í
user³ÉÔ±µØÖ·ÐÅÏ¢±í[7]
3ÏêϸÉè¼Æ
3.1ͳһ¹æ»®ÍøÕ¾µÄ²¼¾ÖºÍ¸ñʽ
Ê×ÏÈÒª¹æ»®ºÃÍøÕ¾µÄ½á¹¹£¬¶ÔÍøÕ¾µÄÍøÒ³´óÌå²¼¾ÖÓÐÒ»¸ö¾ßÌåµÄÂÖÀª¡£²¢ÇÒΪÍøÕ¾µÄÖ÷Ò³¼°¶þ¼¶Ò³ÃæÈ·¶¨Ò»¸ö¹²Í¬µÄ¸ñʽ£¬°üÀ¨Õû¸öÒ³ÃæµÄÑÕÉ«£¬¿í¶È£¬ÒõÓ°£¬±³¾°£¬×ÖÌåµÄ´óСÑÕÉ«Õâ¾ÍÐèÒªÎÒÃÇÖÆ×÷Ò»¸ö³¬Îı¾Ñùʽ±í.cssÎļþ£¬ÒÔ¹©Ã¿¸öÍøÒ³µ÷Óᣱ¾Õ¾¾ßÌåµÄ.css´úÂëÈçÏ£º
body{
SCROLLBAR-FACE-COLOR:#ffffff;
SCROLLBAR-HIGHLIGHT-COLOR:#000000;
SCROLLBAR-SHADOW-COLOR:#000000;
SCROLLBAR-3DLIGHT-COLOR:#ffffff;
SCROLLBAR-ARROW-COLOR:#666666;
SCROLLBAR-TRACK-COLOR:#ffffff;
SCROLLBAR-DARKSHADOW-COLOR:#ffffff;
background-image:url(../images/bg.gif);background-position:center
}
BODY{
FONT-SIZE:12px;FONT-FAMILY:"Verdana","arial"
}
TABLE{
FONT-SIZE:12px;FONT-FAMILY:"Verdana","arial"
}
TR{
FONT-SIZE:12px;FONT-FAMILY:"Verdana","arial"
}
TD{
FONT-SIZE:12px;WORD-BREAK:break-all;FONT-FAMILY:"Verdana","arial"
}
INPUT{
BACKGROUND-COLOR:#ffffff;BORDER-BOTTOM:#0066cc1pxsolid;BORDER-LEFT:#0066cc1pxsolid;BORDER-RIGHT:#0066cc1pxsolid;BORDER-TOP:#0066cc1pxsolid;COLOR:#0066cc;FONT-SIZE:9pt;HEIGHT:16px
}
TEXTAREA{
BORDER-TOP-WIDTH:1px;PADDING-RIGHT:1px;PADDING-LEFT:1px;BORDER-LEFT-WIDTH:1px;FONT-SIZE:12px;BORDER-LEFT-COLOR:#cccccc;BACKGROUND:#fefefe;BORDER-BOTTOM-WIDTH:1px;BORDER-BOTTOM-COLOR:#cccccc;PADDING-BOTTOM:1px;BORDER-TOP-COLOR:#cccccc;PADDING-TOP:1px;BORDER-RIGHT-WIDTH:1px;BORDER-RIGHT-COLOR:#cccccc
}
ÔÚÿ¸öÍøÒ³µÄ³ÌÐòÖмÓÈËÈçϵijÌÐò¶Î:
¡£À´ÊµÏÖµ÷ÓÃÒѾ±àÖƺõij¬Îı¾Ñùʽ±íÎļþclass.css£¬ÕâÑù¾ÍΪÍøÕ¾ÖеÄÿ¸öÍøÒ³É趨һ¸ö¹²Í¬µÄÑùʽ£¬ÈçÕû¸öÍøÒ³ÎÄ×ֵĴóС¡¢×ÖÌ壬»¹Óл³¬Áª½ÓºÍÒÑ·ÃÎʳ¬Áª½ÓµÄÑÕÉ«ÒÔ¼°²Ëµ¥µÄһЩÊôÐԵȵȡ£
ΪÍøÕ¾Éè¼ÆÒ»¸öÖ÷Ò³ÃæʹÓÃDreameWeaverMXÀ´ÖÆ×÷¡£»¹ÒªÓõ½HTMLÓïÑÔ¡¢VBScript¡¢JavaScriptµÈ¡£½«Ç°Ãæ˵µ½µÄ¹¦ÄܺÍÄÚÈÝÒԲ˵¥µÄÐÎʽÁгöÔÚÖ÷Ò³ÉÏ£¬¼¶Áª²Ëµ¥ÉÏÊÇһЩ¾ßÌåµÄ¹¦ÄܺÍÄÚÈÝ¡£µ±È»£¬Õâ¸ö²Ëµ¥ÊÇÓÃJavaScript±àÖƳöÀ´µÄÒ»¸öº¯Êý£¬È»ºó£¬ÔÚÿһ¸ö²Ëµ¥ÎļþµÄ´úÂëÖÐÔÙµ÷ÓÃÕâ¸öº¯Êý£¬ÆäËüµÄ²Ëµ¥Ò²¿ÉÒÔÓÃͬÑùµÄ´úÂëÀ´ÊµÏÖ¡£Í¬Ñù£¬¶ÔÓÚ¶þ¼¶Ò³ÃæµÄÉè¼ÆÒÔ¼°ÆäËüÒ³ÃæµÄÉè¼ÆÒ²ÊÇÓëÖ÷Ò³Ïàͬ¡£Èç¹ûÕâЩҳÃæµÄÖ÷Òª²¿·ÖÓëÏÈÇ°Éè¼ÆµÄÖ÷Ò³Ö÷Ì岿·Ö·ç¸ñºÍ²¼¾ÖÒÔ¼°²Ëµ¥¶¼Ïàͬ£¬ÄÇôÎÒÃǾͿÉÒÔÏȽ¨Á¢Ò»¸ö¿ÕµÄº¬²Ëµ¥µÄÎļþ×÷Ϊģ°å£¬ÒÔºóÿ½¨Á¢Ò»¸öÀàËƵÄÒ³Ã棬¾Í¿ÉÒÔµ÷ÓôËÄ£°åÎļþ£¬ÔÚ´Ë»ù´¡ÉÏÔÙ½øÐÐÐ޸ġ¢²¹³ä[8]¡£
3.2×¢²áºÍµÇ¼ģ¿éÉè¼Æ
×¢²áµÇ¼ģ¿éÊÇϵͳµÄÃÅ»§,ÔÚÕû¸öϵͳÖÐÕ¼ÓÐÖØÒªµÄµØλ¡£ËüµÄÖ÷Òª¹¦ÄÜÊǸù¾ÝÓû§µÄ¼ÈëÐÅÏ¢½øÐÐÉí·Ýʶ±ð,Åųý·Ç·¨Óû§¶Ô±¾ÏµÍ³µÄʹÓÃ,¶ÔºÏ·¨Óû§Ôò°´ÕÕ²»Í¬µÄ¼¶±ð·ÖÀà´¦Àí£¬´Ó¶ø±£Ö¤ÏµÍ³µÄÔËÐа²È«£¬¹ý³ÌÈçͼ3Ëùʾ[9]¡£
ͼ3¹ý³Ìͼ
Óû§½øÈëÖ÷Ò³Ãæºó,ÒªÏë
ÉÏһƪ£º
ASP011ÈËʹÜÀíϵͳ2(ÂÛÎĺͳÌÐò)
ÏÂһƪ£º
ÊÔÎöÓ°Ï칫··ÃæƽÕû¶ÈµÄÒòËؼ°Ó¦²ÉÈ¡µÄÊ©¹¤´ëÊ©