Java SQL ResultSet Blob Read getBlobValue(ResultSet result, String strField)

Here you can find the source of getBlobValue(ResultSet result, String strField)

Description

get Blob Value

License

Apache License

Declaration

public static String getBlobValue(ResultSet result, String strField) throws java.sql.SQLException 

Method Source Code


//package com.java2s;
/*/*  ww w .j  av  a  2s  .c  om*/
 ************************************************************************************
 * Copyright (C) 2001-2010 Openbravo S.L.U.
 * Licensed under the Apache Software License version 2.0
 * You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0
 * Unless required by applicable law or agreed to  in writing,  software  distributed
 * under the License is distributed  on  an  "AS IS"  BASIS,  WITHOUT  WARRANTIES  OR
 * CONDITIONS OF ANY KIND, either  express  or  implied.  See  the  License  for  the
 * specific language governing permissions and limitations under the License.
 ************************************************************************************
 */

import java.sql.Blob;

import java.sql.ResultSet;

public class Main {
    public static String getBlobValue(ResultSet result, String strField) throws java.sql.SQLException {
        String strValueReturn = "";
        Blob blob = result.getBlob(strField);
        if (result.wasNull()) {
            strValueReturn = "";
        } else {
            int length = (int) blob.length();
            if (length > 0)
                strValueReturn = new String(blob.getBytes(1, length));
        }
        return strValueReturn;
    }
}

Related

  1. getBlob(ResultSet results, int parameterIndex)
  2. getBlobAsByteArray(final ResultSet rs, final int ind)
  3. getBlobAsBytes(ResultSet rs, int col)
  4. getBlobBytes(ResultSet rs, int iColumn)
  5. readBlob(ResultSet rs, int index)
  6. readBlobUTF16BinaryStream(ResultSet rs, String fieldName)
  7. readBlobUTF16BinaryStream(ResultSet rs, String fieldName)
  8. readFromBlob(ResultSet rs, String column)