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

最新推荐文章于 2024-05-15 07:08:06 发布

Leon1509

最新推荐文章于 2024-05-15 07:08:06 发布

阅读量391

点赞数

分类专栏： Groovy 文章标签： Groovy Oracle SQL JDBC

本文链接：https://blog.csdn.net/leon1509/article/details/83483242

版权

Groovy 专栏收录该内容

28 篇文章 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中运行，设置如下：
[img]http://dl.iteye.com/upload/attachment/161443/462e601c-6ce4-3e92-9728-95dcf2885fd7.png[/img]

运行结果：

---------- 运行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 秒) - 正常终止