conn.asp

) 25175学校通用网络办公系统 2) 25175新闻系统 3) 25175网站搜索引擎 4) 25175公司量化考核系统 5) 25175学校成绩管理系统 6) 25

<!--#include file="config.asp"-->
<%
Dim powerid
Dim DataPath,domain
Dim Comeurl
DataPath=webPath&"data/#123zh.mdb"			'相对根目录下绝对路径

dim conn,connstr
Dim rs,id,sql
Dim totalput,pagedw,CurrentPage
domain=Request.ServerVariables("server_name")
connstr="DBQ="+server.MapPath(DataPath)+";DRIVER={Microsoft Access Driver (*.mdb)};"
On Error Resume Next 
set conn=server.createobject("adodb.connection")
conn.open connstr

If Err Then
	ScriptAddress = CStr(Request.ServerVariables("SCRIPT_NAME"))		'虚拟目录+文件
	inpath=Split(ScriptAddress,"/")
	ScriptAddress=Replace(ScriptAddress,inpath(UBound(inpath)),"")
	'文件内容开始
	contentstr="<" & "%" & vbCrLf
	contentstr=contentstr & "Dim webPath" & vbCrLf
	contentstr=contentstr & "webPath=""" & ScriptAddress & """" & vbCrLf
	contentstr=contentstr & "%" & ">" & vbCrLf
	'文件内容结束
		filepath=server.mappath("config.asp")
		set obj_fso=server.createobject("scripting.filesystemobject")
		if obj_fso.fileexists(filepath) then
			set obj_file=obj_fso.opentextfile(filepath,2,false)
			obj_file.write contentstr
			obj_file.close
			set obj_file=Nothing
			response.write "sdf"
		Else
			obj_file.close
			filepath=server.mappath("../config.asp")
			set obj_fso=server.createobject("scripting.filesystemobject")
			if obj_fso.fileexists(filepath) then
				set obj_file=obj_fso.opentextfile(filepath,2,false)
				obj_file.write Replace(contentstr,ScriptAddress,Replace(ScriptAddress,"admin/",""))
				obj_file.close
				set obj_file=Nothing
				'Response.Redirect "../index.asp"
				response.write "<SCRIPT LANGUAGE=""JavaScript"">window.location.reload();</SCRIPT>"
			else
			response.write "数据库路径错误,请自行修改根目录下conn.asp文件!"
			End If 
		end if
End If


Function che(Str) 
If Isnull(Str) Then 
	che = "" 
	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, "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", "execute", 1, -1, 1) 
Str = Replace(Str, "exec", "exec", 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) 
che = Replace(Str,"’","’’", 1, -1, 1) 
End Function

Dim sexs(2)
sexs(0)="&nbsp;"
sexs(1)="男"
sexs(2)="女"
%>