防SQL注入



<%

Dim Query_Badword,Form_Badword,i,Err_Message,Err_Web,name

'------定义部份  头----------------------------------------------------------------------

Err_Message = 1  '处理方式:1=提示信息,2=转向页面,3=先提示再转向

Err_Web = "Err.Asp" '出错时转向的页面

Query_Badword="'∥and∥select∥update∥chr∥delete∥%20from∥;∥insert∥mid∥master.∥set∥chr(37)∥="    

'在这部份定义get非法参数,使用"∥"号间隔    

Form_Badword="'∥%∥&∥*∥#∥@∥(∥)∥="     '在这部份定义post非法参数,使用"∥"号间隔

'------定义部份  尾-----------------------------------------------------------------------''power by marquee'www.mb999.com'QQ:278836516 Mail:marquee@mb999.com'On Error Resume Next

'----- 对 get query 值 的过滤.

if request.QueryString<>"" thenChk_badword=split(Query_Badword,"∥")FOR EACH Query_Name IN Request.QueryStringfor i=0 to ubound(Chk_badword)If Instr(LCase(request.QueryString(Query_Name)),Chk_badword(i))<>0 ThenSelect Case Err_Message  Case "1"Response.Write "<Script Language=JavaScript>alert('传参错误!参数 "&name&" 的值中包含非法字符串!/n/n请不要在参数中出现:and update delete ; insert mid master 等非法字符!');window.close();</Script>"  Case "2"Response.Write "<Script Language=JavaScript>location.href='"&Err_Web&"'</Script>"  Case "3"Response.Write "<Script Language=JavaScript>alert('传参错误!参数 "&name&"的值中包含非法字符串!/n/n请不要在参数中出现:and update delete ; insert mid master 等非法字符!');location.href='"&Err_Web&"';</Script>"End SelectResponse.EndEnd IfNEXTNEXTEnd if

'-----对 post 表 单值的过滤.

if request.form<>"" thenChk_badword=split(Form_Badword,"∥")FOR EACH name IN Request.Formfor i=0 to ubound(Chk_badword)If Instr(LCase(request.form(name)),Chk_badword(i))<>0 ThenSelect Case Err_Message  Case "1"Response.Write "<Script Language=JavaScript>alert('出错了!表单 "&name&" 的值中包含非法字符串!/n/n请不要在表单中出现: % & * # ( ) 等非法字符!');window.close();</Script>"  Case "2"Response.Write "<Script Language=JavaScript>location.href='"&Err_Web&"'</Script>"  Case "3"Response.Write "<Script Language=JavaScript>alert('出错了!参数 "&name&"的值中包含非法字符串!/n/n请不要在表单中出现: % & * # ( )  等非法字符!');location.href='"&Err_Web&"';</Script>"End SelectResponse.EndEnd IfNEXTNEXTend if

%>

posted @ 2005-12-17 03:44  spring3  阅读(195)  评论(0编辑  收藏  举报