execute
publicbooleanexecute(GStringgstring) 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 aResultSet
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)
声明:本站所有文章,如无特殊说明或标注,均为本站原创发布。任何个人或组织,在未征得本站同意时,禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。
评论(0)