SQL Server CLOB数据到字符串Java + Angular

import java.io.BufferedReader;
import java.io.IOException;
import java.io.Reader;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class ClobToStringExample {
    public static void main(String[] args) {
        String url = "jdbc:sqlserver://localhost:1433;databaseName=your_database";
        String username = "your_username";
        String password = "your_password";

        try (Connection conn = DriverManager.getConnection(url, username, password)) {
            String sql = "SELECT clob_column FROM your_table WHERE id = ?";
            int id = 1;

            try (PreparedStatement stmt = conn.prepareStatement(sql)) {
                stmt.setInt(1, id);

                try (ResultSet rs = stmt.executeQuery()) {
                    if (rs.next()) {
                        Clob clob = rs.getClob("clob_column");
                        String clobString = clobToString(clob);
                        System.out.println(clobString);
                    }
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    private static String clobToString(Clob clob) throws SQLException, IOException {
        StringBuilder sb = new StringBuilder();
        Reader reader = clob.getCharacterStream();
        BufferedReader br = new BufferedReader(reader);

        String line;
        while ((line = br.readLine()) != null) {
            sb.append(line);
        }

        br.close();
        reader.close();

        return sb.toString();
    }
}

import { HttpClient } from '@angular/common/http';

export class ClobToStringExampleComponent {
    constructor(private http: HttpClient) {}

    getClobData(): void {
        const url = 'your_api_endpoint';
        const id = 1;

        this.http.get(url, { params: { id: id.toString() }, responseType: 'text' })
            .subscribe((clobString: string) => {
                console.log(clobString);
            });
    }
}