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 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.

Click here to download the source files from this book. 

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