Using Java and PHP technology for development in Aix Version 5.3, part 3rd

Part 3rd: Integrating Java Business applications with db2version 9

Introduction: Applications that use Java™ and PHP technologies can be developed in aix®. While gaining the benefits of using PHP as a web-based interface platform, you can write core logic (or redeploy existing java-based applications) using the Java programming language. In this article (part 3rd of the series), we describe how to connect the core applications created in part 2nd to the db2® database to store questions and answers to the questionnaire.

About this series

PHP is a very good web development language, and Java™ programming languages are popular in business application development. Therefore, in order to fully utilize their advantages on the Aix®version 5.3 operating system, PHP Java Bridge is specially developed. The purpose of this series of articles is to enable AIX 5.3 developers to integrate PHP and Java technologies faster in the development of Web applications.

To illustrate this, you will build a simple survey application based on the typical development process, including:

Developing a major Java application

Exposing Java applications as Java-based Web applications through the Servlet

Adding support for storing information in a database

Exposing the original application as a Web service and providing the PHP interface for the application

Re-developing the PHP interface with a dedicated PHP Java bridge

This series of articles consists of six parts:

Part 1th describes an application and sets the environment for building Java applications and for performing Java-based Web applications using Tomcat.

The 2nd part introduces the main application code and the development of a simple Java servlet to provide a web interface for information.

Part 3rd connects the core application to the db2® database to store the questions and answers to the questionnaire survey.

Part 4th transforms the original application so that it can be accessed as a Web service, and it provides the basis for the PHP interface.

The 5th part uses PHP Java Bridge to build the PHP interface for Java applications.

The 6th part is to recreate the application to use PHP Java Bridge instead of the Web service interface.

Introduction

This article integrates the Java Business application created in part 2nd with the DB2 Version 9 database. Data is submitted to a Java business application, and you can use the stored data to provide statistical information about the answer to the questionnaire.

The content of this article includes:

Use of database in questionnaire survey application

Install DB2

Database structure

Create a database table

Inserting data into a table

Provide a report based on the data that is stored

Database role