Customer Support System
This application uses all major components of J2EE. It was used as project in J2EE batches
that started on Jan 20th, 2004.
This application contains two parts - one for customer and another for customer support team.
Operations that can be performed by customer
- Login
- Registering a complaint
- Query existing knowledge base
- Getting information about registered complaints
- Changing password
Operations related to customer support team
- CS team runs Messenger program that pop up a window whenever a complaint is registered by customer
- Sending mails to all customers
Operations, files and related objects
The following table lists operations and associated objects and files.
| Operation
| Files
| Related Objects
|
| Login
| login.html, login.jsp
| Customer javabean
|
| Home Page
| home.jsp
| Customer JavaBean
|
| Updation of Customer profile
| updateprofile.jsp
| Customer JavaBean
|
| Query Knowledge Base
| Querykb.jsp
| Customer javabean
|
| List of Current Complaints
| listcomplaints.jsp
| Customer javabean |
| Add a complaint
| complaint.html, addcompliant.jsp
| Customer javabean, Complaint EJB, complaints message topic.
|
| logout
| logout.jsp
|
|
The following programs are related to customer support team.
| Operation
| Files
| Related Objects
|
| A Swing application that displays a window when a complaint arrives
| Messenger.java
| complaints message topic
|
| A Swing application to send mails to all registered customers
| SendMails.java
| JavaMail
|
Installation Steps
The following are the steps to install this application in your system :
- Download cs.zip and unzip it into webapps directory of
Tomcat installation directory.
- Make sure you include Oracle driver classes in the classpath of Tomcat - use setClassPath.Bat file for this or copy classes12.jar( or classses111.zip) file into WEB-INF/lib directory.
- Create account custsup with password custsup in Oracle.
- Create required tables in Oracle using TABLES.SQL file.
- Create a connection pool in Weblogic for user custsup/custsup.
- Create a datasource with name - oracle and JNDI name oracle.
- Create a message topic - complaints.
- Build ejb in complaint directory - complaint bean is a stateless session bean. Before you build EJB copy file
EXAMPLES.PROPERTIES from SRC directory of examples into complaint directory.
- Copy comlaint_client.jar file from clientclasses directory of Weblogic to /WEB-INF/lib of cs application.
- Make sure Oracle, Weblogic Server and Tomcat are running.
- Run the application using the following url:
http://localhost:8080/cs
- You should see login page of the application.