HWXcLYhW

1@Grab(group = 'mysql', module = 'mysql-connector-java', version = '5.1.18')
2@GrabConfig(systemClassLoader = true)
3import groovy.sql.Sql
4
5def jdbc = 'jdbc:mysql://localhost:3306/gdb'
6def user = 'root'
7def pass = 'pass'
8def driver = 'com.mysql.jdbc.Driver'
9
10sql = Sql.newInstance(jdbc, user, pass, driver)
11
12println 'Create user table'
13sql.execute '''
14create table if not exists user(
15    id integer primary key,
16    name varchar(50) not null,
17    password varchar(35) not null,
18    url varchar(100)
19)
20''' 
21println ''
22
23insertUser = 'insert into user(id, name, password, url) values(?, ?, ?, ?)'
24sql.execute 'truncate table user'
25for(idx in 1..5) {
26    println "Inserting user: user${idx}"
27    sql.execute(insertUser, [idx, "user"+idx, "pass", "ex@example.com"])
28}
29
30sql.close()