Location | A4-106 |
Time | November 2, 14.30-16.15 |
Subject |
In the last lecture we look at how to create tables and insert, update, or delete information
stored in these tables. In this lecture we will look at how to query (read from) the database.
There is basically only one SQL statement for reading data, which is the SELECT
statement, however, it is very powerful. This time we will look at the fundamentals of using
the SELECT . In the next lecture, we will go into further details.
|
Reading | "Database System Concepts" Chapter 4.1 to Chapter 4.6. Here the SELECT statement is
introduced. "JDBC and Java" pages 46-56. Here JDBC ResultSet s are introduced.
There is approximately a one-to-one correspondence between an SQL SELECT statements
and a single Java object of the ResultSet type.
|
Exercises | Exercise |