I need assistance with this Java Project

Project Additional Database and GUI: $21$

Create an application using the same concept as Book App from Chapter $21.$ ch$21\_$ProductManager. Except use a GUI $($Swing$)$ and use MySQL database.

A possible GUI might be as shown below:

Specifications

GUI will need to List all Products

GUI will need to add and delete products

Same concept as ch$21\_$ProductManager

A database will be supplied $($murachdb$\_$prod.sql$)$

Thoughts $-$ a jTable was used for the listing of Products $-$ DbUtils object was used to format the information ex: jTable$1.$setModel$($DbUtils$.$resultSetToTableModel$($rs$))$; where rs is the ResultSet for the query

against the products table. You will have to import net.proteanit.sql$.$ DbUtils in order to do this you will need rs$2$xml$.$jar file in your libraries. This jar file is supplied for you in blackboard.

If you are using a MySQL database version $8\mathrm{.}0$ or later you will need the jar file mysql$-$connector$-$java$-8\mathrm{.}0\mathrm{.}11.$jar this is supplied in Blackboard