executeUpdate
目的 Purpose
Updates the database with DML-style operations使用例 Examples
Account.executeUpdate("delete Book b where b.pages > 100")Account.executeUpdate("delete Book b where b.title like ?", ['Groovy In Action'])Account.executeUpdate("delete Book b where b.author=?", [Author.load(1)])Account.executeUpdate("update Book b set b.title='Groovy In Action'" + "where b.title='GINA'")Account.executeUpdate("update Book b set b.title=:newTitle " + "where b.title=:oldTitle", [newTitle: 'Groovy In Action', oldTitle: 'GINA'])
詳細 Description
GORM does not provide a deleteAll method as deleting data must be done with caution. To delete data you can use executeUpdate. The basic syntax is:Book.executeUpdate(String query) Book.executeUpdate(String query, List positionalParams) Book.executeUpdate(String query, Map namedParams)
Parameters:
query- An HQL query with DML-style operationspositionalParams- AListof parameters for a positional parameterized HQL querynamedParams- AMapof parameters for a named parameterized HQL query