//Created by MyEclipse Struts// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_3.8.4/xslt/JavaClass.xslpackage com.sonic.struts.action;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;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 com.sonic.struts.form.SearchForm;/**  * MyEclipse Struts * Creation date: 05-03-2005 *  * XDoclet definition: * @struts:action path="/search" name="searchForm" input="/search.jsp" scope="request" validate="true" */public class SearchAction extends Action {	// --------------------------------------------------------- Instance Variables	// --------------------------------------------------------- Methods	/** 	 * Method execute	 * @param mapping	 * @param form	 * @param request	 * @param response	 * @return ActionForward	 */	public ActionForward execute(		ActionMapping mapping,		ActionForm form,		HttpServletRequest request,		HttpServletResponse response) {		SearchForm searchForm = (SearchForm) form;		String name=searchForm.getName();		String phone=searchForm.getPhone();		String address=searchForm.getAddress();				String strSql="select a from AddressbookTable as a";		String strSql1="";		if(!name.equals(""))			strSql1 = strSql1 + "name LIKE '" + name + "%' AND";		if(!phone.equals(""))			strSql1 = strSql1 + "name LIKE '" + phone + "%' AND";		if(!address.equals(""))			strSql1 = strSql1 + "name LIKE '" + address + "%'";		if(!strSql1.equals(""))			strSql=strSql + " where " + strSql1.substring(0,strSql1.length()-3);		HttpSession session = request.getSession();		session.setAttribute("strSql",strSql);		return (new ActionForward("/display.jsp"));	}}