Java String如何转为Clob对象？-杰瑞科技汇

Java String 转 CLOB

在Java中将String转换为CLOB（Character Large Object）可以通过以下几种方式实现：

（图片来源网络，侵删）

方法1：使用JDBC的`createClob()`方法

import java.sql.Connection;
import java.sql.Clob;
import java.sql.SQLException;
public StringToClobConverter {
    public static Clob stringToClob(Connection connection, String str) throws SQLException {
        if (str == null) {
            return null;
        }
        Clob clob = connection.createClob();
        clob.setString(1, str);
        return clob;
    }
}

方法2：使用`StringReader`和`setCharacterStream()`

import java.sql.Connection;
import java.sql.Clob;
import java.sql.SQLException;
import java.io.StringReader;
public class StringToClobConverter {
    public static Clob stringToClob(Connection connection, String str) throws SQLException {
        if (str == null) {
            return null;
        }
        Clob clob = connection.createClob();
        clob.setCharacterStream(1).write(str.toCharArray());
        return clob;
    }
}

方法3：使用Oracle特定的方法（如果使用Oracle数据库）

import java.sql.Connection;
import java.sql.SQLException;
import oracle.sql.CLOB;
public class StringToClobConverter {
    public static CLOB stringToClob(Connection connection, String str) throws SQLException {
        if (str == null) {
            return null;
        }
        CLOB clob = CLOB.createTemporary(connection, true, CLOB.DURATION_SESSION);
        clob.putString(1, str);
        return clob;
    }
}

使用示例

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Main {
    public static void main(String[] args) {
        String str = "这是一个很长的文本内容，需要转换为CLOB类型存储到数据库中...";
        try (Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "username", "password")) {
            Clob clob = StringToClobConverter.stringToClob(connection, str);
            String sql = "INSERT INTO my_table (id, my_clob) VALUES (?, ?)";
            try (PreparedStatement pstmt = connection.prepareStatement(sql)) {
                pstmt.setInt(1, 1);
                pstmt.setClob(2, clob);
                pstmt.executeUpdate();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}