com.esri.sde.sdk.client
Class SeSqlConstruct

java.lang.Object
  com.esri.sde.sdk.client.SeSqlConstruct

All Implemented Interfaces:

java.lang.Cloneable

public class SeSqlConstruct
extends java.lang.Object
implements java.lang.Cloneable

An SQL construct is used any time an application needs to specify tables or constraining where clauses in an SDE application.

Constructor Summary

SeSqlConstruct()
Constructor for the SqlConstruct object use the set methods to populate it's fields.

SeSqlConstruct(java.lang.String table)
Constructor for the SqlConstruct object

SeSqlConstruct(java.lang.String[] tables, java.lang.String where)
Creates an SqlConstruct given an array of table names and a where clause.

SeSqlConstruct(java.lang.String table, java.lang.String where)
Creates an SqlConstruct with one table name and where clause.

Method Summary

void	addTable(java.lang.String table) Adds a table name to the list of tables.
java.lang.Object	clone() Clones SeSqlConstruct object.
int	getNumTables() Returns the number of Tables in the construct.
java.lang.String[]	getTables() Returns the Tables in the construct.
java.lang.String	getWhere() Returns the where clause in the construct.
void	setTables(java.lang.String[] tables) Sets the Tables array in the construct.
void	setWhere(java.lang.String where) Sets the where clause in the construct.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SeSqlConstruct

public SeSqlConstruct()

Constructor for the SqlConstruct object use the set methods to populate it's fields.

SeSqlConstruct

public SeSqlConstruct(java.lang.String table)

Constructor for the SqlConstruct object

Parameters:

table - The name of the FROM table

SeSqlConstruct

public SeSqlConstruct(java.lang.String table,
                      java.lang.String where)

Creates an SqlConstruct with one table name and where clause.

The where clause must use the SQL syntax supported by the underlying RDBMS; It is not interprted by SDE

Parameters:

table - The table name to be specified

where - The where clause

Throws:

java.lang.NullPointerException - If table=null or where=null

SeSqlConstruct

public SeSqlConstruct(java.lang.String[] tables,
                      java.lang.String where)

Creates an SqlConstruct given an array of table names and a where clause. The ArcSDE software will construct the from clause with the same order of table names as defined in the array.

The where clause must use the SQL syntax supported by the underlying RDBMS; It is not interprted by SDE

Parameters:

tables - The array of table names to be specified

where - The where clause

Throws:

java.lang.NullPointerException - If table=null or where=null

Method Detail

addTable

public void addTable(java.lang.String table)

Adds a table name to the list of tables.

clone

public java.lang.Object clone()
                       throws java.lang.CloneNotSupportedException

Clones SeSqlConstruct object.

Overrides:

clone in class java.lang.Object

Returns:

Object

Throws:

java.lang.CloneNotSupportedException

getNumTables

public int getNumTables()

Returns the number of Tables in the construct.

Returns:

int

getWhere

public java.lang.String getWhere()

Returns the where clause in the construct.

Returns:

String

setWhere

public void setWhere(java.lang.String where)

Sets the where clause in the construct.

getTables

public java.lang.String[] getTables()

Returns the Tables in the construct.

Returns:

String[]

setTables

public void setTables(java.lang.String[] tables)

Sets the Tables array in the construct.