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...plz any one help to me.. thanks in advance

View Answers

March 29, 2011 at 1:35 PM

Follow these steps:

1)Go to the start->Control Panel->Administrative Tools-> data sources.

2)Click Add button and select the driver Microsoft Access Driver(*.mdb).

3)After selecting the driver, click finish button.

4)Then give Data Source Name and click ok button.

5)Your DSN will get created.

6) Restart your server and run the following jsp code.

<%@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()){
    String str=rs.getString("name");
%>
    <option value="<%=str%>"><%=str%></option>
    <%
}
%>
</select>

Ads

Advertisements

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

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 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

The code for retrieving data from database into Drop Down List.
The code for retrieving data from database into Drop Down List. <% DataSource data = new MysqlDataSource(); Connection con... to MySQL"); PreparedStatement pre = con.prepareStatement("select * from

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="<

retrive data from database?
retrive data from database? hellow i have a database sheet name... from db1 and enter value in text box according there name,rollno and save..... now i want retrive sn,roll no and name and textbox like

how to make drop down list in JSF & fetch data Item from database
how to make drop down list in JSF & fetch data Item from database how to make drop down list in JSF & fetch data Item from database

retrive data from database
retrive data from database hi.. i made a application form. it's have attribute s.no,name,roll no and i enter a few records. now i want to view all record not in database access sheet i want to view it at any another

retrive data from database using jsp in struts?
retrive data from database using jsp in struts? *search.jsp* <%@taglib uri="http://struts.apache.org/tags-html" prefix="html"%> <... searchProduct(SearchDTO sdto) { String query="select * from product

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

url parameter using retrive data from database in jsp
url parameter using retrive data from database in jsp the user can... clicks the Preview button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public

By dropdownlist retrive data from database and show in textbox in jsp.
By dropdownlist retrive data from database and show in textbox in jsp. Hello Sir, I am doing project in jsp.I have to retrive data from database, when I select value from dropdownlist, and that data I want to show in textbox

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

url parameter using retrive data from database in jsp
url parameter using retrive data from database in jsp The user can... clicks the Preview button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public url

data should not repeat in the drop down list when it is loading dynamically from database
data should not repeat in the drop down list when it is loading dynamically from database selDept.jsp <%@page import="java.sql.*"%>... the data dynamically for database but my problem is in the list the same

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 and postgresql as data base syntax which i m using is like:- java class

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

GWT -- retrive the data from Database
GWT -- retrive the data from Database the user can create an event... button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public url. Means anyone

Retrive data from database and perform binary tree operations on that data in jsp or java
Retrive data from database and perform binary tree operations on that data in jsp or java To develop code for MLM project. I want to retrieve data from database dynamically and perform operations on that. Just like calculate

Pls provide me jsp code to get values in drop down list from another table's field....
Pls provide me jsp code to get values in drop down list from another table's... in customer registration page and should be shown in drop down box in front end... pages..... when i insert data in company registration .. it ll have company id

How to access the database from JSP?
How to access the database from JSP? Hi, What is the process of accessing the database from JSP page? Thanks Hi, In the JSP program... database from JSP which explains you how to access the database by embedding

retrive data from oracle to jsp
retrive data from oracle to jsp i am a beginer in jsp so please help... cost and manager name and storing it in the data base. in search proj fiel...(); psmt= conn.prepareStatement("select * from CR_EMPLOYEE_DETAILS

How to insert multiple drop down list data in single column in sql database using servlet
How to insert multiple drop down list data in single column in sql database using servlet i want to insert date of birth of user by using separate drop down list box for year,month and day into dateofbirth column in sql server

retrive image from database using jsp without stream
retrive image from database using jsp without stream How to retrive image from database using jsp without stream like (inputStream

insert and retrive image from sql server database in jsp
insert and retrive image from sql server database in jsp what is the code to insert and retrive an image from sql server database in jsp

how to add data dynamically from database into a dropdown list in a jsp
how to add data dynamically from database into a dropdown list in a jsp ... and department fields also.I have a create an jsp page in which there should 2 drop down... of the persons who work in that department.The values into the drop down list should

I want to display the quantity of the selected item of a drop down list in a textbox. The data is stored in database.
I want to display the quantity of the selected item of a drop down list in a textbox. The data is stored in database. The code for retrieving data from database into Drop Down List. <% DataSource data = new

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

retrive the employee details with image from mysql database using jsp servlet
retrive the employee details with image from mysql database using jsp servlet im doing the web project to retrive the employee profile which i stored in the database using jsp servlet then want to show the result in the next jsp

Display related data in other drop down list on selecting one data in one drop down list
Display related data in other drop down list on selecting one data in one drop down list How to display related datas in dropdown list from database on selecting one data in previous dropdownlist in Java Server Page

how to insert data into database using jsp & retrive
how to insert data into database using jsp & retrive Hello, I have created 1 html page which contain username, password & submit button. in my oracle10G database already contain table name admin which has name, password

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

Retrieving Data from Database to fill Combo Box
Retrieving Data from Database to fill Combo Box Sir, I have a JSP Page with a combo box and a label. I have a database that has two fields id and an image. Now I want to fill the combo box with image and on selecting

JSP Get Data Into Dropdown list From Database
JSP Get Data Into Dropdown list From Database In this section we will discuss about how to fetch data dynamically into the dropdown list in JSP... data from the database and set it into the dropdown list in JSP using MySQL

retreiving data from microsoft access database
retreiving data from microsoft access database How can i retrieve data from microsoft access when i have select the vaules in combo box and text box. When i select these values... i want to retrieve the corresponding columns

Drop Down Box
Drop Down Box In a Drop Down box I want to show the user All the Country In the World. And when he type A-z,then each of the type Show those country which start with those word. Like I For-India

to get picture from ms access database by jsp-servlet....
to get picture from ms access database by jsp-servlet.... I have inserted a picture in ms access data base,,,how we can retrieve that picture by using jsp

Use of Select Box to show the data from database
Use of Select Box to show the data from database ... from database This example will describe you the use of Select Box in a JSP page to show the data fetched from the database. We are using Servlet to get data

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

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 a particular value from one the other list is developed accordingly..depending

jfreechart display from access database data.
jfreechart display from access database data. I have made a database... to retrieve the data from the access database using prepared statement and then display... is to be done in a servlet.. Note that it is a access made database. How can I

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... number of drop down lists(depending upon number of books in that category) on jsp... ,rating2......number of buks in that category(and each drop down list has value

displaying data for a single column from Mysql database in the list box in php form
displaying data for a single column from Mysql database in the list box in php form I have a form in php.want to display data from a single column...; $data = @mysql_query("select * from names"); echo "Select a Name: n"; echo "<

How to pass parameter through drop down list using session management in jsp??
How to pass parameter through drop down list using session management in jsp?? How to pass parameter through drop down list in the URL and access it on same jsp page using session management

Ads