在Grails console中执行SQL语句

最新推荐文章于 2020-04-21 16:26:11 发布

Leon1509

最新推荐文章于 2020-04-21 16:26:11 发布

阅读量145

点赞数

分类专栏： Grails 文章标签： SQL Grails Groovy

本文链接：https://blog.csdn.net/Leon1509/article/details/83532891

版权

Grails 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

import groovy.sql.Sql
def dataSource= ctx.getBean('dataSource')
def sql = new Sql(dataSource)
//def ls = sql.rows(sb.toString());

sql.eachRow("select * from role"){  
println "Name is ${it.name}"
}

结果：

Name is 111

Name is 222

....

.....

================================================================

import groovy.sql.Sql
def dataSource= ctx.getBean('dataSource')
def sql = new Sql(dataSource)

def sb = new StringBuffer("SELECT a.cardid, trim(a.account), trim(a.sno), trim(a.name), ")
sb << "decode(trim(a.sex), '1', '男', '2', '女', '未知') sexname "
sb << "from account@sports_iddbsvr a "
sb << "where rownum < 30"

//def ls = sql.rows(sb.toString());
//def accounts = sql.eachRow(sb.toString())

sql.eachRow(sb.toString()){
    println "Name is ${it.sexname}"
}

结果：

Name is 男

Name is 女

..........

=====================================================

import groovy.sql.Sql
def dataSource= ctx.getBean('dataSource')
def sql = new Sql(dataSource)

def sb = new StringBuffer("SELECT a.cardid, trim(a.account), trim(a.sno), trim(a.name), ")
sb << "decode(trim(a.sex), '1', '男', '2', '女', '未知') sexname "
sb << "from account@sports_iddbsvr a "
sb << "where rownum < 30"

def ls = sql.rows(sb.toString());
//def accounts = sql.eachRow(sb.toString())

ls.each{
    println "性别是${it.sexname}"
}

结果：

性别是男

性别是女

...........