Before you start
In this tutorial, you'll begin the process of building a calendar and reminder system that uses Apache Derby as its database back end. In Parts 2 and 3 of this series, you'll add two different user interfaces to the application; but for now the tutorial concentrates on accessing the data and on setting appropriate reminders using e-mail.
You'll learn about the following:
- Basic Derby concepts
- Installing and interacting with Derby in embedded mode
- Connecting to Derby using JDBC
- Adding data to Derby using JDBC
- Selecting and viewing Derby data using JDBC
- Updating existing Derby data using JDBC
- Using the Java language to send e-mail reminders
This tutorial was created under the assumption that you're familiar with programming in the Java language, but unfamiliar with JDBC and Apache Derby. Familiarity with SQL is helpful, but not required.
To follow along with this tutorial, you need:
- Java 2 Platform, Standard Edition (J2EE) 1.4.2 or higher. You must have the Java Developer Kit, not just the Java Runtime Environment (JRE). Download Java code from the Sun Web site.
- Apache Derby, which you can download from the Apache Software Foundation.
- JavaMail. To send e-mail reminders, you need mail.jar, which is now part of the Java package. You also need activation.jar, downloadable as part of the JavaBeans activation framework. Make sure both files are in your class path.
- A text editor or Integrated Development Environment (IDE). You can easily create Derby applications using an IDE, such as Eclipse, but I'm going to assume you're using a simple text editor.