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.
View Answers
Ads
Related Tutorials/Questions & Answers:
retrieve record from table
retrieve record
from table Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to
retrieve these data
from the field
table. Actually
Advertisements
retrieve record from the field table
retrieve record
from the field table Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to
retrieve these data
from the field
table
How to retrieve record from table
How to
retrieve record
from table Hi. I have a field in database named stages. its datatype is varchar(60). It contains values chennai,trichy,kanchipuram for a single record. I have to
retrieve these data
from the field
table
Retrieve multiple data from database into Table.....
Retrieve multiple data
from database into
Table..... hi...........
I want to
Retrieve multiple data
from database into
Table but i am not able to....
i am only able to
retrieve one value not more than that. means
in my
retrieve record from table and show it in HTML
retrieve record
from table and show it in HTML Hi. I have a field...,trichy,kanchipuram for a single record. I have to
retrieve these data
from the field
table. Actually they are separated by comma. I want to take the values
I have to retrieve these data from the field table
I have to
retrieve these data
from the field table Hi. I have... chennai,trichy,kanchipuram for a single record. I have to
retrieve these data
from the field
table. Actually they are separated by comma. I want to take the values
HTML & MYSQL - retrieve record from table
HTML & MYSQL -
retrieve record
from table Hi. I have a field...,trichy,kanchipuram for a single record. I have to
retrieve these data
from the field
table. Actually they are separated by comma. I want to take the values as single
MYSQL retrieve record from Data table
MYSQL
retrieve record
from Data table Hi. I have a field in database...,kanchipuram for a single record. I have to
retrieve these data
from the field
table. Actually they are separated by comma. I want to take the values as single
how to retrieve data from table with runtime values in sql?
how to
retrieve data
from table with runtime values in sql? how to
retrieve data
from table with runtime values in sql?
For example,
I have
table... to execute the command with the dates which I pass.
I know how to
retrieve a particular
Select data from Table in Database
the selected data
from table in database. The
select query in the database
retrieve...; in simple select statement is given
below
select column
name from table...
table.
select *
from table;
The select query
retrieve all the column present
retrieve data from database with hyperlink
retrieve data
from database with hyperlink sir....i have one
table called '
name' having two values i have to
retrieve those data with a hyperlink... can i do it..help me sir its urgent.......?????
for example-in
table '
name' i
Data retrieve from mysql database
Data
retrieve from mysql database Hi sir,
please give some example... code retrieves the
employee name in the dropdown. When the user selects any
name...+"?
name="+
emp_value
xmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url
retrieve from database........
retrieve from database........ <p>hi i am not able to
retrieve...,password);
String query = "select *
from employee";
st = con.createStatement...", "root", "root");
String query = "select *
from employee where id
how to retrieve a checkbox value(retrieve from DB)
retrieve those value
from another database
table? the
table subject and service below is what I want. But based on the code below the SERVICE
TABLE on SUBJECTID...how to
retrieve a checkbox value(
retrieve from DB) I facing
retrieve data from mysql database
retrieve data
from mysql database hi am not familiar in php.....even though i want to create
combobox effectively.... my query is that when i have selected value on
combobox which is to be
retrieve the relevant data
from mysql
Retrieving All Rows from a Database Table
All Rows
from a
table!
Emp_code:
Emp_
name:
10 ... string type parameter for executing the SQL statement.
SELECT *
FROM table_
name...
Retrieving All Rows
from a Database
Table
retrieve data from database using jsf
retrieve data
from database using jsf Hello
I want an example of source code to
retrieve data
from database
i have a database (oracle)
name as db1...),,
name ,and city
I want after enter value in textbox according idauthor i
retrieve
How to retrieve image from database
How to
retrieve image
from database hi........
How to
retrieve image
from database when it is stored.
I have stored image in postgresql and want to
retrieve in java form.
Can u tel me hw to do?
I am trying n able to do also