深入浅出Hibernate之向Mysql插入BLOB,CLOB数据
mysql version 5.0

database name:sample

数据表DDL:

create table `sample`.`tuser_blob`(
        `id` int not null auto_increment,
       `name` varchar(50),
       `age` int,
       `versio` int,
       `user_type` int,
       `image` blob,
       `resume` mediumblob,
        primary key (`id`)
    );

TuserBlob.hbm.xml文件：

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<!--
    Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
    <class name="org.hibernatetest.bean.TuserBlob" table="tuser_blob">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native" />
        </id>
        <property name="name" type="java.lang.String">
            <column name="name" length="50" />
        </property>
        <property name="age" type="java.lang.Integer">
            <column name="age" />
        </property>
        <property name="versio" type="java.lang.Integer">
            <column name="versio" />
        </property>
        <property name="userType" type="java.lang.Integer">
            <column name="user_type" />
        </property>
        <property name="image" type="java.sql.Blob">
            <column name="image" />
        </property>
        <property name="resume" type="java.sql.Clob">
            <column name="resume" />
        </property>
    </class>
</hibernate-mapping>


对应的java文件：
package org.hibernatetest.bean;

/**
* TuserBlob generated by MyEclipse - Hibernate Tools
*/
import java.sql.Blob;
import java.sql.Clob;
public class TuserBlob  implements java.io.Serializable {

    // Fields   
     private Integer id;
     private String name;
     private Integer age;
     private Integer versio;
     private Integer userType;
     private Blob image;
     private Clob resume;

    // Constructors