【正文】
adLockReadOnly ? Cannot alter the data ( no updates, inserts, or deletions ) ? adLockPessimistic ( better at the database’s integrity ) ? Record lock during editing ? Lock out everyone else from the record you’re editing ? Lock from the time of first change until call the Update method ? adLockOptimistic ? No lock during editing ? Lock the record only during the call to Update ? adLockBatchOptimistic ? No lock during editing ( modify, insert, delete ) ? Batch update: Lock the records only during the call to UpdateBatch 使用 LockType =“書籍” =Cn =AdOpenDynamic = AdOpenPessimistic 或 “書籍” ,Cn, AdOpenDynamic, AdOpenPessimistic ?!盻 amp?!盻 amp?!盻 amp。資料控制項(xiàng)與資料存取物件 資料庫(kù)控制項(xiàng) ( Adodc) ?提供的功能有限 ?方便 ,使用者不需要額外撰寫程式 資料存取物件 (ADO) ?功能較完整 ?需要撰寫程式碼 二者可以交互使用 半自動(dòng) 完全手動(dòng) ADO的子物件 Connection物件:用以連接資料庫(kù) Recordset物件:取得資料來(lái)源 Command物件:儲(chǔ)存操作資料庫(kù)時(shí)用到的命令 Parameter物件:管理查詢或預(yù)儲(chǔ)程式 Field物件:儲(chǔ)存欄位資料 Error物件:處理錯(cuò)誤訊息 Property物件:保存 Connection, Command, Recordset 與 Field物件屬性的物件 物件間相對(duì)關(guān)係 Connection Recordset Fields Field Command Error Property Property P