In java please

Project $19-2$: Products by Category Create an application that accepts

in java netbeans please

a category id and displays the products in that category from the tables in a database. Console Products by Category CATEGORIES $1-$ Guitars $2-$ Basses $3-$ Drums Enter a category id $(999$ to exit$)$: $2$ BASSES Code Name Price $--------------------------------------------------------------$ precision Fender Precision $$799\mathrm{.}99$ hofner Hofner Icon $$399\mathrm{.}50$ CATEGORIES $1-$ Guitars $2-$ Basses $3-$ Drums Enter a category id $(999$ to exit$)$: $3$ DRUMS Code Name Price $--------------------------------------------------------------$ ludwig Ludwig $5-$piece Drum Set with Cymbals $$699\mathrm{.}99$ tama Tama $5-$Piece Drum Set with Cymbals $$799\mathrm{.}99$ CATEGORIES $1-$ Guitars $2-$ Basses $3-$ Drums Enter a category id $(999$ to exit$)$: $999$ Bye!Corrsolet

in :

then $1$

Specifications:

$$itili