gradle参考

Gradle

下载

• gradle全套下载地址： https://services.gradle.org/distribution

gradle执行sql

	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();
        }
    }