Customer Online Support

HelpDesk Application Using JSF

HelpDesk is a meshing based customer support system. It allows customers to do the hobby:
guest must first register the harvest. We have one-to-one kin between prodcut and customers. At the time of registration, customer details and product serial number are taken.
Customer lavatory login later registration.
Customer can post an issue related to the proudct he registered.
Customer can reaction to an issue affix by other customers. They can also reply to a reply condition by support personal
Customer can replace his/her password
If customer forgets password, customer can recover the password
Customer can search for issues based on title of the issue and assist all the details of the issue.
Technologies and Products Used
In order to develop this occupation we are going to use the following technologies.
JSF framework
JDBC
DAO design innovation to access database
Oracle database 10g Express Edition
JavaMail API
Mail Server - CMail Server
Tables Structure
The following are the accedes required for this application.
CUSTOMERS Table
Contains details of all registered customers.



Create this table using CREATE display panel command as follows:
draw table customers
(
customerid number(5) primary key,
loginname varchar(20) unique,
password varchar(10),
reg_date date,
email varchar(50) unique,
serialno varchar(50) unique
);
ISSUES Table
Stores all issues posted by customers. Create this table with the following CREATE TABLE command.
stimulate table Issues
(
Issueid number(5) primary key,
customerid number(5) references customers(customerid),
issuetitle varchar(100),
issuedescription varchar(2000),
postedon date,
status char(1),
resolvedon date,
supportperson varchar(20)
);
ISSUERESPONSES Table
Stores all responses given either by support persons or by customers.
create table IssueResponses
(
IRId number(5) primary key,...If you want to get a ample essay, order it on our website: Orderessay



If you want to get a full essay, wisit our page: write my essay .