how to retrieve the id value itself from the access database to drop down listbox in jsp

Home Answers Viewqa JSP-Servlet how to retrieve the id value itself from the access database to drop down listbox in jsp

QuestionAsk Questions?

periasamy.s

how to retrieve the id value itself from the access database to drop down listbox in jsp
1 Answer(s) 2 years and 2 months ago
Posted in : JSP-Servlet

how to retrieves the id which is an int datatype, from access database to drop down list box in jsp...plz send the code for that.....plz

View Answers

March 30, 2011 at 11:44 AM

<%@page import="java.sql.*"%>
<select>
<option value="--Select--">--Select--</option>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:student");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("Select * from data");
while(rs.next()){
    int id=rs.getInt("id");
%>
<option value="<%=id%>"><%=id%></option>
<%
}
%>
</select>

how to retrieve the id value itself from the access database to drop down listbox in jsp
how to retrieve the id value itself from the access database to drop down listbox in jsp how to retrieves the id which is an int datatype, from access database to drop down list box in jsp...plz send the code for that.....plz

how to set a value of dynamic number of drop down lists on a jsp page and access it value on another jsp page
how to set a value of dynamic number of drop down lists on a jsp page and access it value on another jsp page actually i have to create dynamic number of drop down lists(depending upon number of books in that category) on jsp

Drop down list from database
Drop down list from database Hi, Can I know how do we get the drop down list from database? Eg: select country--select state--select district--so... * from country"); while(rs.next()){ %> <option value="<

