Groovy에서 간단 SQL SELECT

import groovy.sql.Sql

sql = Sql.newInstance("jdbc:oracle:thin:@localhost:1521:XE","BPEL"

,"BPEL","oracle.jdbc.driver.OracleDriver")

rows =[]

sql.eachRow("select * from PERF_OUT"){

rows << it.toRowResult()

}

println rows[1]["PK"] // 첫번째 ROW의 PK 컬럼을 출력