海浩网论坛

标题: 万能的海浩阿,懂asp的进来看看吧 [打印本页]

作者: infoyy 时间: 2012-8-6 15:15:40 标题: 万能的海浩阿,懂asp的进来看看吧

网站的一些栏目点击以后,突然弹出这个页面,但是只要把ie的cookie都删掉了就好了,请问是怎么回事阿,应该如何修改
[attach]647823[/attach]

作者: infoyy 时间: 2012-8-7 11:12:17

conn.asp

Dim Conn,ConnStr
On error resume next
Set Conn=Server.CreateObject("Adodb.Connection")
'--------------------------------------------
If DbType = 1 Then
'--------------------------------------------
ConnStr="Provider=Sqloledb;User ID="&DBUser&";Password="&DBPsw&";Initial Catalog="&DBName&";Data Source="&DBServer&";"
'--------------------------------------------
ElseIf DbType = 0 Then
'--------------------------------------------
ConnStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(DBPath)
'--------------------------------------------
End If
'--------------------------------------------
Conn.open ConnStr
if err then
err.clear
Set Conn = Nothing
Response.Write "系统错误：数据库连接出错，请检查连接字符串!"
Response.End
end if
Sub CloseConn()
On Error Resume Next
Rs.Close:Set Rs=nothing
Conn.close:Set Conn=nothing
End sub
'================================================
'ACCESS与SQL SERVER的SQL语句区别判断
'================================================
Dim ItemRecT,ItemRecF
If DbType = 1 Then
'--------------------------------------------
ItemRecT = "ItemRec = 1"
ItemRecF = "ItemRec = 0"
'--------------------------------------------
ElseIf DbType = 0 Then
'--------------------------------------------
ItemRecT = "ItemRec = True"
ItemRecF = "ItemRec = False"
'--------------------------------------------
End If
'================================================
'函名：CheckSql
'作用：防止SQl注入
'================================================
Function CheckSql(Str)
If Str = "" Then
  CheckSql = ""
  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", "&#101xecute", 1, -1, 1)
Str = Replace(Str, "exec", "&#101xec", 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)
CheckSql = Replace(Str,"’","’’", 1, -1, 1)
End Function
----------
不知道如何修改?

欢迎光临海浩网论坛 (http://bbs.highot.net/)