Help with this please!

We need to use Java to code this assignment which invlolves processing SQL code in Java. I'm currently using the Java JDBC to program this.

Exercises

All operations will be performed on the Mall database.

1. [5 pts] After each of the query operations listed here, display relevant results. When executing the users currently built SQL statement, display all the tuples returned.

2. Provide the user with a menu system that facilitates the following operations.

[5 pts] Entering a complete SQL command. Note, this would only be useful to users who know how to write SQL statements. Inexperienced users would leverage the other options.

[5 pts] Selecting a table from the list of relations.

[5 pts] Once a table has been selected, selecting columns from the table.

[5 pts] Executing the currently built SQL statement as a query from the table/column(s) selected.