Di Wang's Internship Project
Web Service Based Data Management System with AJAX Dashboard
Background
This project was done at Infosys Technologies Ltd., Bangalore, India, through September 2006 to April 2007.
I have been there as a software engineer intern in Consultant Solution Delivery Group for eight months.
This project aims at helping Help Citi Group boost new web-based data management system, in order to increase data process efficiency.
Sample Source Code
insertRecords.java - A java file (Servlet, JSON are used) that handles data
insertion service.
insertData.jsp - A JSP file that handles data insertion web page.
insertData.js - A JavaScript file (dojo widgets are used )that handles
client application accordingly.
insertDialog.css - A CSS file that defines style sheet of data insertion
web page
DBAccessWSClient.java - A Web Service client that invokes
corresponding Web Services
System Design
In short, this project is built on AJAX-J2EE-DB2 architecture. The high-level design is shown in the following figure:
We can see there are mainly three layers:
Here is the rich client application, implemented with Ajax, JavaScript and HTML techniques.
We used dojo toolkit to provide powerful user interfaces.
This layer has two web servers, one is for serving Ajax requests, and the other is for communicating with the data layer.
The Ajax web server is implemented with JSP/Servlet, which is deployed in J2EE web container. (We used Apache Tomcat.)
The Web Service server has two main responsibilities. First, it publishes data management functionalities as standard Web Services.
(Axis 2 was used here). Second, it employs JDBC combined with Database Connection Pool to deliver data from the data layer,
using JDBC for DB2 and Apache DBCP.
This layer is responsible to provide data management services, including common database operations and user-defined data
processes.
Dashboard Demo
Here we only demonstrate several user interfaces constructed with Ajax.
Table Definition Module
Insert Data
Modify Data
