mybatis 向oracle中插入clob/blob类型字段

xml配置文件：

<mapper namespace="com.mapper.api.ProductLableDao">
	<resultMap type="com.mapper.pojo.Test" id="BaseResultMap">
		
		<result property="filed" column="col" jdbcType="CLOB" 
				javaType = "java.lang.String"  typeHandler ="com.mapper.pojo.OracleClobTypeHandler" />
	</resultMap>
<!-- sql -->
</mapper>

typehelper类：

package com.mapper.pojo;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
 
import oracle.sql.CLOB;
 
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.TypeHandler;
 
public class OracleClobTypeHandler implements TypeHandler<Object> {
	
	public Object valueOf(String param) {
		return null;
	}
 
	@Override
	public Object getResult(ResultSet arg0, String arg1) throws SQLException {
		CLOB clob = (CLOB) arg0.getClob(arg1);
		return (clob == null || clob.length() == 0) ? null : clob.getSubString((long) 1, (int) clob.length());
	}
 
	@Override
	public Object getResult(ResultSet arg0, int arg1) throws SQLException {
		return null;
	}
 
	@Override
	public Object getResult(CallableStatement arg0, int arg1) throws SQLException {
		return null;
	}
 
	@Override
	public void setParameter(PreparedStatement arg0, int arg1, Object arg2, JdbcType arg3) throws SQLException {
		CLOB clob = CLOB.empty_lob();
		clob.setString(1, (String) arg2);
		arg0.setClob(arg1, clob);
	}
}

 使用该字段时当做String即可！