oracle 读取本地文件执行sql

package com.kingdee.eas.custom.comm;

import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

import com.kingdee.bos.BOSException;

public class Mytest {
	
	
	
	public static void main(String[] args) throws BOSException, IOException {
		  // 读取SQL文件
        BufferedReader reader = new BufferedReader(new FileReader("C:\\Users\\12593\\Desktop\\导出的sql 无法执行.txt"));
        String line;
        StringBuilder sql = new StringBuilder();
        while ((line = reader.readLine()) != null) {
            sql.append(line);
        }
        reader.close();
 
        
        // Oracle数据库连接参数
        String url = "jdbc:oracle:thin:@192.168.91.137:1521:myora";
        String username = "eas";
        String password = "kingdee";

        // 加载Oracle JDBC驱动程序
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e) {
            System.out.println("无法加载Oracle JDBC驱动程序");
            e.printStackTrace();
            return;
        }

        // 建立与Oracle数据库的连接
        Connection connection = null;
        try {
            connection = DriverManager.getConnection(url, username, password);
            System.out.println("成功连接到Oracle数据库");
            
            // 创建Statement对象
            Statement statement = connection.createStatement();
            try {
				statement.execute(sql.toString());
			} catch (Exception e) {
			   System.out.println("执行异常");
				e.printStackTrace();
			}
            // 关闭连接
            statement.close();
        } catch (SQLException e) {
            System.out.println("无法连接到Oracle数据库");
            e.printStackTrace();
        } finally {
            // 关闭数据库连接
            try {
                if (connection != null) {
                    connection.close();
                    System.out.println("关闭Oracle数据库连接");
                }
            } catch (SQLException e) {
                System.out.println("关闭Oracle数据库连接出错");
                e.printStackTrace();
            }
        }
    }
        
        
        
    
	
	

}