Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

·Àsql×¢ÈëÀà

 using System;
using System.Text.RegularExpressions;
using System.Web;
namespace FSqlKeyWord
{
/**//**//**//// <summary>
/// SqlKey µÄժҪ˵Ã÷¡£
/// </summary>
public class SqlKey
{
private HttpRequest request;
//private const string StrKeyWord = @"select|insert|delete|from|count(|drop table|update|truncate|asc(|mid(|char(|xp_cmdshell|exec master|netlocalgroup administrators|:|net user|""|or|and";

//string StrKeyWord1 = @"(like|and|exec|insert|select|delete|update|chr|mid|master|or|truncate|char|declare|join)".Replace("|",")|(");
private const string StrKeyWord = @"( like | and | exec |insert|select|delete|update|chr|mid|master| or |truncate|char|declare|join|exec master|xp_cmdshell|net user|systypes|sysobjects)";
//private const string StrRegex = @"([-|;|,|/|(|)|[|]|}|{|%|@|*|!|'])";
private const string StrRegex = @"--|'|@|!";
public SqlKey(System.Web.HttpRequest _request)
{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼­
//
this.request = _request;
}
public SqlKey()
{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼­
//
//this.request = _request;
}
/**//**//**//// <summary>
/// Ö»¶ÁÊôÐÔ SQL¹Ø¼ü×Ö
/// </summary>
public static string KeyWord
{
get
{
return StrKeyWord;
}
}
/**//**//**//// <summary>
/// Ö»¶ÁÊôÐÔ¹ýÂËÌØÊâ×Ö·û
/// </summary>
public static string RegexString
{
get
{
return StrRegex;
}
}
/**//**//**//// <summary>
/// ¼ì²éURL²ÎÊýÖÐÊÇ·ñ´øÓÐSQL×¢Èë¿ÉÄܹؼü×Ö¡£
/// </summary>
/// <param na


Ïà¹ØÎĵµ£º

sql´´½¨´¥·¢Æ÷

 create trigger updatemaster                    //´´½¨´¥·¢Æ÷Ãû×ÖÊÇ updatemaster
on votedetails                 &nb ......

SQL Serve 2000 µÄËÄÖÖϵͳÊý¾Ý¿â

 master Êý¾Ý¿â
master Êý¾Ý¿â¼Ç¼ SQL Server ϵͳµÄËùÓÐϵͳ¼¶±ðÐÅÏ¢¡£Ëü¼Ç¼ËùÓеĵǼÕÊ»§ºÍϵͳÅäÖÃÉèÖá£master Êý¾Ý¿âÊÇÕâÑùÒ»¸öÊý¾Ý¿â£¬Ëü¼Ç¼ËùÓÐÆäËüµÄÊý¾Ý¿â£¬ÆäÖаüÀ¨Êý¾Ý¿âÎļþµÄλÖá£master Êý¾Ý¿â¼Ç¼ SQL Server µÄ³õʼ»¯ÐÅÏ¢£¬ËüʼÖÕÓÐÒ»¸ö¿ÉÓõÄ×îРmaster Êý¾Ý¿â±¸·Ý¡£ÓÉÓÚmasterÊý¾Ý¿â¶ÔSQL S ......

̸̸ SQL Êý¾Ý¿âµÄ±¸·ÝÓ뻹ԭ

 ¡¾Ñ§Ï°µãµãµÎµÎ¡¿ ÔںܶàÇé¿öÓë»·¾³ÖУ¬ÎÒÃǶ¼Òª¶ÔÒÑÓеÄÊý¾Ý¿â½øÐб¸·Ý£¬ÕâÑùÒÔ·ÀÖ¹µ±ÎÒÃÇÒòÈËΪ»òÕß·þÎñÆ÷µÈÖî¶àÔ­Òò¶øµ¼ÖµÄÊý¾Ý¶ªÊ§£¬
   ´Ó¶ø¸øÎÒÃÇ´øÀ´ºÜ´óµÄÂé·³£¬ÎÒÒ²ÊǽӴ¥SQLû¶à³¤Ê±¼ä£¬¶ÔÓëËüÇ¿´óµÄÊý¾Ý¿É»Ö¸´¹¦ÄÜ Ò²Ö»ÊÇÂÔÖªÒ»¶þ£¬µ±È»ÔÚÕâÀïÒ²Ö»ÊÇ×ö¶ÔËü×öÂÔÂԵļǼ£¬
  ´¿´âÊÇ ......

ÈçºÎʹÓà SSL À´È·±£Óë SQL Server 2000 °²È«Í¨ÐÅ

 
ÈçºÎʹÓà SSL À´È·±£Óë SQL Server 2000 °²È«Í¨ÐÅ
¸üÐÂÈÕÆÚ£º 2004Äê04ÔÂ20ÈÕ
±¾Ò³ÄÚÈÝ
Ä¿±ê
ÊÊÓ÷¶Î§
ÈçºÎʹÓñ¾ÕÂÄÚÈÝ
ÕªÒª
Äú±ØÐëÁ˽âµÄ±³¾°ÖªÊ¶
°²×°·þÎñÆ÷ÑéÖ¤Ö¤Êé
ÑéÖ¤Ö¤ÊéÊÇ·ñÒÑ°²×°
ÔÚ¿Í»§¶Ë°²×° CA °ä·¢µÄÖ¤Êé
Ç¿ÖÆËùÓпͻ§¶ËʹÓà SSL
ÔÊÐí¿Í»§¶Ë¾ö¶¨ÊÇ·ñʹÓà SSL
Ñé֤ͨÐÅÊÇ·ñÒѼÓÃÜ
ÆäËû× ......

sql²éѯ×îºóÒ»ÌõÊý¾Ý

1¡¢ sql²éѯ×îºóÒ»ÌõÊý¾Ýselect * from table order by id DESC limit 1
2¡¢select top1 * from tablename where order by id desc
ͨ¹ýÔÚmysqlÖвâÊÔ£¬Ö»ÓеÚÒ»ÖÖ¿ÉÒÔʹÓ㬲»ÖªµÀÆäËûÊý¾Ý¿âÊÇ·ñÖ§³ÖµÚ¶þÖÖ·½·¨£¬ÍøÉϺܶàÈË˵ÓõڶþÖÖ·½·¨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