Hi$,$ I$\text{'}$d like you to answer this lab with every code that I need to write, there was a solution but it was not solved by coding. I$\text{'}$m using NetBeans with MySql to access php admin.

so please write the code for each file and if there is a filed where i need to add the path depending on my computer just add a comment to let me know.

Spring $2024$

Lab $7$

Objective:

The objective of this lab exercise is to know about JDBC$.$

This lab maps to CLO#$3.$ This is a group homework.

Procedure:

Go through the handouts titled $"$JDBC$.$ppt$"$

Following the MVC architecture, we are going to build a web application that connects to a

database using JDBC to manage the database of employees in a company.

Make sure that you have a working connection before you start. Follow the installation

instructions in the $"$JDBC$\_$Setup.pdf$"$ document.

Create a database. Call it company.

From your MySQL Workbench, create a table in your database, call it employees. You may use

the following script:

create database company;

use company;

CREATE TABLE 'employees' $($

'emp$\_$id$\text{'}$ int$(11)$ NOT NULL AUTO$\_$INCREMENT,

'empname' varchar$(45)$ NOT NULL,

'password' varchar$(45)$ NOT NULL,

'position' varchar$(45)$ NOT NULL,

'email' varchar$(45)$ NOT NULL,

'salary' int$(6)$ NOT NULL,

PRIMARY KEY $(\text{'}$emp$\_$id$\text{'})$

;

Make sure that your primary key $(\text{'}$emp$\_$id$\text{'})$ is AUTO$\_$INCREMENT

Create a web$-$based application that connects to the company.employees database. This

application will enable the user to perform CRUD operations :

a$.$ Create a new employee record and add it to the table.

b$.$ Read and display the data of all employees in the table.

c$.$ Update the information of any employee in the table.

d$.$ Delete an employee record from the table.

You should follow the MVC architecture and choose your model $($EmployeeBean$),$ controller

$($servlet$),$ and view $($JSPs$).$

You should not have to use the back button in your application. Always include the start page at

any point after your response.

Run and test your application, then submit your project as a $.$zip file $($one submission per group$).$

Objective:

The objective of this lab exercise is to know about JDBC$.$

This lab maps to CLO#$3.$ This is a group homework.

Procedure:

$1.$ Go through the handouts titled $$JDBC$.$ppt$$

$2.$ Following the MVC architecture, we are going to build a web application that connects to a

database using JDBC to manage the database of employees in a company.

$3.$ Make sure that you have a working connection before you start. Follow the installation

instructions in the $$JDBC$\_$Setup.pdf$$ document.

$4.$ Create a database. Call it company.

$5.$ From your MySQL Workbench, create a table in your database, call it employees. You may use

the following script:

create database company;

use company;

CREATE TABLE 'employees' $($

'emp$\_$id$\text{'}$ int$(11)$ NOT NULL AUTO$\_$INCREMENT,

'empname' varchar$(45)$ NOT NULL,

'password' varchar$(45)$ NOT NULL,

'position' varchar$(45)$ NOT NULL,

'email' varchar$(45)$ NOT NULL,

'salary' int$(6)$ NOT NULL,

PRIMARY KEY $(\text{'}$emp$\_$id$\text{'})$

$)$;

$6.$ Make sure that your primary key $(\text{'}$emp$\_$id$\text{'})$ is AUTO$\_$INCREMENT

$7.$ Create a web$-$based application that connects to the company.employees database. This

application will enable the user to perform CRUD operations :

a$.$ Create a new employee record and add it to the table.

b$.$ Read and display the data of all employees in the table.

c$.$ Update the information of any employee in the table.

d$.$ Delete an employee record from the table.

$8.$ You should follow the MVC architecture and choose your model $($EmployeeBean$),$ controller

$($servlet$),$ and view $($JSPs$).$

$9.$ You should not have to use the back button in your application. Always include the start page at

any point after your response.

$10.$ Run and test your application, then submit your project as a $.$zip file $($one submission per group$).$