grails(groovy)返回mysql存储过程的记录集

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";
    }
}

如此简单....

评论

1 楼 flyli815 2011-01-11  

fgd fgsd