Connect to Apache Derby database

I would like to show a simple example, how you can set up Apache Derby on your local Windows machine and connect to it with Java code to write and read data. It is a lightweight relational database management system.

Create a new class and initialize connection with connection string.

I use System.currentTimeMillis() method to create a differently named database in each execution.
After that you need to write necessary SQL queries and store those in String objects.

These will be executed as Statements.
You can check also the whole code, which is needed to establish a database connection, create a database, a table and get data from it.

Related posts:

Out of all the emotions, sensations, feelings, moods, and states of mind that a human can experience, probably the most discussed topic is pleasure and pain. Pleasure and pain are considered by some…

I had to drive across town to give ID documentation to a law firm I’m instructing. They took my documentation, photocopied it and filed it somewhere in their back office. Great… yet another company I…

Hardly anyone ever sees the classic “Virus” now days. Spyware and Trojans are way bigger threat today. Therefore, criteria’s by which antivirus software and security suites should be measured have…