    001    //$HeadURL: svn+ssh://mschneider@svn.wald.intevation.org/deegree/base/trunk/src/org/deegree/io/datastore/sql/wherebuilder/AbstractPropertyNode.java $
    002    /*----------------------------------------------------------------------------
    003     This file is part of deegree, http://deegree.org/
    004     Copyright (C) 2001-2009 by:
    005       Department of Geography, University of Bonn
    006     and
    007       lat/lon GmbH
    008
    009     This library is free software; you can redistribute it and/or modify it under
    010     the terms of the GNU Lesser General Public License as published by the Free
    011     Software Foundation; either version 2.1 of the License, or (at your option)
    012     any later version.
    013     This library is distributed in the hope that it will be useful, but WITHOUT
    014     ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
    015     FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
    016     details.
    017     You should have received a copy of the GNU Lesser General Public License
    018     along with this library; if not, write to the Free Software Foundation, Inc.,
    019     59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
    020
    021     Contact information:
    022
    023     lat/lon GmbH
    024     Aennchenstr. 19, 53177 Bonn
    025     Germany
    026     http://lat-lon.de/
    027
    028     Department of Geography, University of Bonn
    029     Prof. Dr. Klaus Greve
    030     Postfach 1147, 53001 Bonn
    031     Germany
    032     http://www.geographie.uni-bonn.de/deegree/
    033
    034     e-mail: info@deegree.org
    035    ----------------------------------------------------------------------------*/
    036    package org.deegree.io.datastore.sql.wherebuilder;
    037
    038    /**
    039     * Part of a {@link SpecialCharString} that contains standard characters only.
    040     *
    041     * @author <a href="mailto:schneider@lat-lon.de">Markus Schneider </a>
    042     * @author last edited by: $Author: mschneider $
    043     *
    044     * @version $Revision: 6588 $, $Date: 2007-04-11 17:31:29 +0200 (Mi, 11 Apr 2007) $
    045     */
    046    final class PlainText implements SpecialCharStringPart {
    047
    048        private String text;
    049
    050        /**
    051         * Creates a new instance of {@link PlainText}.
    052         *
    053         * @param text
    054         */
    055        PlainText( String text ) {
    056            this.text = text;
    057        }
    058
    059        /**
    060         * Returns an encoding that is suitable for arguments of "IS LIKE"-clauses in SQL.
    061         * <p>
    062         * This means:
    063         * <ul>
    064         * <li>wildCard: encoded as the '%'-character</li>
    065         * <li>singleChar: encoded as the '_'-character</li>
    066         * <li>escape: encoded as the '\'-character</li>
    067         * </ul>
    068         *
    069         * @return encoded string
    070         */
    071        public String toSQLStyle() {
    072            return toSQLStyle( false );
    073        }
    074
    075        /**
    076         * Returns an encoding that is suitable for arguments of "IS LIKE"-clauses in SQL.
    077         * <p>
    078         * This means:
    079         * <ul>
    080         * <li>wildCard: encoded as the '%'-character</li>
    081         * <li>singleChar: encoded as the '_'-character</li>
    082         * <li>escape: encoded as the '\'-character</li>
    083         * </ul>
    084         *
    085         * @param toLowerCase
    086         *            true means: convert to lowercase letters
    087         * @return encoded string
    088         */
    089        public String toSQLStyle( boolean toLowerCase ) {
    090            StringBuffer sqlEscaped = new StringBuffer( text.length() );
    091            String rest = text;
    092            while ( rest.length() > 0 ) {
    093                char currentChar = rest.charAt( 0 );
    094                switch ( currentChar ) {
    095                case '%':
    096                case '_':
    097                case '"':
    098                case '\'':
    099                case '\\': {
    100                    sqlEscaped.append( '\\' );
    101                    sqlEscaped.append( currentChar );
    102                    break;
    103                }
    104                default: {
    105                    if ( toLowerCase ) {
    106                        sqlEscaped.append( Character.toLowerCase( currentChar ) );
    107                    } else {
    108                        sqlEscaped.append( currentChar );
    109                    }
    110                    break;
    111                }
    112                }
    113                rest = rest.substring( 1 );
    114            }
    115            return sqlEscaped.toString();
    116        }
    117
    118        @Override
    119        public String toString() {
    120            return "Text: " + text;
    121        }
    122    }