Query result from Database using Groovy

GroovySQLQueryPerson.groovy

import java.sql.ResultSet
import groovy.sql.Sql;

class GroovySQLQueryPerson {

	static main(args) {
		def db = Sql.newInstance("jdbc:sqlserver://localhost;databaseName=MyDB;integratedSecurity=true", '', '', 'com.microsoft.sqlserver.jdbc.SQLServerDriver')
		db.query('SELECT id FROM Person WHERE name = ?', ["Sam"]){ ResultSet rs ->
			while(rs.next()) println rs.getInt("id")
		}
	}

}