The following web pages introduce important concepts for working with relational databases in the Java programming language. They explain details required for creating and accessing database information using the NetBeans IDE and the Apache Derby database manager.
This web page describes the basic ideas behind relational database. It focuses on how database tables can be used, with a quick overview of how Structured Query Language (SQL) provides access to database data. It uses a simple Cars database as an example.
This PDF is a one page summary of the Cars database and its SQL ownership view.
SQL is a very complex language, but you can do a lot with a few frequently used commands. This is a brief description of those commands.
Most programming languages define interfaces for interacting with a database Organizations that develop database managers can then develop implementations of these interfaces. Java Database Connectivity (JDBC) is the Java interface to SQL. This web page describes how to use JDBC. It includes a Java file for reading SQL into a program so that it can be executed with JDBC.
Forthcoming.
This web page summarizes the frequently used SQL commands. For each command, it shows how JDBC is used to execute the command in a Java program. It is brief but has links to more information from the documentation pages for the Apache Derby database.