@Grab(group = 'mysql', module = 'mysql-connector-java', version = '5.1.18')
@GrabConfig(systemClassLoader = true)
import groovy.sql.Sql

def jdbc = 'jdbc:mysql://localhost:3306/gdb'
def user = 'root'
def pass = 'pass'
def driver = 'com.mysql.jdbc.Driver'

sql = Sql.newInstance(jdbc, user, pass, driver)

println 'Create user table'
sql.execute '''
create table if not exists user(
    id integer primary key,
    name varchar(50) not null,
    password varchar(35) not null,
    url varchar(100)
)
'''
println ''

insertUser = 'insert into user(id, name, password, url) values(?, ?, ?, ?)'
sql.execute 'truncate table user'
for(idx in 1..5) {
    println "Inserting user: user${idx}"
    sql.execute(insertUser, [idx, "user"+idx, "pass", "ex@example.com"])
}

sql.close()