uk.ac.kcl.cch.rdb2java.dynData
Class BaseQuery

java.lang.Object
  uk.ac.kcl.cch.rdb2java.dynData.BaseQuery

All Implemented Interfaces:

IObjectFetcher

Direct Known Subclasses:

FavouriteQuery, GlobalDataQuery, LinkableObjectQuery, LinkQuery, LOTypeQuery, NoteQuery, ObjectTypeQuery, PluginQuery, ResourceQuery

public abstract class BaseQuery

extends Object

implements IObjectFetcher

Field Summary

protected String	cgiWhereString
protected boolean	doDistinct
protected String	fromString
protected Hashtable	htResults
protected String	orderString
protected Vector	queryParams
protected Vector	results
protected Statement	theStatement
protected String	whereString

Constructor Summary

BaseQuery()

Method Summary

void	addNewItem(int key, Object item)
void	addQueryParam(Object obj)
int	executeCount()
Vector	executeQuery()
boolean	getDoDistinct()
Hashtable	getHash()
abstract Rdb2javaCache	getMyCache()
abstract Connection	getMyConnection()
abstract String	getMyKeyName()
abstract ILoadableFromResultSet	getMyNewDataObject()
abstract String	getMySelectEntities()
abstract String	getMySQLFrom()
abstract String	getMyTableJoins()
Object	getObject(int key)
Object	loadIsObject(int key1, int key2)
Object	loadObject(int ID)
abstract void	returnMyConnection(Connection con)
protected ResultSet	runBasicQuery(String query, Connection conh)
protected ResultSet	runParamQuery(String query, Connection conh)
void	setDoDistinct(boolean parm)
void	setFromString(String ws)
void	setOrderString(String ws)
void	setWhereString(String ws)

Methods inherited from class java.lang.Object

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

Field Detail

whereString

protected String whereString

cgiWhereString

protected String cgiWhereString

fromString

protected String fromString

orderString

protected String orderString

doDistinct

protected boolean doDistinct

results

protected Vector results

htResults

protected Hashtable htResults

queryParams

protected Vector queryParams

theStatement

protected Statement theStatement

Constructor Detail

BaseQuery

public BaseQuery()

Method Detail

getMyCache

public abstract Rdb2javaCache getMyCache()

getDoDistinct

public boolean getDoDistinct()

setDoDistinct

public void setDoDistinct(boolean parm)

setWhereString

public void setWhereString(String ws)

setFromString

public void setFromString(String ws)

setOrderString

public void setOrderString(String ws)

addQueryParam

public void addQueryParam(Object obj)

getMySelectEntities

public abstract String getMySelectEntities()

Specified by:

getMySelectEntities in interface IObjectFetcher

getMySQLFrom

public abstract String getMySQLFrom()

Specified by:

getMySQLFrom in interface IObjectFetcher

getMyTableJoins

public abstract String getMyTableJoins()

Specified by:

getMyTableJoins in interface IObjectFetcher

getMyConnection

public abstract Connection getMyConnection()

Specified by:

getMyConnection in interface IObjectFetcher

returnMyConnection

public abstract void returnMyConnection(Connection con)

Specified by:

returnMyConnection in interface IObjectFetcher

getMyNewDataObject

public abstract ILoadableFromResultSet getMyNewDataObject()

Specified by:

getMyNewDataObject in interface IObjectFetcher

getMyKeyName

public abstract String getMyKeyName()

Specified by:

getMyKeyName in interface IObjectFetcher

loadObject

public Object loadObject(int ID)

Specified by:

loadObject in interface IObjectFetcher

getObject

public Object getObject(int key)

runBasicQuery

protected ResultSet runBasicQuery(String query,
                                  Connection conh)
                           throws SQLException

Throws:

SQLException

runParamQuery

protected ResultSet runParamQuery(String query,
                                  Connection conh)
                           throws SQLException

Throws:

SQLException

executeQuery

public Vector executeQuery()

getHash

public Hashtable getHash()

executeCount

public int executeCount()

loadIsObject

public Object loadIsObject(int key1,
                           int key2)

Specified by:

loadIsObject in interface IObjectFetcher

addNewItem

public void addNewItem(int key,
                       Object item)