一个简便的查询框架【内容已删除】

应公司要求，本博客内容已删除

评论

4 楼 able 2007-07-20  

邹总阿,支持下～～

3 楼 lang 2007-07-19  

能不能给我一个action和jsp，我在你给的附件中没有找到相关的使用action和jsp!比如：BalanceManager
我的邮箱是：[e-mail]

2 楼 aystnd 2006-12-13  

另外，我设计的这个查询类为了和Struts结合，特别编写了一个对应的Form类。然后在JSP页面可以通过Struts标签，不需要修改后台代码，实现随意添加、修改Struts标签的属性值，就可实现查询条件的调整
QueryConditionForm：实现与QueryCondition的数据交换

package com.lily.dap.webapp.form;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;

import com.lily.dap.model.QueryExpression;

/**
 * Generated by XDoclet/actionform. This class can be further processed with XDoclet/webdoclet/strutsconfigxml and XDoclet/webdoclet/strutsvalidationxml.
 *
 * @struts.form name="queryConditionForm" 
 */
public class QueryConditionForm extends ActionForm implements java.io.Serializable {
    /**
	 * <code>serialVersionUID</code>
	 */
	private static final long serialVersionUID = -4489598235078274874L;

    protected List conditions = new ArrayList();

    /** Default empty constructor. */
    public QueryConditionForm() {}

	/**
	 * @return the conditions
	 */
	public List getConditions() {
		return conditions;
	}
	
	/**
	 * @param conditions the conditions to set
	 */
	public void setConditions(List conditions) {
		this.conditions = conditions;
	}

	public Object getCondition( String condition )
    {
		String[] items = condition.split(",");
		Iterator it = conditions.iterator();
		while (it.hasNext()) {
			QueryExpression queryExpression = (QueryExpression)it.next();
			if (items[0].equals(queryExpression.getName())) {
				boolean flag = false;
				if (items.length > 2) {
					if (items[1].equals(queryExpression.getOp()) && items[2].equals(queryExpression.getType()))
						flag = true;
				} else if (items.length > 1) {
					if (items[1].equals(queryExpression.getOp()))
						flag = true;
				} else
					flag = true;
				
				if (flag)
					return queryExpression.getValue();
			}
		}
		
		return null;
    }

	public QueryExpression getQueryExpression( String condition )
    {
		Iterator it = conditions.iterator();
		while (it.hasNext()) {
			QueryExpression queryExpression = (QueryExpression)it.next();
			if (condition.equals(queryExpression.getName()))
				return queryExpression;
		}
		
		return null;
    }

    public void setCondition( String condition, Object value )
    {
    	String[] items = condition.split(",");
    	if (items.length > 2)
    		conditions.add(new QueryExpression(items[0], items[1], (String)value, items[2]));
    	else if (items.length > 1)
    		conditions.add(new QueryExpression(items[0], items[1], (String)value));
    	else
    		conditions.add(new QueryExpression(items[0], QueryExpression.OP_EQ, (String)value));
    }

        /* To add non XDoclet-generated methods, create a file named
           xdoclet-QueryConditionForm.java 
           containing the additional code and place it in your metadata/web directory.
        */
    /**
     * @see org.apache.struts.action.ActionForm#reset(org.apache.struts.action.ActionMapping,
     *                                                javax.servlet.http.HttpServletRequest)
     */
    public void reset(ActionMapping mapping, HttpServletRequest request) {
        // reset any boolean data types to false

    }
}

页面代码示例：

<html:form action="listLeaguer"> 
<fmt:message key="userForm.username"/> 
<html:text property="condition(username,like)" styleId="username" styleClass="text_und" size="10"/> 
<fmt:message key="balance.leaguer.field.truename"/> 
<html:text property="condition(truename,like)" styleId="truename" styleClass="text_und" size="10"/> 
<fmt:message key="balance.leaguer.field.commender"/> 
<html:text property="condition(commender,like)" styleId="commender" styleClass="text_und" size="10"/> 
<fmt:message key="balance.leaguer.field.shop"/> 
<html:text property="condition(shopMan,like)" styleId="shopMan" styleClass="text_und" size="10"/> 
<fmt:message key="balance.query.countNum"/> 
<html:text property="condition(joinCountNum,>=)" styleId="begInjoinCountNum" size="10" styleClass="text_und"/>- 
<html:text property="condition(joinCountNum,<=)" styleId="endjoinCountNum" size="10" styleClass="text_und"/> 
<html:text property="condition(inDate,>=)" styleId="begIninDate" size="12" styleClass="text_und" readonly="true"/> 
<img src="images/picker.gif" width="20" height="20" align="absmiddle" style="cursor:hand" onClick="calendar(document.all.begIninDate)"> - 
<html:text property="condition(inDate,<=)" styleId="endInDate" size="12" styleClass="text_und" readonly="true"/> 
<img src="images/picker.gif" width="20" height="20" align="absmiddle" style="cursor:hand" onClick="calendar(document.all.endInDate)"> 
<a href="#" onclick="query();"><fmt:message key="button.query"/></a> 
<fmt:message key="label.inDate"/> 
</html:form> 

然后是Action代码示例：

	public ActionForward list(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		if (log.isDebugEnabled()) {
			log.debug("查询显示计算结果及其列表");
		}
		List balanceList = new ArrayList();
		QueryCondition queryCondition = null;

		String action = ParamUtils.getParameter(request, "actionType");
		if ("query".equals(action)) {
			QueryConditionForm myform = (QueryConditionForm)form;
			queryCondition = (QueryCondition)this.convert(myform);
			request.getSession().setAttribute("balanceQueryCondition", queryCondition);
		} else {
			queryCondition = (QueryCondition)request.getSession().getAttribute("balanceQueryCondition");
			if (queryCondition == null)
				queryCondition = new QueryCondition();
		}
		
		PageSortModel psm = new PageSortModel(request, "balanceList");
		queryCondition.setPageSize(psm.getPageSize());
		queryCondition.setPageNo(psm.getPageNo());
		queryCondition.addOrder("countNum", QueryOrder.DIR_DESC);
		BalanceManager balanceManager = (BalanceManager)getBean("balanceManager");
		
		balanceList = balanceManager.getBalances(queryCondition);
		
		request.setAttribute("balanceList", balanceList);
		
		psm.setTotalRows(queryCondition.getTotalRows());

		return  mapping.findForward("list");
	}

1 楼 aystnd 2006-12-11  

兄弟们，给提提意见吧，呵呵，这个设计肯定还有很多不足的地方，不过我现在用着他觉得还是挺好用的。
哈，页面上增加一个新的查询或者改变查询的方式，比如：原来用“=”，现在要改成“like”,非常的方便。恩，希望大家能自己用用，多提提意见啊。