在Grails console中执行SQL语句

 1.

 

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

....

.....

 

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

 

2.

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 女

..........

 

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

3.

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}"
}

 

 

结果：

性别是男

性别是女

...........

评论

1 楼 dmpx123456 2010-03-22  

楼主，问一下。为什么我按照你上面的方法会出现找不到ctx的异常