usermatch.java

一套JAVA的CA证书签发系统.

/*************************************************************************
 *                                                                       *
 *  EJBCA: The OpenSource Certificate Authority                          *
 *                                                                       *
 *  This software is free software; you can redistribute it and/or       *
 *  modify it under the terms of the GNU Lesser General Public           *
 *  License as published by the Free Software Foundation; either         *
 *  version 2.1 of the License, or any later version.                    *
 *                                                                       *
 *  See terms of license at gnu.org.                                     *
 *                                                                       *
 *************************************************************************/
 
/*
 * UserMatch.java
 *
 * Created on den 20 juli 2002, 23:20
 */
package se.anatom.ejbca.util.query;

/**
 * A class used by Query class to build a query for ejbca ra module. Inherits BasicMatch.  Main
 * function is getQueryString which returns a fragment of SQL statment.
 *
 * @author TomSelleck
 *
 * @see se.anatom.ejbca.util.query.BasicMatch
 * @see se.anatom.ejbca.util.query.TimeMatch
 * @see se.anatom.ejbca.util.query.LogMatch
 */
public class UserMatch extends BasicMatch {
    // Public Constants

    public final static int MATCH_WITH_USERNAME            = 0;
    public final static int MATCH_WITH_EMAIL               = 1;
    public final static int MATCH_WITH_STATUS              = 2; // Value must the number representation.
    public final static int MATCH_WITH_ENDENTITYPROFILE    = 3; // Matches the profile id not profilename.
    public final static int MATCH_WITH_CERTIFICATEPROFILE  = 4; // Matches the certificatetype id not name.
    public final static int MATCH_WITH_CA                  = 5; // Matches the CA id not CA name.
	public final static int MATCH_WITH_TOKEN               = 6;
    // Subject DN fields.
    public final static int MATCH_WITH_UID              = 100;    
    public final static int MATCH_WITH_COMMONNAME       = 101;
    public final static int MATCH_WITH_DNSERIALNUMBER   = 102;   
    public final static int MATCH_WITH_GIVENNAME        = 103; 
    public final static int MATCH_WITH_INITIALS         = 104; 
    public final static int MATCH_WITH_SURNAME          = 105;      
    public final static int MATCH_WITH_TITLE            = 106;      
    public final static int MATCH_WITH_ORGANIZATIONUNIT = 107;
    public final static int MATCH_WITH_ORGANIZATION     = 108;
    public final static int MATCH_WITH_LOCALE           = 109;
    public final static int MATCH_WITH_STATE            = 110;
    public final static int MATCH_WITH_DOMAINCOMPONENT  = 111;      
    public final static int MATCH_WITH_COUNTRY          = 112;    


    // Private Constants.
    private final static String[] MATCH_WITH_SQLNAMES = {"username", "subjectEmail", "status"
                                                         , "endEntityProfileId", "certificateProfileId"
                                                         , "cAId", "tokenType"}; 
                                                         

    // Represents the column names in ra userdata table.
    private static final String MATCH_WITH_SUBJECTDN = "subjectDN";
    private static final String[] MATCH_WITH_SUBJECTDN_NAMES = {
        "UID=", "CN=", "SN=", "GIVENNAME=", "INITIALS=", "SURNAME=", "T=", "OU=", "O=", "L=", "ST=",
        "DC", "C="
    };

    // Public methods.

    /**
     * Creates a new instance of UserMatch.
     *
     * @param matchwith determines which field i userdata table to match with.
     * @param matchtype determines how to match the field. SubjectDN fields can only be matched
     *        with 'begins with'.
     * @param matchvalue the value to match with.
     *
     * @throws NumberFormatException if matchvalue constains illegal numbervalue when matching
     *         number field.
     */
    public UserMatch(int matchwith, int matchtype, String matchvalue)
        throws NumberFormatException {
        this.matchwith = matchwith;
        this.matchtype = matchtype;
        this.matchvalue = matchvalue;

        if ((matchwith >= MATCH_WITH_STATUS) && (matchwith <= MATCH_WITH_CERTIFICATEPROFILE)) {
            new Integer(matchvalue);
        }
    }

    /**
     * Returns a SQL statement fragment from the given data.
     *
     * @return sql string
     */
    public String getQueryString() {
        String returnval = "";

        if (isSubjectDNMatch()) {
            // Ignore MATCH_TYPE_EQUALS.
            returnval = MATCH_WITH_SUBJECTDN + " LIKE '%" +
                MATCH_WITH_SUBJECTDN_NAMES[matchwith - 100] + matchvalue + "%'";
        } else {
            if (matchtype == BasicMatch.MATCH_TYPE_EQUALS) {
                returnval = MATCH_WITH_SQLNAMES[matchwith] + " = '" + matchvalue + "'";
            }

            if (matchtype == BasicMatch.MATCH_TYPE_BEGINSWITH) {
                returnval = MATCH_WITH_SQLNAMES[matchwith] + " LIKE '" + matchvalue + "%'";
            }
        }

        return returnval;
    }

    // getQueryString

    /**
     * Checks if query data is ok.
     *
     * @return true if query is legal, false otherwise
     */
    public boolean isLegalQuery() {
        return !(matchvalue.trim().equals(""));
    }

    // Private Methods
    private boolean isSubjectDNMatch() {
        return this.matchwith >= 100;
    }

    // Private Fields.
    private int matchwith;
    private int matchtype;
    private String matchvalue;
}