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}
groovy脚本操作sql
最新推荐文章于 2022-10-18 14:48:02 发布
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}