c#过滤Mysql非法字符

最新推荐文章于 2025-08-20 18:01:28 发布

原创最新推荐文章于 2025-08-20 18:01:28 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #c# #非法字符

数据库专栏收录该内容

5 篇文章

订阅专栏

本文介绍了一个用于清理字符串中可能导致MySQL崩溃的非法字符的方法。通过一个简单的C#函数，该方法可以有效地移除字符串中的特定字符，确保其安全性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

不是调用mysql的函数，先直接将字符串筛选一遍，避免字符串中含有导致mysql死掉的非法字符。


public string UrnHtml(string strHtml) { 
        string[] aryReg ={"'","<",">","%","""",",",".",">=","=<","-","_",";","||","[","]","&","/","-","|","", }; 
        for (int i = 0; i < aryReg.Length; i++) { 
                strHtml = strHtml.Replace(aryReg[i], string.Empty); 
        }
        return strHtml; 
}