如何在IBatis中使用BLOB和CLOB

下面有一个例子在Ibatis中使用Custom Type Handler (CTH)操作BLOB（二进制字节）和CLOB（字符类型）数据类型。Ibatis2.09后提供了对BLOB和CLOB的支持，下面的例子是oracle上的但也可以用于任何支持Jdbc的数据库。如果用oracle你需要使用最新的ojbc14.jar。

创建表：

Report.sql

REPORT {
       id              varchar2(5),
       name            varchar2(25),
       description     varchar2(1000),
       data            BLOB
}

创建表对应的POJO：

Report.java

/*
* Report.java
*
* Created on March 23, 2005, 11:00 AM
*/
package reporting.viewer.domain;

/**
*
* @author Nathan Maves
*/
public class Report {
  
   /**
    * Holds value of property id.
    */
   private String id;
   /**
    * Holds value of property name.
    */
   private String name;
   /**
    * Holds value of property description.
    */
   private String id;
   /**
    * Holds value of property data.
    */
   private byte[] data;


   //Standard accessors and mutators

  public byte[] getData() {
      return this.data;
  }

   public void setData(byte[] data) {        this.data = data;    }
}

iBatis配置文件：

Report.xml

<typeAlias alias="Report" type="reporting.viewer.domain.Report"/>

<resultMap class="Report" id="ReportResult">         <result column="id" property="id" />         <result column="name" property="name" />         <result column="description" property="description" />         <result column="data" property="data" jdbcType="BLOB"/> </resultMap>

<select id="getReportById" parameterClass="string" resultMap="ReportResult">
       SELECT
           *
       FROM
           REPORT
       WHERE
           id = #value#
</select>

<insert id="insertReport" parameterClass="Report">
       INSERT INTO
           REPORT (
               id,
               name,
               description,
               data
               )
           values (
               #id#,
               #name#,
               #description#,
               #data#
           )
</insert>

<update id="updateReport" parameterClass="Report">
       UPDATE REPORT set
               name = #name#,
               description = #description#,
               data = #data#
       WHERE
               id = #id#
</update>

就这么多ok。
更多请看http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+BLOB+or+CLOB