conn.asp

学校网站管理系统

<%
response.buffer=true
starttime=timer()
Const Version="2006"
Const Edition="商业版"
Const ConnType="0"   '设置数据库类型
'==============ACCESS数据库连接设置==============
Const ACCESSPATH="data/web300.mdb"              '数据库路径
Const BACKACCESSPATH="backdata/web300.mdb"    '数据库备份路径
'以下先不用设置
'==============SQL数据库连接设置=================
Const SqlDatabaseName = "dxy"		'数据库名	
Const SqlUsername = "sa"		'用户名
Const SqlPassword = "123456"		'用户密码
Const SqlSource = "(local)"		'数据地址（本地用local，远程用IP）
'■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■
if ConnType=0 then
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(ACCESSPATH)
elseif ConnType=1 then
connstr="Provider=Sqloledb;UserID="&SqlUsername&";Password="&SqlPassword&";InitialCatalog="&SqlDatabaseName&";Data Source="&SqlSource&";"
else
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(ACCESSPATH)
end if
'on error resume next
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open connstr

If Err Then
err.Clear
Set Conn=Nothing
response.Redirect"error.asp?action=error&text=本站提示您：数据库连接出错，请检查连接字串!" 
response.End
End If
'■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■
sub pass()
'网站是否打开
if web=1 then
response.Redirect"error.asp?action=stop&text="&webwords&"" 
response.End
end if
'IP地址限制访问
request_ip=request.servervariables("remote_addr")
re_ip=split(replace_ip,"|")
for i=0 to ubound(re_ip)
if right(re_ip(i),1)="*" then
if left(re_ip(i),6)=left(request_ip,6) then
response.Redirect"error.asp?action=stop&text=对不起，您的IP已封锁!" 
response.End
end if
elseif re_ip(i)=request_ip then
response.Redirect"error.asp?action=stop&text=对不起，您的IP已封锁!"
response.End
end if
next
end sub
sub yecaosql()
'定义部份
Dim Fy_Post,Fy_Get,Fy_In,Fy_Inf,Fy_Xh,Fy_db,Fy_dbstr,Kill_IP,WriteSql
'自定义需要过滤的字串,用 "|" 分隔
Fy_In = "'|;|and|(|)|exec|insert|select|delete|update|count|*|%|chr|mid|master|truncate|char|declare"
Kill_IP=True
WriteSql=True			
Fy_Inf = split(Fy_In,"|")
'POST部份
If Request.Form<>"" Then
For Each Fy_Post In Request.Form
For Fy_Xh=0 To Ubound(Fy_Inf)
If Instr(LCase(Request.Form(Fy_Post)),Fy_Inf(Fy_Xh))<>0 Then
If WriteSql=True Then
conn.Execute("insert into SqlIn(Sqlin_IP,SqlIn_Web,SqlIn_FS,SqlIn_CS,SqlIn_SJ) values('"&Request.ServerVariables("REMOTE_ADDR")&"','"&Request.ServerVariables("URL")&"','POST','"&Fy_Post&"','"&replace(Request.Form(Fy_Post),"'","''")&"')")
conn.close
Set conn=Nothing
End If
Response.Write "<Script>alert('请不要在参数中包含非法字符尝试注入！');</Script>"
response.Redirect"error.asp?action=stop&text=苦命的孩子！你永远也进不了我的站点了！"
response.End
End If
Next
Next
End If
'GET部份
If Request.QueryString<>"" Then
For Each Fy_Get In Request.QueryString
For Fy_Xh=0 To Ubound(Fy_Inf)
If Instr(LCase(Request.QueryString(Fy_Get)),Fy_Inf(Fy_Xh))<>0 Then
If WriteSql=True Then
conn.Execute("insert into YC_sql(Sqlin_IP,SqlIn_Web,SqlIn_FS,SqlIn_CS,SqlIn_SJ) values('"&Request.ServerVariables("REMOTE_ADDR")&"','"&Request.ServerVariables("URL")&"','GET','"&Fy_Get&"','"&replace(Request.QueryString(Fy_Get),"'","''")&"')")
conn.close
Set conn=Nothing
End If
Response.Write "<Script>alert('请不要在参数中包含非法字符尝试注入！');</Script>"
response.Redirect"error.asp?action=stop&text=苦命的孩子！你永远也进不了我的站点了！"
response.End
End If
Next
Next
End If

If Kill_IP=True Then
Dim Sqlin_IP,rsKill_IP,sql
Sqlin_IP=Request.ServerVariables("REMOTE_ADDR")
Sql="select Sqlin_IP from [YC_sql] where Sqlin_IP='"&Sqlin_IP&"'"
Set rsKill_IP=conn.execute(sql)
If Not(rsKill_IP.eof or rsKill_IP.bof) Then
response.Redirect"error.asp?action=stop&text=对不起，您的IP已被系统自动封锁!请联系管理员!"
response.End
End If
rsKill_IP.close
End If
end sub
sub closedata()
conn.close
set conn=nothing
end sub
Function Encode(content)
dim tmp
tmp=content
tmp=replace(tmp,"<","&lt;")
tmp=replace(tmp,">","&gt")
tmp=replace(tmp,"'","")
tmp=replace(tmp,"char(34)","")
Encode=tmp
End Function
%>