ado 批更新模式_ADO的完整形式是什么？

ado 批更新模式

ADO：ActiveX数据对象 (ADO: ActiveX Data Objects)

ADO is an abbreviation of "ActiveX Data Objects".

ADO是“ ActiveX数据对象”的缩写 。

Microsoft's ActiveX Data Objects (ADO) consists of an order of sequence of Component Object Model (COM) objects for accessing sources of data in computing. A division of MDAC (Microsoft Data Access Components), it makes available a middleware layer among programming languages and OLE DB, which is a way of accessing data stores, whether databases or not, in a standardized approach. ADO enables a developer to write programs that access data devoid of understanding how the database is put into operation; developers required to be conscious of the database for association simply. No information, data, and facts of SQL are necessary to access a database when using ADO, even if one can use ADO to implement SQL commands straightforwardly with the drawback of bringing in dependency upon the category of the database used.

Microsoft的ActiveX数据对象(ADO)由用于访问计算中数据源的组件对象模型(COM)对象的顺序顺序组成。 它是MDAC(Microsoft数据访问组件)的一个分支，在编程语言和OLE DB之间提供了一个中间件层，这是一种以标准化方式访问数据存储(无论是否为数据库)的方式。 ADO使开发人员能够编写访问数据的程序，而无需了解如何使数据库运行。 开发人员需要简单地意识到数据库的关联性。 使用ADO时 ，访问数据库不需要SQL的任何信息，数据和事实，即使一个人可以使用ADO来直接实现SQL命令，也具有依赖于所用数据库类别的缺点。

In October 1996, Microsoft launched ADO, placing the arrangement of software as a descendant to Microsoft's former object layers for accessing sources of data, comprising RDO (Remote Data Objects) and DAO (Data Access Objects).

1996年10月，Microsoft启动了ADO ，将软件安排作为Microsoft以前的对象层(用于访问数据源)的后代，包括RDO(远程数据对象)和DAO(数据访问对象)。

ADO is manufactured by the combination of four collections and twelve objects.

ADO由四个集合和十二个对象组合而成。

ADO集合 (ADO Collections)

• Fields:

  领域 ：

  This collection includes an order of arrangement of Field objects. The Collection of field objects can be used in either a Recordset object or in a Record object.

  该集合包括Field对象的排列顺序。 字段对象的集合可以在Recordset对象或Record对象中使用。

• Properties:

  特性 ：

  An object can have more than one Property object, which is included in the object's Properties collection.

  一个对象可以具有多个Property对象，该对象包含在该对象的Properties集合中。

• Parameters:

  参数 ：

  A Command object can have quite a lot of Parameter commands to modify its predefined performance, and each of the Parameter objects is included in the Command object's Parameters collection.

  一个Command对象可以有很多Parameter命令来修改其预定义的性能，并且每个Parameter对象都包含在Command对象的Parameters集合中。

• Errors:

  错误 ：

  All provider-created errors are passed to a collection of Error objects, at the same time as the Errors collection itself is included in a Connection object.

  提供程序创建的所有错误都将传递到Error对象的集合，同时Errors集合本身包含在Connection对象中。

ADO基本用法 (ADO Fundamental Usage)

A variety of fundamental steps are necessary in order to be able to access and control data using ADO, which comprise:

为了能够使用ADO访问和控制数据，必须采取各种基本步骤，这些步骤包括：

• Build a connection object to make a connection to the database.

  建立连接对象以建立与数据库的连接。

• Build a recordset object to take delivery of data.

  构建一个记录集对象以接收数据。

• Open the connection

  打开连接

• Occupy the record set by opening it and passing the preferred table name or SQL statement as a factor to open function.

  通过打开记录集并传递首选的表名或SQL语句作为打开函数的因素来占用记录集。

• Perform all the preferred searching/processing on the extracted data.

  对提取的数据执行所有首选搜索/处理。

• Carry out the changes as a user-made to the data (if any) by using Update or

  通过使用更新或更新，对数据(如果有)进行用户更改。

• Update Batch techniques.

  更新批处理技术。

• Close the recordset

  关闭记录集

• Secure and close up the connection

  保护并关闭连接

支持软件 (Supported software)

• ADO is supported in any advance language that supports binding to binary COM interfaces.

  任何支持绑定到二进制COM接口的高级语言都支持ADO。

• These languages consist of ASP, Delphi, PowerBuilder, and Visual Basic for Applications (VBA).

  这些语言包括ASP，Delphi，PowerBuilder和Visual Basic for Applications(VBA)。

• ADO support has now been supplemented to dBase Plus 8 (With ADO).

  dBase Plus 8(带有ADO)现已对ADO支持进行了补充。

翻译自: https://www.includehelp.com/dictionary/ado-full-form.aspx

ado 批更新模式