mysql如何连接oracle

import java.sql.*;

public class MySQLToOracleConnection {
    public static void main(String[] args) {
        String mysqlUrl = "jdbc:mysql://localhost:3306/mydb";
        String mysqlUser = "user";
        String mysqlPassword = "password";

        String oracleUrl = "jdbc:oracle:thin:@localhost:1521:orcl";
        String oracleUser = "user";
        String oraclePassword = "password";

        try {
            // 加载MySQL驱动
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection mysqlConn = DriverManager.getConnection(mysqlUrl, mysqlUser, mysqlPassword);

            // 加载Oracle驱动
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection oracleConn = DriverManager.getConnection(oracleUrl, oracleUser, oraclePassword);

            // 执行查询
            Statement stmt = mysqlConn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM mytable");

            // 将数据插入Oracle
            PreparedStatement pstmt = oracleConn.prepareStatement("INSERT INTO mytable (id, name) VALUES (?, ?)");
            while (rs.next()) {
                pstmt.setInt(1, rs.getInt("id"));
                pstmt.setString(2, rs.getString("name"));
                pstmt.executeUpdate();
            }

            // 关闭连接
            rs.close();
            stmt.close();
            mysqlConn.close();
            pstmt.close();
            oracleConn.close();
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
    }
}