ASP最新SQL防注入过滤涵数-阿里云开发者社区

ASP最新SQL防注入过滤涵数

2017-11-08 1115

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

简介：

Function Checkstr(Str)
If Isnull(Str) Then
CheckStr = ""
Exit Function
End If
Str = Replace(Str,Chr(0),"", 1, －1, 1)
Str = Replace(Str, """", """, 1, －1, 1)
Str = Replace(Str,"<；","<；", 1, －1, 1)
Str = Replace(Str,">；",">；", 1, －1, 1)
Str = Replace(Str, "script", "script", 1, －1, 0)
Str = Replace(Str, "SCRIPT", "SCRIPT", 1, －1, 0)
Str = Replace(Str, "Script", "Script", 1, －1, 0)
Str = Replace(Str, "script", "Script", 1, －1, 1)
Str = Replace(Str, "object", "object", 1, －1, 0)
Str = Replace(Str, "OBJECT", "OBJECT", 1, －1, 0)
Str = Replace(Str, "Object", "Object", 1, －1, 0)
Str = Replace(Str, "object", "Object", 1, －1, 1)
Str = Replace(Str, "applet", "applet", 1, －1, 0)
Str = Replace(Str, "APPLET", "APPLET", 1, －1, 0)
Str = Replace(Str, "Applet", "Applet", 1, －1, 0)
Str = Replace(Str, "applet", "Applet", 1, －1, 1)
Str = Replace(Str, "[", "[")
Str = Replace(Str, "]", "]")
Str = Replace(Str, """", "", 1, －1, 1)
Str = Replace(Str, "=", "=", 1, －1, 1)
Str = Replace(Str, "’", "’’", 1, －1, 1)
Str = Replace(Str, "select", "select", 1, －1, 1)
Str = Replace(Str, "execute", "execute", 1, －1, 1)
Str = Replace(Str, "exec", "exec", 1, －1, 1)
Str = Replace(Str, "join", "join", 1, －1, 1)
Str = Replace(Str, "union", "union", 1, －1, 1)
Str = Replace(Str, "where", "where", 1, －1, 1)
Str = Replace(Str, "insert", "insert", 1, －1, 1)
Str = Replace(Str, "delete", "delete", 1, －1, 1)
Str = Replace(Str, "update", "update", 1, －1, 1)
Str = Replace(Str, "like", "like", 1, －1, 1)
Str = Replace(Str, "drop", "drop", 1, －1, 1)
Str = Replace(Str, "create", "create", 1, －1, 1)
Str = Replace(Str, "rename", "rename", 1, －1, 1)
Str = Replace(Str, "count", "count", 1, －1, 1)
Str = Replace(Str, "chr", "chr", 1, －1, 1)
Str = Replace(Str, "mid", "mid", 1, －1, 1)
Str = Replace(Str, "truncate", "truncate", 1, －1, 1)
Str = Replace(Str, "nchar", "nchar", 1, －1, 1)
Str = Replace(Str, "char", "char", 1, －1, 1)
Str = Replace(Str, "alter", "alter", 1, －1, 1)
Str = Replace(Str, "cast", "cast", 1, －1, 1)
Str = Replace(Str, "exists", "exists", 1, －1, 1)
Str = Replace(Str,Chr(13),"<；br>；", 1, －1, 1)
CheckStr = Replace(Str,"’","’’", 1, －1, 1)

End Function

本文转自loveme2351CTO博客，原文链接：http://blog.51cto.com/loveme23/8218 ，如需转载请自行联系原作者

ASP最新SQL防注入过滤涵数

热门文章

最新文章

相关课程

相关电子书

相关实验场景