Summary

In this chapter we covered SQL/JDBC programming. We used what we learned to provide database support for our address book application. We took a brief torn" oS SQL fundamentals, including the SQL sublanguages, DDL and DML.

The exercises showed how to connect and use two different databases: a JDBC-ODBC bridge (Microsoft Access) and a pure JDBC connection (InstrytDB). We saw some of the difficulties in porting to and running on multiple databases.

We also saw the importance of modular design when we grafted database support onto the address book application. In addition, we ueed j ava . Utils . Properties to make changing properties easier. We also discovered the dynamic capabilities of Python's_import_statement, which uses the module name in a property file to load an I/O ctttily module. The dynamism of P^ho n and polymorphism was reinforced when we added database support to the AddressModel class by creating a database-aware subclass and a database-aware dictionary.

CONTENTS

CONTENTS

Was this article helpful?

0 0

Post a comment