Package org.araneaframework.backend.list

Examples of org.araneaframework.backend.list.SqlExpression.toSqlString()

105
106
107
108
109
110
111
112
113
114
115
        }
        return value.getValue();
      }
    });
    SqlExpression sqlExpr = builder.buildSqlExpression(expr);
    String sqlString = sqlExpr.toSqlString();
    Object[] values = sqlExpr.getValues();
    log.info("SQL string: " + sqlString);
    log.info("SQL values: " + Arrays.asList(values));
  }
}
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
        }
        return value.getValue();
      }
    });
    SqlExpression sqlExpr = builder.buildSqlExpression(expr);
    String sqlString = sqlExpr.toSqlString();
    Object[] values = sqlExpr.getValues();
    log.info("SQL string: " + sqlString);
    log.info("SQL values: " + Arrays.asList(values));
  }
}
View Full Code Here
347
348
349
350
351
352
353
354
355
356
357
   *
   * @return the database fields list seperated by commas, which can be used in "SELECT" clause.
   */
  public String getDatabaseFields() {
    SqlExpression expr = this.getFieldsSqlExpression();
    return expr != null ? expr.toSqlString() : "";
  }
 
  /**
   * Returns the filter database condition, which can be used in "WHERE" clause.
   *
 
View Full Code Here
357
358
359
360
361
362
363
364
365
366
367
   *
   * @return the filter database condition, which can be used in "WHERE" clause.
   */
  public String getDatabaseFilter() {
    SqlExpression expr = this.getFilterSqlExpression();
    return expr != null ? expr.toSqlString() : "";
  }
 
  public String getDatabaseFilterWith(String prefix, String suffix) {
    StringBuffer whereCondition = new StringBuffer();   
    if (this.filterExpr != null) {
View Full Code Here
389
390
391
392
393
394
395
396
397
398
399
   *
   * @return the order database representation, which can be used in "ORDER BY" clause.
   */
  public String getDatabaseOrder() {
    SqlExpression expr = this.getOrderSqlExpression();
    return expr != null ? expr.toSqlString() : "";
  }
 
  /**
   * Returns the database order query with <code>prefix</code> added before and
   * <code>suffix</code> after it if the query is not empty.
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
  public String toSqlString() {
    StringBuffer sb = new StringBuffer();
    for (Iterator i = this.children.iterator(); i.hasNext();) {
      SqlExpression expr = (SqlExpression) i.next();
      // sb.append("(").append(expr.toSqlString()).append(")");
      sb.append(expr.toSqlString());
      if (i.hasNext()) {
        sb.append(" AND ");
      }
    }
    return sb.toString();
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
  public String toSqlString() {
    StringBuffer sb = new StringBuffer();
    for (Iterator i = this.children.iterator(); i.hasNext();) {
      SqlExpression expr = (SqlExpression) i.next();
      // sb.append("(").append(expr.toSqlString()).append(")");
      sb.append(expr.toSqlString());
      if (i.hasNext()) {
        sb.append(" OR ");
      }
    }
    return sb.toString();
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
public class SqlConcatenationExpression extends SqlMultiExpression {
  public String toSqlString() {
    StringBuffer sb = new StringBuffer();
    for (Iterator i = this.children.iterator(); i.hasNext();) {
      SqlExpression expr = (SqlExpression) i.next();
      sb.append(expr.toSqlString());
      if (i.hasNext()) {
        sb.append(" || ");
      }
    }
    return sb.toString();
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
public class SqlCollectionExpression extends SqlMultiExpression {
  public String toSqlString() {
    StringBuffer sb = new StringBuffer();
    for (Iterator i = this.children.iterator(); i.hasNext();) {
      SqlExpression expr = (SqlExpression) i.next();
      sb.append(expr.toSqlString());
      if (i.hasNext()) {
        sb.append(", ");
      }
    }
    return sb.toString();
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
  public String toSqlString() {
    StringBuffer sb = new StringBuffer();
    sb.append(this.name).append("(");
    for (Iterator i = this.children.iterator(); i.hasNext();) {
      SqlExpression expr = (SqlExpression) i.next();
      sb.append(expr.toSqlString());
      if (i.hasNext()) {
        sb.append(", ");
      }
    }
    sb.append(")");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.