2 of 2
Paper No: 1
Field Name Type
userID
Constrain
Primary key,
varchar(50)
not null
fullName nvarchar(500) Not null
roleID
char(2)
Not null,
Default 'MB
password varchar(50)
Not null
Description
ID used for system login
Member's full name
User roles in the system:
AD-Administrator; MB-Member
Password used for login
2. Fashion table: tblFashion
Field Name Type
Constrain
id
char(5)
Primary Key,
not null,
name
nvarchar(50)
Not null
description nvarchar(500) Not null
Validation Description
format:F-XX-Theproduct code consists of 5
characters, the first character is the letter F and the
last 3digits are numbers, describing the
conventional order in production.
Product name
Interpretation information
Price of the product in numeric format
Size, specifications
price
float
Not null
size
nvarchar(50)
Not null
status
bit
Default 0
With two values: 1- In business; 0 - Temporarily
suspended
Requirements:
Create a Java web application, which can be used to manage the Fashion. The application have
the following functions:
1. Login Logout.....
1.1. Login
[4.00]
1.1.1. On login.jsp page, user enters userID and password to login system, These fields
cannot be left blank and must use the appropriate input type........
0.5d
1.1.2. if the userlDor the password is incorrect, the error message will be display like this
"Invalid user or password"...
0.5d
1.1.3. if the userID with the password is correct, then grant the access permission, Set up
a session and retain the essential account information required for the upcoming
featuresthen go to welcome.jsp page...
1.0d
1.2. Welcome
1.2.1. After successful login, the user is redirected to welcome.jsp, where a welcome
message is displayed in the format: 'Welcome[fullName] I'. This message must also
be shown on all functional pages accessed after login...
0.54
1.2.2. The links allow the user to choose to go to the search.jsp page or log out of the
system.
1.3. Logout
0.5d
