8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Java Server Pages
Java Server Pages (JSP) are an extension of the Servlet framework, which allows Java to be used as a scripting language within HTML files, like ASP and PHP. When the files containing the Java scripting are requested from the webserver they are compiled as servlets which actually produce the content. This article assumes the default installation of the HTTP server has taken place and the HTTP server is running.
Webserver Configuration
First we create a directory on the Oracle server to hold the JSP files.
ORACLE_HOME\Apache\Apache\htdocs\TSH
Save PSP Files
Next we place the JSP files, with the appropriate modifications, in the new directory.
- dept_insert_req.jsp (Right-click and select "Save Target As...")
- dept_insert_act.jsp (Right-click and select "Save Target As...")
Since this code contains HTML it may look normal when displayed by the browser, but the JSP code will not be executed. Either view the source or save the source to a file to read the code.
Test It
Once the files are saved to the filesystem they can be requested from the webserver and tested by opening a browser and requesting the following address, where "yourServer" is the name of the Oracle server.
http://yourServer:7778/TSH/dept_insert_req.jsp
Enter some values into the form and press the submit button. The resulting page should show a successful completion message or an error message. In addition the contents of the DEPT
table are displayed as an HTML table.
For more informationn see:
Hope this helps. Regards Tim...