08-12 01:08 阅读 78

关注

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)