java - How to get resultset data in grails -

below query:

def getdata1 = sql.rows("select student_id,school_grade_class_id class_assign") 

how student_id getdata1?

update:

def getdata1 = sql.rows("select student_id,school_grade_class_id class_assign")   def getdata2 = sql.rows("select class_id,class_name,school_grade_id class_rel school_grade_class_id=**x**") 

i should replace x resultset value of school_grade_class_id getdata1. should do?

you can this:

getdata1.each{     println it.student_id } 

or

sql.eachrow("select student_id,school_grade_class_id class_assign", {    println it.student_id })