create procedure testsp()
begin
select * from test;
end//
import groovy.sql.Sql;
class TestController {
def dataSource;
def index = {
Sql sql = new Sql(dataSource);
sql.eachRow("call testsp()"){
println it;
}
render "ok";
}
}
如此简单....