The technology JDBCTM API (Java Database Connectivity) provides the open industry standard for connecting applications written in Java language for relational databases.
The objective of this publication is to provide a fast and useful, but especially handy tool for learning to developers and professionals who are beginning to develop desktop applications GUI (Graphical User Interface) Basic to access relational databases.
In general is aimed at anyone who feels the need to educate oneself in the field with a basic knowledge of Java and Swing components as well as databases, in particular MySql AB server or Microsoft Access.
It is not a tutorial nor a collection of practice but a set of fundamental practical applications that serve to channel in the right ways developing graphical desktop applications for the management of relational databases.
As database server for testing applications has been used MySql AB, well known open source database. It is also illustrated access to the database desktop Microsoft Access.
In the first 2 chapters are conducting an overview of JDBC API and serve the reader as guidelines for understanding examples and as a reference to the theoretical aspects from possibly deepen.
In practice in the following publication is described as a step by step to develop Java GUI application covering all aspects:
It is shown how the package Netbeans5.5 or Netbeans6.0 permits from the environment IDE to connect to MySql through a DBExplorer module to create databases and run the SQL statement.
After reading this publication has the mindset to set up and develop graphics applications dealing with relational databases and perhaps deepen studies to write applications of a certain complexity.