Java SQL Blob getAsString(Blob blob)

Description

get As String

License

Open Source License

Declaration

public static String getAsString(Blob blob) throws Exception 

Method Source Code

//package com.java2s;
/**//from  www. ja  v  a  2  s  .c  o  m
 * The contents of this file are subject to the OpenMRS Public License
 * Version 1.0 (the "License"); you may not use this file except in
 * compliance with the License. You may obtain a copy of the License at
 * http://license.openmrs.org
 *
 * Software distributed under the License is distributed on an "AS IS"
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
 * License for the specific language governing rights and limitations
 * under the License.
 *
 * Copyright (C) OpenMRS, LLC.  All Rights Reserved.
 */

import java.io.BufferedReader;
import java.io.InputStreamReader;

import java.sql.Blob;

public class Main {
    public static String getAsString(Blob blob) throws Exception {
        BufferedReader br = new BufferedReader(new InputStreamReader(blob.getBinaryStream()));
        StringBuffer sb = new StringBuffer();
        String line;
        while ((line = br.readLine()) != null) {
            sb.append(line);
        }
        return sb.toString();
    }
}

Related

1. blob2FloatArray(Blob blob)
2. blobToBytes(Blob blob)
3. blobToBytes(Blob blob)
4. getBlobType(byte[] image)
5. getDataFromBlob(Blob b)
6. getDataFromBlob(Blob b)
7. getLongBlobTypeString(Connection conn)