how to get jdbc datasource record

Hello,
I have a jdbc databsource which return a record with a few columns.
I want to use groovy to be able to access the values of these columns.
How do i do this.

Thanks

Ali