ado接口（Ado接口）.docVIP

ado接口（Ado接口） The ADO library contains three basic interfaces: the _ConnectionPtr interface, the _CommandPtr interface, and the _RecordsetPtr interface. The _ConnectionPtr interface returns a recordset or an empty pointer. It is usually used to create a data connection or to execute a SQL statement that does not return any results, such as a stored procedure. Using a _ConnectionPtr interface to return a recordset is not a good way to use it. Operations that are used to return records are usually implemented using _RecordserPtr. In _ConnectionPtr operations, you want to get the number of records to traverse all the records, but not with the _RecordserPtr. The _CommandPtr interface returns a recordset. It provides a simple way to execute the stored procedures and SQL statements that return the recordset. When you use the _CommandPtr interface, you can take advantage of the global _ConnectionPtr interface, or you can use the connection string directly in the _CommandPtr interface. If you execute only one or more data access operations, the latter is a better choice. But if you want to access the database, and to return many records set, then you should use the global _ConnectionPtr interface to create a data connection, and then use the _CommandPtr interface to execute stored procedures and SQL statements. _RecordsetPtr is a recordset object. Compared to the two objects above, it provides more control functions for the Recordset, such as record locking, cursor control, and so on. As with the _CommandPtr interface, it is not necessary to use a data connection has been created, you can use a connection string instead of connecting the pointer value to the _RecordsetPtr connection member variable, let it create a data connection. If you want to use multiple recordset, the best way is to use the global _ConnectionPtr interface that has created a data connection just like the Command object And then use _RecordsetPtr to execute stored procedures and SQL statements. ADO is de