在线播放一区二区精品视频,日韩精品在线观看一区二区,国产一区二三区

主頁(yè) > 知識(shí)庫(kù) > 純編碼實(shí)現(xiàn)Access數(shù)據(jù)庫(kù)的建立或壓縮

純編碼實(shí)現(xiàn)Access數(shù)據(jù)庫(kù)的建立或壓縮

<% '#######以下是一個(gè)類文件，下面的注解是調(diào)用類的方法################################################ '# 注意：如果系統(tǒng)不支持建立Scripting.FileSystemObject對(duì)象，那么數(shù)據(jù)庫(kù)壓縮功能將無(wú)法使用 '# Access 數(shù)據(jù)庫(kù)類 '# CreateDbFile 建立一個(gè)Access 數(shù)據(jù)庫(kù)文件 '# CompactDatabase 壓縮一個(gè)Access 數(shù)據(jù)庫(kù)文件 '# 建立對(duì)象方法: '# Set a = New DatabaseTools '# by (蕭寒雪) s.f. '######################################################################################### Class DatabaseTools Public function CreateDBfile(byVal dbFileName,byVal DbVer,byVal SavePath) '建立數(shù)據(jù)庫(kù)文件 'If DbVer is 0 Then Create Access97 dbFile 'If DbVer is 1 Then Create Access2000 dbFile On error resume Next If Right(SavePath,1)<>"\" Or Right(SavePath,1)<>"/" Then SavePath = Trim(SavePath)  "\" If Left(dbFileName,1)="\" Or Left(dbFileName,1)="/" Then dbFileName = Trim(Mid(dbFileName,2,Len(dbFileName))) If DbExists(SavePath  dbFileName) Then Response.Write ("對(duì)不起，該數(shù)據(jù)庫(kù)已經(jīng)存在!") CreateDBfile = False Else Dim Ca Set Ca = Server.CreateObject("ADOX.Catalog") If Err.number<>0 Then Response.Write ("無(wú)法建立，請(qǐng)檢查錯(cuò)誤信息 "  Err.number  " "  Err.Description) Err.Clear Exit function End If If DbVer=0 Then call Ca.Create("Provider=Microsoft.Jet.OLEDB.3.51;Data Source="  SavePath  dbFileName) Else call Ca.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="  SavePath  dbFileName) End If Set Ca = Nothing CreateDBfile = True End If End function Public function CompactDatabase(byVal dbFileName,byVal DbVer,byVal SavePath) '壓縮數(shù)據(jù)庫(kù)文件 '0 為access 97 '1 為access 2000 On Error resume next If Right(SavePath,1)<>"\" Or Right(SavePath,1)<>"/" Then SavePath = Trim(SavePath)  "\" If Left(dbFileName,1)="\" Or Left(dbFileName,1)="/" Then dbFileName = Trim(Mid(dbFileName,2,Len(dbFileName))) If DbExists(SavePath  dbFileName) Then Response.Write ("對(duì)不起，該數(shù)據(jù)庫(kù)已經(jīng)存在!") CompactDatabase = False Else Dim Cd Set Cd =Server.CreateObject("JRO.JetEngine") If Err.number<>0 Then Response.Write ("無(wú)法壓縮，請(qǐng)檢查錯(cuò)誤信息 "  Err.number  " "  Err.Description) Err.Clear Exit function End If If DbVer=0 Then call Cd.CompactDatabase("Provider=Microsoft.Jet.OLEDB.3.51;Data Source="  SavePath  dbFileName,"Provider=Microsoft.Jet.OLEDB.3.51;Data Source="  SavePath  dbFileName  ".bak.mdb;Jet OLEDB;Encrypt Database=True") Else call Cd.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="  SavePath  dbFileName,"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="  SavePath  dbFileName  ".bak.mdb;Jet OLEDB;Encrypt Database=True") End If '刪除舊的數(shù)據(jù)庫(kù)文件 call DeleteFile(SavePath  dbFileName) '將壓縮后的數(shù)據(jù)庫(kù)文件還原 call RenameFile(SavePath  dbFileName  ".bak.mdb",SavePath  dbFileName) Set Cd = False CompactDatabase = True End If end function Public function DbExists(byVal dbPath) '查找數(shù)據(jù)庫(kù)文件是否存在 On Error resume Next Dim c Set c = Server.CreateObject("ADODB.Connection") c.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="  dbPath If Err.number<>0 Then Err.Clear DbExists = false else DbExists = True End If set c = nothing End function Public function AppPath() '取當(dāng)前真實(shí)路徑 AppPath = Server.MapPath("./") End function Public function AppName() '取當(dāng)前程序名稱 AppName = Mid(Request.ServerVariables("SCRIPT_NAME"),(InStrRev(Request.ServerVariables("SCRIPT_NAME") ,"/",-1,1))+1,Len(Request.ServerVariables("SCRIPT_NAME"))) End Function Public function DeleteFile(filespec) '刪除一個(gè)文件 Dim fso Set fso = CreateObject("Scripting.FileSystemObject") If Err.number<>0 Then Response.Write("刪除文件發(fā)生錯(cuò)誤!請(qǐng)查看錯(cuò)誤信息 "  Err.number  " "  Err.Description) Err.Clear DeleteFile = False End If call fso.DeleteFile(filespec) Set fso = Nothing DeleteFile = True End function Public function RenameFile(filespec1,filespec2) '修改一個(gè)文件 Dim fso Set fso = CreateObject("Scripting.FileSystemObject") If Err.number<>0 Then Response.Write("修改文件名時(shí)發(fā)生錯(cuò)誤!請(qǐng)查看錯(cuò)誤信息 "  Err.number  " "  Err.Description) Err.Clear RenameFile = False End If call fso.CopyFile(filespec1,filespec2,True) call fso.DeleteFile(filespec1) Set fso = Nothing RenameFile = True End function End Class %>

[Ctrl+A 全選注:引入外部Js需再刷新一下頁(yè)面才能執(zhí)行]

標(biāo)簽：麗江成都公主嶺內(nèi)江臺(tái)灣重慶懷化天津

巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《純編碼實(shí)現(xiàn)Access數(shù)據(jù)庫(kù)的建立或壓縮》，本文關(guān)鍵詞純,編碼,實(shí)現(xiàn),Access,數(shù)據(jù)庫(kù),；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。