How to load data from database in dropdown list using in struts

[Mariraj Sankar]

i had tried but i got error

This is Action class(DeleteAction)

/*******************************************************************************
 * Copyright (c) 2005 Eteration A.S. and others. All rights reserved. This
 * program and the accompanying materials are made available under the terms of
 * the Eclipse Public License v1.0 which accompanies this distribution, and is
 * available at http://www.eclipse.org/legal/epl-v10.html
 * 
 * Contributors: Eteration A.S. - initial API and implementation
 ******************************************************************************/
package action;

import java.io.IOException;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletException;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import connection.*;
import beans.*;
import java.util.*;


public class DeleteAction extends Action {

	public ActionForward execute(ActionMapping mapping,
									ActionForm form, 
									HttpServletRequest request, 
									HttpServletResponse response)
									throws IOException, ServletException {
		String target="";
		List mlist= getBooks();
		formbean.DeleteEmployee fb=(formbean.DeleteEmployee)form;
		fb.setCrewList(clist); //error  in this line
		return mapping.findForward(target);
		
		

	
				
	}
	public static List getBooks() //Creating of DAO class
	
	
	{
		List clist = new ArrayList();
		Connectionbean cb =new Connectionbean();

		try
		{
			cb.connect();
			 String sql = " select * from BOOK ";
			 cb.ps =cb.con.prepareStatement(sql);
			 cb.rs = cb.ps.executeQuery();
			 while(cb.rs.next())
			 {
				 Crew crew =new Crew();
				 crew.setPfnum(cb.rs.getInt("pfnumber"));
				 clist.add(crew);
			 }

		}
		catch(Exception e)
		{
			
		}
	         return clist;
	}
	

}

This is actionbean (DeleteEmployee)

/*******************************************************************************
 * Copyright (c) 2005 Eteration A.S. and others. All rights reserved. This
 * program and the accompanying materials are made available under the terms of
 * the Eclipse Public License v1.0 which accompanies this distribution, and is
 * available at http://www.eclipse.org/legal/epl-v10.html
 * 
 * Contributors: Eteration A.S. - initial API and implementation
 ******************************************************************************/

package formbean;

import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import java.util.*;
public class DeleteEmployee extends ActionForm {
	private List CrewList;
	private String[] crew;

	public ActionErrors validate(ActionMapping mapping, HttpServletRequest request) {
		ActionErrors errors = new ActionErrors();
		// Validate an attribute named "xxx"
		//if( getXXX() == null || getXXX().length() == 0 )
		//	errors.add("xxx",new ActionMessage("errors.required","xxx"));
		return errors;
	}
		
	public void reset(ActionMapping mapping, HttpServletRequest request) {
		
		super.reset(mapping, request);
	}

	public List getCrewList() {
		return CrewList;
	}

	public void setCrewList(List crewList) {
		CrewList = crewList;
	}

	public String[] getCrew() {
		return crew;
	}

	public void setCrew(String[] crew) {
		this.crew = crew;
	}

This is bean class(Crew)

package beans;

public class Crew {
	
	 int pfnum;		 
	public int getPfnum() {
		return pfnum;
	}
	public void setPfnum(int pfnum) {
		this.pfnum = pfnum;
	}
}

}

How to create DAO please provide solution
;;;;
i am very confused.....

moderator: added code tags

[mahesh shinde]

Let Me try first some simple
DAO basically contains database related methods
In Your case if you create one new class suppose BookDAO
You can put the getBooks() method in that class
and its become your DAO.
Call that method using creating the instant of DAO class.