Programmer Books

Java 6: JDBC and database applications

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

You can also get this PDF by using our Android Mobile App directly: