找回密码
 立即注册
搜索
查看: 1300|回复: 1

万能的海浩阿,懂asp的进来看看吧

[复制链接]

102

主题

481

回帖

788

积分

高级会员

积分
788
发表于 2012-8-6 15:15:40 | 显示全部楼层 |阅读模式
网站的一些栏目点击以后,突然弹出这个页面,但是只要把ie的cookie都删掉了就好了,请问是怎么回事阿,应该如何修改

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有账号?立即注册

×

102

主题

481

回帖

788

积分

高级会员

积分
788
 楼主| 发表于 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,"<","&lt;", 1, -1, 1)
Str = Replace(Str,">","&gt;", 1, -1, 1)  
Str = Replace(Str, "script", "&#115;cript", 1, -1, 0)
Str = Replace(Str, "SCRIPT", "&#083;CRIPT", 1, -1, 0)
Str = Replace(Str, "Script", "&#083;cript", 1, -1, 0)
Str = Replace(Str, "script", "&#083;cript", 1, -1, 1)
Str = Replace(Str, "object", "&#111;bject", 1, -1, 0)
Str = Replace(Str, "OBJECT", "&#079;BJECT", 1, -1, 0)
Str = Replace(Str, "Object", "&#079;bject", 1, -1, 0)
Str = Replace(Str, "object", "&#079;bject", 1, -1, 1)
Str = Replace(Str, "applet", "&#097;pplet", 1, -1, 0)
Str = Replace(Str, "APPLET", "&#065;PPLET", 1, -1, 0)
Str = Replace(Str, "Applet", "&#065;pplet", 1, -1, 0)
Str = Replace(Str, "applet", "&#065;pplet", 1, -1, 1)
Str = Replace(Str, "[", "&#091;")
Str = Replace(Str, "]", "&#093;")
Str = Replace(Str, """", "", 1, -1, 1)
Str = Replace(Str, "=", "&#061;", 1, -1, 1)
Str = Replace(Str, "’", "’’", 1, -1, 1)
Str = Replace(Str, "select", "sel&#101;ct", 1, -1, 1)
Str = Replace(Str, "execute", "&#101xecute", 1, -1, 1)
Str = Replace(Str, "exec", "&#101xec", 1, -1, 1)
Str = Replace(Str, "join", "jo&#105;n", 1, -1, 1)
Str = Replace(Str, "union", "un&#105;on", 1, -1, 1)
Str = Replace(Str, "where", "wh&#101;re", 1, -1, 1)
Str = Replace(Str, "insert", "ins&#101;rt", 1, -1, 1)
Str = Replace(Str, "delete", "del&#101;te", 1, -1, 1)
Str = Replace(Str, "update", "up&#100;ate", 1, -1, 1)
Str = Replace(Str, "like", "lik&#101;", 1, -1, 1)
Str = Replace(Str, "drop", "dro&#112;", 1, -1, 1)
Str = Replace(Str, "create", "cr&#101;ate", 1, -1, 1)
Str = Replace(Str, "rename", "ren&#097;me", 1, -1, 1)
Str = Replace(Str, "count", "co&#117;nt", 1, -1, 1)
Str = Replace(Str, "chr", "c&#104;r", 1, -1, 1)
Str = Replace(Str, "mid", "m&#105;d", 1, -1, 1)
Str = Replace(Str, "truncate", "trunc&#097;te", 1, -1, 1)
Str = Replace(Str, "nchar", "nch&#097;r", 1, -1, 1)
Str = Replace(Str, "char", "ch&#097;r", 1, -1, 1)
Str = Replace(Str, "alter", "alt&#101;r", 1, -1, 1)
Str = Replace(Str, "cast", "ca&#115;t", 1, -1, 1)
Str = Replace(Str, "exists", "e&#120;ists", 1, -1, 1)
Str = Replace(Str,Chr(13),"<br>", 1, -1, 1)
CheckSql = Replace(Str,"’","’’", 1, -1, 1)
End Function
----------
不知道如何修改?
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

Archiver|手机版|小黑屋|海浩社区

GMT+8, 2025-9-20 05:46 , Processed in 0.085154 second(s), 21 queries .

Powered by Discuz! X3.5

© 2001-2025 Discuz! Team.

快速回复 返回顶部 返回列表