Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JSP-Servlet retrieve Dept Name from table dept and retrieve list of employee from emp table for that dept in combobox

Have Programming Question? Ask it here!
 
 
 


Seshagiri
retrieve Dept Name from table dept and retrieve list of employee from emp table for that dept in combobox
0 Answer(s)      a year and a month ago
Posted in : JSP-Servlet


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.


Advertisement
View Answers

Related Tutorials/Questions & Answers:
retrieve Dept Name from table dept and retrieve list of employee from emp table for that dept in combobox
retrieve Dept Name from table dept and retrieve list of employee from emp table... 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
How to display all the rows in JSP ,MySQL select condition statement IN dept_table
is displayed.@select * from department where dept_no=10;My display code in JSP...;br><br> <form method="post" name="form"> <table border="1">...); String query = "select * from dept"; st = con.createStatement(); ResultSet rs
Advertisements
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
Retrieve Value from Table - Hibernate
Retrieve 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 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
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
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
retrieve the records from one table to another table by using cursors
retrieve the records from one table to another table by using cursors  ... int default 0; declare cur cursor for select name from emp; declare continue... from one table to another table by using cursors.The following is my procedure
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
how to retrieve data from database using combobox value without using request.getParameter in jsp - JSP-Servlet
how to retrieve data from database using combobox value without using request.getParameter in jsp  Answer pl
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
Retrieve The Data From MySql Datbase
Retrieve The Data From MySql Datbase   How to Retrieve The Data From MYSQL database TO Use Select the Emp_id Option.And Also Search Option
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
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
how to use StringTokenizer to retrieve the class name, attributes name and methods name from the Java Source Code
how to use StringTokenizer to retrieve the class name, attributes name and methods name from the Java Source Code  hi, I have done a program whereby... one problem which is retrieve the Class Name, Attributes Name and Methods Names
how to retrieve data from database ?????/
how to retrieve data from database ?????/  how to retrieve data from database
how to retrieve data from database ?????/
how to retrieve data from database ?????/  how to retrieve data from database
how to retrieve data from database ?????/
how to retrieve data from database ?????/  how to retrieve data from database
how to retrieve data from database ?????/
how to retrieve data from database ?????/  how to retrieve data from database
how to retrieve data from database
how to retrieve data from database  unable to retrieve data from database using mySQL by using jsp sessions and beans for editing
data should not repeat in the drop down list when it is loading dynamically from database
, `DEPT_NAME` varchar(255) default NULL ); emp CREATE TABLE `emp... = con.createStatement(); ResultSet rs = stmt.executeQuery("Select * from emp where DEPT...;body> <select name='dept' onchange="showEmp(this.value)">
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   
Select from select list + display
=":"+rs.getString("EMP_NAME")+":"+rs.getString("DEPT_NAME"); } out.println(data...Select from select list + display  i have a select list containing... select EmpCode from the select list, the corresponding EmpName and DeptName should
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
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 display all the Select values from the MySQL database table in where condition= In JSP?
in the jsp file. @select * from table dept where dept_no=10;" jsp code i have used...How to display all the Select values from the MySQL database table in where...; <form method="post" name="form"> <table border="1"> <tr><
How to search the table name in MS SQL Database 2005 from application
How to search the table name in MS SQL Database 2005 from application  How to search the table name in MS SQL Database 2005 from application from our helpdesk application? application might be in html
Retrieving data from table using DBCP
;from a table!\n");     BasicDataSource ...;System.out.println("ID: " + "\t\t" + "NAME...;    String s = res.getString("name"
data should not repeat in the drop down list when it is loading dynamically from database
, `DEPT_NAME` varchar(255) default NULL ); emp: CREATE... = con.createStatement(); ResultSet rs = stmt.executeQuery("Select * from emp where DEPT...;/script> </head> <body> <select name='dept
Extracting table from Access Database to Servlet
Extracting 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 MSSQL
How 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 MSSQL
How 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 MSSQL
How 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 a field from SQLite to Edittext in android
How to retrieve a field from SQLite to Edittext in android  Hi... Im new to android.. i do no how to retrieve a field from database(SQLite). I'd...; Cursor m=db.rawQuery("SELECT Password FROM "+ USERS_TABLE+"WHERE email
How to retrieve a field from SQLite to Edittext in android
How to retrieve a field from SQLite to Edittext in android  Hi... Im new to android.. i do no how to retrieve a field from database(SQLite). I'd...; Cursor m=db.rawQuery("SELECT Password FROM "+ USERS_TABLE+"WHERE email
how to use bean to retrieve data from database
how to use bean to retrieve data from database  how to use bean to retrieve data from database   poda sendru
Retrieve data from databse using where in JSP
Retrieve 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
Retrieve date from MYSQL database
Retrieve date from MYSQL database In this tutorial, you will learn how to retrieve date from database. Storing and Retrieving dates from the database... of birth of persons from the database table. For this, we have used the TimeStamp
to retrieve from radiobox and comparing with a string - Struts
to retrieve from radiobox and comparing with a string  im creating a exam application in jsp which makes students to attend java questions.. created... a table ans(ques,op1,op2,op3,op4,op5,ans) in the mysql database and try
How to Retrieve Data from Facebook Using PHP
How to Retrieve Data from Facebook Using PHP  is this link has right content regards that?? http://techpdf.co.cc/blog/how-to-retrieve-data-from-facebook-using-php
How to Retrieve Data from Facebook Using PHP
How to Retrieve Data from Facebook Using PHP  is this link has right content regards that?? http://techpdf.co.cc/blog/how-to-retrieve-data-from-facebook-using-php
Retrieve value of radio button from database to form
Retrieve value of radio button from database to form  var gn=document.getElementsByName("empg"); //empg is name of radio input type. for(var i=0;i
Retrieve a list of words from a website and show a word count plus a specified number of most frequently occurring words
Retrieve a list of words from a website and show a word count plus a specified... the document text from the web (provided by utility class) 2.Filter the desired... 3. Read the (word, num_occurrences) map entry pairs into an array/list structure
retrieve data from mysql database and store it in a variable ?
retrieve data from mysql database and store it in a variable ?  sir... that retrieve the integer values from the database and stored in the integer variables. In addition to it, we have added numbers that are retrieved from
Advertisements
 

 

 

DMCA.com