Mybatis中mysql blob類型亂碼解決

mysql中存了一個頁面的html，應為欄位比較長，存成blob類型，在取出後發現會有亂碼出現，解決方式是自己擴充了一個TypeHandler

public class MyBlobTypeHandler extends BaseTypeHandler<String> {    ###指定字元集    private static final String DEFAULT_CHARSET = "utf-8";    @Override    public void setNonNullParameter(PreparedStatement ps, int i,            String parameter, JdbcType jdbcType) throws SQLException {        ByteArrayInputStream bis;        try {            ###把String轉化成byte流            bis = new ByteArrayInputStream(parameter.getBytes(DEFAULT_CHARSET));        } catch (UnsupportedEncodingException e) {            throw new RuntimeException("Blob Encoding Error!");        }           ps.setBinaryStream(i, bis, parameter.length());    }    @Override    public String getNullableResult(ResultSet rs, String columnName)            throws SQLException {        Blob blob = rs.getBlob(columnName);        byte[] returnValue = null;        if (null != blob) {            returnValue = blob.getBytes(1, (int) blob.length());        }        try {            ###把byte轉化成string            return new String(returnValue, DEFAULT_CHARSET);        } catch (UnsupportedEncodingException e) {            throw new RuntimeException("Blob Encoding Error!");        }    }    @Override    public String getNullableResult(CallableStatement cs, int columnIndex)            throws SQLException {        Blob blob = cs.getBlob(columnIndex);        byte[] returnValue = null;        if (null != blob) {            returnValue = blob.getBytes(1, (int) blob.length());        }        try {            return new String(returnValue, DEFAULT_CHARSET);        } catch (UnsupportedEncodingException e) {            throw new RuntimeException("Blob Encoding Error!");        }    }}

在設定檔中配置如下

<result column="menu" property="menu" typeHandler="MyBlobTypeHandler"/>

搞定。