乡下人产国偷v产偷v自拍,国产午夜片在线观看,婷婷成人亚洲综合国产麻豆,久久综合给合久久狠狠狠9

  • <output id="e9wm2"></output>
    <s id="e9wm2"><nobr id="e9wm2"><ins id="e9wm2"></ins></nobr></s>

    • 分享

      將數(shù)據(jù)庫中的信息存儲至xml文件中

       duduwolf 2005-08-04

      save.asp

       <!-- #include file="adovbs.inc" -->
      <%
      ‘ Constants file included above.

      ‘ 如果文件存在則刪除
      Dim objFSO
      Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
      If objFSO.FileExists(Server.MapPath("db_xml.xml")) Then
       objFSO.DeleteFile Server.MapPath("db_xml.xml")
      End IF
      Set objFSO = Nothing

      ‘變量聲明
      Dim cnnXML  ‘ ADO connection
      Dim rstXML  ‘ ADO recordset

      ‘創(chuàng)建數(shù)據(jù)連接對象
      Set cnnXML = Server.CreateObject("ADODB.Connection")

      ‘ 這是連接access數(shù)據(jù)庫的例子:
      ‘cnnXML.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _
      ‘ & Server.MapPath("db_scratch.mdb") & ";"

      ‘ 下面以Sqlserver為例子講解:
      cnnXML.Open "Provider=SQLOLEDB;Data Source=10.2.1.214;" _
       & "Initial Catalog=samples;User Id=samples;Password=password;" _
       & "Connect Timeout=15;Network Library=dbmssocn;"


      Set rstXML = Server.CreateObject("ADODB.Recordset")
      Set rstXML = cnnXML.Execute("SELECT * FROM scratch ORDER BY id;")

      Response.Write "<p>Saving data as XML...</p>" & vbCrLf

      ‘ 保存至xml格式.
      rstXML.Save Server.MapPath("db_xml.xml"), adPersistXML

      ‘ 關(guān)閉對象、釋放資源
      rstXML.Close
      Set rstXML = Nothing
      cnnXML.Close
      Set cnnXML = Nothing

      Response.Write "<p>XML file written...</p>" & vbCrLf
      Response.Write "<p>Click <a href=""db_xml.xml"">here</a> to view the file.</p>" & vbCrLf
      %>

      附:adovbs.inc

       <%
      ‘--------------------------------------------------------------------
      ‘ Microsoft ADO

      ‘ (c) 1996-1998 Microsoft Corporation.  All Rights Reserved.



      ‘ ADO constants include file for VBScript

      ‘--------------------------------------------------------------------

      ‘---- CursorTypeEnum Values ----
      Const adOpenForwardOnly = 0
      Const adOpenKeyset = 1
      Const adOpenDynamic = 2
      Const adOpenStatic = 3

      ‘---- CursorOptionEnum Values ----
      Const adHoldRecords = &H00000100
      Const adMovePrevious = &H00000200
      Const adAddNew = &H01000400
      Const adDelete = &H01000800
      Const adUpdate = &H01008000
      Const adBookmark = &H00002000
      Const adApproxPosition = &H00004000
      Const adUpdateBatch = &H00010000
      Const adResync = &H00020000
      Const adNotify = &H00040000
      Const adFind = &H00080000
      Const adSeek = &H00400000
      Const adIndex = &H00800000

      ‘---- LockTypeEnum Values ----
      Const adLockReadOnly = 1
      Const adLockPessimistic = 2
      Const adLockOptimistic = 3
      Const adLockBatchOptimistic = 4

      ‘---- ExecuteOptionEnum Values ----
      Const adRunAsync = &H00000010
      Const adAsyncExecute = &H00000010
      Const adAsyncFetch = &H00000020
      Const adAsyncFetchNonBlocking = &H00000040
      Const adExecuteNoRecords = &H00000080

      ‘---- ConnectOptionEnum Values ----
      Const adAsyncConnect = &H00000010

      ‘---- ObjectStateEnum Values ----
      Const adStateClosed = &H00000000
      Const adStateOpen = &H00000001
      Const adStateConnecting = &H00000002
      Const adStateExecuting = &H00000004
      Const adStateFetching = &H00000008

      ‘---- CursorLocationEnum Values ----
      Const adUseServer = 2
      Const adUseClient = 3

      ‘---- DataTypeEnum Values ----
      Const adEmpty = 0
      Const adTinyInt = 16
      Const adSmallInt = 2
      Const adInteger = 3
      Const adBigInt = 20
      Const adUnsignedTinyInt = 17
      Const adUnsignedSmallInt = 18
      Const adUnsignedInt = 19
      Const adUnsignedBigInt = 21
      Const adSingle = 4
      Const adDouble = 5
      Const adCurrency = 6
      Const adDecimal = 14
      Const adNumeric = 131
      Const adBoolean = 11
      Const adError = 10
      Const adUserDefined = 132
      Const adVariant = 12
      Const adIDispatch = 9
      Const adIUnknown = 13
      Const adGUID = 72
      Const adDate = 7
      Const adDBDate = 133
      Const adDBTime = 134
      Const adDBTimeStamp = 135
      Const adBSTR = 8
      Const adChar = 129
      Const adVarChar = 200
      Const adLongVarChar = 201
      Const adWChar = 130
      Const adVarWChar = 202
      Const adLongVarWChar = 203
      Const adBinary = 128
      Const adVarBinary = 204
      Const adLongVarBinary = 205
      Const adChapter = 136
      Const adFileTime = 64
      Const adDBFileTime = 137
      Const adPropVariant = 138
      Const adVarNumeric = 139

      ‘---- FieldAttributeEnum Values ----
      Const adFldMayDefer = &H00000002
      Const adFldUpdatable = &H00000004
      Const adFldUnknownUpdatable = &H00000008
      Const adFldFixed = &H00000010
      Const adFldIsNullable = &H00000020
      Const adFldMayBeNull = &H00000040
      Const adFldLong = &H00000080
      Const adFldRowID = &H00000100
      Const adFldRowVersion = &H00000200
      Const adFldCacheDeferred = &H00001000
      Const adFldKeyColumn = &H00008000

      ‘---- EditModeEnum Values ----
      Const adEditNone = &H0000
      Const adEditInProgress = &H0001
      Const adEditAdd = &H0002
      Const adEditDelete = &H0004

      ‘---- RecordStatusEnum Values ----
      Const adRecOK = &H0000000
      Const adRecNew = &H0000001
      Const adRecModified = &H0000002
      Const adRecDeleted = &H0000004
      Const adRecUnmodified = &H0000008
      Const adRecInvalid = &H0000010
      Const adRecMultipleChanges = &H0000040
      Const adRecPendingChanges = &H0000080
      Const adRecCanceled = &H0000100
      Const adRecCantRelease = &H0000400
      Const adRecConcurrencyViolation = &H0000800
      Const adRecIntegrityViolation = &H0001000
      Const adRecMaxChangesExceeded = &H0002000
      Const adRecObjectOpen = &H0004000
      Const adRecOutOfMemory = &H0008000
      Const adRecPermissionDenied = &H0010000
      Const adRecSchemaViolation = &H0020000
      Const adRecDBDeleted = &H0040000

      ‘---- GetRowsOptionEnum Values ----
      Const adGetRowsRest = -1

      ‘---- PositionEnum Values ----
      Const adPosUnknown = -1
      Const adPosBOF = -2
      Const adPosEOF = -3

      ‘---- enum Values ----
      Const adBookmarkCurrent = 0
      Const adBookmarkFirst = 1
      Const adBookmarkLast = 2

      ‘---- MarshalOptionsEnum Values ----
      Const adMarshalAll = 0
      Const adMarshalModifiedOnly = 1

      ‘---- AffectEnum Values ----
      Const adAffectCurrent = 1
      Const adAffectGroup = 2
      Const adAffectAll = 3
      Const adAffectAllChapters = 4

      ‘---- ResyncEnum Values ----
      Const adResyncUnderlyingValues = 1
      Const adResyncAllValues = 2

      ‘---- CompareEnum Values ----
      Const adCompareLessThan = 0
      Const adCompareEqual = 1
      Const adCompareGreaterThan = 2
      Const adCompareNotEqual = 3
      Const adCompareNotComparable = 4

      ‘---- FilterGroupEnum Values ----
      Const adFilterNone = 0
      Const adFilterPendingRecords = 1
      Const adFilterAffectedRecords = 2
      Const adFilterFetchedRecords = 3
      Const adFilterPredicate = 4
      Const adFilterConflictingRecords = 5

      ‘---- SearchDirectionEnum Values ----
      Const adSearchForward = 1
      Const adSearchBackward = -1

      ‘---- PersistFormatEnum Values ----
      Const adPersistADTG = 0
      Const adPersistXML = 1

      ‘---- StringFormatEnum Values ----
      Const adStringXML = 0
      Const adStringHTML = 1
      Const adClipString = 2

      ‘---- ConnectPromptEnum Values ----
      Const adPromptAlways = 1
      Const adPromptComplete = 2
      Const adPromptCompleteRequired = 3
      Const adPromptNever = 4

      ‘---- ConnectModeEnum Values ----
      Const adModeUnknown = 0
      Const adModeRead = 1
      Const adModeWrite = 2
      Const adModeReadWrite = 3
      Const adModeShareDenyRead = 4
      Const adModeShareDenyWrite = 8
      Const adModeShareExclusive = &Hc
      Const adModeShareDenyNone = &H10

      ‘---- IsolationLevelEnum Values ----
      Const adXactUnspecified = &Hffffffff
      Const adXactChaos = &H00000010
      Const adXactReadUncommitted = &H00000100
      Const adXactBrowse = &H00000100
      Const adXactCursorStability = &H00001000
      Const adXactReadCommitted = &H00001000
      Const adXactRepeatableRead = &H00010000
      Const adXactSerializable = &H00100000
      Const adXactIsolated = &H00100000

      ‘---- XactAttributeEnum Values ----
      Const adXactCommitRetaining = &H00020000
      Const adXactAbortRetaining = &H00040000

      ‘---- PropertyAttributesEnum Values ----
      Const adPropNotSupported = &H0000
      Const adPropRequired = &H0001
      Const adPropOptional = &H0002
      Const adPropRead = &H0200
      Const adPropWrite = &H0400

      ‘---- ErrorValueEnum Values ----
      Const adErrInvalidArgument = &Hbb9
      Const adErrNoCurrentRecord = &Hbcd
      Const adErrIllegalOperation = &Hc93
      Const adErrInTransaction = &Hcae
      Const adErrFeatureNotAvailable = &Hcb3
      Const adErrItemNotFound = &Hcc1
      Const adErrObjectInCollection = &Hd27
      Const adErrObjectNotSet = &Hd5c
      Const adErrDataConversion = &Hd5d
      Const adErrObjectClosed = &He78
      Const adErrObjectOpen = &He79
      Const adErrProviderNotFound = &He7a
      Const adErrBoundToCommand = &He7b
      Const adErrInvalidParamInfo = &He7c
      Const adErrInvalidConnection = &He7d
      Const adErrNotReentrant = &He7e
      Const adErrStillExecuting = &He7f
      Const adErrOperationCancelled = &He80
      Const adErrStillConnecting = &He81
      Const adErrNotExecuting = &He83
      Const adErrUnsafeOperation = &He84

      ‘---- ParameterAttributesEnum Values ----
      Const adParamSigned = &H0010
      Const adParamNullable = &H0040
      Const adParamLong = &H0080

      ‘---- ParameterDirectionEnum Values ----
      Const adParamUnknown = &H0000
      Const adParamInput = &H0001
      Const adParamOutput = &H0002
      Const adParamInputOutput = &H0003
      Const adParamReturnValue = &H0004

      ‘---- CommandTypeEnum Values ----
      Const adCmdUnknown = &H0008
      Const adCmdText = &H0001
      Const adCmdTable = &H0002
      Const adCmdStoredProc = &H0004
      Const adCmdFile = &H0100
      Const adCmdTableDirect = &H0200

      ‘---- EventStatusEnum Values ----
      Const adStatusOK = &H0000001
      Const adStatusErrorsOccurred = &H0000002
      Const adStatusCantDeny = &H0000003
      Const adStatusCancel = &H0000004
      Const adStatusUnwantedEvent = &H0000005

      ‘---- EventReasonEnum Values ----
      Const adRsnAddNew = 1
      Const adRsnDelete = 2
      Const adRsnUpdate = 3
      Const adRsnUndoUpdate = 4
      Const adRsnUndoAddNew = 5
      Const adRsnUndoDelete = 6
      Const adRsnRequery = 7
      Const adRsnResynch = 8
      Const adRsnClose = 9
      Const adRsnMove = 10
      Const adRsnFirstChange = 11
      Const adRsnMoveFirst = 12
      Const adRsnMoveNext = 13
      Const adRsnMovePrevious = 14
      Const adRsnMoveLast = 15

      ‘---- SchemaEnum Values ----
      Const adSchemaProviderSpecific = -1
      Const adSchemaAsserts = 0
      Const adSchemaCatalogs = 1
      Const adSchemaCharacterSets = 2
      Const adSchemaCollations = 3
      Const adSchemaColumns = 4
      Const adSchemaCheckConstraints = 5
      Const adSchemaConstraintColumnUsage = 6
      Const adSchemaConstraintTableUsage = 7
      Const adSchemaKeyColumnUsage = 8
      Const adSchemaReferentialConstraints = 9
      Const adSchemaTableConstraints = 10
      Const adSchemaColumnsDomainUsage = 11
      Const adSchemaIndexes = 12
      Const adSchemaColumnPrivileges = 13
      Const adSchemaTablePrivileges = 14
      Const adSchemaUsagePrivileges = 15
      Const adSchemaProcedures = 16
      Const adSchemaSchemata = 17
      Const adSchemaSQLLanguages = 18
      Const adSchemaStatistics = 19
      Const adSchemaTables = 20
      Const adSchemaTranslations = 21
      Const adSchemaProviderTypes = 22
      Const adSchemaViews = 23
      Const adSchemaViewColumnUsage = 24
      Const adSchemaViewTableUsage = 25
      Const adSchemaProcedureParameters = 26
      Const adSchemaForeignKeys = 27
      Const adSchemaPrimaryKeys = 28
      Const adSchemaProcedureColumns = 29
      Const adSchemaDBInfoKeywords = 30
      Const adSchemaDBInfoLiterals = 31
      Const adSchemaCubes = 32
      Const adSchemaDimensions = 33
      Const adSchemaHierarchies = 34
      Const adSchemaLevels = 35
      Const adSchemaMeasures = 36
      Const adSchemaProperties = 37
      Const adSchemaMembers = 38

      ‘---- SeekEnum Values ----
      Const adSeekFirstEQ = &H1
      Const adSeekLastEQ = &H2
      Const adSeekAfterEQ = &H4
      Const adSeekAfter = &H8
      Const adSeekBeforeEQ = &H10
      Const adSeekBefore = &H20

      ‘---- ADCPROP_UPDATECRITERIA_ENUM Values ----
      Const adCriteriaKey = 0
      Const adCriteriaAllCols = 1
      Const adCriteriaUpdCols = 2
      Const adCriteriaTimeStamp = 3

      ‘---- ADCPROP_ASYNCTHREADPRIORITY_ENUM Values ----
      Const adPriorityLowest = 1
      Const adPriorityBelowNormal = 2
      Const adPriorityNormal = 3
      Const adPriorityAboveNormal = 4
      Const adPriorityHighest = 5

      ‘---- CEResyncEnum Values ----
      Const adResyncNone = 0
      Const adResyncAutoIncrement = 1
      Const adResyncConflicts = 2
      Const adResyncUpdates = 4
      Const adResyncInserts = 8
      Const adResyncAll = 15

      ‘---- ADCPROP_AUTORECALC_ENUM Values ----
      Const adRecalcUpFront = 0
      Const adRecalcAlways = 1
      %>

        本站是提供個人知識管理的網(wǎng)絡(luò)存儲空間,所有內(nèi)容均由用戶發(fā)布,不代表本站觀點。請注意甄別內(nèi)容中的聯(lián)系方式、誘導購買等信息,謹防詐騙。如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請點擊一鍵舉報。
        轉(zhuǎn)藏 分享 獻花(0

        0條評論

        發(fā)表

        請遵守用戶 評論公約

        類似文章 更多