Spring boot + mybatis +oracle +blob 入库

vo类

public class BottomFeature 
{
	private static final long serialVersionUID = 1L;

	/** 对象id */
	private String objid;
	/** 值 */
	private byte[] feature;//重点，类型为byte

	public void setObjid(String objid)
	{
		this.objid = objid;
	}

	public String getObjid()
	{
		return objid;
	}

    public byte[] getFeature() {
        return feature;
    }

    public void setFeature(byte[] feature) {
        this.feature = feature;
    }

    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("objid", getObjid())
            .append("feature", getFeature())
            .toString();
    }
}

 

xml：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xxx.firearms.mapper.BottomFeatureMapper">

    <resultMap type="BottomFeature" id="BottomFeatureResult">
        <result property="objid"    column="objid"    />
        <result property="feature"    column="feature"  javaType="java.sql.Blob" jdbcType="BLOB" typeHandler="org.apache.ibatis.type.BlobTypeHandler"/>#重点 javaType、JdbcType、typeHandler
    </resultMap>

	<sql id="selectBottomFeatureVo">
        select objid, feature from standard_bottom_feature
    </sql>

    <select id="selectBottomFeatureList" parameterType="BottomFeature" resultMap="BottomFeatureResult">
        <include refid="selectBottomFeatureVo"/>
        <where>
            <if test="objid != null  and objid != '' "> and objid = #{objid}</if>
             <if test="feature != null "> and feature = #{feature}</if>
         </where>
    </select>

    <select id="selectBottomFeatureById" parameterType="String" resultMap="BottomFeatureResult">
        <include refid="selectBottomFeatureVo"/>
        where objid = #{objid}
    </select>

    <insert id="insertBottomFeature" parameterType="BottomFeature">
        insert into standard_bottom_feature
			(objid,
			feature)
        values
			(#{objid},
			#{feature,jdbcType=BLOB} )#重点，加jdbcType
    </insert>
</mapper>