Package net.sf.jsqlparser.expression

Examples of net.sf.jsqlparser.expression.Expression

2518
2519
2520
2521
2522
2523
2524
2525
2526
2527
2528
2529
    throw new Error("Missing return statement in function");
  }

  final public WhenClause WhenThenSearchCondition() throws ParseException {
        WhenClause whenThen = new WhenClause();
        Expression whenExp = null;
        Expression thenExp = null;
    jj_consume_token(K_WHEN);
    whenExp = Expression();
    jj_consume_token(K_THEN);
    thenExp = SimpleExpression();
           whenThen.setWhenExpression(whenExp);
View Full Code Here
2532
2533
2534
2535
2536
2537
2538
2539
2540
2541
2542
2543
    throw new Error("Missing return statement in function");
  }

  final public WhenClause WhenThenValue() throws ParseException {
        WhenClause whenThen = new WhenClause();
        Expression whenExp = null;
        Expression thenExp = null;
    jj_consume_token(K_WHEN);
    whenExp = PrimaryExpression();
    jj_consume_token(K_THEN);
    thenExp = SimpleExpression();
           whenThen.setWhenExpression(whenExp);
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
    this.sort=sort;
  }
  Pattern whereReg=Pattern.compile("where[ ]*", Pattern.CASE_INSENSITIVE);
  protected Expression getExpressionWithoutParenthesis(Expression ex){
    if(ex instanceof Parenthesis){
      Expression child = ((Parenthesis)ex).getExpression();
      return getExpressionWithoutParenthesis(child);
    }else{
      return ex;
    }
   
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
      JSONArray sublist = new JSONArray();//{colname:{operate:1,value:xxxx}}
      JSONObject subQuery=new JSONObject();
      subQuery.put("subQuery", "1");
      subQuery.put("filter", "AND");
      subQuery.put("list", sublist);
      Expression exp = getExpressionWithoutParenthesis(ex);
      linkList.put(subQuery);
      generateList(exp,sublist,subQuery);
     
    }else{
      JSONObject item=new JSONObject();//
View Full Code Here
359
360
361
362
363
364
365
366
367
368
369
    if(split.length>1)
    {
      String where=split[1].trim();
      CCJSqlParserManager pm = new CCJSqlParserManager();
      PlainSelect plainSelect =  (PlainSelect)((Select) pm.parse(new StringReader("select * from abc where "+where))).getSelectBody();
      Expression e  = getExpressionWithoutParenthesis(plainSelect.getWhere());
      JSONArray jsonObj = new JSONArray();//{colname:{operate:1,value:xxxx}}

      JSONObject subQuery=new JSONObject();
      subQuery.put("subQuery", "1");
      subQuery.put("filter", "AND");
View Full Code Here
284
285
286
287
288
289
290
291
292
293
294
295
    public void visit(ExpressionList expressionList) {
      if (useBracketsInExprList)
        buffer.append("(");
        for (Iterator iter = expressionList.getExpressions().iterator(); iter.hasNext();) {
            Expression expression = (Expression) iter.next();
            expression.accept(this);
            if (iter.hasNext())
                buffer.append(", ");
        }
      if (useBracketsInExprList)
        buffer.append(")");
View Full Code Here
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
        buffer.append("{t '" + timeValue.getValue().toString() + "'}");
    }

  public void visit(CaseExpression caseExpression) {
    buffer.append("CASE ");
    Expression switchExp = caseExpression.getSwitchExpression();
    if( switchExp != null ) {
      switchExp.accept(this);
    }
   
    List clauses = caseExpression.getWhenClauses();
    for (Iterator iter = clauses.iterator(); iter.hasNext();) {
      Expression exp = (Expression) iter.next();
      exp.accept(this);
    }
   
    Expression elseExp = caseExpression.getElseExpression();
    if( elseExp != null ) {
      elseExp.accept(this);
    }
   
    buffer.append(" END");
  }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
    }

    if (plainSelect.getGroupByColumnReferences() != null) {
      buffer.append(" GROUP BY ");
      for (Iterator iter = plainSelect.getGroupByColumnReferences().iterator(); iter.hasNext();) {
        Expression columnReference = (Expression) iter.next();
        columnReference.accept(expressionVisitor);
        if (iter.hasNext()) {
          buffer.append(", ");
        }
      }
    }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
    buffer.append("UPDATE " + update.getTable().getWholeTableName() + " SET ");
    for (int i = 0; i < update.getColumns().size(); i++) {
      Column column = (Column) update.getColumns().get(i);
      buffer.append(column.getWholeColumnName() + "=");

      Expression expression = (Expression) update.getExpressions().get(i);
      expression.accept(expressionVisitor);
      if (i < update.getColumns().size() - 1) {
        buffer.append(", ");
      }

    }
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
  }

  public void visit(ExpressionList expressionList) {
    buffer.append(" VALUES (");
    for (Iterator iter = expressionList.getExpressions().iterator(); iter.hasNext();) {
      Expression expression = (Expression) iter.next();
      expression.accept(expressionVisitor);
      if (iter.hasNext())
        buffer.append(", ");
    }
    buffer.append(")");
  }
View Full Code Here
TOP

Related Classes of net.sf.jsqlparser.expression.Expression

  • com.alimama.mdrill.jdbc.SqlParser
  • com.beacon50.jdbc.aws.SimpleDBPreparedStatement
  • com.beacon50.jdbc.aws.SimpleDBStatement
  • estimators.JSQLTypeConverterTest
  • net.sf.jsqlparser.parser.CCJSqlParser
  • net.sf.jsqlparser.parser.CCJSqlParserUtilTest
  • net.sf.jsqlparser.util.deparser.ExpressionDeParser
  • net.sf.jsqlparser.util.deparser.InsertDeParser
  • net.sf.jsqlparser.util.deparser.ReplaceDeParser
  • net.sf.jsqlparser.util.deparser.SelectDeParser
    • Copyright © 2018 www.massapicom. 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.