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 }