manage_backup.asp

学校网站管理系统采用ASP+ACCESS编写而成

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--#include file="conn.asp"-->
<link href="Inc/Tzstudent_Com.css" rel="stylesheet" type="text/css">
<!--#include file="Inc/popedom.asp"-->
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
  <tr> 
    <td align="center" valign="top">
	
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td height="25">
<div align="center"><strong>备份数据库</strong></div><%
if request("action")="Backup" then
call backupdata()
else
%></td>
        </tr>
        <tr> 
          <form method="post" action="Manage_backup.asp?action=Backup">
		    <td><br>
              <table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#DEDFDE">
                <tr bgcolor="#f7f7f7"> 
                  <td height="25" colspan="2"><div align="center"><strong>备份数据文件</strong>[需要FSO权限]</div></td>
                </tr>
                <tr> 
                  <td width="41%" height="22" bgcolor="#f7f7f7"> <div align="right">当前数据库路径</div></td>
                  <td width="59%" bgcolor="#FFFFFF"><input type=text size=50 name=DBpath value="<%=db%>"></td>
                </tr>
                <tr> 
                  <td height="10" colspan="2" bgcolor="#FFFFFF"></td>
                </tr>
                <tr> 
                  <td height="22" bgcolor="#f7f7f7"> <div align="right">备份数据库目录<br>
                  [如目录不存在，程序将自动创建]</div></td>
                  <td height="22" bgcolor="#FFFFFF"><input type=text size=50 name=bkfolder value=Databackup></td>
                </tr>
                <tr> 
                  <td height="10" colspan="2" bgcolor="#FFFFFF"></td>
                </tr>
                <tr> 
                  <td height="22" bgcolor="#f7f7f7"><div align="right">备份数据库名称<br>
  [如备份目录有该文件，将覆盖，如没有，将自动创建]</div></td>
                  <td height="22" bgcolor="#FFFFFF"><input type=text size=30 name=bkDBname value=Data.mdb></td>
                </tr>
                <tr> 
                  <td height="10" colspan="2" bgcolor="#FFFFFF"></td>
                </tr>
                <tr bgcolor="#f7f7f7"> 
                  <td height="22" colspan="2"><div align="center">
                      <input type=submit value="确定">
                    </div></td>
                </tr>
                <tr> 
                  <td height="22" colspan="2" bgcolor="#FFFFFF"><br>
                    <br>
                    本程序的默认数据库文件为<%=db%><br>
                    您可以用这个功能来备份您的法规数据，以保证您的数据安全！<br>
                    注意：所有路径都是相对与程序空间根目录的相对路径</td>
                </tr>
                <tr> 
                  <td height="22" colspan="2" bgcolor="#FFFFFF">&nbsp;</td>
                </tr>
              </table></td>
          </form>
        </tr>
      </table>
      <%end if%><% 
sub backupdata() 
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 
response.write "<br><br><br><br><br><br><br><br><br><br>"
response.write "备份数据库成功，您备份的数据库路径为" &bkfolder& "\"& bkdbname 
response.write "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>"
Else 
response.write "找不到您所需要备份的文件。" 
End if 
end sub 
'------------------检查某一目录是否存在------------------- 
Function CheckDir(FolderPath) 
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) 
Set fso1 = CreateObject("Scripting.FileSystemObject") 
Set f = fso1.CreateFolder(foldername) 
MakeNewsDir = True 
Set fso1 = nothing 
End Function 
%></td>
  </tr>
</table>
<script src="edit.js" type="text/javascript"></script>