attributequeryitem.java

日常的办公系统 应用工作流框架等增加员工的基本信息、培训信息、奖罚信息、薪资信息

/*
 * Copyright (c) 2005, John Mettraux, OpenWFE.org
 * All rights reserved.
 * 
 * Redistribution and use in source and binary forms, with or without 
 * modification, are permitted provided that the following conditions are met:
 * 
 * . Redistributions of source code must retain the above copyright notice, this
 *   list of conditions and the following disclaimer.  
 * 
 * . Redistributions in binary form must reproduce the above copyright notice, 
 *   this list of conditions and the following disclaimer in the documentation 
 *   and/or other materials provided with the distribution.
 * 
 * . Neither the name of the "OpenWFE" nor the names of its contributors may be
 *   used to endorse or promote products derived from this software without
 *   specific prior written permission.
 * 
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 
 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE 
 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE 
 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR 
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF 
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS 
 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN 
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) 
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE 
 * POSSIBILITY OF SUCH DAMAGE.
 *
 * $Id: AttributeQueryItem.java,v 1.15 2005/05/17 16:41:06 jmettraux Exp $
 */

//
// AttributeQueryItem.java
//
// [e-mail]
//
// generated with 
// jtmpl 1.1.00 16.08.2003 John Mettraux ([e-mail])
//

package openwfe.org.xdbc.query;

import openwfe.org.sql.SqlUtils;
import openwfe.org.xdbc.XdbcException;


/**
 * no comment
 *
 * <p><font size=2>CVS Info :
 * <br>$Author: jmettraux $
 * <br>$Id: AttributeQueryItem.java,v 1.15 2005/05/17 16:41:06 jmettraux Exp $ </font>
 *
 * @author [e-mail]
 */
public class AttributeQueryItem

    extends AtomicQueryItem

{

    static org.apache.log4j.Logger log = org.apache.log4j.Logger
        .getLogger(AttributeQueryItem.class.getName());

    //
    // CONSTANTS & co

    public final static String ATTNAME = "attName";
    public final static String ATTVALUE = "attValue";


    public final static String XML_ELT_NAME = "att-query";

    public final static String XML_ATT_ATT_NAME = "att-name";
    public final static String XML_ATT_ATT_VALUE = "att-value";

    //
    // FIELDS

    protected String attName = null;
    protected String attValue = null;

    //
    // CONSTRUCTORS

    public AttributeQueryItem 
        (String attName, String attValue)
    {
        this.attName = attName;
        this.attValue = attValue;
    }

    public AttributeQueryItem 
        (String attName, String attValue, int valueOperator)
    {
        this.attName = attName;
        this.attValue = attValue;
        this.valueOperator = valueOperator;
    }

    //
    // METHODS from QueryItem

    public String getQueryString ()
    {
        StringBuffer sb = new StringBuffer();

        sb.append("(");

        if (this.attName != null)
        {
            sb.append(ATTNAME);
            sb.append(" LIKE ");
            sb.append(SqlUtils.prepareString(this.attName));
        }

        if (this.attName != null && this.attValue != null)
            sb.append(" AND ");

        if (this.attValue != null)
        {
            sb.append(ATTVALUE);
            sb.append(getValueOperator());
            sb.append(SqlUtils.prepareString(this.attValue));
        }

        sb.append(")");

        return sb.toString();
    }

    public org.jdom.Element encode ()
    {
        org.jdom.Element result = new org.jdom.Element(XML_ELT_NAME);

        result.setAttribute(XML_ATT_ATT_NAME, this.attName);
        result.setAttribute(XML_ATT_ATT_VALUE, this.attValue);

        result.setAttribute(XML_ATT_VALUE_OPERATOR, encodeValueOperator());

        return result;
    }

    public boolean matches (org.jdom.Element elt)
    {
        java.util.Iterator it = elt.getAttributes().iterator();
        while (it.hasNext())
        {
            org.jdom.Attribute att = (org.jdom.Attribute)it.next();

            if (att.getName().matches(this.attName) &&
                compare(att.getValue(), this.attValue))
            {
                return true;
            }
        }

        return childrenMatches(elt);
    }

    public IdSet query (String clientIdLike, java.sql.Connection con)
        throws XdbcException
    {
        return query(ATTRIBUTES, clientIdLike, con);
    }

    //
    // METHODS

    //
    // STATIC METHODS

    public static QueryItem decode (org.jdom.Element elt)
    {
        String attName = elt.getAttributeValue(XML_ATT_ATT_NAME);
        String attValue = elt.getAttributeValue(XML_ATT_ATT_VALUE);

        String sValueOperator = elt.getAttributeValue(XML_ATT_VALUE_OPERATOR);

        AttributeQueryItem aqi = new AttributeQueryItem(attName, attValue);
        aqi.setValueOperator(decodeValueOperator(sValueOperator));
        return aqi;
    }

}