webprogrammingwithplsql(已修改)
2024-11-09 16:45 本頁面
【正文】 Web Programming with PL/SQL Erdogan Dogdu Geia State University Computer Science Department CSC8711 Content ? Oracle Architecture for Web Apps ? Oracle mod_plsql Apache module ? HTTP ? A Simple PL/SQL Web Toolkit Example ? PL/SQL Web Toolkit ? Parameter Passing ? HTML Forms ? PL/SQL Server Pages CSC8711 Oracle Web Extensions ?3tier: client, application server (OAS 9i), database (Oracle 9i) ?mod_plsql in OAS ?PL/SQL Web Toolkit CSC8711 Web Request Processing 1. The Oracle HTTP Server receives a PL/SQL Server Page request from a client browser. 2. The Oracle HTTP Server routes the request to mod_plsql. 3. The request is forwarded by mod_plsql to the Oracle Database. By using the configuration information stored in your DAD, mod_plsql connects to the database. CSC8711 Web Request Processing (cont.) 4. Mod_plsql prepares the call parameters, and invokes the PL/SQL procedure in the application. 5. The PL/SQL procedure generates an HTML page using data and the PL/SQL Web Toolkit accessed from the database. 6. The response is returned to mod_plsql. 7. The Oracle HTTP Server sends the response to the client browser. CSC8711 Invoking mod_plsql ? location/[[!][schema.][package.]proc_ name[?query_string]] ? Example: – CSC8711 HTTP ? GET, PO
教學課件相關(guān)推薦
鄂ICP備17016276號-1