35.10. Forwarding Requests from JavaServer Pages | Introduction to Java Programming-Comprehensive Version (6th Edition)

[Page 1091]

The Goddess Chalchihuitlicue, found in the Valley of Mexico, 1300-1500 AD (stone), Aztec / Muse de l'Homme, Paris, France / Bridgeman Art Library.

This part is devoted to the development of Web applications using Java. Chapter 32 introduces the use of Java to develop database projects, Chapter 33 introduces advanced features of Java database programming, and Chapters 34 and 35 introduce how to use Java servlets and JSP to generate dynamic contents from Web servers. Chapter 36 introduces high-level network programming using remote method invocation.

[Page 1092]
Prerequisites for Part 8

You can cover Chapter 32 after Chapter 16, "Applets and Multimedia," and then cover Chapters 34 and 35. Chapter 33 is an optional chapter, which can be skipped completely. Chapter 36 can be covered after Chapter 16, "Applets and Multimedia."

Chapter 32 Java Database Programming

Chapter 33 Advanced Java Database Programming

Chapter 34 Servlets

Chapter 35 JavaServer Pages

Chapter 36 Remote Method Invocation

[Page 1093]

Chapter 32. Java Database Programming

Mayan God Shel, Mexico. Photographer: Philip Coblentz. Courtesy Brand X Pictures.

Objectives

To understand the concept of database and database management systems (32.2).

To understand the relational data model: relational data structures, constraints, and languages (32.2).

To use SQL to create and drop tables, and to retrieve and modify data (32.3).

To learn how to load a driver, connect to a database, execute statements, and process result sets using JDBC (32.4).

To use prepared statements to execute precompiled SQL statements (32.5).

To handle transactions in the Connection interface (32.6).

To explore database metadata using the DatabaseMetaData and ResultSetMetaData interfaces.

[Page 1094]

32.1. Introduction

You may have heard a lot about database systems. Database systems are everywhere. Your social security information is stored in a database by the government. If you shop online, your purchase information is stored in a database by the company. If you attend a university, your academic information is stored in a database by the university. Database systems not only store data, they also provide means of accessing, updating, manipulating, and analyzing data. Your social security information is updated periodically, and you can register in courses online. Database systems play an important role in society and in commerce.

This chapter introduces database systems, SQL, and how to develop database applications using Java. If you already know SQL, you may skip 32.2 and 32.3.