groovy sql

import groovy.sql.Sql;
class xoxo {
def dataSource
... ...
// 应用老库
def uuu = {
... ...
 def sql = new Sql(dataSource)
 sql.firstRow("select * from xxx")
 sql.rows("select * from xxx")
 sql.eachRow("select * from xxx"){ row ->
     println row.ooo
 }
 sql.execute("insert into xxx(aaa, bbb) values ('o1', 'o2'")
 sql.execute("insert into xxx (aaa,bbb) values (? , ?)",['o1', 'o2']); 
 sql.execute("update xxx set aaa = 'o1' where bbb = ?",['o2']);
... ...
}
... ...
}

// 新连数据库
def sql = Sql.newInstance(
  地址,
  用户名,
  密码,
  驱动
)