Java SQL ResultSet Read readBytes(ResultSet rs, int pos)

Description

read Bytes

License

Open Source License

Declaration

public static byte[] readBytes(ResultSet rs, int pos) throws IOException, SQLException 

Method Source Code

//package com.java2s;
/*/*from  w w w .j  av  a 2s  .c  om*/
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 *
 * Copyright (c) 2000-2017 Oracle and/or its affiliates. All rights reserved.
 *
 * The contents of this file are subject to the terms of either the GNU
 * General Public License Version 2 only ("GPL") or the Common Development
 * and Distribution License("CDDL") (collectively, the "License").  You
 * may not use this file except in compliance with the License.  You can
 * obtain a copy of the License at
 * https://oss.oracle.com/licenses/CDDL+GPL-1.1
 * or LICENSE.txt.  See the License for the specific
 * language governing permissions and limitations under the License.
 *
 * When distributing the software, include this License Header Notice in each
 * file and include the License file at LICENSE.txt.
 *
 * GPL Classpath Exception:
 * Oracle designates this particular file as subject to the "Classpath"
 * exception as provided by Oracle in the GPL Version 2 section of the License
 * file that accompanied this code.
 *
 * Modifications:
 * If applicable, add the following below the License Header, with the fields
 * enclosed by brackets [] replaced by your own identifying information:
 * "Portions Copyright [year] [name of copyright owner]"
 *
 * Contributor(s):
 * If you wish your version of this file to be governed by only the CDDL or
 * only the GPL Version 2, indicate your decision by adding "[Contributor]
 * elects to include this software in this distribution under the [CDDL or GPL
 * Version 2] license."  If you don't indicate a single choice of license, a
 * recipient has the option to distribute your version of this file under
 * either the CDDL, the GPL Version 2 or to extend the choice of license to
 * its licensees as provided above.  However, if you add GPL Version 2 code
 * and therefore, elected the GPL Version 2 license, then the option applies
 * only if the new code is made subject to such option by the copyright
 * holder.
 */

import java.io.*;
import java.sql.*;

public class Main {
    public static byte[] readBytes(ResultSet rs, int pos) throws IOException, SQLException {

        InputStream is = rs.getBinaryStream(pos);

        // If column is empty then InputStream will be NULL
        if (is == null) {
            return null;
        }

        ByteArrayOutputStream bos = new ByteArrayOutputStream(1024);

        // read until either:
        //   returned number of bytes is 0 or -1: no more to read
        //   get an eof
        byte[] buf = new byte[1024];
        while (true) {
            try {
                int cnt = is.read(buf, 0, 256);
                if (cnt > 0) {
                    bos.write(buf, 0, cnt);
                } else {
                    // cnt = 0 or -1; cannot read anything, we are done
                    break;
                }
            } catch (EOFException e) {
                // done
                break;
            }
        }

        return bos.toByteArray();
    }
}

Related

1. getValue(ResultSet rs, String sField)
2. getValue4Type(ResultSet rs, String column, Class typeClass)
3. getValueByObjectType(ResultSetMetaData metaData, ResultSet rs, int index)
4. getValueFromResultSet(int index, final ResultSet resultSet, final Class type)
5. readBitBoolean(ResultSet result, int index)
6. readDate(ResultSet result, int index)
7. readMap(final ResultSet rs)
8. readObject(java.sql.ResultSet resultSet, int index)
9. readResults(ResultSet resultSet)