Question: retrieve Dept Name from table dept and retrieve list of employee from emp table for that dept in combobox
I have an 2 textboxes and 1 combobox in my HTML page.
user will provide the input in one textbox then JSP code should retrieve data from database from table1 and display it in another textbox and from the same input paramter then its should retrieve the data from another table and display that list in combobox.
For example, In HTML page, we have Dept ID Textbox (Input Paramater), Dept Name Textbox, and Employee combobox.
If user enter 10 in Dept Number Textbox and onblur event,it should retrieve Dept Name from table dept(select deptno,deptname from dept where deptno=10) and retrieve list of employee from table emp for that dept in combobox using this query (select ename from emp e,dept d where e.deptno=d.deptno and d.deptno=10)
Out Put should be as below In Dept ID textbox it should be 10 In Dept Name textbox it should be Sales In employee Combobox,list of employee in dept 10
Can anybody help me in writing the JSP code for this.