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 BlobTypeHandler 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(parameter);
34 ps.setBinaryStream(i, bis, parameter.length);
35 }
36
37 @Override
38 public byte[] getNullableResult(ResultSet rs, String columnName) throws SQLException {
39 return toPrimitiveBytes(rs.getBlob(columnName));
40 }
41
42 @Override
43 public byte[] getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
44 return toPrimitiveBytes(rs.getBlob(columnIndex));
45 }
46
47 @Override
48 public byte[] getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
49 return toPrimitiveBytes(cs.getBlob(columnIndex));
50 }
51
52 private byte[] toPrimitiveBytes(Blob blob) throws SQLException {
53 return blob == null ? null : blob.getBytes(1, (int) blob.length());
54 }
55 }