这段代码 中间连接数据库，其他的不是很清楚，有谁讲解一下吗？

[win7cc]

<%
'On Error Resume Next
dim ServerPath
ServerPath = Request.ServerVariables("URL")
ServerPath = Split(LCase(ServerPath),"/manage/")(0)
ServerPath = "/"

dim DbPath,Pwd,conn
DbPath = SERVER.MapPath(ServerPath&"Data/Data.mdb")
Set conn= Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& DbPath
'response.Write dbpath
Call GetSiteInfo()

if Err then
Err.Clear
'response.Write("<meta http-equiv='Content-Type' content='text/html; charset=gb2312'>")
PMsg="数据库连接错误！请检查连接字串！"
'Call PopMsg("连接数据库")
end if

Sub CloseConn()
conn.close()
set conn=nothing
end sub

if request("repl")<>"off" then
Call ChkData()
end if

sub ChkData()
'--------定义部份------------------
Dim XH_Post,XH_Get,XH_In,XH_Inf,XH_Xh,XH_db,XH_dbstr
'自定义需要过滤的字串,用 "|" 分隔
XH_In = "'|;|exec|insert|select|delete%20from|update|count|*|%|chr|mid|master|truncate|char|declare|drop%20table|from|net%20user|xp_cmdshell|/add|net%20localgroup%20administrators|Asc|char"
'----------------------------------
XH_Inf = split(XH_In,"|")
'--------POST部份------------------
if Request.Form<>"" Then
For Each XH_Post In Request.Form
For XH_Xh=0 To Ubound(XH_Inf)
if Instr(LCase(Request.Form(XH_Post)),XH_Inf(XH_Xh))<>0 Then
PMsg = "处理数据时发生错误！<br />数据类型不匹配！"
Call PopMsg("数据类型")
End if
Next
Next
End if
'----------------------------------

'--------GET部份-------------------
if Request.QueryString<>"" Then
For Each XH_Get In Request.QueryString
For XH_Xh=0 To Ubound(XH_Inf)
if Instr(LCase(Request.QueryString(XH_Get)),XH_Inf(XH_Xh))<>0 Then
PMsg = "处理数据时发生错误！<br />数据类型不匹配！"
Call PopMsg("数据类型")
End if
Next
Next
End if
'----------------------------------
end sub%>


这段代码 中间连接数据库，其他的不是很清楚，有谁讲解一下吗？

[ChinaXtHuLang]

关闭数据库链接

Sub CloseConn()
conn.close()
set conn=nothing
end sub

防止攻击注入

if request("repl")<>"off" then
Call ChkData()
end if

sub ChkData()
'--------定义部份------------------
Dim XH_Post,XH_Get,XH_In,XH_Inf,XH_Xh,XH_db,XH_dbstr
'自定义需要过滤的字串,用 "|" 分隔
XH_In = "'|;|exec|insert|select|delete%20from|update|count|*|%|chr|mid|master|truncate|char|declare|drop%20table|from|net%20user|xp_cmdshell|/add|net%20localgroup%20administrators|Asc|char"
'----------------------------------
XH_Inf = split(XH_In,"|")
'--------POST部份------------------
if Request.Form<>"" Then
For Each XH_Post In Request.Form
For XH_Xh=0 To Ubound(XH_Inf)
if Instr(LCase(Request.Form(XH_Post)),XH_Inf(XH_Xh))<>0 Then
PMsg = "处理数据时发生错误！<br />数据类型不匹配！"
Call PopMsg("数据类型")
End if
Next
Next
End if
'----------------------------------

'--------GET部份-------------------
if Request.QueryString<>"" Then
For Each XH_Get In Request.QueryString
For XH_Xh=0 To Ubound(XH_Inf)
if Instr(LCase(Request.QueryString(XH_Get)),XH_Inf(XH_Xh))<>0 Then
PMsg = "处理数据时发生错误！<br />数据类型不匹配！"
Call PopMsg("数据类型")
End if
Next
Next
End if
'----------------------------------
end sub

[zj_JavaBean]

好像是为了安全过滤一些SQL关键字 防注入吧
'--------POST部份------------------
if Request.Form<>"" Then
For Each XH_Post In Request.Form
For XH_Xh=0 To Ubound(XH_Inf)
if Instr(LCase(Request.Form(XH_Post)),XH_Inf(XH_Xh))<>0 Then
PMsg = "处理数据时发生错误！<br />数据类型不匹配！"
Call PopMsg("数据类型")
End if
Next
Next
End if
'----------------------------------

'--------GET部份-------------------
if Request.QueryString<>"" Then
For Each XH_Get In Request.QueryString
For XH_Xh=0 To Ubound(XH_Inf)
if Instr(LCase(Request.QueryString(XH_Get)),XH_Inf(XH_Xh))<>0 Then
PMsg = "处理数据时发生错误！<br />数据类型不匹配！"
Call PopMsg("数据类型")
End if
Next
Next
End if
'----------------------------------
end sub%>

两种传值的处理