java执行sql脚本

java执行sql脚本

package com.sync.common.utils;

import org.apache.ibatis.jdbc.ScriptRunner;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Component;
import java.io.File;
import java.io.FileReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * @Auther: ZHANG PU
 * @Date: 2022/8/25 18:06
 * @Description:
 */
@Component
public class ExecuteSql {
    @Value("${spring.datasource.druid.slave.url}")
    private   String url;
    @Value("${spring.datasource.druid.slave.username}")
    private   String username;
    @Value("${spring.datasource.druid.slave.password}")
    private   String password;
    @Value("${spring.datasource.driverClassName}")
    private   String driver;

    /**
     * 功能描述: 执行sql语句
     * @author zhang pu
     * @date 18:11 2022/8/25
     */
    public void mybatisExec(File filePath) throws ClassNotFoundException, SQLException {
        Class.forName(driver);
        Connection conn = DriverManager.getConnection(url, username, password);
        ScriptRunner runner = new ScriptRunner(conn);
        try {
            runner.setStopOnError(true);
            runner.runScript(new FileReader(filePath));
        } catch (Exception e) {
            e.printStackTrace();
        }
        conn.close();
    }
}