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)); } }