admin_data.asp

本程序采用花香内核

<%Admin="SysMdb"%>
<!--#include file="check.asp"-->
<!--#include file="inc/config.asp"-->
<!--#include file="inc/inc.asp"-->
<!--#include file="mdb.asp"-->
<%
if session("adminlogin")<>sessionvar then
  response.Write "<script>alert('您超越范围！您的权限不足！');top.location.href='admin.asp';</script>"
response.end
end if
%>
<LINK href="inc/admin.css" type=text/css rel=stylesheet>
<%
select case request("action")
case "godata"
call godata()
case "backdata"
if request("act")="Backup" then
call updata()
else		
call backdata()
end if
case "redata"
if request("act")="data" then
dim Dbpath,backpath,fso
			Dbpath=request.form("Dbpath")
			backpath=request.form("backpath")
			if dbpath="" then
			response.write "请输入您要恢复成的数据库全名"	
			else
			Dbpath=server.mappath(Dbpath)
			end if
			backpath=server.mappath(backpath)
		
			Set Fso=server.createobject("scripting.filesystemobject")
			if fso.fileexists(dbpath) then  					
			fso.copyfile Dbpath,Backpath%>
<table width=98% align="center" border="1" cellspacing="0" cellpadding="3" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss><td align="center"  height=25>恭喜恭喜！</td></tr>
<tr height=50><td align="center">您的数据库已经成功恢复!请到首页进行调式！ </td></tr></table>
<%else%>
<table width=98% align="center" border="1" cellspacing="0" cellpadding="3" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss><td align="center"  height=25>错误提示！</td></tr>
<tr height=50><td align="center">备份目录下并无您的备份文件！ </td></tr></table>
<%end if
else
call redata()
end if
end select
%>
<%
'====================压缩数据库 =========================
sub godata()
%>
<table width=98% align="center" border="1" cellspacing="0" cellpadding="3" class=lanyubk style="border-collapse: collapse">
<form action="Admin_data.asp?action=godata" method="post">
<tr class=lanyuss>
<td height=25>&nbsp;※&nbsp;压缩数据库</td>
</tr>
<tr>
<td  height=30>&nbsp;数据库文件：<input type="text" name="dbpath" value="<%=mdb%>">&nbsp;
<input type="checkbox" name="boolIs97" value="True">如果使用 Access 97 数据库请选择
(默认为 Access 2000 数据库)
</td>
</tr>
<tr>
<td height=30 align=center>
<input type="submit" value="压 缩" class=put onmouseover="this.className='overput'" onmouseout="this.className='put'">
</td>
</tr>
<form>
</table>
<br>
<%
dim dbpath,boolIs97
dbpath = request("dbpath")
boolIs97 = request("boolIs97")

If dbpath <> "" Then
dbpath = server.mappath(dbpath)
	response.write(CompactDB(dbpath,boolIs97))
End If

end sub

