KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > jcorporate > expresso > core > misc > SQLFastStringBuffer


1 /* ====================================================================
2  * The Jcorporate Apache Style Software License, Version 1.2 05-07-2002
3  *
4  * Copyright (c) 1995-2002 Jcorporate Ltd. All rights reserved.
5  *
6  * Redistribution and use in source and binary forms, with or without
7  * modification, are permitted provided that the following conditions
8  * are met:
9  *
10  * 1. Redistributions of source code must retain the above copyright
11  * notice, this list of conditions and the following disclaimer.
12  *
13  * 2. Redistributions in binary form must reproduce the above copyright
14  * notice, this list of conditions and the following disclaimer in
15  * the documentation and/or other materials provided with the
16  * distribution.
17  *
18  * 3. The end-user documentation included with the redistribution,
19  * if any, must include the following acknowledgment:
20  * "This product includes software developed by Jcorporate Ltd.
21  * (http://www.jcorporate.com/)."
22  * Alternately, this acknowledgment may appear in the software itself,
23  * if and wherever such third-party acknowledgments normally appear.
24  *
25  * 4. "Jcorporate" and product names such as "Expresso" must
26  * not be used to endorse or promote products derived from this
27  * software without prior written permission. For written permission,
28  * please contact info@jcorporate.com.
29  *
30  * 5. Products derived from this software may not be called "Expresso",
31  * or other Jcorporate product names; nor may "Expresso" or other
32  * Jcorporate product names appear in their name, without prior
33  * written permission of Jcorporate Ltd.
34  *
35  * 6. No product derived from this software may compete in the same
36  * market space, i.e. framework, without prior written permission
37  * of Jcorporate Ltd. For written permission, please contact
38  * partners@jcorporate.com.
39  *
40  * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
41  * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
42  * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
43  * DISCLAIMED. IN NO EVENT SHALL JCORPORATE LTD OR ITS CONTRIBUTORS
44  * BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
45  * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED
46  * TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
47  * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
48  * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
49  * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
50  * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
51  * SUCH DAMAGE.
52  * ====================================================================
53  *
54  * This software consists of voluntary contributions made by many
55  * individuals on behalf of the Jcorporate Ltd. Contributions back
56  * to the project(s) are encouraged when you make modifications.
57  * Please send them to support@jcorporate.com. For more information
58  * on Jcorporate Ltd. and its products, please see
59  * <http://www.jcorporate.com/>.
60  *
61  * Portions of this software are based upon other open source
62  * products and are subject to their respective licenses.
63  */
64
65 package com.jcorporate.expresso.core.misc;
66
67 import com.jcorporate.expresso.kernel.util.FastStringBuffer;
68
69
70 /**
71  * Stringbuffer with specific method to work on sql requests
72  *
73  * @author Yves Henri AMAIZO
74  */
75 public class SQLFastStringBuffer {
76     /**
77      * SQL query
78      */
79     FastStringBuffer sb;
80     /**
81      * indicate the list beginning
82      */
83     private boolean begin = true;
84
85     /**
86      * Constructor
87      */
88     public SQLFastStringBuffer() {
89         sb = new FastStringBuffer();
90     }
91
92     /**
93      * Initialises l'objet SQLFastStringBuffer.
94      *
95      * @param s String s Initial StringBuffer
96      */
97     public SQLFastStringBuffer(String JavaDoc s) {
98         sb = new FastStringBuffer(s);
99     }
100
101     /**
102      * Constructor
103      *
104      * @param length the size of the buffer
105      */
106     public SQLFastStringBuffer(int length) {
107         sb = new FastStringBuffer(length);
108     }
109
110     /**
111      * add separator to the list, if required
112      *
113      * @return this
114      */
115     public SQLFastStringBuffer addListSeparator() {
116         if (begin) {
117             begin = false;
118         } else {
119             sb.append(",");
120         }
121         return this;
122     }
123
124     /**
125      * add a double to the stringbuffer
126      *
127      * @param v parameter to add
128      * @return this
129      */
130     public SQLFastStringBuffer append(double v) {
131         sb.append(v);
132         return this;
133     }
134
135     /**
136      * add an integer value to string
137      *
138      * @param v the integer to append
139      * @return this
140      */
141     public SQLFastStringBuffer append(int v) {
142         sb.append(v);
143         return this;
144     }
145
146     /**
147      * add a String to stringbuffer
148      *
149      * @param v the string to append
150      * @return this
151      */
152     public SQLFastStringBuffer append(String JavaDoc v) {
153         sb.append(v);
154         return this;
155     }
156
157     /**
158      * add an item to the list
159      *
160      * @param i the item to add
161      * @return this
162      */
163     public SQLFastStringBuffer appendSQLItem(String JavaDoc i) {
164         addListSeparator();
165         sb.append(i);
166         return this;
167     }
168
169     /**
170      * add a SQL value to the current list
171      *
172      * @param v the value
173      * @return this
174      */
175     public SQLFastStringBuffer appendSQLNestedValue(double v) {
176         addListSeparator();
177         sb.append(v);
178         return this;
179     }
180
181     /**
182      * add a SQL value to the current list
183      *
184      * @param v the value
185      * @return this
186      */
187     public SQLFastStringBuffer appendSQLNestedValue(int v) {
188         addListSeparator();
189         sb.append(v);
190         return this;
191     }
192
193     /**
194      * add a SQL value to the current list
195      *
196      * @param v the value
197      * @return this
198      */
199     public SQLFastStringBuffer appendSQLNestedValue(String JavaDoc v) {
200         addListSeparator();
201         return appendSQLValue(v);
202     }
203
204     /**
205      * add a SQL value to the current String (no list separator)
206      *
207      * @param v the value
208      * @return this
209      */
210     public SQLFastStringBuffer appendSQLValue(double v) {
211         sb.append(v);
212         return this;
213     }
214
215     /**
216      * add a SQL value to the current String (no list separator)
217      *
218      * @param v the value
219      * @return this
220      */
221     public SQLFastStringBuffer appendSQLValue(int v) {
222         sb.append(v);
223         return this;
224     }
225
226     /**
227      * add a SQL value to the current String (no list separator)
228      *
229      * @param v the value
230      * @return this
231      */
232     public SQLFastStringBuffer appendSQLValue(String JavaDoc v) {
233         int i = 0;
234         if (v != null) {
235             while ((i = v.indexOf("'", i)) >= 0) {
236                 v = v.substring(0, i) + "'" + v.substring(i);
237                 i += 2;
238             }
239             sb.append("'");
240         }
241         sb.append(v);
242         if (v != null) {
243             sb.append("'");
244         }
245         return this;
246     }
247
248     /**
249      * add a SQL value to the current String (no list separator)
250      *
251      * @param str the value to append
252      * @return this
253      */
254     public SQLFastStringBuffer appendSQLPadValue(String JavaDoc str) {
255         sb.append(" " + str + " ");
256         return this;
257     }
258
259     /**
260      * starts a sql list (initialize the separator inserter)
261      *
262      * @return this
263      */
264     public SQLFastStringBuffer startList() {
265         begin = true;
266         return this;
267     }
268
269     /**
270      * @return the String value of this object
271      */
272     public String JavaDoc toString() {
273         return sb.toString();
274     }
275 }
276
Popular Tags