Package net.sf.jsqlparser.expression

Examples of net.sf.jsqlparser.expression.Expression

66
67
68
69
70
71
72
73
74
75
76
77
      buffer.append(" SET ");
      for (int i = 0; i < replace.getColumns().size(); i++) {
        Column column = (Column) replace.getColumns().get(i);
        buffer.append(column.getWholeColumnName() + "=");

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

      }
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
  }

  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
41
42
43
44
45
46
47
48
49
50
51
52
  /**
   * Test of parseExpression method, of class CCJSqlParserUtil.
   */
  @Test
  public void testParseExpression() throws Exception {
    Expression result = CCJSqlParserUtil.parseExpression("a+b");
    assertEquals("a + b", result.toString());
    assertTrue(result instanceof Addition);
    Addition add = (Addition)result;
    assertTrue(add.getLeftExpression() instanceof Column);
    assertTrue(add.getRightExpression() instanceof Column);
  }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
    assertTrue(add.getRightExpression() instanceof Column);
  }
 
  @Test
  public void testParseExpression2() throws Exception {
    Expression result = CCJSqlParserUtil.parseExpression("2*(a+6.0)");
    assertEquals("2 * (a + 6.0)", result.toString());
    assertTrue(result instanceof Multiplication);
    Multiplication mult = (Multiplication)result;
    assertTrue(mult.getLeftExpression() instanceof LongValue);
    assertTrue(mult.getRightExpression() instanceof Parenthesis);
  }
View Full Code Here
61
62
63
64
65
66
67
68
    assertTrue(mult.getRightExpression() instanceof Parenthesis);
  }
   
    @Test
  public void testParseCondExpression() throws Exception {
    Expression result = CCJSqlParserUtil.parseCondExpression("a+b>5 and c<3");
    assertEquals("a + b > 5 AND c < 3", result.toString());
  }
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
      buffer.append(" SET ");
      for (int i = 0; i < replace.getColumns().size(); i++) {
        Column column = replace.getColumns().get(i);
        buffer.append(column.getFullyQualifiedName()).append("=");

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

      }
View Full Code Here
116
117
118
119
120
121
122
123
124
125
126
127
  @Override
  public void visit(ExpressionList expressionList) {
    buffer.append(" VALUES (");
    for (Iterator<Expression> iter = expressionList.getExpressions().iterator(); iter.hasNext();) {
      Expression expression = iter.next();
      expression.accept(expressionVisitor);
      if (iter.hasNext()) {
        buffer.append(", ");
      }
    }
    buffer.append(")");
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
        if (!update.isUseSelect()) {
            for (int i = 0; i < update.getColumns().size(); i++) {
                Column column = update.getColumns().get(i);
                buffer.append(column.getFullyQualifiedName()).append(" = ");

                Expression expression = update.getExpressions().get(i);
                expression.accept(expressionVisitor);
                if (i < update.getColumns().size() - 1) {
                    buffer.append(", ");
                }
            }
        } else {
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
136
    @Override
    public void visit(ExpressionList expressionList) {
        buffer.append(" VALUES (");
        for (Iterator<Expression> iter = expressionList.getExpressions().iterator(); iter.hasNext();) {
            Expression expression = iter.next();
            expression.accept(expressionVisitor);
            if (iter.hasNext()) {
                buffer.append(", ");
            }
        }
        buffer.append(")");
View Full Code Here
140
141
142
143
144
145
146
147
148
149
150
151
    public void visit(MultiExpressionList multiExprList) {
        buffer.append(" VALUES ");
        for (Iterator<ExpressionList> it = multiExprList.getExprList().iterator(); it.hasNext();) {
            buffer.append("(");
            for (Iterator<Expression> iter = it.next().getExpressions().iterator(); iter.hasNext();) {
                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.