cheat sheets.

$ cheat groovy_sql
Sql methods:
void eachRow(sql) { row -> code }
void eachRow(prepStmt, [values]) { row -> code }
void query(sql) { resultSet -> code }
void query(prepStmt, [values]) { resultSet -> code }
List rows(sql)
List rows(prepStmt, [values])
Object firstRow(sql)
Object firstRow(prepStmt, [values])

boolean execute(sql)
boolean execute(prepStmt, [values])

int executeUpdate(sql)
int executeUpdate(prepStmt, [values])


ref: http://groovy.codehaus.org/GSQL
api: http://groovy.codehaus.org/gapi/groovy/sql/package-summary.html
Version 1, updated 207 days ago.
. o 0 ( edit | history )
( add new | see all )