Efficient creation of secure Java applications, part 1th

Using Rational application Developer and Data Studio

This tutorial is part 1th of how to use Rational®application Developer, Data Studio, and Rational AppScan to build a Java-Safe WEB Application Series tutorial two.

Preparatory work

This article describes how to build Java-and database-based application development using the PureQuery features of Data Studio and use Rational application Developer to quickly build java-based Web applications. Mastering the knowledge of JSP and WEB development is good for your understanding, but not the skills you must master.

About this series of tutorials

There are two parts in this series that expand your WEB application development skills by introducing how to use rational application Developer, Data Studio, and rational appscan.

The 1th part quickly creates a Java-based property management application using the integrated development environment of the Rational application Developer and the pureQuery features of Data Studio.

Part 2nd uses Rational AppScan to discover and fix security vulnerabilities that make your system more secure and reliable.

About this tutorial

This tutorial will show you how to use Data Studio to automate the creation of reliable database connection classes more quickly and efficiently. Efficiently create java-based WEB applications using Rational application Developer and Data Studio, and to the WebSphere application server. You'll learn how to use Rational application Developer and Data Studio to create and program applications, including the following:

Creating a DB2 database connection

Create a Dynamic Web application based on PureQuery

Generating PureQuery code from a database table

Add pureQuery Customer Query code

Using the PureQuery class to generate JSP pages

To the WebSphere application Server and test

You will learn and apply these concepts by creating a property management Web application that allows users to log on to the system and view their property. The Yahoo! Finance API is used to capture the real time value of the owning stock and options. You can also create a form manually and add new ownership of the property.

System Requirements

You will need the following three products to complete the example of this tutorial:

Rational Application Developer

Get Rational application Developer from the IBM website (click to download (recommended) Link using the new IBM installation Manager). The Rational application Developer is an IDE based on all Eclipse features that you can use to develop your Java WEB application.

Data Studio

This is a free plugin that includes all the features of pureQuery and you can use it as a database driver for application development. This requires a version of 1.1.2 (the only version that is compatible with the Rational application Developer 7.0.0.6).

DB2 express-c

Data Studio needs to establish a database connection to generate PureQuery code. This uses the database DB2 express-c.

Note the compatibility of the rational application Developer and data studio versions (for example, rational application Developer 7.0.0.7 and data Studio 1.1.3, If there are these two versions). Learn about compatibility between versions, referring to IBM documentation. The latest version, the Rational application Developer 7.0.0.6 and the Data Studio 1.1.2 are mutually compatible.

Install Rational application Developer and Data Studio to the same package group

Before you start using Rational application Developer and Data Studio, you need to install them to the same package group. The next step is to confirm that you have used the correct version of each product.

You will also be installing the DB2 express-c database, although this section will not be involved in this article. After you create a new database and datasheet, manually insert new rows of data by double-clicking your newly created table in control center.

Install Rational application Developer

Reference Prerequisites use IBM installation Manager to download and install the software you need through your installation options.

When you click on the file you downloaded, you will see the following illustration:

Figure 1. installation package