gradle 定义sql task

在gradle脚本中初始化数据库

dependencies {
    driver 'mysql:mysql-connector-java:5.1.34'
}
URLClassLoader loader = GroovyObject.class.classLoader
configurations.driver.each {File file ->
    loader.addURL(file.toURL())
}
//执行sql命令测试
task hello7 <<{
    def mysql = Sql.newInstance("jdbc:mysql://123.57.210.1:3306/guanlizhihui?useUnicode=true&characterEncoding=utf8",
                "root",
                "m1y2s3q4l5",
                "com.mysql.jdbc.Driver")
    try {
        //读取多个文件执行
        def files = file("data").listFiles().sort()
        files.each {File file ->
            println file.name
            if (file.isFile()){
                file.text.split(";").each{
                    println it
                    mysql.execute it
                }
            }
        //读取单个文件执行
//       file("data/test.sql").text.split(";").each {
//         println it
//          mysql.execute it
             //执行单条sql
//            mysql.execute '''\
//            CREATE TABLE IF NOT EXISTS protal_test(
//            id int primary key,name varchar(20)
//            );
//            '''
        }
        mysql.close()
    } catch (Exception e) {
        e.printStackTrace();
    }
}