1   
2   
3   
4   
5   
6   
7   
8   
9   
10  
11  
12  
13  
14  
15  
16  package org.apache.ibatis.type;
17  
18  import java.io.ByteArrayInputStream;
19  import java.sql.Blob;
20  import java.sql.CallableStatement;
21  import java.sql.PreparedStatement;
22  import java.sql.ResultSet;
23  import java.sql.SQLException;
24  
25  
26  
27  
28  public class BlobByteObjectArrayTypeHandler extends BaseTypeHandler<Byte[]> {
29  
30    @Override
31    public void setNonNullParameter(PreparedStatement ps, int i, Byte[] parameter, JdbcType jdbcType)
32        throws SQLException {
33      ByteArrayInputStream bis = new ByteArrayInputStream(ByteArrayUtils.convertToPrimitiveArray(parameter));
34      ps.setBinaryStream(i, bis, parameter.length);
35    }
36  
37    @Override
38    public Byte[] getNullableResult(ResultSet rs, String columnName)
39        throws SQLException {
40      Blob blob = rs.getBlob(columnName);
41      return getBytes(blob);
42    }
43  
44    @Override
45    public Byte[] getNullableResult(ResultSet rs, int columnIndex)
46        throws SQLException {
47      Blob blob = rs.getBlob(columnIndex);
48      return getBytes(blob);
49    }
50  
51    @Override
52    public Byte[] getNullableResult(CallableStatement cs, int columnIndex)
53        throws SQLException {
54      Blob blob = cs.getBlob(columnIndex);
55      return getBytes(blob);
56    }
57  
58    private Byte[] getBytes(Blob blob) throws SQLException {
59      Byte[] returnValue = null;
60      if (blob != null) {
61        returnValue = ByteArrayUtils.convertToObjectArray(blob.getBytes(1, (int) blob.length()));
62      }
63      return returnValue;
64    }
65  }