QueryObject

  Table table = new Table("table");
  Column column = new Column("column", "alias", table);
  Criteria criteria = new Compare(column, "=", "123");
  SelectStatement select = new SelectStatement(table, column, criteria);
  SqlQueryVisitor visitor = new SqlQueryVisitor();
  select.accept(visitor);
      => SELECT table.column alias FROM table WHERE table.column = '123'
                    

  Column variable = new Value(new Timestamp(new Date().getTime()));
  PrecompiledQueryVisitor visitor = new PrecompiledQueryVisitor();
  variable.accept(visitor);
      => ? を出力
  visitor.setParamToStatement(preparedStatement, n);
      => n番目のパラメータにタイムスタンプをセット
                    

  Column variable = new Value(new Timestamp(new Date().getTime()));
  SqlQueryVisitor visitor = new SqlQueryVisitor();
  variable.accept(visitor);
      => '2009-02-17 17:09:47.069'
                    

  Column variable = new Value(new BigDecimal("123.456"));
  SqlQueryVisitor visitor = new SqlQueryVisitor();
  variable.accept(visitor);
      => 123.456
                    

  Column function = new Function("CONCAT", "value", new Column("column"));
      => CONCAT('value', column)
                    

  Column operation = new Operation("||", new Column("column"), "STR1", "STR2");
      => column || 'STR1' || 'STR2'
                    

  Criteria comparison = new Compare("column", "=", "value");
      => column = 'value'
                

  Criteria comparison = new Compare("column", "=", "");
      => 空文字列
            
  Value value = new Value("");
  value.setBlankable(true);
  Criteria comparison = new Compare("column", "=", value);
      => column = ''
                

  Table table1 = new Table("table1");
  Table table2 = new Table("table2");
  table1.setOuterJoin(true);
  Compare criteria = new Compare(
      new Column("column1", table1), "=", new Column("column2", table2));
          => table1.column1(+) = table2.column2
                

  Criteria criteria = new CriteriaText("(column1 || '-' || column2) = ?", "9999-99");
  SqlQueryVisitor visitor = new SqlQueryVisitor();
  criteria.accept(visitor);
      => (column1 || '-' || column2) = '9999-99'
                  

  Criteria like = new Like("column", Like.CONTAINS, "abc");
  SqlQueryVisitor sqlVisitor = new SqlQueryVisitor();
  like.accept(sqlVisitor);
      => column LIKE '%abc%'
  PrecompiledQueryVisitor precompiledVisitor = new PrecompiledQueryVisitor();
  like.accept(precompiledVisitor);
      => column LIKE ?
      => パラメータとして"%abc%"を保持
                   

  Criteria like = new Like("column", "?_?", "abc", "def");
  SqlQueryVisitor sqlVisitor = new SqlQueryVisitor();
  like.accept(sqlVisitor);
      => column LIKE '%abc%column LIKE 'abc_def'
  PrecompiledQueryVisitor precompiledVisitor = new PrecompiledQueryVisitor();
  like.accept(precompiledVisitor);
      => column LIKE ?
      => パラメータとして"abc_def"を保持
                   

  Criteria between = new Between("column", new BigDecimal("1.23"), new BigDecimal("3.45"));
      => column BETWEEN 1.23 AND 3.45
                    

  String[] array = new String[] { "a", "b", "c" };
  Criteria in = new In("column", array);
      => column IN ('a', 'b', 'c')
                    

  SelectStatement select = new SelectStatement("table", "*");
  Criteria exists = new Exists(select);
      => EXISTS (SELECT * FROM table)
                    

  Criteria isNull = new IsNull("column");
      => column IS NULL
                    

  Criteria isNull = new Not(new IsNull("column"));
      => column IS NOT NULL
                    

  Criteria and = new And(
          new Compare("column1", "=", "value1"));
  CriteriaGroup or = new Or(
          new Compare("column2", "=", "value2"),
          new Compare("column3", "=", "value3"));
  and.add(or);
      => column1 = 'value1' AND (column2 = 'value2' OR column3 = 'value3')
                    

  Criteria orgroup = new Or(
          new Compare("column1", "=", "value1"),
          new Compare("column2", "=", "value2"));
  Criteria not = new Not(orgroup);
      => NOT (column1 = 'value1' OR column2 = 'value2')
                    

  SelectStatement select = new SelectStatement();
  Table table1 = new Table("table1", "a");
  Table table2 = new Table("table2", "b");
  select.addTable(table1, table2);
  Column column1 = new Column("column1", table1);
  select.addColumn(column1);
  select.addWhere(new Compare(column1, "=", new Column("column2", table2)),
          new Compare(new Column("column3", table2), "=", "value"));
      => SELECT a.column1 FROM table1 a, table2 b WHERE a.column1 = b.column2 AND b.column3 = 'value'
                

  Table table1 = new Table("table1");
  Table table2 = new Table("table2");
  table2.setOuterJoin(true);
  SelectStatement select = new SelectStatement();
  select.addTable(table1, table2);
  Column column1 = new Column("column1", table1);
  Column column2 = new Column("column2", table2);
  select.addColumn(column1);
  select.addWhere(new Compare(column1, "=", column2));
      => SELECT table1.column1 FROM table1, table2 WHERE table1.column1 = table2.column2(+)
                    

  Column column1 = new Column("column1");
  Column column2 = new Column("column2");
  Column sum = new Function("SUM", column2);
  SelectStatement select = new SelectStatement("table", column1, sum);
  select.addGroup(column1);
  select.addHaving(new Compare(sum, ">=", new Integer(5)));
      => SELECT column1, SUM(column2) FROM table GROUP BY column1 HAVING SUM(column2) >= 5
                    

  Column column1 = new Column("column1");
  Column column2 = new Column("column2");
  SelectStatement select = new SelectStatement("table", column1, column2);
  select.addOrder(column1);
  select.addOrder(column2, false);
      => SELECT column1, column2 FROM table ORDER BY column1 ASC, column2 DESC
                    

  SelectStatement select1 = new SelectStatement("table1", "*");
  SelectStatement select2 = new SelectStatement("table2", "*");
  Union union = new Union("UNION ALL", select1, select2);
      => SELECT * FROM table1 UNION ALL SELECT * FROM table2