Simple SQL Insert / Select with Groovy

GroovySQLTesting.groovy

import groovy.sql.Sql;

import java.sql.Connection
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;


class GroovySQLTesting {

	static main(args) {
	def db = Sql.newInstance("jdbc:sqlserver://localhost;databaseName=MyDB;integratedSecurity=true", '', '', 'com.microsoft.sqlserver.jdbc.SQLServerDriver')
	db.execute 'exec proc_InsertNewPerson ?,?,?', ['matt', 30, 16803]
	db.execute 'exec proc_InsertNewPerson ?,?,?', ['geoff', null, 16803]
	db.execute 'exec proc_InsertNewPerson ?,?,?', ['max', null, 16803]
	
	db.eachRow("select * from Person") {
			println(it)
		}
	}

}