You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@turbine.apache.org by mi...@apache.org on 2001/06/22 23:49:45 UTC
cvs commit: jakarta-turbine/proposals/eric/statement BaseSql.java
mikeh 01/06/22 14:49:45
Modified: proposals/eric/statement BaseSql.java
Log:
Added overloaded versions for taking StringBuffer
Revision Changes Path
1.2 +26 -9 jakarta-turbine/proposals/eric/statement/BaseSql.java
Index: BaseSql.java
===================================================================
RCS file: /home/cvs/jakarta-turbine/proposals/eric/statement/BaseSql.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- BaseSql.java 2001/06/22 01:48:14 1.1
+++ BaseSql.java 2001/06/22 21:49:45 1.2
@@ -108,6 +108,7 @@
{
public static String EMPTY = "";
public static String SELECT = "SELECT ";
+ public static String SET = "SET ";
public static String FROM = " FROM ";
public static String WHERE = " WHERE ";
public static String ORDER_BY = " ORDER BY ";
@@ -130,7 +131,7 @@
public static String LIKE = " LIKE ";
public static String AND = " AND ";
public static String OR = " OR ";
- public static String NOT = "NOT ";
+ public static String NOT = " NOT ";
public static String COUNT = "COUNT";
public static String MIN = "MIN";
public static String MAX = "MAX";
@@ -175,20 +176,27 @@
* @param middle String the thing in the middle
* @return [left][middle][right]
*/
+
protected String leftRightMiddle(String left,
String right,
String middle)
{
- StringBuffer sb = new StringBuffer(
- left.length()
+ StringBuffer sb = new StringBuffer(left.length()
+right.length()
+middle.length());
- sb.append(left)
- .append(middle)
- .append(right);
+ leftRightMiddle(sb, left, right, middle);
return sb.toString();
}
+ protected String leftRightMiddle(StringBuffer sb,
+ String left,
+ String right,
+ String middle)
+ {
+ sb.append(left).append(middle).append(right);
+ return sb.toString();
+ }
+
/**
* The workhorse used by several other methods to construct a
* String of the form
@@ -222,9 +230,19 @@
//list and converting each item to a string and summing
//their lengths, but would that would be any less
//expensive than letting the StringBuffer resize itself?
- StringBuffer sb = new StringBuffer(
- left.length()+right.length()+( (connector.length() + 7) * list.size() ));
+ int size = left.length() + right.length() +
+ ((connector.length() + 7) * list.size());
+ StringBuffer sb = new StringBuffer(size);
+ leftRightListConnector(sb, left, right, list, connector);
+ return sb.toString();
+ }
+ protected void leftRightListConnector(StringBuffer sb,
+ String left,
+ String right,
+ List list,
+ String connector)
+ {
Iterator listIterator = list.iterator();
sb.append(left);
if (listIterator.hasNext())
@@ -237,7 +255,6 @@
.append(listIterator.next());
}
sb.append(right);
- return sb.toString();
}
/**
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org