Hey there!

I currently working with mySQL and JSP to build an eCommerce site for a fictional company selling components for desktop computers. The project is part of my course at the university.

In the database we have made a superclass products, with the following subclasses: harddrive, monitor, graphic cards etc.

In the user interface, when adding new products, I want the user to be able to select what kind of product to add (i.e. what subclass to use). The question is, how can I query the name of the subclasses, so I don't have to put the name of any potential new subclass into the jsp code?