用SqlPlus在Java上运行SQL文件

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

public class SqlPlusExample {
    public static void main(String[] args) {
        try {
            // 连接Oracle数据库
            String url = "jdbc:oracle:thin:@localhost:1521:xe";
            String username = "your_username";
            String password = "your_password";
            Connection connection = DriverManager.getConnection(url, username, password);

            // 读取SQL文件
            String sqlFile = "path_to_your_sql_file.sql";
            BufferedReader reader = new BufferedReader(new FileReader(sqlFile));
            StringBuilder sqlBuilder = new StringBuilder();
            String line;
            while ((line = reader.readLine()) != null) {
                sqlBuilder.append(line);
                sqlBuilder.append("\n");
            }
            reader.close();

            // 执行SQL语句
            String sql = sqlBuilder.toString();
            Statement statement = connection.createStatement();
            statement.execute(sql);

            // 关闭连接
            statement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}