Java 6: JDBC and database applications

Description

This book is the sixth in a series of books on software development. The subject is database applications, and how to write programs in Java that uses a database. As the database is used MySQL. The book has an appendix that provides a quick introduction to SQL and describes the most basic syntax. The book assumes a basic knowledge of Java corresponding to the book’s Java 1, 2 and 3 in this serie.

Content

1. Introduction
   1. About surrogate keys
2. JDBC
   1. HelloJDBC
   2. Exercise 1
3. Database operations
   1. SQL statements
   2. Exercise 2
4. ResultSet
   1. Update a ResultSet
   2. Municipalities and zipcodes
   3. Exercise 3
   4. Problem 1
   5. Stored procedures
5. Data types
6. Transactions
   1. Bach updates
   2. Exercise 4
7. The component JTable
   1. The demo program
   2. Problem 2
8. Files in databases
   1. Exercise 5
9. DDL commands
10. Final examples
    1. World
    2. MyWines