ASP Technology Access Web database

I. Multiple scenarios for accessing a Web database
Currently, there are several technologies for accessing Web databases in the Windows environment, including:
1. Public Gateway Interface CGI (Common gateway Interface)
CGI is a technology that is implemented earlier. Applicable to a variety of server platforms, such as UNIX, Windows, and so on, but CGI development
Cost is high, maintenance is difficult, function is limited, do not have transaction processing function, Occupy server resource more.
2. Internet DB connector IDC (Internet database Connector)
IDC integrates in the ISAPI (Internet Server API), leverages DLL technology and is easy to expand, but programming
is more complex than CGI and applies only to small database systems.
3. Advanced Database Connector ADC (Advance DB Connector)
ADC provides ActiveX control to access the database, and its main feature is that data queries are browsed by the client
, which requires that some of the records in the server-side database be downloaded to the client, with a large overhead and slow response
, and is only applicable to database query operations that are particularly frequent.
4. JAVA/JDBC Language Programming
The Java language is an object-oriented, portable, multithreaded language that can be used to connect to a database through JDBC
。 The software written with JAVA/JDBC is highly portable and suitable for a variety of operating systems, but its execution efficiency and execution speed
is not ideal, at present cannot establish the high efficiency, the high speed application.
5. Dynamic Server Pages ASP (Active Server Page)
ASP is Microsoft's latest Web application development technology, focusing on the processing of dynamic Web pages and Web database open
Hair, programming flexible, concise, with high performance, is currently the best choice to access the Web database.
Two. asp Introduction
1.ASP access to the database principle
ASP is a server-side script execution environment that can be used to generate and execute dynamic, high-performance Web server programs
。
When a user requests an ASP home page using a browser, the Web server responds and invokes the ASP engine to execute the ASP file.
and explain the scripting language (JScript or VBScript), connect the database through ODBC, and access the group by the database
A piece of ADO (ActiveX data Objects) completes the database operation, the last ASP generation contains the data query result the HT
ML home page Returns the client display.
As the ASP runs on the server side, the results of the run are returned to the user's browser as an HTML home page, so the ASP source
Order will not leak, increase the security of the system confidentiality. In addition, ASP is an object-oriented scripting environment where users can
Add ActiveX components to expand its functionality and expand its scope of application.
2.ASP the structure of the page:
ASP's program code is simple, generic, file name from. asp end, ASP file is usually composed of four parts:
1 Standard HTML Tags: all HTML tags can be used.
2 ASP Syntax command: The ASP code located in the <%%> tag.