/* * Copyright 2004-2015 the Seasar Foundation and the Others. * * Licensed under the Apache License, Version 2.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://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. */ package org.seasar.extension.jdbc.gen.internal.sqltype; import java.io.ByteArrayInputStream; import java.sql.Blob; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Types; import org.seasar.extension.jdbc.gen.sqltype.SqlType; import org.seasar.framework.util.Base64Util; /** * {@link Types#BLOB}に対応する{@link SqlType}です。 * * @author taedium */ public class BlobType extends AbstractSqlType { /** 空のバイト配列 */ protected static byte[] EMPTY_BYTES = new byte[] {}; /** * インスタンスを構築します。 */ public BlobType() { this("blob"); } /** * インスタンスを構築します。 * * @param dataType * データ型 */ public BlobType(String dataType) { super(dataType); } public void bindValue(PreparedStatement ps, int index, String value) throws SQLException { if (value == null) { ps.setNull(index, Types.BLOB); } else if (value.length() == 0) { ps.setBinaryStream(index, new ByteArrayInputStream(EMPTY_BYTES), 0); } else { byte[] bytes = Base64Util.decode(value); ps.setBinaryStream(index, new ByteArrayInputStream(bytes), bytes.length); } } public String getValue(ResultSet resultSet, int index) throws SQLException { Blob blob = resultSet.getBlob(index); if (blob == null) { return null; } final long length = blob.length(); if (length == 0) { return Base64Util.encode(EMPTY_BYTES); } if (length > Integer.MAX_VALUE) { throw new ArrayIndexOutOfBoundsException(); } return Base64Util.encode(blob.getBytes(1L, (int) length)); } }