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

import groovy.sql.Sql

dbHandle = null
def getDb(){
   if(dbHandle) return dbHandle
   def ds = new oracle.jdbc.pool.OracleDataSource()
   ds.driverType = 'oracle.jdbc.driver.OracleDriver'
   ds.URL = 'jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.41)(PORT = 1521)))(CONNECT_DATA =(SID = orcl)))'

   ds.user = 'auto'
   ds.password = 'auto'
   dbHandle = new Sql(ds)

   return dbHandle
}

def db = getDb()
/*
def roles = db.rows('select * from role')
println roles
*/

def roles = db.dataSet('role')
roles.each{
  println "id is : ${it.id}     name is : ${it.name}"
}

运行方式：

在EditPlus中运行，设置如下：



运行结果：

---------- 运行GroovyScript ----------

id is : 20     name is : 系统管理员
id is : 21     name is : 领导
id is : 22     name is : 车辆审批领导
id is : 23     name is : 车辆调度值班员
id is : 24     name is : 驾驶员

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