Question

1. Create the following table in your database using this code (post the script directly in MySQL workbench window and then run): create table Employee ( );emp_id INT NOT NULL AUTO_INCREMENT, emp_name VARCHAR(100) NOT NULL, emp_email VARCHAR(40) NOT NULL, emp_address VARCHAR(40) NOT NULL, emp_position VARCHAR(40) NOT NULL, PRIMARY KEY ( emp_id) INSERT INTO Employee (emp_name, emp_email, emp_address, emp_position) VALUES ("Mary Smith", "smithm@strose.edu", "1234 Main Street, Albany, NY", "Director IT"); INSERT INTO Employee (emp_name, emp_email, emp_address, emp_position) VALUES ("John Pat", "patj@strose.edu", "12 Allen Street, Albany, NY", "Helpdesk Tech"); INSERT INTO Employee (emp_name, emp_email, emp_address, emp_position) VALUES ("Tony Gillian", "gillinat@strose.edu", "77 Manning Street, Albany, NY", "Network Analyst"); Note *** Employee ID is automatically generated and you do not need to enter that field when doing the insert (see the INSERT statements above). 2. Create a Java class that establishes a connection to your database and executes the following: a. Insert a new Employee into the table b. Update an existing Employee in the table c. Select all Employees from the table. d. Delete an Employee from the table. e. Select an Employee from the table using an Employee name from user input. Your code should output the contents of the database table after every SQL execution. Take a snapshot (screenshot) of the contents of the database table after every output (from the console or from the workbench). Submit the following documents in a zipped folder labelled yourlastname_HWK2.zip 1. Java code in the proper Java file (.java). 2. Snapshots of the contents of your database table.

          1. Create the following table in your database using this code (post the script directly in
MySQL workbench window and then run):
create table Employee (
);emp_id INT NOT NULL AUTO_INCREMENT,
emp_name VARCHAR(100) NOT NULL,
emp_email VARCHAR(40) NOT NULL,
emp_address VARCHAR(40) NOT NULL,
emp_position VARCHAR(40) NOT NULL,
PRIMARY KEY ( emp_id)
INSERT INTO Employee (emp_name, emp_email, emp_address,
emp_position) VALUES ("Mary Smith", "smithm@strose.edu",
"1234 Main Street, Albany, NY", "Director IT");
INSERT INTO Employee (emp_name, emp_email, emp_address,
emp_position) VALUES ("John Pat", "patj@strose.edu", "12
Allen Street, Albany, NY", "Helpdesk Tech");
INSERT INTO Employee (emp_name, emp_email, emp_address,
emp_position) VALUES ("Tony Gillian",
"gillinat@strose.edu", "77 Manning Street, Albany, NY",
"Network Analyst");
Note *** Employee ID is automatically generated and you do not need to enter that field
when doing the insert (see the INSERT statements above).
2. Create a Java class that establishes a connection to your database and executes the
following:
a. Insert a new Employee into the table
b. Update an existing Employee in the table
c. Select all Employees from the table.
d. Delete an Employee from the table.
e. Select an Employee from the table using an Employee name from user input.
Your code should output the contents of the database table after every SQL execution.
Take a snapshot (screenshot) of the contents of the database table after every output (from the
console or from the workbench).
Submit the following documents in a zipped folder labelled yourlastname_HWK2.zip
1. Java code in the proper Java file (.java).
2. Snapshots of the contents of your database table.

1. Create the following table in your database using this code (post the script directly in
MySQL workbench window and then run):
create table Employee (
);empid INT NOT NULL AUTOINCREMENT,
empname VARCHAR(100) NOT NULL,
empemail VARCHAR(40) NOT NULL,
empaddress VARCHAR(40) NOT NULL,
empposition VARCHAR(40) NOT NULL,
PRIMARY KEY ( empid)
INSERT INTO Employee (empname, empemail, empaddress,
empposition) VALUES ("Mary Smith", "smithm@strose.edu",
"1234 Main Street, Albany, NY", "Director IT");
INSERT INTO Employee (empname, empemail, empaddress,
empposition) VALUES ("John Pat", "patj@strose.edu", "12
Allen Street, Albany, NY", "Helpdesk Tech");
INSERT INTO Employee (empname, empemail, empaddress,
empposition) VALUES ("Tony Gillian",
"gillinat@strose.edu", "77 Manning Street, Albany, NY",
"Network Analyst");
Note *** Employee ID is automatically generated and you do not need to enter that field
when doing the insert (see the INSERT statements above).
2. Create a Java class that establishes a connection to your database and executes the
following:
a. Insert a new Employee into the table
b. Update an existing Employee in the table
c. Select all Employees from the table.
d. Delete an Employee from the table.
e. Select an Employee from the table using an Employee name from user input.
Your code should output the contents of the database table after every SQL execution.
Take a snapshot (screenshot) of the contents of the database table after every output (from the
console or from the workbench).
Submit the following documents in a zipped folder labelled yourlastnameHWK2.zip
1. Java code in the proper Java file (.java).
2. Snapshots of the contents of your database table.

Added by Sara D.

Question

Please give Ace some feedback