Dynamic data retrival from the database using jsp and java
Posted on 2004-09-30
I have two sucessive dropdowns that are being populated from the database individually. Now I need to modify the dropdowns so that by selecting a value in the first dropdown should bring its relevant data in the second dropdown from the database in the same page.
Table A has User ID, User Name and List of Books owned by the user, the user name and List of Books are to be populated on the page and I have user id as parameter to be passed to the database. Database is oracle, and the coding should be in jsp and java files. So if I change the user name from the list of users obtained from the database, it should dynamically give me the list of books owned by that user in the second dropdown without a submit button.
This is a urgent requirement please reply.