 | Level: Intermediate Tyler Anderson (tyleranderson5@yahoo.com), Freelance Writer, Stexar Corp.
25 Apr 2006 Since OpenLaszlo's open source announcement,
many developers have been using OpenLaszlo to create
user-friendly rich Internet applications. Many of these
applications require a database solution to have dynamic
data fed to them. Because OpenLaszlo runs on Apache Tomcat
by default, which supports JavaServer Pages (JSP) and
servlets (Java™), Apache Derby is an excellent
database to use because it can be embedded in such
applications and because Derby is written in pure Java code.
In this tutorial, you'll build a management interface to the
online shopping console created in Part
1. You'll also allow orders to be written to the
database and enable management to edit, delete, and add new
items to the database via the OpenLaszlo user interface (UI).
Objectives
When you complete this tutorial, you'll be
proficient in OpenLaszlo, be able to communicate with a
database, and know how to insert, update, and delete
data from the Apache Derby database using the OpenLaszlo
markup language.
Prerequisites
None
System requirements
You need the following tools to follow along with this tutorial:
-
OpenLaszlo -- This tutorial uses the latest
version of OpenLaszlo, version 3.1. Download
OpenLaszlo 3.1, and get installation instructions
for your operating system.
-
Apache Derby -- Download Apache Derby,
ensuring that the .jar files you receive are added
to your CLASSPATH.
-
IBM DB2® drivers -- Download IBM
Cloudscape™ (IBM DB2 JDBC Universal Driver,
for Cloudscape/Derby) to connect to Derby. Make sure
to add the drivers to your CLASSPATH.
-
Java SDK -- OpenLaszlo, Apache Derby, and the
DB2 drivers require the Java platform. This tutorial
uses Java 1.4.2_09; however, any version later than
this should suffice. Download the Java SDK from Sun Microsystems.
This tutorial was written on a Microsoft®
Windows® operating system, but the differences
should be minimal, if any, if you're using a different
operating system, such as Linux®.
Duration
Under 2 hours
Formats html, pdf
| | | |
