The Oracle component implements a dynamic Web database
- 2020-05-24 06:23:43
- OfStack
The ORACLE tutorial you are looking at is: the Oracle component implements a dynamic Web database. [abstract] this paper briefly introduces the basic method of implementing Web database, discusses the basic method of using Oracle's server option 1WebServer combined with PL/SQL and the relevant built-in program package to realize dynamic Web, and gives a simple example.
With the development of computer Internet, Internet is becoming one of the main means of information exchange around the world. As an important part of Internet, WWW (World Wide Web) organizes information in the form of HTML and integrates and transmits all kinds of information by means of hyperlink. It has the features of friendly interface and simple operation. Users can directly browse and query all kinds of information by Web browser. Therefore, as a window for organizations and enterprises to display information, the amount of information and functions that Web server can provide directly affects its own image and customer visits.
In traditional Web servers, text and other information are stored and managed in the form of files, and the web pages provided to the user's browser are mostly static. When a user enters URL of an HTML document in a browser, it accesses a file on WebServer, which changes only when a network administrator places a new file with the same name on an Web server. With the expansion of the application field of WWW, the static Web page is increasingly unable to meet the requirements of dynamic, real-time and interactive information services, which requires the combination of database technology and WWW to achieve efficient access to data resources.
1. Build Web database application with Oracle WebServer
The Oracle 8 server is a complete information management environment. It is a repository for large amounts of data and provides users with fast access to this data. It can support the C/S structure for distributed processing and Web computing. Using WebServer in its server option 1, it provides powerful capabilities for implementing Web database applications.
Generally speaking, Web database applications can be connected to WebServer and DB Server by providing CGI/API and other middleware at WebServer, or they can be downloaded to the client by Web browser to run and directly access the database at the client, such as Java Applet, Active X, Plug-in and so on. This article focuses on writing programs to implement dynamic Web applications using the PL/SQL provided by Oracle 8 and its powerful built-in package. Belongs to the use of middleware development of 1. Middleware is responsible for managing the WebServer and DBServer communication between the application and provide services, it can directly call an external application or script code to access the database, so it can provide dynamic HTML page associated with the database, or to perform a user query, and the query results formatted into HTML page through WebServer again back to the user's browser. Its 1 - like structure is as follows:
Web browser ←→ Internet ←→ Web Server ←→ CGI/API ←→ Oracle DB Server
2, PL/SQL
Starting with version 6, Oracle supports one process processing language, PL/SQL, as the standard programming language for all Oracle tools, so that all process components can be implemented in the Oracle server product. The following important functions can be achieved with PL/SQL:
Stored procedures, programs (or code snippets) that reside in the Oracle database and do specific important work for your organization;
Database triggers, code stored in the database, can be triggered by events generated by the application.
Package, that is, the combination of multiple processes in 1 as a single unit of code stored in the database.
The built-in package is pre-generated, stored in a database, and can be called in an PL/SQL code block that can pass arguments as needed. It can output the result directly to the terminal window. Read and write data directly from operating system files; Perform multiple functions such as dynamic SQL. Common ones include HTP, HTF, es1064en-UTIL, etc. The application of dynamic Web is illustrated by an example of a dynamic online query score.
With the development of computer Internet, Internet is becoming one of the main means of information exchange around the world. As an important part of Internet, WWW (World Wide Web) organizes information in the form of HTML and integrates and transmits all kinds of information by means of hyperlink. It has the features of friendly interface and simple operation. Users can directly browse and query all kinds of information by Web browser. Therefore, as a window for organizations and enterprises to display information, the amount of information and functions that Web server can provide directly affects its own image and customer visits.
In traditional Web servers, text and other information are stored and managed in the form of files, and the web pages provided to the user's browser are mostly static. When a user enters URL of an HTML document in a browser, it accesses a file on WebServer, which changes only when a network administrator places a new file with the same name on an Web server. With the expansion of the application field of WWW, the static Web page is increasingly unable to meet the requirements of dynamic, real-time and interactive information services, which requires the combination of database technology and WWW to achieve efficient access to data resources.
1. Build Web database application with Oracle WebServer
The Oracle 8 server is a complete information management environment. It is a repository for large amounts of data and provides users with fast access to this data. It can support the C/S structure for distributed processing and Web computing. Using WebServer in its server option 1, it provides powerful capabilities for implementing Web database applications.
Generally speaking, Web database applications can be connected to WebServer and DB Server by providing CGI/API and other middleware at WebServer, or they can be downloaded to the client by Web browser to run and directly access the database at the client, such as Java Applet, Active X, Plug-in and so on. This article focuses on writing programs to implement dynamic Web applications using the PL/SQL provided by Oracle 8 and its powerful built-in package. Belongs to the use of middleware development of 1. Middleware is responsible for managing the WebServer and DBServer communication between the application and provide services, it can directly call an external application or script code to access the database, so it can provide dynamic HTML page associated with the database, or to perform a user query, and the query results formatted into HTML page through WebServer again back to the user's browser. Its 1 - like structure is as follows:
Web browser ←→ Internet ←→ Web Server ←→ CGI/API ←→ Oracle DB Server
2, PL/SQL
Starting with version 6, Oracle supports one process processing language, PL/SQL, as the standard programming language for all Oracle tools, so that all process components can be implemented in the Oracle server product. The following important functions can be achieved with PL/SQL:
Stored procedures, programs (or code snippets) that reside in the Oracle database and do specific important work for your organization;
Database triggers, code stored in the database, can be triggered by events generated by the application.
Package, that is, the combination of multiple processes in 1 as a single unit of code stored in the database.
The built-in package is pre-generated, stored in a database, and can be called in an PL/SQL code block that can pass arguments as needed. It can output the result directly to the terminal window. Read and write data directly from operating system files; Perform multiple functions such as dynamic SQL. Common ones include HTP, HTF, es1064en-UTIL, etc. The application of dynamic Web is illustrated by an example of a dynamic online query score.