groovy execute

Sql (groovy 2.0.1 API)

execute

public boolean execute(GString 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:

expand(Object)