Dependant & dynamic drop down list
be in this or AJAX forum. I have one dynamic drop down list from data base (working... on the values selected by user in first drop down list. How to achieve this ? ...`)); This will select only ONE row (country) from first drop down. In my case

Drop down and radio button value on edit action
Drop down and radio button value on edit action HI, I have a title field and a payment type field for title i have used drop down with values... i get the value from the database for title and radio button selected

jsp drop down-- select Option
jsp drop down-- select Option how to get drop down populated... = results.getString(2); String id = results.getString(1); %><option value="<%= name %>... code populate the second dropdown on selecting the value from the first

JSP Dependent Drop Down Menu
JSP Dependent Drop Down Menu Hey Guy/Gals! I need someone help to guide me in creating a drop down menu, where the first menu affects the second menu and it's selection. So in my database I have a category table that has a ID

retrive the data from access database to drop down list box in jsp
retrive the data from access database to drop down list box in jsp hai, im new to jsp now im using the jsp along with access database.in table i load all the data's i need to retrive the data from database to dropdown list box

Login With Drop Down
Login With Drop Down Hi all, I am doing a project using JSP. My... the departments. Now, my intention is to select the department from the drop down... using the drop down box and the Username and passwords must match with the Database

dependent drop down box - JSP-Servlet
dependent drop down box haloo sir Please give me the solution how to extract data from dependent drop down box with page refresh...; window.location.replace("http://localhost:8080/examples/jsp/dependentDropdown.jsp?id="+cid+"&&value

checkbox with dropdown listbox in jsp
checkbox with dropdown listbox in jsp i loaded the the data into the drop down listbox in jsp from access database.now i have to add a check box,if it checked means dropdownlist box carryout the data's,else it should

Ajax drop down and textbox
Ajax drop down and textbox hie frnds I have a dropdown menu in the 3...;And one more thing how to insert to the database dynamically... menu consisting of options 1,2,3. When the user select any option from

Dependent drop down list
Dependent drop down list hi,i am trying to design a form on which 2 dependent drop down list is used my code is successful but when i select class from first drop down list all the data get lossed means the value entered

jsp code for a drop down box to retrive value from database
jsp code for a drop down box to retrive value from database my project needs to get the value from database in to the drop down box..... pls give me...=con.createStatement(); ResultSet rs=st.executeQuery("select * from login

Create Listbox in JSP using AJAX control
Create Listbox in JSP using AJAX control Hi everyone!!! I want... about AJAX. In that listbox,listbox items are dictly fetched from databases... , it should show all country names in drop-down manner in list-box. And if i

dynamic drop down list
dynamic drop down list I want to create 2 drop down list, where it takes value from database and the two list are dependent..means if I select... on the value chosen from the previous. want code in javascript and jsp, Can you help

Dependant & dynamic drop down list - Follow up
Dependant & dynamic drop down list - Follow up Thanks for your answer. As per your answer This will select only ONE row (country) from first drop... jsp for extract. How to achieve this ? 1)country.jsp: <%@page

dynamic drop down
into the designation drop down (use jsp+javascript+servlet) reply soon 1...dynamic drop down I have created 2 drop downs in jsp.1...(); ResultSet rs = stmt.executeQuery("Select * from designation where DEPT_NO='"+id

to update drop down list value when selected from website
to update drop down list value when selected from website hi help me, i want to insert value into db when i select from a drop down list..._assoc($list)){ ?> <option value="<?php echo $row_list['Age_Id']; ?>

Login With Drop Down, Having Departments in different table
is to select the department from the drop down box and then login to the page. I... to login when I select department from the drop down list. Since I cannot populate the departments name from each table into drop down I use Select tag and declare

Drop Down reload in IE
from the 2nd drop down then the 1st drop down ( which is date) automatically loads to 1 which is first value..This is the problem im facing in IE but it works...Drop Down reload in IE Hi i was using two drop down box..One

how to retreive data dynamically from mysql to drop down list
how to retreive data dynamically from mysql to drop down list sir... fron end using jsp , after storing the data successfully .i want to retrieve the data of a particular column in a table into drop down list dynamically

Drop-down text selection in jsp/html
Drop-down text selection in jsp/html Hi, I am trying to create JSP.... Now the first dropdown will have all the values. The second drop-down depends upon... this path and query the database. So how can i know in the backend which is first

How to send the data selected from drop down menu from html page to sql 2005 database.
How to send the data selected from drop down menu from html page to sql 2005... by user from html drop down menu such as check-in date for hotel reservation system ,how can I save these data in database and how to retrieve later .Thanks

retrieve value from database on the basis of maximum id number
retrieve value from database on the basis of maximum id number hi, i want to retrieve value of maximum id number from the database and show that value in jTextField.when the user clicks on the button that maximum id number

how to delete the access database value in jsp
how to delete the access database value in jsp i loaded my database data into the dropdown list box...now i want to delete the value..plz send the source code to delete the value in dropdown list box and also from database

Drop Down
Drop Down How to insert date into database using dropdown like facebook

jsp login code ... when username , drop down box and password is correct
value is correct.... the drop down box values should be retrieved from database...jsp login code ... when username , drop down box and password is correct ....... the value is retrieved from database into combo box..... but the validation

store values of drop down list box in database
store values of drop down list box in database how to store values of drop down list box in oracle database in jsp?I have information inserting form where i have date of birth as drop down list box

drop down
drop down how can i add data from choice/dropdown component of java awt to myaql table

data should not repeat in the drop down list when it is loading dynamically from database
the whole department field from the data base (i.e in the drop down list...data should not repeat in the drop down list when it is loading dynamically... be included in the drop down list. 1)selDept.jsp: <%@page import

how to import values from database to the drop down box
how to import values from database to the drop down box hi iam... employee page i kept a drop down box for employee Ids i want all employee IDs will display in the drop down box please help me with the code

How to retrieve data from database by using combo box value in jsp? - JSP-Servlet
How to retrieve data from database by using combo box value in jsp? ...; } function showEmp(emp_value) { if(document.getElementById("emp_id").value... =""; document.getElementById("emp_id").value =""; if (xmlHttp.readyState==4

view data from database using drop down list
view data from database using drop down list hi i want to view the data from database by selecting a value in a drop down list. for an example drop down list have picture element.when click it select pictures from the database

How to retrieve data by using combo box value in jsp? - JSP-Servlet
How to retrieve data by using combo box value in jsp? For example, In Employee.jsp form, When i click employee id value in combo box...... i already stored combo box values from database. pl

code for insert the value from jsp to access database
code for insert the value from jsp to access database code for insert the value from jsp to access database

Get values in drop down list
Get values in drop down list Pls provide me jsp code to get values in drop down list from another table's field. my project has customer... in drop down box in front end..... pls provide me code.. thanx

how to retrieve images from database to jsp?
how to retrieve images from database to jsp? Hi sir,i want to stores images along with the name and price with database and retrieve it on jsp.and...(); String strQuery = "select image from data where id="+id; ResultSet rs

retrieve from database........
retrieve from database........ <p>hi i am not able to retrieve string from database to a text box in web page my code is as follows:-</p>...", "root", "root"); String query = "select * from employee where id

How to retrieve data by using combo box value in jsp? - JSP-Servlet
How to retrieve data by using combo box value in jsp? Hi Friends, When i click combobox value in jsp form page, it will diplay related value.... I am using only this page.. not get value from another page

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

Retrieve image from mysql database through jsp
Retrieve image from mysql database through jsp... to retrieve image from mysql database through jsp code. First create a database... will be retrieved from database on the basis of 'id' field of the table. So code

want to insert values in drop down menu in struts1.3
want to insert values in drop down menu in struts1.3 I am using DynaValidatorForm.please help me with inserting values in color drop down menu. I...; <jsp:root xmlns:jsp="http://java.sun.com/JSP/Page" xmlns:fmt="http

insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql can... data into database using an drop down box .....as i m using eclipse as jdbc...("addressafterretirement", new Model()); public form1a(Integer emp_id

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics