DAO RDO ADO Пыжьянов Вячеслав Сагадиева Лиля

DAO, RDO & ADO Пыжьянов Вячеслав Сагадиева Лиля

1989

Сентябрь 1992

Август 1996

Октябрь 1996

MDAC/WDAC архитектура

Развитие ADO

Data Access Objects

Программирование DAO на C++ Вызов интерфейсов OLE DB напрямую Использование классов MFC Cdao (CDao. Xxx) Использование классов DAO SDK

MFC: CDao. Query. Def. Info queryinfo; int n. Queries = p. DB->Get. Query. Def. Count( ); for ( int i = 0; i < n. Queries; i++ ) { Get. Query. Def. Info( i, queryinfo ); printf("query name is: %sn", queryinfo. m_str. Name); } DAO SDK: Cdb. Database DB; for (long i = 0; i < DB. Querydefs. get. Count(); i++) printf("query name is: %sn", DB. Querydefs[i]. Get. Name());

Remote Data Objects

RDO and Microsoft Jet/DAO RDO Object DAO/JET Object rdo. Engine DBEngine NI Index rdo. Error rdo. Resultset Recordset rdo. Environment Workspace NI Table-type rdo. Connection Database Keyset-type Dynaset-type rdo. Table. Def Static-type (r/w) Snapshot-type (r/o) Dynamic-type (none) rdo. Parameter Forward-only – type Forward-onlytype NI Relation (cursorless) (none) NI Group rdo. Column Field NI User rdo. Query. Def

Active. X Data Objects

Открытие соединения Объект Connection (. Open) Объект Recordset (. Open) Установка свойств соединения With obj. Conn. Provider = "SQLOLEDB". Properties("Data Source") = "My. Sql. Server". Properties("Integrated Security") = "SSPI". Open. Default. Database = "Northwind" End With

Получение данных Объект Command Dim obj. Cmd As New ADODB. Command obj. Cmd. Command. Text = "SELECT *" &_ "FROM Orders " & _ "ORDER BY Order. ID" obj. Cmd. Command. Type = ad. Cmd. Text Set obj. Conn = Get. New. Connection obj. Cmd. Active. Connection = obj. Conn Set obj. Rs = obj. Cmd. Execute

Вызов хранимой процедуры Dim obj. Cmd As New ADODB. Command Dim obj. Parm 1 As New ADODB. Parameter Dim obj. Rs As New ADODB. Recordset obj. Cmd. Command. Text = “Cust. Orders” obj. Cmd. Command. Type = ad. Cmd. Stored. Proc Set obj. Conn = Get. New. Connection obj. Cmd. Active. Connection = obj. Conn obj. Cmd. Parameters. Refresh obj. Cmd(1) = "ALFKI“ Set obj. Rs = obj. Cmd. Execute

Объект Recordset Определение размера и текущей записи. Границы recordset Навигация по данным. ◦ Переход на другую запись ◦ Использование закладок ◦ Использование страниц Fields Collection Дополнительные возможности: организация данных, поиск, фильтрация и т. д.

Изменение данных Изменение существующей записи Добавление: ◦ recordset. Add. New Field. List, Values Edit. Mode: Константа Описание ad. Edit. None Нет текущих операций обновления ad. Edit. In. Progress Данные в текущей позиции изменены, но не сохранены ad. Edit. Add Текущая запись находится в буфере копирования, но сохранение еще не вызвано ad. Edit. Delete Текущая запись удалена

Работа с курсорами Forward-only cursors (ad. Open. Forward. Only) Static cursors (ad. Open. Static) Keyset cursors (ad. Open. Keyset) Dynamic cursors (ad. Open. Dynamic )

Ошибки ADO Ошибки OLE DB Ошибки провайдера Ошибки, связанные с объектом Field Ошибки, связанные с recordset

События Установление связи Begin. Trans. Complete, Commit. Trans. Complete, Rollback. Trans. Complete Will. Connect, Connect. Complete, Disconnect Will. Execute, Execute. Complete Info. Message Объект Recordset Fetch. Progress, Fetch. Complete Will. Change. Field, Field. Change. Complete Will. Move, Move. Complete, End. Of. Recordset Will. Change. Record, Record. Change. Complete Will. Change. Recordset, Recordset. Change. Complete

Транзакции Begin. Trans Commit. Trans Rollback. Trans

Объекты DAO Объекты ADO Database connections Fields Objects Error Objects Transactions Properties Recordsets Connections Workspace Object Database Object Table. Defs Object Query. Defs Object Index Object Jet -Specific Features: Groups/Users Object Relations Object Containers Object Document Object Properties Object Events Command Object Disconnected Recordsets

ADO MD (Multidimensional)

DIMENSIONS {All, North America, Europe, Canada, USA, UK, Germany, Canada-West, Canada-East, USA-NW, USA-SW, USA-NE, USA-SE, England, Scotland, Wales, Ireland, Germany-North, Germany-South, Ottawa, Toronto, Vancouver, Calgary, Seattle, Boise, Los Angeles, Houston, Shreveport, Miami, Boston, New York, London, Dover, Glasgow, Edinburgh, Cardiff, Pembroke, Belfast, Derry, Berlin, Hamburg, Munich, Stuttgart}

Hierarchies The world Continents Countries Regions Cities

Levels The World = {All} Continents = {North America, Europe} Countries = {Canada, USA, UK, Germany} Regions = {Canada-East, Canada-West, USA -NE, USA-NW, USA-SE, USA-SW, England, Ireland, Scotland, Wales, Germany-North, Germany-South} Cities = {Ottawa, Toronto, Vancouver, Calgary, Seattle, Boise, Los Angeles, Houston, Shreveport, Miami, Boston, New York, London, Dover, Glasgow, Edinburgh, Cardiff, Pembroke, Belfast, Derry, Berlin, Hamburg, Munich, Stuttgart}

Members {All} (parent of) {Europe, North America} {North America} (parent of) {Canada, USA} {USA} (parent of) {USA-NE, USA-NW, USA-SE, USA-SW} {USA-NW} (parent of) {Boise, Seattle}

ADO MD

ADOX Microsoft Active. X Data Objects Extensions for Data Definition Language and Security