Chapter 5: JDBC and Web Access to Relational Databases
Eclectic Online Shopping Enterprise
The ER diagram of the Eclectic Online Shopping Enterprise is presented in Chapter 1
(Figure 1.1) and extended in Exercise 1 of Checkpoint 1.2.5 to include a specialization hierarchy for
order information. The supporting examples for this chapter demonstrate the use of JSP and ASP.NET to
create a Web interface to the Eclectic Online Shopping Enterprise. For each technology, the Web application
provides a Web site where customers can create accounts, browse and search items, select items to purchase,
and view past order information. The JSP implementation demonstrates the use of JDBC as described in
Chapter 5. The ASP.NET implementation demonstrates the use of ADO.NET, which is similar in functionality
to JDBC.
MetaWebDB Application
MetaWebDB is a Web-based application that dynamically accesses a
relational database via a call-level interface.
The MetaWebDB application provides the user with the
capability to issue ad hoc queries and data manipulation statements over
the database and displays the metadata and instance of the database in another
browser window.
[MetaJDBC] -
MetaJDBC is an implementation of the MetaWebDB application written in Java
that uses the JDBC API to dynamically access a relational database.
The Web-based user interface employs Java Server Pages (JSPs), Java
Servlets,
and JavaBeans.
- Documentation:Demonstrates use of
Java Database Connectivity (JDBC) and Microsoft Access
- Reference:JDBC Demonstration Courseware Using Servlets and Java Server Pages
Suzanne W. Dietrich, Susan D. Urban, and Ion Kyriakides
Proceedings of the ACM SIGCSE International Conference on Computer
Science EducationM, Covington, Kentucky, March 2002, 266-270.
/li>
- Download Code
[MetaADO.NET] -
MetaADO.NET is an implementation of the MetaWebDB application using ADO.NET
to dynamically access a relational database. ASP.NET and C# are used to
implement the Web interface.
http://www.eas.asu.edu/~advdb CURRICULUM EXAMPLES Chapter 5