mysql直接访问oracle数据库

import java.sql.*;

public class MySQLToOracleBridge {
    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
            Connection mysqlConn = DriverManager.getConnection(mysqlUrl, mysqlUser, mysqlPassword);
            Statement mysqlStmt = mysqlConn.createStatement();
            ResultSet mysqlRs = mysqlStmt.executeQuery("SELECT * FROM mytable");

            // 连接Oracle
            Connection oracleConn = DriverManager.getConnection(oracleUrl, oracleUser, oraclePassword);
            Statement oracleStmt = oracleConn.createStatement();

            // 将数据插入Oracle
            while (mysqlRs.next()) {
                String sql = "INSERT INTO mytable (id, name) VALUES (" + mysqlRs.getInt("id") + ", '" + mysqlRs.getString("name") + "')";
                oracleStmt.executeUpdate(sql);
            }

            mysqlRs.close();
            mysqlStmt.close();
            mysqlConn.close();

            oracleStmt.close();
            oracleConn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}