c#过滤Mysql非法字符

最新推荐文章于 2024-06-20 07:28:08 发布

重口味码农

最新推荐文章于 2024-06-20 07:28:08 发布

阅读量1.6k

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： mysql c# 非法字符

本文链接：https://blog.youkuaiyun.com/acingdreamer/article/details/53259410

数据库专栏收录该内容

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; 
}