Groovy JDBC Mysql

#!/usr/bin/env groovy
# author: thiago-amm

import static java.sql.ResultSet.*

@Grab('mysql:mysql-connector-java:6.0.6')
@GrabConfig(systemClassLoader = true)
import groovy.sql.Sql

def sql = Sql.newInstance(
    url: 'jdbc:mysql://localhost:3306/groovy',
    user: 'groovy',
    password: 'groovy',
    driver: 'com.mysql.jdbc.Driver',
    cacheStatements: true,
    resultSetConcurrency: CONCUR_READ_ONLY
)

def query = "SELECT * FROM paises"

sql.eachRow(query) { row ->
    println row
}

println '#' * 50
println "#\t\tNome\t\tSigla"
println '#' * 50
sql.eachRow(query) { row ->
    println "${row.id}\t\t${row.nome}\t\t${row.sigla}"
}