mysql clob转varchar2

SELECT my_clob_column FROM my_table;

import java.sql.Clob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ClobToString {
    public static void main(String[] args) {
        try {
            // 连接MySQL数据库
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "username", "password");
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT my_clob_column FROM my_table");

            while (rs.next()) {
                Clob clob = rs.getClob("my_clob_column");
                String clobString = clob.getSubString(1, (int) clob.length());
                System.out.println(clobString);
            }

            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class InsertIntoOracle {
    public static void main(String[] args) {
        try {
            // 连接Oracle数据库
            Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "username", "password");
            String sql = "INSERT INTO my_oracle_table (my_varchar2_column) VALUES (?)";
            PreparedStatement pstmt = conn.prepareStatement(sql);

            // 假设clobString是从MySQL中读取并转换后的字符串
            String clobString = "your_converted_string_here";
            pstmt.setString(1, clobString);
            pstmt.executeUpdate();

            pstmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}