Groovy and load a jar

m.groovy

this.class.classLoader.rootLoader.addURL(new URL("file:////Users/linkerlin/.m2/repository/mysql/mysql-connector-java/5.1.21/mysql-connector-java-5.1.21.jar"))
import groovy.sql.Sql
sql = Sql.newInstance("jdbc:mysql://localhost:3306/test", "root", "", "com.mysql.jdbc.Driver")
sql.eachRow("SELECT id, username FROM users")
{
   println "The employee's name is ${it.username}"
}

// Or using grape
@GrabConfig(systemClassLoader=true) // this is very important...
@Grapes( 
@Grab(group='mysql', module='mysql-connector-java', version='5.1.21') 
)
import groovy.sql.Sql
sql = Sql.newInstance("jdbc:mysql://localhost:3306/test", "root", "", "com.mysql.jdbc.Driver")
sql.eachRow("SELECT id, username FROM users")
{
   println "The employee's name is ${it.username}"
}