Sql

Overview

Package

Class

Use

Deprecated

Index

Home >> All >> org >> apache >> turbine >> util >> db >> [ statement overview ]

PREV CLASS NEXT CLASS

SUMMARY:

JAVADOC |

Sourc code of org.apache.turbine.util.db.statement.Sql

SOURCE |

Download org.apache.turbine.util.db.statement.Sql

DOWNLOAD | NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.apache.turbine.util.db.statement
Interface Sql

All Known Implementing Classes:: BaseSql

public interface Sql

This interface defines methods to construct String fragments of SQL statements. BaseSql provides a base implementation of this interface. Chaining the methods allows the creation of arbitrarily complex statements.

    getInsert       --> insert into left (item1,...,itemN)
    getValues       --> values (item1,...,itemN)
    getUpdate       --> update left item1,...,itemN
    getSet          --> set left=right
    getDelete       --> delete from left
    getSelect       --> select item1,item2,...,itemN
    getFrom         --> from item1,item2,...,itemN
    getWhere        --> where tree
    getEqual        --> (left = right)
    getNotEqual     --> (left != right)
    getGreaterThan  --> (left > right)
    getGreaterEqual --> (left >= right)
    getLessThan     --> (left < right)
    getLessEqual    --> (left <= right)
    getNull         --> (item is null)
    getNotNull      --> (item is not null)
    getIn           --> (left in right)
    getNotIn        --> (left not in right)
    getAnd          --> (left and right)
    getOr           --> (left or right)
    getNot          --> (not item)
    getAscending    --> item ASC
    getDescending   --> item DESC
    getOrderBy      --> order by item1,item2,...,itemN
    getGroupBy      --> group by item1,item2,...,itemN
    getHaving       --> having tree
    getCount        --> count(item)
    getMin          --> min(item)
    getMax          --> max(item)
    getAvg          --> avg(item)
    getSum          --> sum(item)
    getUpper        --> upper(item)

Version:: $Id: Sql.java,v 1.1.6.2 2004/05/20 04:34:17 seade Exp $

Method Summary

java.lang.String getAnd(java.lang.String left, java.lang.String right)
          Constructs a logical comparison using the and operator.

java.lang.String getAscending(java.lang.String left)
          Constructs an ascending fragment.

java.lang.String getAvg(java.lang.String middle)
          Constructs a avg function.

java.lang.String getCount(java.lang.String middle)
          Constructs a count function.

java.lang.String getDelete(java.lang.String left)
          Constructs a delete fragment.

java.lang.String getDescending(java.lang.String left)
          Constructs a descending fragment.

java.lang.String getEquals(java.lang.String left, java.lang.String right)
          Constructs a logical comparison using the equals operator.

java.lang.String getFrom(java.util.List list)
          Constructs a from fragment.

java.lang.String getGreaterEqual(java.lang.String left, java.lang.String right)
          Constructs a logical comparison using the greater than or equal to operator.

java.lang.String getGreaterThan(java.lang.String left, java.lang.String right)
          Constructs a logical comparison using the greater than operator.

java.lang.String getGroupBy(java.util.List list)
          Constructs a group by fragment.

java.lang.String getHaving(java.lang.String middle)
          Constructs a having fragment.

java.lang.String getIn(java.lang.String left, java.util.List list)
          Constructs an in fragment.

java.lang.String getInsert(java.lang.String left, java.util.List list)
          Constructs an insert fragment.

java.lang.String getIsNotNull(java.lang.String left)
          Constructs an is not null fragment.

java.lang.String getIsNull(java.lang.String left)
          Constructs an is null fragment.

java.lang.String getLessEqual(java.lang.String left, java.lang.String right)
          Constructs a logical comparison using the less than or equal to operator.

java.lang.String getLessThan(java.lang.String left, java.lang.String right)
          Constructs a logical comparison using the less than operator.

java.lang.String getLike(java.lang.String left, java.lang.String right)
          Constructs a logical comparison using the like operator.

java.lang.String getMax(java.lang.String middle)
          Constructs a max function.

java.lang.String getMin(java.lang.String middle)
          Constructs a min function.

java.lang.String getNot(java.lang.String right)
          Constructs a logical comparison using the not operator.

java.lang.String getNotEquals(java.lang.String left, java.lang.String right)
          Constructs a logical comparison using the not equals operator.

java.lang.String getNotIn(java.lang.String left, java.util.List list)
          Constructs an not in fragment.

java.lang.String getOr(java.lang.String left, java.lang.String right)
          Constructs a logical comparison using the or operator.

java.lang.String getOrderBy(java.util.List list)
          Constructs an order by fragment.

java.lang.String getSelect(java.util.List list)
          Constructs a select fragment.

