RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Internet Features
«Prev
Next»
Database Administration
Managing Storage
Tablespace Resource Management
Large Database Features
Internet Database Configurations
Security Features
Installation Configuration
Universal Installer
Parameter Initialization Changes
Configuration Assistant
Universal Installer Upgrade
Software Packager
Install Conclusion
Intro Table Space
Table Space Management
Locally Managed Tablespaces
Transportable Tablespaces
Read Only Tablespaces
DB Resource Manager
Use Resource Manager
Resource Manager Conclusion
SQL*Loader
SQL Loader Improvements
Load LOB Data SQL Loader
Table Management Enhancements
Relocate | Restructure Table
Create Temporary Table
Remove Unused Column
Oracle Database Limits
Oracle Enhancements
JDBC Client
Multimedia | Oracle
Java Oracle
Intermedia Exchange
Text Retrieval
Oracle Internet Directory
Oracle Tools Features
JSP Web Development
Directory Conclusion
Web Enterprise
Delivering Web pages with SQLJ - Exercise
Delivering Web pages with SQLJ
Create an applet using SQLJ
Objective:
Add code to an applet using SQLJ.
Exercise scoring
This exercise is worth a maximum of 10 points.
Background/overview
In this lesson you have seen how to create an applet that queries the House-O-Pets data. In an earlier lesson, you saw how to use interMedia to deliver an image file from the database. Now you will use your knowledge to create an applet that delivers an image of the product based on the user's query criteria.
Download files
Download the partially completed applet.
Instructions
Download the partially completed applet. Add the SQLJ component to the applet. Then answer the following questions.
What is the advantage of using SQLJ and Java over using JDBC and Java?
What other information would you recommend displaying along with the product image?
Submitting your exercise
Copy your applet source code and your answers into the box below. Click the
Submit
button to submit your exercise.
Question 1: The advantage of using SQLJ and Java over using JDBC and Java is that you are coding only SQL commands instead of coding the intermediate steps (such as OPEN, PARSE, FETCH, and so on) that are required when coding JDBC and Java.
Question 2: Other information that might be displayed along with the product image would include the product number, name, the current number in stock, comments about care and feeding (for pets), and the price.
Submit