ASP.NET SQL ×¢ÈëÃâ·Ñ½â¾ö·½°¸
UrlScanµÄ3.1ÊÇÒ»¸ö°²È«µÄ¹¤¾ß£¬ÏÞÖÆÁËIISµÄHTTPÇëÇ󽫴¦ÀíÀàÐÍ¡£ ͨ¹ý×èÖ¹Ìض¨µÄHTTPÇëÇó£¬ÔÚURLScan 3.1°²È«¹¤¾ßÓÐÖúÓÚ·ÀÖ¹¶Ô·þÎñÆ÷Ó¦ÓóÌÐò¿ÉÄÜÓꦵÄÇëÇó¡£ UrlScanµÄ3.1ÊÇURLScan 2.5µÄ¸üа汾¡£Ö§³ÖIIS 5.1ÖУ¬IIS 6.0ºÍIIS 7.0ÔÚWindows VistaºÍWindows Server 2008¡£ÏÂÔصØÖ·http://download.csdn.net/source/2057125
×èÖ¹¶ÔWebÓ¦ÓóÌÐò¿ÉÄÜÓꦵÄÇëÇó
UrlScan3.1¸ù¾Ý¹ÜÀíÔ±ÉèÖõĹæÔò¹ýÂËËùÓд«Èëµ½·þÎñÆ÷µÄÇëÇó¡£Ö»ÒªÇëÇóͨ¹ý¹ýÂË£¬²ÅÄܵõ½·þÎñÆ÷µÄ´¦Àí¡£
¼õÇáSQL×¢Èë¹¥»÷
ͨ¹ý UrlScan3.1µÄ¿ÉÅäÖÿÉÒÔ¹ýÂËHTTP²éѯ×Ö·û´®ÖµºÍÆäËûµÄHTTP±êÍ·£¬ÒÔ¼õÇáSQL×¢Èë¹¥»÷£¬´Ó¶ø¹®¹ÌÓ¦ÓóÌÐòµÄ°²È«¡£
·ÖÎöÈÕÖ¾Îļþ
UrlScan3.1ÌṩÁËW3C¸ñʽµÄÈÕÖ¾Îļþ·ÖÎöÎļþ£¬×ñÑ΢ÈíÈÕÖ¾·ÖÎöÆ÷2.2·ÖÎö½â¾ö·½°¸¡£
ÌØÕ÷
еÄURLScan 3.1°æ±¾¿ÉÒÔ°²×°ÔÚIIS 5.1£¬IIS 6.0ºÍIIS 7.0 ÉÏ
´´½¨¶ÀÌصē¾Ü¾ø”¹æÔòÓÃÓÚ¼ì²â²éѯ×Ö·û´®£¬ËùÓбêÌ⣬»òÌض¨Í·¡£
ÔÚÒ»¸öÈ«¾ÖµÄDenyQueryStringÅäÖýÚÖУ¬Äú¿ÉÒÔ×Ô¶¨ÒåÇëÇó¹æÔò
ÔÚÒ»¸öÈ«¾ÖµÄAlwaysAllowedUrlsÅäÖýڲ¿·ÖÔÊÐíÄúÖ¸¶¨°²È«µÄÍøÖ·£¬´Ó¶øͨ¹ýURLµÄ¼ì²é¡£
ÔÚÒ»¸öÈ«¾ÖµÄAlwaysAllowedQueryStringsÅäÖýÚÖУ¬¿ÉÒÔÖ¸¶¨²éѯ×Ö·û´®µÄ°²È«£¬½«Í¨¹ýËùÓеIJéѯ×Ö·û´®¼ì²é¡£
תÒåÐòÁУ¨È磥0D£¥£©£¬¿ÉÓÃÓÚ·ñÈϹæÔò£¬ËùÒÔ¿ÉÒÔ·ñ¶¨µÄCRLFºÍÉæ¼°·Ç´òÓ¡×Ö·ûµÄÆäËûÐòÁС£
UrlScanµÄ¶à¸öʵÀý¿ÉÒÔΪվµã°²×°¹ýÂËÆ÷£¬Æä×Ô¼ºµÄÅäÖú͹æÔò£¨Urlscan.iniµÄ£©Ã¿¸ö¡£
¸ü¸Ä֪ͨ»á´«²¥µ½IIS¹¤×÷½ø³Ì¡£
ÔöÇ¿µÄW3C¸ñʽµÄÅäÖôíÎó¸ñʽ¼Ç¼ÔÚ±¸×¢Ê¹Í·ÖС£
Ïà¹ØÎĵµ£º
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁУ¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT TOP·ÖÒ³)
Óï¾äÐÎʽ£º
SELECT TOP Ò³¼Ç¼ÊýÁ¿ *
from ±íÃû
WHERE (ID NOT IN
(SELECT TOP (ÿҳÐÐÊý*(Ò³Êý-1)) ID
from ±íÃû
ORDER BY ID))
ORDER BY ID
//×Ô¼º»¹¿ÉÒÔ¼ÓÉÏһЩ²éѯÌõ¼þ
Àý:
select top 2 ......
1 ÓÃUNIONÌæ»»OR (ÊÊÓÃÓÚË÷ÒýÁÐ)
ͨ³£Çé¿öÏÂ, ÓÃUNIONÌæ»»WHERE×Ó¾äÖеÄOR½«»áÆ𵽽ϺõÄЧ¹û. ¶ÔË÷ÒýÁÐʹÓÃOR½«Ôì³ÉÈ«±íɨÃè. ×¢Òâ, ÒÔÉϹæÔòÖ»Õë¶Ô¶à¸öË÷ÒýÁÐÓÐЧ.
Èç¹ûÓÐcolumnûÓб»Ë÷Òý, ²éѯЧÂÊ¿ÉÄÜ»áÒòΪÄãûÓÐÑ¡ÔñOR¶ø½µµÍ. ÔÚÏÂÃæµÄÀý×ÓÖÐ, LOC_ID ºÍREGIONÉ϶¼½¨ÓÐË÷Òý.
¸ßЧ: SELECT LOC_ID , LOC_DESC , ......
select *from student
select student_id from student
select student_id ,student_name from student
select student_id student_name from student ½«student_name ×÷Ϊstudent_idµÄ±ðÃû´¦Àí
È磺 select student_id a from student
select a=student_id from student
´Óstudent±íÖзֱð¼ ......
¿ì¹ýÄ꣬ºÃ¾Ãûдʲô¶«Î÷ÁË¡£²»ÖªµÀ×î½üÊÇ̫æÁË£¬»¹ÊÇ×Ô¼ºÓеãÀÁ£¬Ð´Ð©×Ô¼º»ýÀ۵Ķ«Î÷¡£¶¼ÊÇЩ×î»ù±¾µÄÓ¦Ó㬺ʹó¼Ò·ÖÏíÏ¡£
ÑéÖ¤ÂëÔںܶàµØ·½¶àÓõ½£¬ÍøÉϸ÷ÖÖÐÎÐÎÉ«É«µÄ´úÂëÒ³ºÜ¶àÁË£¬ÎÒ¾ÍÊÇ´ò·¢µãʱ¼äддÁË¡£
ÔÀí£ºÍ¨¹ýGUI+Éú³ÉÓÐËĸöÊý×ÖµÄͼƬ£¬½«ËĸöÊý×Ö´æ·Åµ½SessionÖУ¬È»ºóͨ¹ýÑéÖ¤ÄãÊäÈëµÄÑéÖ¤ÂëºÍSession ......
Ajax¿ª·¢ÈËÔ±ÐèÒªµÄJavaScript֪ʶ
JavaScriptµ®ÉúÓÚ1995 Ä꣬×î×³ÉÔÚNetsCape Navigatorä¯ÀÀÆ÷ÖС£Microsoft ÔÚIE3Öм¯³É¡£1998Äê±»±ê×¼»¯ÎªECMAScript.
Microsoft Ajax Library¸ÄÉÆÁËJavaScriptµÄÃæÏò¶ÔÏóÄ£ÐÍ¡£
3.1ʹÓöÔÏó
JavaScriptÖеĶÔÏó²¢²»ÊÇÀàÐ͵ÄʵÀý£¬ÒòΪJavaScript²»Ö§³ ......