手机
当前位置:查字典教程网 >编程开发 >ASP教程 >ASP防止SQL注入方法
ASP防止SQL注入方法
摘要:通用防SQL注入代码ASP版代码dimsql_injdataSQL_injdata="'|and|exec|insert|select|de...

通用防SQL注入代码ASP版

代码

dim sql_injdata

SQL_injdata = "'|and|exec|insert|select|delete|update|count|*|%|chr|mid|master|truncate|char|declare"

SQL_inj = split(SQL_Injdata,"|")

If Request.QueryString<>"" Then

For Each SQL_Get In Request.QueryString

For SQL_Data=0 To Ubound(SQL_inj)

if instr(Request.QueryString(SQL_Get),Sql_Inj(Sql_DATA))>0 Then

'Response.Write(Request.QueryString)

Response.Write ""

Response.end

end if

next

Next

End If

If Request.Form<>"" Then '

For Each Sql_Post In Request.Form

For SQL_Data=0 To Ubound(SQL_inj)

if instr(Request.Form(Sql_Post),Sql_Inj(Sql_DATA))>0 Then

'Response.Write(Request.Form)

Response.Write ""

Response.end

end if

next

Next

End If

sss=LCase(request.servervariables("QUERY_STRING"))

if instr(sss,"select")<>0 or instr(sss,"inster")<>0 or instr(sss,"delete")<>0 or instr(sss,"(")<>0 or instr(sss,"'or")<>0 then

response.write "

你的网址不合法"

response.end

end if

StrTemp=request.servervariables("server_name")&request.servervariables("url")&"?"&Request.QueryString

StrTemp = LCase(StrTemp)

If Instr(StrTemp,"select%20") or Instr(StrTemp,"insert%20") or Instr(StrTemp,"delete%20from") or Instr(StrTemp,"count(") or Instr(StrTemp,"drop%20table") or Instr(StrTemp,"update%20") or Instr(StrTemp,"truncate%20") or Instr(StrTemp,"asc(") or Instr(StrTemp,"mid(") or Instr(StrTemp,"char(") or Instr(StrTemp,"xp_cmdshell") or Instr(StrTemp,"exec%20master") or Instr(StrTemp,"net%20localgroup%20administrators") or Instr(StrTemp,"net%20user") or Instr(StrTemp,"%20or%20") or Instr(StrTemp,"'") or Instr(StrTemp,"%20") or Instr(StrTemp,"""") or Instr(StrTemp,"“") or Instr(StrTemp,"”") or Instr(StrTemp,":") or Instr(StrTemp,":") or Instr(StrTemp,";") or Instr(StrTemp,";") or Instr(StrTemp,",") or Instr(StrTemp,",") or Instr(StrTemp,"%27") then

Response.Write ""

Response.end

End If

【ASP防止SQL注入方法】相关文章:

ASP中FSO的神奇功能 - 写文件

ASP获取地址栏URL地址方法

ASP类的写法

图片的入库与读取的方法

解决ASP(图像)上传漏洞的方法

ASP常用函数:IIF()

ASP面向对象编程探讨及比较

ASP代码实现301重定向及带参数的方法

ASP整合一个SQL语句类

ASP代码给网页添加验证码的实现方法

精品推荐
分类导航