vba mysql 非法字符串_过滤SQL非法字符串

///

/// 过滤SQL非法字符串

///

///

///

public static string Filter(string value)

{

if (string.IsNullOrEmpty(value))

return string.Empty;

value = Regex.Replace(value, @";", string.Empty);

value = Regex.Replace(value, @"'", string.Empty);

value = Regex.Replace(value, @"&", string.Empty);

value = Regex.Replace(value, @"%20", string.Empty);

value = Regex.Replace(value, @"--", string.Empty);

value = Regex.Replace(value, @"==", string.Empty);

value = Regex.Replace(value, @"

value = Regex.Replace(value, @">", string.Empty);

value = Regex.Replace(value, @"%", string.Empty);

return value;

}