How to populate Dropdownlist from database

All,

I am new to this world.
I wrote an application that has a dropdown list and I need data from database to be populated in that dropdown before submitting and adding the data to another table.

Please help me in getting this done through beans or JSP.

Thank you all..
Anish

Hi
Store the data in hashmap or in an array list and iterate it for example use as in this way

for(int i=0;i<arraylist.size;i++)
{
Bean instance = (Instance of bean)arraylist.get(i);
//Store all the values in the bean and now close the scriptlet
//Put the code for select box like
<option value= <%=bean instance.get id %><%=bean intance.get required value&>
}

Hope you have understood

Regards
K. Sandeep

hi Sandeep,

i am very new to this, so to be honest I dont understand,.
Let me put what i have done so far..
In my Class file

package PPickDomain;

import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;

public class PickDomain {

String DDomain;
private String user;
private String pwd;
private String Domain;

//private Connection connection=null;
// private ResultSet rs = null;
// private Statement st = null;
Connection connection = null;
Statement st = null;
ResultSet rs = null;
ResultSet rs1 = null;
public PickDomain()
{
try {

DriverManager.registerDriver(
new oracle.jdbc.driver.OracleDriver());
String serverName = "localhost";
int port = 1521;
String user1 = "scott";
String password = "tiger";
String SID = "ORACLE";
String URL = "jdbc

racle:thin:@" + serverName + ":" + port + ":" + SID;
connection = DriverManager.getConnection(URL, user1, password);
}
catch(Exception e)
{
System.out.println("Exception is ;"+e);
e.printStackTrace();
}
}

public void setDomain(String Domain)
{
this.Domain = Domain;
}
public String getDomian ()
{
return (this.Domain);
}

public String selectD()
{
try
{

Statement s = connection.createStatement();
rs=s.executeQuery("Select T_A_DOMAIN from BILL_DOMAIN");

//Not sure what to do next //

}

catch(Exception e)
{
System.out.println("Exception is ;"+e);
e.printStackTrace();
}
return DDomain;
}

}

in my JSP file..

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd" >

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>

<HTML>
<HEAD>
<TITLE>Adding ticket to Database Table </TITLE>
</HEAD>

<BODY bgcolor="#ffffcc">
<font size="+3" color="green"><br> Add the Ticket Details here</font>
<FORM action="addticket2.jsp" method="get">
<TABLE style="background-color: #ECE5B6;" WIDTH="30%" >

<TR>
<TH width="50%">Domain</TH>
<TD width="50%"><select name="Domain" size="1">
<option selected="selected">Select a Domain</option>

</select>

</FORM>
</body>
</html>

please help with this code.
thanks buddy...

A couple of things.

First off, since you are new to JSP, it's important to establish good habits right up front. Rule #1 is to never, never, never, put Java code ina JSP. Never. That's a really old-fashioned and bad practice.

Rather, you should fetch the data from the DB in a servlet controller, or a bean, to use on the JSP.

Also, please be sure to use code tags when posting code to the forums. Unformatted code is extremely hard to read and many people that might be able to help you will just move along to posts that are easier to read. Please read this for more information.

You can go back and change your post to add code tags by clicking the

button on your post.

try something like this....but you need to modify ...just putting quickly

<HTML>
<HEAD>
<TITLE>Adding ticket to Database Table </TITLE>
</HEAD>

<BODY bgcolor="#ffffcc">

<%
for(int i=0;i<arraylist.size;i++)
{
Bean instance = (Instance of bean)arraylist.get(i);

%>

<option value= <%=bean instance.get id %><%=bean intance.get required value&>

<font size="+3" color="green"><br> Add the Ticket Details here</font>

}
<FORM action="addticket2.jsp" method="get">
<TABLE style="background-color: #ECE5B6;" WIDTH="30%" >

<TR>
<TH width="50%">Domain</TH>
<TD width="50%"><select name="Domain" size="1">
<option selected="selected">Select a Domain</option>

</select>

</FORM>
</body>
</html>

Gudim, Just above your post Bear mentioned that don't use Java code(Scriptlets) in JSP. JSTL and EL better alternatives.

Vishal Pandya wrote:Gudim, Just above your post Bear mentioned that don't use Java code(Scriptlets) in JSP. JSTL and EL better alternatives.

I agree. Your JSP would be structured something like this:

This code assumes that some previous code, such as your MVC controller, placed a java.util.List in scope -- e.g., via request.setAttribute("mylist",aList); -- and also assumes that each list item has a "getProperty()" method.

To learn more, Google "JSP expression language" and "jstl".

The Java Bean ( DTO ) is as follows:

The Java Bean ( DAO ) is as follows.

package src;

import javax.naming.*;
import javax.sql.*;
import java.sql.*;
import java.util.*;

public class StateDAO
{
	private List<StateDTO> stateList ;
	private DataSource myDS;
	private Context initCtx;
	private Context envCtx;
	private String tmp;

public StateDAO()
	{
	}

public List<StateDTO> getStateList()
	{
		stateList = new ArrayList<StateDTO>() ;
		myDS      = null;
		Connection connection = null;
		Statement  stmt         = null;
		ResultSet  rs              = null;

try
    	{
          initCtx  =  new  InitialContext();
          envCtx  =  (Context)  initCtx.lookup("java:comp/env");
          myDS    =  (DataSource) envCtx.lookup("jdbc/test");
        }
        
        catch (Exception e)
        {
			System.out.println(e);
        }
        
        try
        {
          connection   = myDS.getConnection();
          stmt           = connection.createStatement();
		  rs               = stmt.executeQuery("Select Cod, Name from states Order By Name ASC");
		  
		  while(rs.next())
		  {
				String stname = rs.getString("Name") ;
				String stcod    = rs.getString("Cod") ;
				StateDTO s     = new StateDTO(stcod,stname);
				stateList.add(s);
		  }

}
	    catch (Exception e)
	    {
	      System.out.println(e);
	    }
	    
	    finally
	    {
			try
			{
				if(connection !=null)
				{
					connection.close();
				}
			}
			catch (Exception e)
			{
				System.out.println(e);
			}
	    }
	    
		return stateList;	
	}
}

JSP accessing the DAO class is as follows.

The database ( test ) is updated with state names in a table ( states ) .

In the code sample provided by Sunder Ganapathy for the dropdown, is there a posibility to pass locale from jsp to the DAO?

My database table is setup for different locales and I am currently working with something like this: ("select * FROM tablename WHERE tablename.locale='en_CA'")

I need the locale to change when user switches language. I am thinking of keeping locale in a session variable but not sure if it would be a good practice to specify session variable in the WHERE clause. Are there other better options?

Thank you in advance.

It's fine to pass the value of any scoped variable to the lower layers of the application, as long as you aren't passing the session itself (ar anything else from the servlet packages).

Another way of looking at it is if you need to import javax.servlet in model classes, you're doing it wrong!