public bool execute(String sql)
{//throws SQLException {
// a result set object
//
TsResultSet r;
statementString = sql;
// execute the query
//
r = connection.executetinySQL(this);
// check for a null result set. If it wasn't null,
// use it to create a tinySQLResultSet, and return whether or
// not it is null (not null returns true).
//
if (r == null)
{
result = null;
}
else
{
result = new TinySQLResultSet(r, this);
}
return(result != null);
}
/**
*
* Returns the last result set
* @see java.sql.PreparedStatement#getResultSet
* @return null if no result set is available, otherwise a result set
*
*/
public java.sql.ResultSet getResultSet()
{//throws SQLException {
java.sql.ResultSet r;
r = result; // save the existing result set
result = null; // null out the existing result set
return(r); // return the previously extant result set
}
/**
*
* Execute an SQL statement and return a result set.
* @see java.sql.PreparedStatement#executeQuery
* @exception SQLException raised for any errors
* @param sql the SQL statement string
* @return the result set from the query
*
*/
public java.sql.ResultSet executeQuery()
{//throws SQLException {
lock (this)
{
// tinySQL only supports one result set at a time, so
// don't let them get another one, just in case it's
// hanging out.
//
result = null;
// create a new tinySQLResultSet with the tsResultSet
// returned from connection.executetinySQL()
//
if (debug)
{
java.lang.SystemJ.outJ.println("executeQuery conn is " + connection.toString());
}
return(new TinySQLResultSet(connection.executetinySQL(this), this));
}
}
