Use ASP technology to develop WWW-based database retrieval programs

ASP is a new technology launched by Microsoft to replace CGI. It is currently recognized as the best tool for building Windows NT dynamic sites. It is fully integrated with ADO (Active Data Object, a new Data access model) and provides powerful database access functions, making it an important means of online database management.
I. INTRODUCTION to ASP
ASP is included in Internet Information Server (IIS3.0). The extension is represented by. asp. ASP files can be edited by using a regular text editor, or by using a dedicated auxiliary development tool InterDev for development and design, interDev integrates the whole Web programming (including Web design, ASP Programming, and database management), and is suitable for the development and development of large engineering projects. ASP uses VBScript, JavaScript, and other scripting languages as development tools, embedded in HTML text, and uses "<%... %> "To include ASP Programs. When a user initiates a request from a browser to the Web server, the Web server automatically interprets ASP Programs as standard HTML-formatted homepage content. The user only needs to use a browser that can normally execute HTML programs, you can browse the content of the homepage designed by ASP, so it has nothing to do with the browser and ensures that the source code of ASP is not leaked.
ASP includes five built-in ActiveX server components and five built-in objects: Database Access component (Database Access component) and File Access component (File Access component) ad Rotator component, Content Linking component, Browser Capabilities component, Request, Server) session, Response, and Application ). Among all ASP components, the most useful component is the database access component, also known as ActiveX Data object or ADO. The component and the objects contained in the component will be used to read and write the ODBC data source.
In addition, another important feature of ASP technology is that programmers can use Java, Visual Basic, Visual C ++ and other languages to create ActiveX server components that meet their special needs to expand ASP functions, make your dynamic web page almost infinitely scalable, which is not comparable to the traditional CGI program.
2. Combine with ADO to develop WWW-based database retrieval programs
The combination of ASP and ADO technology enables WWW-based database management. Users can search, input, update, and delete database information in the browser screen, in this way, the homepage content that provides database information is established. ADO provides seven objects and four sets for database management, including Connection, Command, Parameter, Recordset, Field, Property, Error, Fields, Properties, Parameters, and Errors. The Connection object is used to establish a Connection with the database. The Command object performs database operations, and The Recordset object can view or operate the data returned from the database. The Field object and Fields set allow operations on each Field in the current record. The Parameter object and Parameters set provide information and data for the Command object, the Property object and Properties set provide information for the features of Connection, Command, Recordset, and Field objects. The Error object and Errors set provide Error information when an Error occurs.