jet.server.api.db
Interface Table

All Superinterfaces:

DBObject

public interface Table

extends DBObject

A Table is a data table in a database.

Method Summary

int	delete(FieldValue[] fields)
int	delete(java.lang.String whereClause)
Fields	fields()
Field	fields(int index)
Field	fields(java.lang.String fieldName)
Database	getDatabase()
java.lang.String	getExternalDataPath(FieldValue[] fields)
boolean	hasExternalData()
int	insert(FieldValue[] fields)
int	insert(java.util.List records)
Recordset	query(Field[] fields, java.lang.String whereClause, boolean distinct)
Recordset	query(Field[] fields, java.lang.String whereClause, boolean distinct, int setType)
java.lang.Number	queryAvgValue(java.lang.String field, java.lang.String whereClause, boolean distinct)
int	queryCountValue(java.lang.String field, java.lang.String whereClause, boolean distinct)
java.lang.Number	queryMaxValue(java.lang.String field, java.lang.String whereClause, boolean distinct)
java.lang.Number	queryMinValue(java.lang.String field, java.lang.String whereClause, boolean distinct)
java.lang.Number	querySumValue(java.lang.String field, java.lang.String whereClause, boolean distinct)
Uniques	uniques()
Unique	uniques(int index)
Unique	uniques(java.lang.String unqName)
int	update(FieldValue[] fields, java.lang.String whereClause)

Methods inherited from interface jet.server.api.db.DBObject

getName, getProperties, getProperty, getProperty, getUCName, setProperty

Method Detail

getDatabase

public Database getDatabase()

fields

public Fields fields()

fields

public Field fields(int index)

fields

public Field fields(java.lang.String fieldName)

query

public Recordset query(Field[] fields,
                       java.lang.String whereClause,
                       boolean distinct)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

query

public Recordset query(Field[] fields,
                       java.lang.String whereClause,
                       boolean distinct,
                       int setType)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

queryCountValue

public int queryCountValue(java.lang.String field,
                           java.lang.String whereClause,
                           boolean distinct)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

querySumValue

public java.lang.Number querySumValue(java.lang.String field,
                                      java.lang.String whereClause,
                                      boolean distinct)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

queryAvgValue

public java.lang.Number queryAvgValue(java.lang.String field,
                                      java.lang.String whereClause,
                                      boolean distinct)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

queryMaxValue

public java.lang.Number queryMaxValue(java.lang.String field,
                                      java.lang.String whereClause,
                                      boolean distinct)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

queryMinValue

public java.lang.Number queryMinValue(java.lang.String field,
                                      java.lang.String whereClause,
                                      boolean distinct)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

insert

public int insert(FieldValue[] fields)
           throws java.sql.SQLException

Throws:

java.sql.SQLException

insert

public int insert(java.util.List records)
           throws java.sql.SQLException

Throws:

java.sql.SQLException

update

public int update(FieldValue[] fields,
                  java.lang.String whereClause)
           throws java.sql.SQLException

Throws:

java.sql.SQLException

delete

public int delete(java.lang.String whereClause)
           throws java.sql.SQLException

Throws:

java.sql.SQLException

delete

public int delete(FieldValue[] fields)
           throws java.sql.SQLException

Throws:

java.sql.SQLException

hasExternalData

public boolean hasExternalData()

getExternalDataPath

public java.lang.String getExternalDataPath(FieldValue[] fields)

uniques

public Uniques uniques()

uniques

public Unique uniques(int index)

uniques

public Unique uniques(java.lang.String unqName)