📄 man_data3.asp
字号:
<!--#INCLUDE FILE="config.asp" -->
<%
Response.Expires=0
Response.ExpiresAbsolute = Now() - 1
Response.AddHeader "Pragma","No-Cache"
Response.AddHeader "Cache-Control","Private"
Response.CacheControl = "No-Cache"
if not IsArray(Session("info")) then Response.Redirect "err.asp?kind=20"
info=Session("info")
if InStr(Application("maninfo"),"," & info(0) & ",")<>0 then Response.Redirect "manyou.asp"
if zzbird_master<>info(0) then Response.Redirect "err1.asp?kind=13"
Const Jet_Conn_Partial = "Provider=Microsoft.Jet.OLEDB.4.0; Data source="
Dim strDatabase, strFolder, strFileName
strFolder = Server.MapPath("temp_database.mdb")
strFolder = Replace(strFolder,"temp_database.mdb","")
strDatabase = "temp_database.mdb"
Private Sub dbCompact(strDBFileName)
Dim SourceConn
Dim DestConn
Dim oJetEngine
Dim oFSO
SourceConn = Jet_Conn_Partial & strFolder & strDatabase
DestConn = Jet_Conn_Partial & strFolder & "Temp" & strDatabase
Set oFSO = Server.CreateObject("Scripting.FileSystemObject")
Set oJetEngine = Server.CreateObject("JRO.JetEngine")
With oFSO
If Not .FileExists(strFolder & strDatabase) Then
Response.Write ("Not Found: " & strFolder & strDatabase)
Stop
Else
If .FileExists(strFolder & "Temp" & strDatabase) Then
Response.Write ("发生错误...... " _
& "删除原数据库...... 尝试重新操作......")
.DeleteFile (strFolder & "Temp" & strDatabase)
End If
End If
End With
With oJetEngine
.CompactDatabase SourceConn, DestConn
End With
oFSO.DeleteFile strFolder & strDatabase
oFSO.MoveFile strFolder & "Temp" _
& strDatabase, strFolder& strDatabase
Set oFSO = Nothing
Set oJetEngine = Nothing
End Sub
Select Case Request.Form("cmd")
Case "下一步"
dbCompact Request.Form("DBFileName")
Response.Redirect "man_data4.asp"
End Select
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>压缩数据</title>
<style>
<!--
fieldset { font-size: 10pt }
-->
</style>
</head>
<body bgcolor="buttonface" style="border: 3px double buttonface">
<form method="POST" name="man" action="">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="46%" id="AutoNumber1" height="62">
<tr>
<td width="100%" height="150">
<fieldset style="padding: 2; width:281; height:142">
<legend><img border="0" src="images/data.gif">压缩数据</legend>
<p align="center">第三步<p align="center">正在压缩......<p align="center">
请等待......</fieldset>
</td>
</tr>
<tr>
<td width="100%" align="right"><input type="hidden" value="temp_database.mdb" name="DBFileName"><input type="button" value="上一步" name="a1" disabled><input type="submit" value="下一步" name="cmd">
<input type="button" value="完成" name="a3" disabled><input type="button" value="取消" name="a4" disabled></td>
</tr>
</table>
</form>
<script>
document.man.cmd.click();
</script>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -