 | Level: Intermediate Nicholas Chase (ibm@nicholaschase.com), Freelance Writer, Backstop Media
13 Sep 2005 Build a calendar and reminder application using the Java language and the Apache Derby database in Part 1 of this three-part tutorial series. This tutorial starts by showing you how to install the database and exploring interactions with it through Java Database Connectivity (JDBC). Parts 2 and 3 will examine different options for including Derby in your application and Derby's transactional capabilities as we move from a single-user to a multiuser system. Finally, we'll move to a multimode system that includes a Web interface. In this tutorial
- Calendar overview
- Setting up the database
- Inserting data: events
- Selecting data
- Updating data
- Inserting data, revisited
- Setting reminders
Prerequisites
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.
System requirements
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.
Duration
Under two hours
Formats html, pdf
| | | |
