execute

public boolean execute( gstring)                throws java.sql.SQLException

Executes the given SQL with embedded expressions inside. Also saves the updateCount, if any, for subsequent examination.

Example usage:

def scott = [firstname: "Scott", lastname: "Davis", id: 5, location_id: 50] sql.execute """     insert into PERSON (id, firstname, lastname, location_id) values ($scott.id, $scott.firstname, $scott.lastname, $scott.location_id) """ assert sql.updateCount == 1

Resource handling is performed automatically where appropriate.

Parameters:

gstring - a GString containing the SQL query with embedded params

Returns:

true if the first result is a

ResultSet object;

false if it is an update count or there are no results

Throws:

java.sql.SQLException - if a database access error occurs

See Also: