Table of Contents

Chapter 1 Introduction

1.0 Purpose and Scope

1.1 Background

1.2 Aims and Objectives

1.3 Outline

Chapter 2 Databases and the World Wide Web

2.0 Introduction

2.1 The Databases Client/Server model

2.1.1 Components of a client/server database application

2.1.2 Two Tier Architecture

2.1.3 Three Tier Architecture

2.2 The World Wide Web and Databases

2.3 Database Connectivity Solutions for the Internet

2.3.1 Common Gateway Interface Systems

2.3.2 Middleware Solutions

2.3.3 Java and JDBC

2.3.4 ActiveX

2.3.5 Web Aware Databases

2.3.6 Distributed Object Systems

2.3.6.1 Object Request Broker

2.3.6.2 Common Object Request Broker Architecture

2.4 Distributed Databases

2.5 Conclusion

Chapter 3 Java Database Connectivity

3.0 Introduction

3.1 Structured Query Language

3.2 SQL Access Group

3.3 Open Database Connectivity

3.4 Java Database Programming

3.5 JDBC

3.5.1 JDBC API

3.5.2 JDBC Drivers

3.5.2.1 JDBC-ODBC bridge and ODBC driver.

3.5.2.2 Native-API partly-Java driver

3.5.2.3 JDBC-Net pure Java driver

3.5.2.4. Native-protocol pure Java driver

3.6 Scenarios for use

3.6.1 Applets

3.6.2 Applications

3.6.3 Trusted Applets

3.6.4 Three-tier access

3.7 Benefits of Java and JDBC

3.8 Disadvantages of JDBC

3.9 Conclusion

Chapter 4 Design of the Framework for Object-Relational Mapping

4.0 Introduction

4.1 The Object Management Technique

4.2 Analysis

4.2.1 The Object model

4.2.1.1 Problem Statement

4.2.1.2 Identifying object classes

4.2.1.3 Identify associations between classes

4.2.1.4 Add attributes for objects and links.

4.2.1.5 Using inheritance to share common Structure

4.2.2 The Dynamic model

4.2.2.1 Developing a State Diagram

4.2.3 The Functional Model

4.2.3.1 Identify input and output values

4.2.3.2 Build a Data Flow Diagram

4.3 System Design

4.4 Object Design

4.5 Conclusion

Chapter 5 Implementation

5.0 Introduction

5.1 Implementing JDBC.

5.1.1 JDBC Statements

5.1.2 Retrieving Data

5.1.3 Meta Data

5.2 Exception Handling

5.3 Developing a Higher Level Abstraction of JDBC

5.3.1 Visibility Modifiers

5.3.2 Instance Variables and Methods

5.4 Framework for Object-Relational Mapping

5.5 Implementing the Graphical User Interface

5.6 Conclusion

Chapter 6 Evaluation and Conclusions

6.0 Introduction

6.1 Evaluation

6.1.1 Formative Evaluation

6.1.2 Summative Evaluation

6.2 Methods of Evaluation

6.2.1 Analytic Evaluation

6.2.2 Expert Evaluation

6.2.3 Observational Evaluation

6.2.4 Survey Evaluation

6.3 Testing

6.4 Results and Recommendations

6.5 Conclusion

References

List of Appendices

Appendix A DatabaseConnect Class

Appendix B Mapping Class

Appendix C FInt, FString & FDouble Classes

Appendix D DatabaseConnectTest Application

Appendix E GUI Application

Appendix F Car Class & Application

Appendix G Lotto Class

Appendix H LottoInitialise & LottoRun Applications

Appendix I TheDemo Application

List of Figures

Fig 2.1 Database Client/Server Architecture

Fig 2.2 Layers of a database application

Fig 2.3 Three Tier Database Architecture

Fig 2.4 Basic Architecture of the World Wide Web

Fig 2.5 Three-Tier Client/Server Database Access via CGI

Fig 2.6 Java Database Access via Internet/Intranet

Fig 3.1 Architecture of a JDBC application

Fig 3.2 The JDBC API

Fig 3.3 The JDBC-ODBC Bridge

Fig 3.4 Type 2 JDBC Driver

Fig 3.5 Type 3 Pure JDBC Driver

Fig 3.6 Type 4 Pure JDBC Driver

Fig 3.7 Applet Database Access via the Internet

Fig 3.8 Java Application Database Access

Fig 3.9 Three-Tier Java Applet/Application Database Access

Fig 4.1 Iterative Object-Oriented Development Process

Fig 4.2 Initial Object Diagram

Fig 4.3 Event Flow Diagram for Simple Database Application

Fig 4.4 The State Diagram

Fig 4.5 Context Diagram

Fig 4.6 Top Level Data Flow Diagram

Fig 4.7. Level 1 Data Flow Diagram

Fig 4.8. Subsystem Block Diagram of Database Application

Fig 4.9 Main tasks of Initial DatabaseConnect Class

Fig 4.10. Initial Class Diagram of Mapping

Fig 4.11. FString Class Diagram

Fig 5.1 Sequence of method calls for class DatabaseConnect

Fig 5.2 Design of Mapping Constructor

Fig 5.3 Class Diagram for FDouble

Fig 5.4 Actions carried out by the store method

Fig 5.5 Prototype of Database Application

Fig 6.1 Hierarchy of constructor calls for a subclass of Mapping

Fig 6.2 Output from LottoTest application

Fig 6.3 Layout of Application Testing DatabaseConnect and Mapping classes

Table of Contents

Home