groovy脚本操作sql

import groovy.sql.Sql
def ds= __ac.getBean('dataSource')
def sql=new Sql(ds)
println sql
sql.eachRow("""
select * from target_url where app_id=? limit 10
""", [1]){println it.url}