searchaction.java

swnglu数据库连接统struts和hinernate

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package addressbook.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 org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

import addressbook.form.SearchForm;

/** 
 * MyEclipse Struts
 * Creation date: 12-26-2008
 * 
 * XDoclet definition:
 * @struts.action path="/search" name="searchForm" input="/form/search.jsp" scope="request" validate="true"
 */
public class SearchAction extends Action {
	/*
	 * Generated 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;// TODO Auto-generated method stub
		String name = searchForm.getName();
		String phone = searchForm.getPhone();
		String address = searchForm.getAddress();
		String email=searchForm.getEmail();
		String province=searchForm.getProvince();
		ActionMessages errors = new ActionMessages(null);
	
		try{
			//利用hibernate连接
			String strSql = new String(" from TAddressbook where ");
			//利用struts桥连接
		//String strSql = new String("select * from t_addressbook where ");
		if(!name.equals("")){
			strSql = strSql + "name like '"+ name + "%' and";
		}
		if(!phone.equals("")){
			strSql = strSql + "phone like '" + phone+ "%' and";
		}
		if(!address.equals("")){
			strSql = strSql + "address like '"+ address + "%'and";
		}
		if(!email.equals("")){
			strSql = strSql + "email like '"+ email + "%'and";
		}
		
		if(!province.equals("")){
			strSql = strSql + "province like '"+ province + "%'";
		}
		else
			strSql = strSql.substring(0, strSql.length()-3);
		
		HttpSession session = request.getSession();
		session.setAttribute("strsql", strSql);
		}catch (Exception e){
			e.printStackTrace();
			errors.add("falid",  new ActionMessage("error.search.failed"));
		}
		
		return mapping.findForward("display");
	}
}