java.lang.String getSet(java.lang.String left, java.lang.String right)
          Constructs a set statement.

java.lang.String getSum(java.lang.String middle)
          Constructs a sum function.

java.lang.String getUpdate(java.lang.String item, java.util.List list)
          Constructs an update fragment.

java.lang.String getUpper(java.lang.String middle)
          Constructs an upper function.

java.lang.String getValues(java.util.List list)
          Constructs a values fragment.

java.lang.String getWhere(java.lang.String middle)
          Constructs a where fragment.

java.lang.String quoteAndEscapeText(java.lang.String rawText)
          Quotes and escapes raw text for placement in a SQL expression.

Method Detail

getEquals

public java.lang.String getEquals(java.lang.String left,
                                  java.lang.String right)

Constructs a logical comparison using the equals operator.

getNotEquals

public java.lang.String getNotEquals(java.lang.String left,
                                     java.lang.String right)

Constructs a logical comparison using the not equals operator.

getLessThan

public java.lang.String getLessThan(java.lang.String left,
                                    java.lang.String right)

Constructs a logical comparison using the less than operator.

getGreaterThan

public java.lang.String getGreaterThan(java.lang.String left,
                                       java.lang.String right)

Constructs a logical comparison using the greater than operator.

getLessEqual

public java.lang.String getLessEqual(java.lang.String left,
                                     java.lang.String right)

Constructs a logical comparison using the less than or equal to operator.

getGreaterEqual

public java.lang.String getGreaterEqual(java.lang.String left,
                                        java.lang.String right)

Constructs a logical comparison using the greater than or equal to operator.

getIsNull

public java.lang.String getIsNull(java.lang.String left)

Constructs an is null fragment.

getIsNotNull

public java.lang.String getIsNotNull(java.lang.String left)

Constructs an is not null fragment.

getIn

public java.lang.String getIn(java.lang.String left,
                              java.util.List list)

Constructs an in fragment.

getNotIn

public java.lang.String getNotIn(java.lang.String left,
                                 java.util.List list)

Constructs an not in fragment.

getLike

public java.lang.String getLike(java.lang.String left,
                                java.lang.String right)

Constructs a logical comparison using the like operator.

getAnd

public java.lang.String getAnd(java.lang.String left,
                               java.lang.String right)

Constructs a logical comparison using the and operator.

getOr

public java.lang.String getOr(java.lang.String left,
                              java.lang.String right)

Constructs a logical comparison using the or operator.

getNot

public java.lang.String getNot(java.lang.String right)

Constructs a logical comparison using the not operator.

getAscending

public java.lang.String getAscending(java.lang.String left)

Constructs an ascending fragment.

getDescending

public java.lang.String getDescending(java.lang.String left)

Constructs a descending fragment.

getInsert

public java.lang.String getInsert(java.lang.String left,
                                  java.util.List list)

Constructs an insert fragment.

getValues

public java.lang.String getValues(java.util.List list)

Constructs a values fragment.

getUpdate

public java.lang.String getUpdate(java.lang.String item,
                                  java.util.List list)

Constructs an update fragment.

getSet

public java.lang.String getSet(java.lang.String left,
                               java.lang.String right)

Constructs a set statement.

getDelete

public java.lang.String getDelete(java.lang.String left)

Constructs a delete fragment.

getSelect

public java.lang.String getSelect(java.util.List list)

Constructs a select fragment.

getFrom

public java.lang.String getFrom(java.util.List list)

Constructs a from fragment.

getWhere

public java.lang.String getWhere(java.lang.String middle)

Constructs a where fragment.

getHaving

public java.lang.String getHaving(java.lang.String middle)

Constructs a having fragment.

getOrderBy

public java.lang.String getOrderBy(java.util.List list)

Constructs an order by fragment.

getGroupBy

public java.lang.String getGroupBy(java.util.List list)

Constructs a group by fragment.

getCount

public java.lang.String getCount(java.lang.String middle)

Constructs a count function.

getMin

public java.lang.String getMin(java.lang.String middle)

Constructs a min function.

getMax

public java.lang.String getMax(java.lang.String middle)

Constructs a max function.

getAvg

public java.lang.String getAvg(java.lang.String middle)

Constructs a avg function.

getSum

public java.lang.String getSum(java.lang.String middle)

Constructs a sum function.

getUpper

public java.lang.String getUpper(java.lang.String middle)

Constructs an upper function.

quoteAndEscapeText

public java.lang.String quoteAndEscapeText(java.lang.String rawText)

Quotes and escapes raw text for placement in a SQL expression. For simplicity, the text is assumed to be neither quoted nor escaped.

raw string: O'Malley's Can't be beat!
qutoed and escaped: 'O''Malley''s Can''t be beat!'