retrieve the value from database into dropdown list using JDBC SQL 2005

retrieve the value from database into dropdown list using JDBC SQL 2005

How to retrieve the value from database into dropdown list using JDBC & SQL 2005?

View Answers

March 14, 2012 at 12:35 PM

JSP Code:

Create table country(country_id,country) in database and try the following code:

<%@page import="java.sql.*"%>
<html>
<form name="form" method="post" >
<b>Select a country:</b>&nbsp;</td>
<select name="sel"><option value=""><---Select---></option>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
String connectionURL = "jdbc:mysql://localhost:3306/test";;
Connection connection= DriverManager.getConnection(connectionURL, "root", "root");
PreparedStatement psmnt = connection.prepareStatement("select * from country ");
ResultSet results = psmnt.executeQuery();
while(results.next()){
String name = results.getString(2);
String id = results.getString(1);
%><option value="<%= name %>">
<% out.println(name); %>
</option>
<%} results.close(); psmnt.close(); %>
</select><br>
<input type="submit" value="Submit"/><br>

</form>
<%String option=request.getParameter("sel");
if(option==null){
}
else{%>
<input type="text" value="<%=option%>">
<%
}
%>
</html>

March 14, 2012 at 12:50 PM

Java Code:

import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;

class ComboExample {
    ComboExample() {
        JFrame f = new JFrame();
        f.getContentPane().setLayout(null);
        final JComboBox combo = new JComboBox();

            try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root","root");
            Statement st = connect.createStatement();
            ResultSet rs = st.executeQuery("Select name from data");
                        while (rs.next()) {
                        combo.addItem(rs.getString("name"));

            }
            } catch (Exception ex) {
                }

        combo.setBounds(20, 50, 150, 20);
        f.add(combo);

        f.setSize(400, 200);
        f.setVisible(true);
    }
    public static void main(String[] args) {
        ComboExample c = new ComboExample();
    }
}

Ads

Related Tutorials/Questions & Answers:

3 dropdown list from the database using JSP
3 dropdown list from the database using JSP Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other and get the options from the database using JSP

how to load value in dropdown list after selecting value from first dropdown list using javascript
how to load value in dropdown list after selecting value from first dropdown list using javascript how to load value in dropdown list after selecting value from first dropdown list using javascript

Advertisements

Dropdown code to retrieve result from oracle database
that will retrieve values from the database into dropdown. As the user choose any option...Dropdown code to retrieve result from oracle database Hi Friends, I... retrieve the result from Oracle database.We have procedures created already.Just

Retrieve data from database by using sql tag of JSTL SQL library
Retrieve data from database by using sql tag of JSTL SQL library... we will see how retrieve data from database using sql query given by user... named 'employee_master' in same database by the sql query given below

retrieve related data from database using jsp and mysql
retrieve related data from database using jsp and mysql Hi sir, please give some example of jsp code for retrieving mysql database values in multiple dropdown list. if we change a value in a dropdown its related value must

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

JSP Get Data Into Dropdown list From Database
data from the database and set it into the dropdown list in JSP using MySQL...JSP Get Data Into Dropdown list From Database In this section we will discuss... fetching of data into the dropdown list in JSP using Eclipse IDE and the Tomcat 7

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

Retrieve values from database using views
Retrieve values from database using views hi......... I have a huge database so i have created views in database where i am selecting only the columns which are required. As my front end is java swings i want to retrieve data

help to select a value from the dropdown list
help to select a value from the dropdown list I have a html file... from the drop down list created in a div and put it in the textbox kim... <input type="text" size="30" name="inputString" value="" id="inputString

<img src=""> using retrieve image from database using jsp
using retrieve image from database using jsp how to <img src="" > tag using retrieve image from database and display in jsp

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

Populate dropdown menu from database using jsp and servlet
Populate dropdown menu from database using jsp and servlet please i need code to populate dropdown menu from mysql database using jsp and servlet. thanks

Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other and get the options from the database using JSP
Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other and get the options from the database using JSP as i said i want to create 3 drop dropdown list each depend on the other and get the options from

Retrieve database from the table dynamically in jsp from oracle using servlet
Retrieve database from the table dynamically in jsp from oracle using servlet Sir, I have created a table in oracle using eclipse, and added few... using java servlet from the database in the jsp page

retrieve the data to text fields from database on clicking the value of combo box
retrieve the data to text fields from database on clicking the value of combo box retrieve the data to text fields from database on clicking... getting data into textarea from database table by clicking on the button

Retriving value from dropdown list nad disply it in other page
Retriving value from dropdown list nad disply it in other page Hello, I have a dropdownbox on my webpage and a map which contains a marker... of the selected value from the dropdown list and dispaly it to on the next page. i

how to store and retrieve images int and from the database using php
how to store and retrieve images int and from the database using php please anyone can help me in storing the images and retrieve it back from the Mysql database using php

populating textbox value from the database using onchange function,
populating textbox value from the database using onchange function, ... selecting from dropdownlist. i have a form in jsp n I created the dropdown list dynamically from the database(mysql). after selecting the value from the dropd

How to retrieve image from database using jsp and servlet?
How to retrieve image from database using jsp and servlet? Hi, I am trying to find code for displaying the image from database in a JSP page. How to retrieve image from database using jsp and servlet

How to insert image in sql database from user using servlet
How to insert image in sql database from user using servlet pls tell me accept image from user and insert image in sql server 2005 database using servlet and jsp

How to Retrieve Data from the database and write into excel file using Java
How to Retrieve Data from the database and write into excel file using Java Hi, I am trying to develop an small application where i trying to retrieve Data from the database and store the details in excel file. Please can

Retrieve image from database using servlet and display in JSP
Retrieve image from database using servlet and display in JSP Hi, I am total new to JSP although I am learning it for the last few days. Now I want to use MySQL Database from JSP page. How to retrieve image from database using

jsp- database dependent dropdown list
jsp- database dependent dropdown list i want 2 dropdown list 1- CLASS 2-SECTION both are should come from database. and if i select a class suppose class a the corresponding section dropdown list should retrieve the section

retrieve data from mysql database
selected value on combobox which is to be retrieve the relevant data from mysql database using php.... below my code is that.. <html> <head>...retrieve data from mysql database hi am not familiar in php.....even

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 ... get dynamically from the database and whenever a new person has registered his... in storing them into the database,this registration form contains name

Finding MAX value from emp_id column using SQL query?
Finding MAX value from emp_id column using SQL query? I need to select maximum of the Emp_id values from SQL server 2005 table.I was using... of emp id from the table.(Actually it picks up Max value using by looking at 1st

Data retrieve from mysql database
Data retrieve from mysql database Hi sir, please give some example of jsp code for retrieving mysql database values in multiple dropdown list. if we change a value in a dropdown its related value must be shown in the adjacent

select value from autocomplete textbox using jquery in jsp from database.
select value from autocomplete textbox using jquery in jsp from database. ... but was unable to find out exact way to fullfill the solution of selecting value from autocomplete textbox using jquery in jsp from mysql database. Kindly send me

select value from autocomplete textbox using jquery in jsp from database.
select value from autocomplete textbox using jquery in jsp from database. Hii Sir, Lots of thnx to ur reply .I went through both... of selecting value from autocomplete textbox using jquery in jsp from mysql database

Ads