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(
地址,
用户名,
密码,
驱动
)