net.spy.db
Interface DBSPLike

All Known Implementing Classes:

DBSP

public interface DBSPLike

Interface describing the basic DBSP features. This is used primarily as a superinterface for any abstract spts.

Method Summary

void	close() Get rid of this object.
ResultSet	executeQuery() Execute a query.
int	executeUpdate() Execute an update.
long	getCacheTime() Get the cache time configured for this call.
int	getQueryTimeout() Get the query timeout.
void	setCacheTime(long time) Set the cache time for this cachable query.
void	setQueryTimeout(int timeout) Set the timeout for this query.

Method Detail

executeQuery

public ResultSet executeQuery()
                       throws SQLException

Execute a query.

Returns:

the Results from the query

Throws:

SQLException - if there's a problem executing the query

executeUpdate

public int executeUpdate()
                  throws SQLException

Execute an update.

Returns:

the number of rows affected by this update

Throws:

SQLException - if there's a problem executing the query

setCacheTime

public void setCacheTime(long time)

Set the cache time for this cachable query.

Parameters:

time - time (in seconds) results should be valid

getCacheTime

public long getCacheTime()

Get the cache time configured for this call.

Returns:

time (in seconds) results should be valid

setQueryTimeout

public void setQueryTimeout(int timeout)

Set the timeout for this query.

See Also:

Statement#setQueryTimeout(int)

getQueryTimeout

public int getQueryTimeout()

Get the query timeout.

See Also:

Statement#getQueryTimeout()

close

public void close()

Get rid of this object.