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

How to create DAO class for Retrive data from data base

Thank you so much paul

hai Friends
i wish to do SCJP 6 certification.so that What are the procedure to prepare for the exam. and also is it easy or doubt?

Hai friends,
i worked database application in eclipse with separate mysql connection. but i wish work only Mysql back up file and also without any connection. like visual studio built in database. so anyone know about Built in database in eclipse.



IDE:
ObjectWeb Lomboz for JavaEE Development
Version: 3.3