Wiki source code of dblookup

Last modified by Administrator on 2010/10/28 16:28

Content · Comments (0) · Annotations (0) · Attachments (0) · History · Information

{{groovy}}
import javax.naming.*;
import groovy.sql.Sql

Context initCtx = new InitialContext()
Context ctx = initCtx.lookup("java:/comp/env")

def datasource = ctx.lookup("jdbc/demo")

def db = new Sql(datasource)

db.rows("select fname, lname, company from customer where state = ?", ["CA"], {println(it)})

{{/groovy}}