001: //$HeadURL: https://svn.wald.intevation.org/svn/deegree/base/trunk/src/org/deegree/io/datastore/sql/StatementBuffer.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;
044:
045: import java.sql.PreparedStatement;
046: import java.util.ArrayList;
047: import java.util.Iterator;
048: import java.util.List;
049:
050: import org.deegree.framework.log.ILogger;
051: import org.deegree.framework.log.LoggerFactory;
052:
053: /**
054: * Helper class for the creation and logging of {@link PreparedStatement}s.
055: * <p>
056: * It allows to concatenate the query step by step and holds the arguments of the query as well.
057: *
058: * @author <a href="mailto:schneider@lat-lon.de">Markus Schneider </a>
059: * @author last edited by: $Author: apoth $
060: *
061: * @version $Revision: 9342 $, $Date: 2007-12-27 04:32:57 -0800 (Thu, 27 Dec 2007) $
062: */
063: public class StatementBuffer {
064:
065: protected static final ILogger LOG = LoggerFactory
066: .getLogger(StatementBuffer.class);
067:
068: // contains the SQL-query string
069: private StringBuffer queryBuffer = new StringBuffer(500);
070:
071: // contains the arguments of the query
072: private List<StatementArgument> argumentList = new ArrayList<StatementArgument>();
073:
074: /**
075: * Appends the given character to the statement.
076: *
077: * @param c
078: */
079: public void append(char c) {
080: this .queryBuffer.append(c);
081: }
082:
083: /**
084: * Appends the given string to the statement.
085: *
086: * @param s
087: */
088: public void append(String s) {
089: this .queryBuffer.append(s);
090: }
091:
092: /**
093: * Appends the given {@link StringBuffer} to the statement.
094: *
095: * @param sb
096: */
097: public void append(StringBuffer sb) {
098: this .queryBuffer.append(sb);
099: }
100:
101: /**
102: * Appends the given argument (as the replacement value for the '?' character in the query) to
103: * the statement.
104: *
105: * @param o
106: * @param typeCode
107: */
108: public void addArgument(Object o, int typeCode) {
109: StatementArgument argument = new StatementArgument(o, typeCode);
110: this .argumentList.add(argument);
111: }
112:
113: /**
114: * Returns the query string (without the arguments' values).
115: *
116: * @return the query string (without the arguments' values)
117: */
118: public String getQueryString() {
119: return this .queryBuffer.toString();
120: }
121:
122: /**
123: * Returns an {@link Iterator} over the arguments of the query.
124: *
125: * @return an Iterator over the arguments of the query
126: */
127: public Iterator<StatementArgument> getArgumentsIterator() {
128: return this .argumentList.iterator();
129: }
130:
131: @Override
132: public String toString() {
133: return queryBuffer.toString();
134: }
135:
136: /**
137: * Encapsulates an argument value and the SQL type code for the target column.
138: *
139: * @author <a href="mailto:schneider@lat-lon.de">Markus Schneider</a>
140: * @author last edited by: $Author: apoth $
141: *
142: * @version $Revision: 9342 $, $Date: 2007-12-27 04:32:57 -0800 (Thu, 27 Dec 2007) $
143: */
144: public class StatementArgument {
145:
146: private Object o;
147:
148: private int typeCode;
149:
150: StatementArgument(Object o, int typeCode) {
151: this .o = o;
152: this .typeCode = typeCode;
153: }
154:
155: /**
156: * Returns the argument value.
157: *
158: * @return the argument value
159: */
160: public Object getArgument() {
161: return this .o;
162: }
163:
164: /**
165: * Returns the SQL type code for the column that is targeted by the argument.
166: *
167: * @return the SQL type code for the column that is targeted by the argument
168: */
169: public int getTypeCode() {
170: return this.typeCode;
171: }
172: }
173: }
|