assetsearchaction.java

J2EE电子商务系统开发从入门到精通---基于Struts和Hibernate技术实现

/*
 * AssetSearchAction.java
 *
 * Created on 2006年6月11日, 下午7:11
 */

package action.asset;

import dbservice.hibernate.HibernateService;
import form.asset.AssetSearchForm;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import model.asset.hibernate.AssetUtil;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForward;
/**
 *
 * @author Administrator
 * @version
 */

public class AssetSearchAction extends Action {
    
    /* forward name="success" path="" */
    private final static String SUCCESS = "success";
    
    /**
     * This is the action called from the Struts framework.
     * @param mapping The ActionMapping used to select this instance.
     * @param form The optional ActionForm bean for this request.
     * @param request The HTTP Request we are processing.
     * @param response The HTTP Response we are processing.
     * @throws java.lang.Exception
     * @return
     */
    public ActionForward execute(ActionMapping mapping, ActionForm  form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        // 获得页面表单中用户输入的信息
        AssetSearchForm searchForm = (AssetSearchForm)form;
        String column = searchForm.getColumn();
        String keyword = searchForm.getKeyword();
        
        // 根据用户表单输入，构造出hql或sql语句
        String query = null;        
        if (column.equals("id") ) {
            query = "from Asset where id like '%" + keyword + "%'";
        }
        else if (column.equals("name") || column.equals("price")) {
            query = "from Asset where " + column + " like '%" + keyword + "%'";
        }
        else if (column.equals("typeId")) {
            query = "from Asset asset where asset.assettype.name like '%" + keyword + "%'";
        }
        else if (column.equals("departmentId")) {
            query = "from Asset asset where asset.department.name like '%" + keyword + "%'";
        }
        else if (column == null || column.equals("")) {
            query = "from Asset";
        }
        
        // 执行hql/sql查询语句，返回所有满足条的资产信息
        List list = HibernateService.execQuery(query);
        if (list == null) {
            return new ActionForward(mapping.getInput());
        }
        
        // 获得HttpSession缓存
        HttpSession httpSession = request.getSession();
        // 将column值存入缓存当中
        httpSession.setAttribute("column", column);
        // 将keyword值存入缓存当中
        httpSession.setAttribute("keyword", keyword);
        // 将查询的所有结果存入缓存当中
        httpSession.setAttribute("assetlist", list);
        
        return mapping.findForward(SUCCESS);        
    }
}