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 Blob blob = rs.getBlob(columnName);
40 byte[] returnValue = null;
41 if (null != blob) {
42 returnValue = blob.getBytes(1, (int) blob.length());
43 }
44 return returnValue;
45 }
46
47 @Override
48 public byte[] getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
49 Blob blob = rs.getBlob(columnIndex);
50 byte[] returnValue = null;
51 if (null != blob) {
52 returnValue = blob.getBytes(1, (int) blob.length());
53 }
54 return returnValue;
55 }
56
57 @Override
58 public byte[] getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
59 Blob blob = cs.getBlob(columnIndex);
60 byte[] returnValue = null;
61 if (null != blob) {
62 returnValue = blob.getBytes(1, (int) blob.length());
63 }
64 return returnValue;
65 }
66 }