'=====================压缩参数=========================
Function CompactDB(dbPath, boolIs97)
Dim fso, Engine, strDBPath,JET_3X
strDBPath = left(dbPath,instrrev(DBPath,"\"))
Set fso = CreateObject("Scripting.FileSystemObject")
If fso.FileExists(dbPath) Then
	fso.CopyFile dbpath,strDBPath & "temp.mdb"
	Set Engine = CreateObject("JRO.JetEngine")

	If boolIs97 = "True" Then
		Engine.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & "temp.mdb", _
		"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & "temp1.mdb;" _
		& "Jet OLEDB:Engine Type=" & JET_3X
	Else
		Engine.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & "temp.mdb", _
		"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & "temp1.mdb"
	End If

fso.CopyFile strDBPath & "temp1.mdb",dbpath
fso.DeleteFile(strDBPath & "temp.mdb")
fso.DeleteFile(strDBPath & "temp1.mdb")
Set fso = nothing
Set Engine = nothing%>
<table width=98% align="center" border="1" cellspacing="0" cellpadding="3" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss>
<td height=25 align=center>
<%
CompactDB = "你的数据库【" & dbpath & "】已经压缩成功!" & vbCrLf
%>
<%Else%>
数据库名称或路径不正确. 请重试! 
<%End If
End Function
%>
</td>
</tr>
</table>
<%sub backdata()%>
<table width=98% align="center" border="1" cellspacing="0" cellpadding="3" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss>
<td height=25>&nbsp;※&nbsp;备份数据库( 需要FSO支持，FSO相关帮助请看微软网站 )</td>
</tr>
<form method="post" action="Admin_data.asp?action=backdata&act=Backup">
<tr><td height=25>
&nbsp;当前数据库路径(相对路径)：<input type=text size=25 name=DBpath value="<%=mdb%>"></td></tr>
<tr><td height=25>
&nbsp;备份数据库目录(相对路径)：<input type=text size=25 name=bkfolder value="backdata">
&nbsp;如目录不存在，程序将自动创建</td></tr>
<tr><td height=25>
&nbsp;备份数据库名称(填写名称)：<input type=text size=25 name=bkDBname value=hx66.mdb>
&nbsp;如备份目录有该文件，将覆盖，如没有，将自动创建</td></tr>
<tr><td height=30 align=center>
&nbsp;<input type=submit value="备 份" class=put onmouseover="this.className='overput'" onmouseout="this.className='put'"></td></tr></form></table>
<%end sub
sub updata()
        dim Dbpath,bkfolder,bkdbname,fso
		Dbpath=request.form("Dbpath")
		Dbpath=server.mappath(Dbpath)
		bkfolder=request.form("bkfolder")
		bkdbname=request.form("bkdbname")
		Set Fso=server.createobject("scripting.filesystemobject")
		if fso.fileexists(dbpath) then
			If CheckDir(bkfolder) = True Then
			fso.copyfile dbpath,bkfolder& "\"& bkdbname
			else
			MakeNewsDir bkfolder
			fso.copyfile dbpath,bkfolder& "\"& bkdbname
			end if%>
<table width=98% align="center" border="1" cellspacing="0" cellpadding="3" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss><td align="center" height=25>恭喜恭喜！</td></tr>
<tr height=50><td align="center"> 
备份数据库成功，您备份的数据库路径为<%=bkfolder%>\<%=bkdbname%>
</td></tr></table>
<%Else%>
<table width=98% align="center" border="1" cellspacing="0" cellpadding="3" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss><td align="center"  height=30>错误提示！</td></tr>
<tr height=100><td align="center"> 
找不到您所需要备份的文件! 
</td></tr></table>
<%End if
end sub
'------------------检查某一目录是否存在-------------------
Function CheckDir(FolderPath)
    dim fso1
	folderpath=Server.MapPath(".")&"\"&folderpath
    Set fso1 = CreateObject("Scripting.FileSystemObject")
    If fso1.FolderExists(FolderPath) then
       '存在
       CheckDir = True
    Else
       '不存在
       CheckDir = False
    End if
    Set fso1 = nothing
End Function
'-------------根据指定名称生成目录-----------------------
Function MakeNewsDir(foldername)
	dim f,fso1
    Set fso1 = CreateObject("Scripting.FileSystemObject")
        Set f = fso1.CreateFolder(foldername)
        MakeNewsDir = True
    Set fso1 = nothing
End Function
%>
<%
'====================恢复数据库=========================
sub redata()
%>
<table width=98% align="center" border="1" cellspacing="0" cellpadding="3" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss>
<td height=25>&nbsp;※&nbsp;恢复数据库( 需要FSO支持，FSO相关帮助请看微软网站 )
</td></tr>
<form method="post" action="ADMIN_data.asp?action=redata&act=data">
<tr><td height=25>
&nbsp;备份数据库路径(相对)：<input type=text size=40 name=DBpath value="backdata/hx66.mdb" ></td></tr>
<tr><td height=25>
&nbsp;目标数据库路径(相对)：<input type=text size=40 name=backpath value="<%=mdb%>"></td></tr>
<tr><td height=30 align=center>
&nbsp;<input type=submit value="恢 复" class=put onmouseover="this.className='overput'" onmouseout="this.className='put'">
</td></tr></form></table>
<%end sub%>