how to display data in database in dropdown list using java

See more:

Java

JSP

Hi all,

Let make an illustration. Assume I have two tables in database like below
1) table Report
-report_id
-report_name
2) table OptionReport
-option_id
-option_name
-report_id

One report_id can have many option_name. I have to display report_id, report_name and option_name but for option_name, I need to display in dropdown list. The problem is I don't know how to display data of option_name in dropdown list based on its report_id. I have to do this by using java.

Thanks for any advice and helps