Ibaties读写CLOB.Blob的配置

xml如下：说明一下，在resultMap中可以通过typeHandler来指定具体的handler.在inline变量中，可以通过handler来定义相应的typeHandler 

<sqlMap namespace="Food"> 
   
   <typeAlias alias="Food" type="org.esoft.hdb.bo.Food"/> 
   <resultMap id="foodResult" class="Food"> 
       <result property="id" column="C_ID"/> 
       <result property="name" column="C_NAME"/> 
       <result property="content" column="C_content" 
           typeHandler="org.springframework.orm.ibatis.support.ClobStringTypeHandler"/> 
       <result property="image" column="C_image" 
           typeHandler="org.springframework.orm.ibatis.support.BlobByteArrayTypeHandler"/> 
   </resultMap> 
   <sql id="foodFragment">select C_ID,C_NAME,C_CONTENT,C_IMAGE from T_FOOD</sql> 
       <select id="getAll" resultMap="foodResult"> 
       <include refid="foodFragment"/> 
   </select> 
   <select id="selectById" parameterClass="string" resultMap="foodResult"> 
       <include refid="foodFragment"/> where C_ID=#id#</select> 
   
   <insert id="insert" parameterClass="Food"> insert into T_FOOD ( C_ID, 
       C_NAME,C_CONTENT, C_IMAGE) values ( #id#, 
       #name#,#content,handler=org.springframework.orm.ibatis.support.ClobStringTypeHandler#, 
       #image,handler=org.springframework.orm.ibatis.support.BlobByteArrayTypeHandler#) 
       </insert> 
   
   <update id="update" parameterClass="Food"> update T_FOOD set C_NAME = #name#, 
       C_CONTENT = 
       #content,handler=org.springframework.orm.ibatis.support.ClobStringTypeHandler#, 
       C_IMAGE = 
       #image,handler=org.springframework.orm.ibatis.support.BlobByteArrayTypeHandler# 
       where C_ID = #id# </update> 
   
   <delete id="deleteById" parameterClass="string"> delete from T_FOOD where C_ID = #id# 
       </delete> 
   
</sqlMap> 


public interface FoodService { 

   
     void save(Food food); 
     Food get(String id); 
     /** 
     * @param food 
     */ 
     void update(Food food); 
} 

public class FoodServiceImpl implements FoodService { 
     private FoodDAO foodDAO; 

     private DaoCreator creator; 

     public void setCreator(DaoCreator creator) { 
         this.creator = creator; 
     } 

     protected FoodDAO getFoodDAO() { 
         if (foodDAO == null) { 
             foodDAO = (FoodDAO) creator.createDao(FoodDAO.class, Food.class); 
         } 
         return foodDAO; 
     } 

     public Food get(String id) { 
         return getFoodDAO().get(id); 
     } 
     public void save(Food food) { 
         getFoodDAO().save(food); 
     } 
     public void update(Food food) { 
         getFoodDAO().update(food); 
     } 

}