Databases are an important part of many applications. In this web presentation a web application is developed that illustrates the use of the following tools:

• the NetBeans development environment,
• the Apache Derby database server.

In this example a Cars application is developed. Its development is broken down into three major steps:

• setting up a database
• building tables and adding test content to them
• developing the application

Complete versions of the NetBeans IDE are bundled with an Apache Derby database server. It provides support for creating a Derby database and building tables in the database.

Complete versions of the NetBeans IDE are also bundled with GlassFish server. In addition to its primary function of hosting web applications, it provides support for creating connection pools. A connection pool is made available to a web application by defining a resource. The resource can then be accessed by JSF managed beans using resource injection to get connections.

There are five tables in the database:

• the person table
• the manufacturer table
• the model table
• the car table
• the ownership table

The SQL files for building these tables can be downloaded here.

Forthcoming