【Java开源代码栏目提醒】:本文主要为网学会员提供AssetSearchAction.java,希望对需要AssetSearchAction.java网友有所帮助,学习一下!
/*
* 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);
}
}
上一篇:
AssetModifyForm.java
下一篇:
为定制而来 欧马可快递物流一体化解决方案抢滩苏浙沪