62,268
社区成员
发帖
与我相关
我的任务
分享/// <summary> ///替换单引号 /// </summary> /// <param name="str"></param> /// <returns></returns> public static string FormatSQLParamSign(string str) { StringBuilder sb = new StringBuilder(str.Trim()); sb.Replace("'", "''"); return sb.ToString(); } public static readonly string blackwords = ";|and|exec|insert|select|delete|update|*|%|chr|mid|master|truncate|char|declare|drop table|xp_cmdshell|netlocalgroup|administrators|net user"; /// <summary> ///拼接sql字符串条件时,替换特殊字符,如'- |and|exec|insert|select|delete|update|count|*|%|chr|mid|master|truncate|char|declare /// </summary> /// <param name="str"></param> /// <returns></returns> public static string FormatSQLParam(string str) { StringBuilder sb = new StringBuilder(str.Trim()); sb.Replace("'", "''"); string[] BlackList = blackwords.Split('|'); for (int i = 0; i < BlackList.Length; i++) { sb.Replace(BlackList[i], ""); } return sb.ToString(); } /// <summary> /// 对Like 条件的特殊字符进行处理 % [ _ ^ '等 /// </summary> /// <param name="str"></param> /// <returns></returns> public static string FormatSQLLikeParam(string str) { StringBuilder sb = new StringBuilder(str.Trim()); sb.Replace("'", "''").Replace("[", "[[]").Replace("%", "[%]").Replace("_", "[_]").Replace("^", "[^]"); return sb.ToString(); }