ASP.NET³£¼û°²È«ÎÊÌâ
ASP.NET³£¼û°²È«ÎÊÌâ
Ò»¡¢SQLÓï¾ä©¶´
Ðí¶à³ÌÐòÔ±ÔÚÓÃsqlÓï¾ä½øÐÐÓû§ÃÜÂëÑé֤ʱÊÇͨ¹ýÒ»¸öÀàËÆÕâÑùµÄÓï¾äÀ´ÊµÏֵģº
Sql="Select * from Óû§±í where ÐÕÃû = '" + name + "' and ÃÜÂë = '" + password + "'"
ͨ¹ý·ÖÎö¿ÉÒÔ·¢ÏÖ£¬ÉÏÊöÓï¾ä´æÔÚ×ÅÖÂÃüµÄ©¶´¡£µ±ÎÒÃÇÔÚÓû§Ãû³ÆÖÐÊäÈëÏÂÃæµÄ×Ö·û´®Ê±£ºtest' or '1' = '1£¬È»ºó¿ÚÁîËæ±ãÊäÈ룬ÎÒÃÇÉèΪaaa¡£±äÁ¿´ú»»ºó£¬sqlÓï¾ä¾Í±ä³ÉÁËÏÂÃæµÄ×Ö·û´®£º
Sql="Select * from Óû§±í where ÐÕÃû='test' or '1' = '1' and ÃÜÂë = 'aaa'
ÎÒÃǶ¼ÖªµÀselectÓï¾äÔÚÅжϲéѯÌõ¼þʱ£¬Óöµ½»ò£¨or£©²Ù×÷¾Í»áºöÂÔÏÂÃæµÄÓ루and£©²Ù×÷£¬¶øÔÚÉÏÃæµÄÓï¾äÖÐ1=1µÄÖµÓÀԶΪtrue£¬ÕâÒâζ×ÅÎÞÂÛÔÚÃÜÂëÖÐÊäÈëʲôֵ£¬¾ùÄÜͨ¹ýÉÏÊöµÄÃÜÂëÑéÖ¤£¡
Select * from Óû§±í where ÐÕÃû = 'ºÏ·¨µÄÐÕÃû' or '1' = '1' and ÃÜÂë = '' //ÎÞÐèÃÜÂë
Select * from Óû§±í where ÐÕÃû = '' or '1'='1' and ÃÜÂë = '' or '1'='1' //ÎÞÐèÓû§ÃûºÍÃÜÂë
Select * from Óû§±í where ÐÕÃû = 'ºÏ·¨µÄÐÕÃû' --' and ÃÜÂë = '' //ÎÞÐèÃÜÂë
½â¾ö·½·¨£º
·ÀÖ¹ASP.NETÓ¦Óñ»SQL×¢Èëʽ¹¥»÷´³Èë²¢²»ÊÇÒ»¼þÌØ±ðÀ§ÄѵÄÊÂÇ飬ֻҪÔÚÀûÓÃ±íµ¥ÊäÈëµÄÄÚÈݹ¹ÔìSQLÃüÁî֮ǰ£¬°ÑËùÓÐÊäÈëÄÚÈݹýÂËÒ»·¬¾Í¿ÉÒÔÁË¡£¹ýÂËÊäÈëÄÚÈÝ¿ÉÒÔ°´¶àÖÖ·½Ê½½øÐУº
1¡¢¼ì²éÓû§ÊäÈëµÄºÏ·¨ÐÔ£¬È·ÐÅÊäÈëµÄÄÚÈÝÖ»°üº¬ºÏ·¨µÄÊý¾Ý¡£Êý¾Ý¼ì²éÓ¦µ±ÔÚ¿Í»§¶ËºÍ·þÎñÆ÷¶Ë¶¼Ö´ÐЗ—Ö®ËùÒÔÒªÖ´ÐзþÎñÆ÷¶ËÑéÖ¤£¬ÊÇΪÁËÃÖ²¹¿Í»§¶ËÑéÖ¤»úÖÆ´àÈõµÄ°²È«ÐÔ¡£ÔÚ¿Í»§¶Ë£¬¹¥»÷ÕßÍêÈ«ÓпÉÄÜ»ñµÃÍøÒ³µÄÔ´´úÂ룬ÐÞ¸ÄÑéÖ¤ºÏ·¨ÐԵĽű¾£¨»òÕßÖ±½Óɾ³ý½Å±¾£©£¬È»ºó½«·Ç·¨ÄÚÈÝͨ¹ýÐ޸ĺóµÄ±íµ¥Ìá½»¸ø·þÎñÆ÷¡£
2¡¢¶ÔÓÚ¶¯Ì¬¹¹ÔìSQL²éѯµÄ³¡ºÏ£¬¿ÉÒÔʹÓÃÏÂÃæµÄ¼¼Êõ£º
µÚÒ»£ºÌæ»»µ¥ÒýºÅ£¬¼´°ÑËùÓе¥¶À³öÏֵĵ¥ÒýºÅ¸Ä³ÉÁ½¸öµ¥ÒýºÅ¡£
µÚ¶þ£ºÉ¾³ýÓû§ÊäÈëÄÚÈÝÖеÄËùÓÐÁ¬×Ö·û¡£
µÚÈý£º¶ÔÓÚÓÃÀ´Ö´ÐвéѯµÄÊý¾Ý¿âÕÊ»§£¬ÏÞÖÆÆäȨÏÞ¡£Óò»Í¬µÄÓû§ÕÊ»§Ö´Ðвéѯ¡¢²åÈë¡¢¸üС¢É¾³ý²Ù×÷¡£ÓÉÓÚ¸ôÀëÁ˲»Í¬ÕÊ»§¿ÉÖ´ÐеIJÙ×÷£¬Òò¶øÒ²¾Í·ÀÖ¹ÁËÔ±¾ÓÃÓÚÖ´ÐÐSELECTÃüÁîµÄµØ·½È´±»ÓÃÓÚÖ´ÐÐINSERT¡¢UPDATE»òDELETEÃüÁî¡£
3¡¢Óô洢¹ý³ÌÀ´Ö´ÐÐËùÓеIJéѯ¡£SQL²ÎÊýµÄ´«µÝ·½Ê½½«·ÀÖ¹¹¥»÷ÕßÀûÓõ¥ÒýºÅºÍÁ¬×Ö·ûʵʩ¹¥»÷¡£´ËÍ⣬Ëü»¹Ê¹µÃÊý¾Ý¿âȨÏÞ¿ÉÒÔÏÞÖÆµ½Ö»ÔÊÐíÌØ¶¨µÄ´æ´¢¹ý³ÌÖ´ÐУ¬ËùÓеÄÓû§ÊäÈë±ØÐë×ñ´Ó±»µ÷ÓõĴ洢¹ý³ÌµÄ°²È«ÉÏÏÂÎÄ£¬ÕâÑ
Ïà¹ØÎĵµ£º
¹ØÓڿؼþͼ±êµÄÊ£¬¿ÉûÉÙϹÕÛÌÚ£¬´ÓǰÄêÏëÈëÊÖÕâ·½Ãæ¿ªÊ¼£¬¾Íû¸ã¶¨¹ý¡£N¶à´óϺµÄÌù×Ó¶¼·ÀÃÁË£¬Ò²Ã»ÕÒ³ö¸öÍ·Ð÷À´¡£Æäʵ×ʼÓдÎÕæ¸øÃɳöÀ´ÁË£¡²»¹ýºóÀ´¸Ä¿Ø¼þ£¬Ò²²»ÖªµÀ¸ÄÄÄÁË¡£Ã»ÁË£¡ÓÚÊÇÂúÊÀ½çµÄCSDN¡¢MSDN¡£¡£¡£¡£NBµÄÈË£¬NBµÄÎÄÕ¿´ÁËÑÛÔΣ¬´òËÀҲûÓÐŪ³öÀ´¡£×òÌìÏîÄ¿ÖÐÓöµ½ÎÊÌ⣬¿´ÁËÒ»¸çÃǵĿؼþ£¨WEBABCD£ºÖÁ½ñ ......
http://www.cnblogs.com/TerryFeng/archive/2009/02/01/1382123.html
ÕâºÜ³£Óã¬ËÑË÷ÁËһϲ©¿ÍÔ°µÄ“ÕÒÕÒ¿´”ºÍ¹È¸è£¬¿´µ½´ó²¿·Ö¶¼ÊÇ×ªÔØÓÚÒ»Á½ÆªÎÄÕ£¨¶øÇÒÀ´Ô´»¹²»ÊDz©¿ÍÔ°£©£¬ÓеÄÊǼòµ¥µÄ˵һµãÎÞ·¨ÔËÐУ¬¸ø³õѧÕߵĵ÷ÊÔºÍѧϰ´øÀ´²»·½±ã£¬ÎÒÔÚÕâÀォjQuery Ajax µ÷ÓÃAspx.Net WebService µÄ¼¸¸ö³£Óõķ½·¨ ......
DateTime dt = DateTime.Now;
// Label1.Text = dt.ToString();//2005-11-5 13:21:25
// Label2.Text = dt.ToFileTime().ToString();//127756416859912816
// Label3.Text = dt.ToFileTimeUtc().ToString();//127756704859912816
// Labe ......
ASP.NET defines an application as the sum of all files, pages, handlers, modules, and executable code that can be invoked or run in the scope of a given virtual directory (and its subdirectories) on a Web application server. For example, an "order" application might be published in the "/order" virt ......