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
Related Tutorials/Questions & Answers:
retrieve record from tableretrieve 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 Value from Table - HibernateRetrieve Value
from Table Hai friend,
I need help, How can i
retrieve values
From database using hibernate in web Application. As I new to hibernate I couldn't find solution for this problem.. Can anyone help please..
retrieve record from the field tableretrieve 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 tableHow 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 HTMLretrieve 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 tableI 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 tableHTML & 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 tableMYSQL
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;ADS... in the syntax
from table.
select *
from table;
The select query
retrieve all
retrieve data from database with hyperlinkretrieve 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
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
Data retrieve from mysql databaseData
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
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 databaseretrieve 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_TO_REPLACE_2
SELECT *
FROM table_
name:
Above code retrieves all data
from specific...\jdbc\jdbc-mysql>java GetAllRows
Getting All Rows
from a
table!
Emp...
Retrieving All Rows
from a Database
Table
How to retrieve image from databaseHow 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
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 store and retrieve image from database in JSP?How to store and
retrieve image
from database in JSP? Hi,
In one... and
retrieve image
from database in JSP?
Thanks
HI,
You can use... the image. Check this example:
Retrieve image
from database using Servlet.
Thanks
Extracting table from Access Database to ServletExtracting
table from Access Database to Servlet Sir,
I have a
table with 4 field deptid, headid, normalexpend and projectexpend. Now I have... for all depts need to be displayed.
For ex.
dept d1 has spend 400 under head h1.
dept How to retrieve single row from MSSQLHow to
retrieve single row
from MSSQL Hello sir,
Sir i had created the
table in MSSQL,the fields with patient
name,pid,Dname(doctor
name... the patient
name and doc
name and search button in GUI window.What i want is after
How to retrieve single row from MSSQLHow to
retrieve single row
from MSSQL Hello sir,
Sir i had created the
table in MSSQL,the fields with patient
name,pid,Dname(doctor
name... the patient
name and doc
name and search button in GUI window.What i want is after
How to retrieve single row from MSSQLHow to
retrieve single row
from MSSQL Hello sir,
Sir i had created the
table in MSSQL,the fields with patient
name,pid,Dname(doctor
name... the patient
name and doc
name and search button in GUI window.What i want is after
Retrieve date from MYSQL database to
retrieve the date of birth of
persons
from the database
table. For this, we have...
Retrieve date
from MYSQL database
In this tutorial, you will learn how to
retrieve date
from database.
Storing and Retrieving dates
from the database
Retrieve data from databse using where in JSPRetrieve data
from databse using where in JSP Hi, can somebody help me?
I have a jsp page. in that i want to get data
from the database where... INCORRECT SQL SYNTAX
<html>
.....
<body>
<%
//
table