The Encapsulation and Reuse of ADO Database Access Interface in Software Engineering

ADO is an optimized solution of universal database access technology. Compared with common database access technology, ADO has the characteristics of being easy to use, high speed, less memory and small disk remains. Especially, it supports to access SQL Server database through the Client/Server Mode. In accordance with the idea of object oriented designing. we encapsulate the connection of the database, carrying out non-query SQL and SQL querying to obtain Record sets relatively independent with the use of the database programming object model, which offered by ADO. The reusing can achieve a unified manipulation of the database. Avoiding duplication of codes written, facilitating the expansion and maintenance of later stage in large-scale projects, especially more large-scale projects.