The goal of this project is to guide student to design and implement a dynamic website using J2EE technology. The required website should include HTML5 code, CSS3 syntax, Java class, JSP page, Servlet page and MySQL database. For this purpose, we ask you to complete the following tasks.

Note: You are not allowed to use any example or case study from the class or lab exercises already done. But you should suggest another different business process for real-life company to implement the required dynamic website.

Task 1: Business Scenario Description (2 marks)

Choose an example of real-life company and describe its business scenario useful to design and implement a dynamic website. For example, this company may be baby gift (write details about website )

Task 2: Website Database (3 marks)

(1). Create the MySQL database including at least one table with minimum five attributes. (1.5 marks)

(2). Connect your website to this database using Java Database Connectivity (JDBC). (1.5 marks)

Task 3: Website Java class (5 marks)

Create the website java class denoted (e.g., customer.java) including the following:

1. At least 3 encapsulated private attributes. (1.5 marks)
2. A constructor by default. (1 mark)
3. A constructor with at least 3 parameters. (1 mark)
4. Apply Accessor and Mutator to each encapsulated attribute. (1.5 marks)

Task 4: JSP webpages and Servlet (11 marks)

(1). Create your index.jsp page, which is the homepage of the website and includes the main information about your real-life company. This page should include: (4 marks)

• A code HTML forms that contain several controls such as label, text boxes, check boxes, radio buttons, combo boxes, list boxes, buttons (Submit, Reset, Validate), etc. to send data to the servlet.
• A link to the external Cascading Style Sheets (CSS) file that provides the formatting of the webpage content and layout.
• A navigation bar (designed horizontally or vertically) containing links, via buttons or hyperlinks, to the other JSP webpage(s) described in question (2).
• A header file (header.html) containing the website title such as Abu Dhabi International Airport. This HTML external file should be imported in the file index.jsp.
• A short paragraph describing the whole website.
• An image such as the company logo.
• A footer file (footer.jsp) including the Copyright information and the last date of the website update. This JSP external file should be imported in the file index.jsp.

(2). The Booking.jsp page containing a web form based on the information existing on the database table. The customer should complete the required booking information before submitting his form. Then, this page will be redirected to the servlet page. (4 marks)

(3). A process of data validation is performed by the servlet page to check if the inserted data are acceptable or not: (3 marks, 1.5 for each)

1. In case of wrong inserted data, the website should redirect the customer to a new page Error.jsp including information about the wrong booking. Link this page to your external CSS file.
2. In case of successful inserted data, the website should redirect the customer to a new page Confirmation.jsp including a notification letter congratulating the success of his/her booking process. Link this page to your external CSS file.

Note:

After running your website code using NetBeans software, copy your Java programs, file-by-file in this word file, and then provide all screenshots of your code output. If you cannot achieve the output of your execution, you provide only the code without the screenshots.