In this document, we describe a simple application that keeps track of payments made to client accounts. Setup: The current version of the application is configured to use an HSQLDB database (although connections to a MySQL database and an MS Access database are also included in comments at the beginning of ClientBillingDB.java).

To use an HSQLDB, download the HSQLDB system from http://hsqldb.sourceforge.net/ and copy hsqldb.jar into the JRE lib/ext folder (this jar file is also included in the HSQLDB folder). A sample database (clients.properties and clients.script) has been included in the project folder.
To use a MYSQL database, download the MYSQL server from http://www.mysql.com/, install the server and create the database. A script that creates the database has been included in the MYSQL folder in the project folder. If MYSQL is used, it is worthwhile downloading the MYSQL Control Center which provides GUI access to the databases. To use an MS Access database under Windows, an ODBC connection that links the database, “clients.mdb”, and the logical database name used in the system, Clients, must be defined. ODBC connections are defined in the control panel (ODBC) on earlier versions of Windows and are defined in “DataSources (ODBC)” in the Administrative Tools section of the Control Panel in more recent versions of Windows.

Download pdf Client Billing Application