SQLQuery (Ontopia)

java.lang.Object
- net.ontopia.persistence.query.sql.SQLQuery

```
public class SQLQuery
extends Object
```
INTERNAL: Represents an abstract SQL query. Holds SQL query information in a platform independent form.

Field Summary

Fields
Modifier and Type	Field and Description
`protected boolean`	`distinct`
`protected SQLExpressionIF`	`filter`
`protected int`	`limit`
`protected int`	`offset`
`protected List`	`orderby`
`protected List`	`select`

Constructor Summary

Constructors
Constructor and Description

SQLQuery()

Constructors
Constructor and Description
`SQLQuery()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addAscending(SQLAggregateIF aggregate)`
`void`	`addAscending(SQLValueIF value)`
`void`	`addDescending(SQLAggregateIF aggregate)`
`void`	`addDescending(SQLValueIF value)`
`void`	`addOrderBy(SQLOrderBy sob)`
`void`	`addSelect(SQLAggregateIF aggregate)`
`void`	`addSelect(SQLValueIF value)`
`boolean`	`getDistinct()`
`SQLExpressionIF`	`getFilter()`
`int`	`getLimit()`
`int`	`getOffset()`
`List`	`getOrderBy()`
`List`	`getSelect()`
`int`	`getWidth()`
`boolean`	`isSetQuery()`
`void`	`setDistinct(boolean distinct)`
`void`	`setFilter(SQLExpressionIF filter)`
`void`	`setLimit(int limit)`
`void`	`setOffset(int offset)`
`String`	`toString()`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

select
```
protected List select
```

distinct
```
protected boolean distinct
```

limit
```
protected int limit
```

offset
```
protected int offset
```

filter
```
protected SQLExpressionIF filter
```

orderby
```
protected List orderby
```

Constructor Detail
- SQLQuery
```
public SQLQuery()
```

Method Detail

isSetQuery
```
public boolean isSetQuery()
```

getDistinct
```
public boolean getDistinct()
```

setDistinct

public void setDistinct(boolean distinct)

getLimit
```
public int getLimit()
```

setLimit
```
public void setLimit(int limit)
```

getOffset
```
public int getOffset()
```

setOffset
```
public void setOffset(int offset)
```

getSelect
```
public List getSelect()
```

addSelect

public void addSelect(SQLValueIF value)

addSelect

public void addSelect(SQLAggregateIF aggregate)

getWidth
```
public int getWidth()
```

getOrderBy
```
public List getOrderBy()
```

addOrderBy

public void addOrderBy(SQLOrderBy sob)

addAscending

public void addAscending(SQLValueIF value)

addDescending

public void addDescending(SQLValueIF value)

addAscending

public void addAscending(SQLAggregateIF aggregate)

addDescending

public void addDescending(SQLAggregateIF aggregate)

getFilter
```
public SQLExpressionIF getFilter()
```

setFilter

public void setFilter(SQLExpressionIF filter)

toString
```
public String toString()
```
Overrides:

toString in class Object

Class SQLQuery

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

select

distinct

limit

offset

filter

orderby

Constructor Detail

SQLQuery

Method Detail

isSetQuery

getDistinct

setDistinct

getLimit

setLimit

getOffset

setOffset

getSelect

addSelect

addSelect

getWidth

getOrderBy

addOrderBy

addAscending

addDescending

addAscending

addDescending

getFilter

setFilter

toString