Groovy连接数据并打印数据(2)，超简单！

import groovy.sql.Sql
def sql = Sql.newInstance("jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.41)(PORT = 1521)))(CONNECT_DATA =(SID = syntong)))","auto","auto_123","oracle.jdbc.driver.OracleDriver")
def roles = sql.dataSet('role')

def subRoles = roles.findAll{ it.id == 21 }
subRoles.each {
println "Name is ${it.name}"
}

运行方法：使用EditPlus，设置方法如下：


显示结果：

---------- 运行GroovyScript ----------
Name is 领导

输出完毕 (耗时 9 秒) - 正常终止