JavaBean:
private byte[] fileContent;//文件内容
sqlmap.xml
<resultMap>
<result property="fileContent" column="FILE_CONTENT"
typeHandler="org.springframework.orm.ibatis.support.BlobByteArrayTypeHandler"/>
</resultMap>
<insert>
insert into 表名(FILE_CONTENT)
values(#fileContent, handler=org.springframework.orm.ibatis.support.BlobByteArrayTypeHandler#)
</insert>
<update>
<isNotEmpty> FILE_CONTENT=#fileContent,handler=org.springframework.orm.ibatis.support.BlobByteArrayTypeHandler#
</isNotEmpty>
</update>
事务定义配置文件
<!-- 配置iBatis支持Blob数据类型 -->
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" />
<bean id="sqlMapClientBase" abstract="true"
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocations">
<list>
<value>/WEB-INF/config/commons/sqlMapConfig-commons.xml</value>
<value>/WEB-INF/config/pif/sqlMapConfig-pif.xml</value>
</list>
</property>
<property name="dataSource" ref="com.shunde.spring.dataSource" />
<property name="lobHandler" ref="lobHandler" />
</bean>
<bean id="sqlMapClient" parent="sqlMapClientBase"></bean>
对应接口及实现类要添加事务控制