execute
public boolean execute(GString gstring) throws java.sql.SQLExceptionExecutes 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 == 1Resource handling is performed automatically where appropriate.
Parameters:
- Returns:
gstring
- a GString containing the SQL query with embedded params- Throws:
true
if the first result is aResultSet
object;false
if it is an update count or there are no results- See Also:
java.sql.SQLException
- if a database access error occursexpand(Object)
转载于:https://www.cnblogs.com/lexus/archive/2012/08/06/2625479.html