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