groovy执行sql简单示例

这里主要展示groovy为了代码的执行方便，竟然将依赖在脚本中指定。
简直是太方便了。

import groovy.sql.Sql

//可以指定maven仓库
@GrabResolver(name = 'aliyun', root = 'http://maven.aliyun.com/nexus/content/groups/public/')
//jdbc驱动类需要用Class.forName加载
@GrabConfig(systemClassLoader = true)
@Grab('mysql:mysql-connector-java:5.1.46')
class SqlDatabase {
    static Sql setUpDatabase() {
        def url = 'jdbc:mysql://localhost:3306/xxx?useUnicode=true&characterEncoding=UTF-8'
        def user = 'root'
        def password = ''
        def driver = 'com.mysql.jdbc.Driver'
        def sql = Sql.newInstance(url, user, password, driver)
        return sql
    }
}

def sql = SqlDatabase.setUpDatabase()
sql.eachRow('SELECT * FROM t_customer limit 0,3') { row ->
  def id = row[0]
  def name = row.cust_name
  println("${id},${name}")
}

println("""
'\${a}'
${new Date().getYear()}
""")
println([1,2,3].collect({it*2}))