oracle clob转为mysql

-- 示例：创建MySQL表
CREATE TABLE my_table (
    id INT PRIMARY KEY,
    content LONGTEXT
);

-- 示例：设置字符集
ALTER DATABASE my_database CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

import java.sql.*;

public class ClobToLongtextMigration {
    public static void main(String[] args) {
        String oracleUrl = "jdbc:oracle:thin:@localhost:1521:orcl";
        String mysqlUrl = "jdbc:mysql://localhost:3306/my_database";
        String oracleUser = "oracle_user";
        String oraclePassword = "oracle_password";
        String mysqlUser = "mysql_user";
        String mysqlPassword = "mysql_password";

        try (Connection oracleConn = DriverManager.getConnection(oracleUrl, oracleUser, oraclePassword);
             Connection mysqlConn = DriverManager.getConnection(mysqlUrl, mysqlUser, mysqlPassword)) {

            // 查询Oracle CLOB数据
            String query = "SELECT id, content FROM my_oracle_table";
            try (Statement stmt = oracleConn.createStatement();
                 ResultSet rs = stmt.executeQuery(query)) {

                // 插入MySQL LONGTEXT数据
                String insertQuery = "INSERT INTO my_table (id, content) VALUES (?, ?)";
                try (PreparedStatement pstmt = mysqlConn.prepareStatement(insertQuery)) {
                    while (rs.next()) {
                        pstmt.setInt(1, rs.getInt("id"));
                        pstmt.setString(2, rs.getString("content"));
                        pstmt.executeUpdate();
                    }
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}