Scribd
Upload
58 views3 pages

MySQL Connector Java Exam Guide

This document provides instructions for a final exam practical question on website implementation. Students are asked to: 1. Choose a real-life case study and design a database in MySQL Workbench with at least one table and three rows of data. 2. Create an HTML homepage and Java servlet to build a dynamic website connected to the database using JDBC. 3. Include a button on the homepage to insert, delete, or update a row in the database table. Display the table to confirm the database operation was successful. The question is worth 20 marks total and evaluates skills including database design, building a dynamic website, and performing CRUD operations on the database through Java and JDBC.

Uploaded by

Sajjad Saeed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
58 views3 pages

MySQL Connector Java Exam Guide

This document provides instructions for a final exam practical question on website implementation. Students are asked to: 1. Choose a real-life case study and design a database in MySQL Workbench with at least one table and three rows of data. 2. Create an HTML homepage and Java servlet to build a dynamic website connected to the database using JDBC. 3. Include a button on the homepage to insert, delete, or update a row in the database table. Display the table to confirm the database operation was successful. The question is worth 20 marks total and evaluates skills including database design, building a dynamic website, and performing CRUD operations on the database through Java and JDBC.

Uploaded by

Sajjad Saeed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 3

Issue 18/08/2011 Revision Date 10/06/2015 Ref No. ECT-ACAF-ACAFO- FRM.

029

Final Exam

Questions 1 2 3 Total
Point 10 10 20 40
Student
Mark

1
Issue 18/08/2011 Revision Date 10/06/2015 Ref No. ECT-ACAF-ACAFO- FRM.029

Final Exam
Question 3: Website implementation (20 Marks)

Exam instructions:
1. Download the “Final Exam” practical questions word file from the Moodle.
2. Download the final exam word file “Answer Sheet” from the Moodle.
3. Copy/paste your HTML and java code as well as your website screenshots (if exist!) in your word
file “Answer Sheet”.
4. Submit your word file “Answer Sheet” to the Moodle Turnitin.
5. Submit your full website as a zipped folder to the Moodle website.

The goal is to design and implement a dynamic web java application connected to MySQL database.
For this purpose, each student should choose a real-life case study and implement its website. For
example: Hospital, University/College, Pharmacy, Clinic, Airport, Hotel, Travel Agency, Car Rent
Agency, Embassy, Ministry, etc.

Note: Students are not allowed to use any example / case study from the class or lab exercises already
done, but they should suggest another different case study with different java website.

We will guide you by the following steps to achieve your goal:

1). Create a database for your case study using MySQL Workbench. It should include at least one table
with minimum three attributes, one of them is the primary key. (2 marks)
2). Create your database table and insert three rows at least. You can create a script file (“table.sql”)
including the table creation and the data insertion. Then, load this script file into your MySQL Server.
(4 marks, 2 for creation and 2 for insertion)

3). Create your web Java application including at least the website homepage (file “index.html”) and a
java servlet (file “servlet.java”). (8 marks: 3 for “index.html” and 5 for “servlet.java”)

2
Issue 18/08/2011 Revision Date 10/06/2015 Ref No. ECT-ACAF-ACAFO- FRM.029

Final Exam
4). Connect your web java application to your database using the JDBC driver available on Moodle
(mysql-connector-java JAR 8.0.20). Test your connectivity by showing your database table from the
NetBeans. (3 marks)

5). In the file “index.html”, each student chooses to implement ONE of the following submit buttons:
(2 marks)
- Button “Insert”, when clicked by the user a row is inserted in the database table and a
message is displayed to acknowledge the success of the inserting process.
- Button “Delete”, when clicked by the user a row is deleted from the database table and a
message is displayed to acknowledge the success of the deleting process.
- Button “Update”, when clicked by the user a row is updated from the database table and a
message is displayed to acknowledge the success of the updating process.

In each case of Insert, Delete or Update display your MySQL database table to show and confirm the
success of each process. (1 mark)

You might also like