Jsp Option Value
In this section, we are going to create a select box by retrieving the value
from the database in jsp. For further processing, first of all you need to
create a table in the database.
We create a table 'countries' that has the specified fieldnames and datatypes
respectively.
Create Table 'countries':
CREATE TABLE countries
(countries_id varchar(10) NOT NULL,
countries_name varchar(100) default
NULL); |
Then we have used the html tag <select>. Its syntax is:
<select name="">
<option value="">--select--</option>
<option value="">--select--</option>
- - - - - - -- - - - - - -- - - - -- - - --
- - - - - - - -- - - - -- - - -- -- - -- --
</select> |
Do the database connectivity and use the query "select * from countries"
in order to retrieve the values from the table 'countries'. Then we have create
a variable 'name' of string type and using the ResultSet method getString(2),
all the values are retrieved from the database and stored into this variable.
Then put this variable inside the <option> tag like: <option value="<%= name %>">
Here is the code of optionValue.jsp:
<%@page import="java.sql.*"%>
<html>
<form name="form" method="post" >
<b>Select a country:</b> </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 countries ");
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{
out.println("You have selected: <b>"+option+"</b>"+"<br>");
}
%>
</html> |
Output will be displayed as:
On clicking the dropdown button, it will show you a list of countries:
After selecting the country, click the button, a message is displayed:
Download
Source Code:
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
