| Location | A4-106 |
| Time | November 9, 14.30-16.15 |
| Subject |
In the last lecture we look at how to combine information stored in two or more tables
using the SELECT's various options for joining tables. In addition,
we will design a simple and general Java class that can be used to both query and
modify
an underlying database table. Such mapping from Java to SQL is normally done by a tool. We
will look at what it is the tools actually do. To make a tool it is handy to be able to
look at the metadata for both a table and a ResultSet.
|
| Reading | "Database System Concepts" Chapter 4.7 and Chapter 4.10. Here views and joins are
introduced. "JDBC and Java" pages 57-91 (you may skip the section "Stored Procedures" pages 60-62.
Here JDBC ResultSets are introduced. Here the advanced parts of the ResultSet
class is introduced and later on the metadata capabilities.
|
| Exercises | Exercise |
| Slides |