如果你有Java的代码--它应该可以在Groovy上工作，也许只需要做些小的修改。
下面是Groovy中jdbc连接的外观：

@GrabConfig(systemClassLoader=true)
@Grab(group='com.amazon.redshift', module='redshift-jdbc42', version='2.1.0.9')

import groovy.sql.Sql

def props = [
    url:      'jdbc:redshift://adee-cluster.c9ld7lgff4o4.us-east-2.redshift.amazonaws.com:5555/dev', 
    user:     'awsuser', 
    password: 'changeme', 
    driver:   'com.amazon.redshift.jdbc42.Driver'
]

Sql.withInstance(props){sql->
    println 'connected'
    def query = "select id, first_name, last_name from public.employee where first_name like :firstName"
    def params = [firstName:'Rob%']
    sql.eachRow(query, params){row->
        println "row: id=${row.id}, name=${row.first_name} ${row.last_name}"
    }
}