SSH对blob的支持

刚刚解决一个图片存入数据库的问题，留个记录备查。

[color=blue]1、主要步骤[/color]
1.1配置hibernate：
1.1.1、配置hibernate的持久类文件中对应的字段为byte[]类型
1.1.2、配置hibernate的类映射文件中对应的字段type为
org.springframework.orm.hibernate3.support.BlobByteArrayType

1.2、配置spring：
1.2.1、配置nativeJdbcExtractor，如下：
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor" />
1.2.2、配置oracleLobHandler
<bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true">
<property name="nativeJdbcExtractor">
<ref bean="nativeJdbcExtractor" />
　　 </property>
　　 </bean>
1.2.3、把oracleLobHandler加入sessionFactory中:
<property name="lobHandler">
<ref bean="oracleLobHandler" />
</property


[color=blue]2、源代码[/color]
2.1.1、table_test_image

create table TABLE_TEST_IMAGE
(
  ID  VARCHAR2(40),
  FID VARCHAR2(40),
  IMG BLOB
)

2.1.2、Image.java

package ie.search.test.model;

public class Image {
	private String id;
	private String fid;
	private byte[] img;
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getFid() {
		return fid;
	}
	public void setFid(String fid) {
		this.fid = fid;
	}
	public byte[] getImg() {
		return img;
	}
	public void setImg(byte[] img) {
		this.img = img;
	}
}

2.1.3、Image.hbm.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="ie.search.test.model.Image" table="TABLE_TEST_IMAGE" >
        <id name="id" type="java.lang.String">
            <column name="ID" length="40" />
              <generator class="sequence"> 
                <param name="sequence">SEQ_TEST_IMAGE</param> 
              </generator>
        </id>

         <property name="fid" type="string">
            <column name="FID" length="40">
                <comment>外键</comment>
            </column>
        </property>

        <property name="img" type="org.springframework.orm.hibernate3.support.BlobByteArrayType">
            <column name="IMG" >
                <comment>图片</comment>
            </column>
        </property>

    </class>
</hibernate-mapping>

2.1.4、spring配置文件片段

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">

	<!-- for Oracle9i ojdbc14.jar测试通过 -->
	<bean id="nativeJdbcExtractor" lazy-init="true" class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor"/>
	<bean id="lobHandler" lazy-init="true"   class="org.springframework.jdbc.support.lob.OracleLobHandler">
	        <property name="nativeJdbcExtractor">
	            <ref bean="nativeJdbcExtractor"/>
	        </property>
	</bean> 
	<!-- Oracle9i over -->

	<!-- for Oracle10g ojdbc14.jar测试通过-->
	<!--
	<bean id="lobHandler" lazy-init="true"   class="org.springframework.jdbc.support.lob.DefaultLobHandler">
	</bean> 
	-->
	<!-- Oracle10g over -->

	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />	
		<property name="lobHandler" ref="lobHandler"/>
		<property name="mappingDirectoryLocations">
			<list>
				<value>classpath*:ie/bsp/modules/commonquery/model/</value>
				<value>classpath*:ie/bsp/modules/reference/model/</value>
				<value>classpath*:ie/bsp/modules/commcomponent/model/</value>
				<value>classpath*:ie/bsp/modules/zone/model/</value>				
				<value>classpath*:ie/search/feature/featureTick/model/</value>
				<value>classpath*:ie/search/feature/featureMosquito/model/</value>
				<value>classpath*:ie/search/vector/tick/model/</value>
				<value>classpath*:ie/search/feature/featureMouse/model/</value>
				<value>classpath*:ie/search/feature/featureFlea/model/</value>
				<value>classpath*:ie/perm/model/</value>




			</list>
		</property>

		<property name="hibernateProperties">

			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.format_sql">true</prop>
				<prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop>
				<prop key="hibernate.cache.use_query_cache">true</prop>

			</props>
		</property>


	</bean>
	</beans>

2.1.5、存取图片的action代码段

public String saveImage(){
		FileInputStream fis=null;
		Image image=new Image();
		image.setFid("1");
		byte[] img=null;
		try {
			File f=new File("d:\\upload\\-1.jpg");
			fis=new FileInputStream(f);
			byte[] b=new byte[fis.available()];
			fis.read(b);
			fis.close();
			img=b;
			image.setImg(img);
			imageDao.save2(image);
		} catch (Exception e) {
			e.printStackTrace();
		}
		imageDao.save2(image);
		return "success";
	}

	public String readImage(){
		System.out.println(this.getClass()+".readImage()...");
		Image image=imageDao.get("21");
		FileOutputStream fos=null;
		try {
			fos=new FileOutputStream("d:\\upload\\target1.jpg");
			fos.write(image.getImg());
			fos.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return "success";
	}

[color=blue]3、注意[/color]
<bean id="nativeJdbcExtractor"/>
用了c3p0连接池的情况下用： C3P0NativeJdbcExtractor
如果是dpcp连接池，则用：CommonsDbcpNativeJdbcExtractor
如果没有使用连接池，则用：SimpleNativeJdbcExtractor
其他的，用了jboss，weblogic连接池等等的情况，都有专门的Extractor对应。