Examples of groovy.sql.Sql$AbstractStatementCommand

• groovy.sql.Sql
  y.codehaus.org'] sql.execute 'insert into PROJECT (id, name, url) values (?, ?, ?)', params Or insert a row using GString syntax:

   def map = [id:20, name:'Grails', url:'http://grails.codehaus.org'] sql.execute "insert into PROJECT (id, name, url) values ($map.id, $map.name, $map.url)" 

  Or a row update:

   def newUrl = 'http://grails.org' def project = 'Grails' sql.executeUpdate "update PROJECT set url=$newUrl where name=$project" 

  Now try a query using eachRow:

   println 'Some GR8 projects:' sql.eachRow('select * from PROJECT') { row -> println "${row.name.padRight(10)} ($row.url)" } 

  Which will produce something like this:

   Some GR8 projects: Groovy     (http://groovy.codehaus.org) Grails     (http://grails.org) Griffon    (http://griffon.codehaus.org) Gradle     (http://gradle.org) 

  Now try a query using rows:

   def rows = sql.rows("select * from PROJECT where name like 'Gra%'") assert rows.size() == 2 println rows.join('\n') 

  with output like this:

   [ID:20, NAME:Grails, URL:http://grails.org] [ID:40, NAME:Gradle, URL:http://gradle.org] 

  Also, eachRow and rows support paging. Here's an example:

   sql.eachRow('select * from PROJECT', 2, 2) { row -> println "${row.name.padRight(10)} ($row.url)" } 

  Which will start at the second row and return a maximum of 2 rows. Here's an example result:

   Grails     (http://grails.org) Griffon    (http://griffon.codehaus.org) 

  Finally, we should clean up:

   sql.close() 

  If we are using a DataSource and we haven't enabled statement caching, then strictly speaking the final close() method isn't required - as all connection handling is performed transparently on our behalf; however, it doesn't hurt to have it there as it will return silently in that case.

  Named and named ordinal parameters

  Several of the methods in this class which have a String-based sql query and params in a List