Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

spring+hibernateÖд¦Àíoracle BLOB

 1¡¢ÅäÖÃhibernate£º
    1.1¡¢ÅäÖÃhibernateµÄ³Ö¾ÃÀàÎļþÖжÔÓ¦µÄ×Ö¶ÎΪbyte[]ÀàÐÍ
    2.2¡¢ÅäÖÃhibernateµÄÀàÓ³ÉäÎļþÖжÔÓ¦µÄ×Ö¶ÎtypeΪ 
            org.springframework.orm.hibernate3.support.BlobByteArrayType
2¡¢ÅäÖÃspring£º
    2.1¡¢ÅäÖÃnativeJdbcExtractor£¬ÈçÏ£º  
          <bean   id="nativeJdbcExtractor" 
               class="org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor" />
 
    2.2¡¢ÅäÖÃoracleLobHandler
       <bean id="oracleLobHandler"   class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true">
         <property name="nativeJdbcExtractor">
             <ref bean="nativeJdbcExtractor" />
         </property>
       </bean>
   2.3°ÑoracleLobHandler¼ÓÈësessionFactoryÖÐ:
      <property name="lobHandler">
          <ref bean="oracleLobHandler" />
     </property>
3¡¢×ܽ᣺
    ÕýÈ·ÅäÖÃÒÔÉÏÁ½Ìõ£¬¾Í¿ÉÒÔÏñ´¦ÀíÆÕͨµÄ¶ÔÏóÒ»Ñù´¦ÀíoracleµÄ´ó¶ÔÏó¡£¶øÇÒ¿ÉÒÔ·½ÃæµÄ´ÓoracleÉÏÒÆÖ²µ½Ö§³Ö´ó¶ÔÏóµÄÆäËûÊý¾Ý¿âÉÏ£¬ÆÁ±ÎÁ˲»Í¬Êý¾Ý¿â´¦Àílob×ֶεIJî±ð£»
4¡¢À©Õ¹£º
    4.1¡¢´¦Àíclob¶ÔÏóÒ²ºÜ·½±ã£¬ÔÚÅäÖÃhibernateʱ°Ñ¶ÔÓ¦µÄÀàµÄÊôÐÔ×Ö¶ÎÅäÖÃΪString£¬Ó³ÉäÎļþtypeÅäÖÃΪorg.springframework.orm.hibernate3.support.ClobStringType¾ÍÐÐÁË¡£
        <property name="context" column="context" type="org.springframework.orm.hibernate.support.Cl


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

OracleµÄÌåϵ

 oracleµÄÌåϵºÜÅÓ´ó£¬ÒªÑ§Ï°Ëü£¬Ê×ÏÈÒªÁ˽âoracleµÄ¿ò¼Ü¡£ÔÚÕâÀ¼òÒªµÄ½²Ò»ÏÂoracleµÄ¼Ü¹¹£¬ÈóõѧÕß¶ÔoracleÓÐÒ»¸öÕûÌåµÄÈÏʶ¡£
¡¡¡¡1¡¢ÎïÀí½á¹¹£¨ÓÉ¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡¢²ÎÊýÎļþ¡¢¹éµµÎļþ¡¢ÃÜÂëÎļþ×é³É£©
¡¡¡¡¿ØÖÆÎļþ£º°üº¬Î¬»¤ºÍÑéÖ¤Êý¾Ý¿âÍêÕûÐԵıØÒªÐÅÏ¢¡¢ÀýÈ磬¿ØÖÆÎļþÓÃÓÚʶ±ðÊý¾ÝÎļ ......

Oracle PL/SQLÈëÃÅÖ®¿®Êö

 Ò»¡¢PL/SQL³öÏÖµÄÄ¿µÄ
¡¡¡¡½á¹¹»¯²éѯÓïÑÔ(Structured Query
Language£¬¼ò³ÆSQL)ÊÇÓÃÀ´·ÃÎʹØÏµÐÍÊý¾Ý¿âÒ»ÖÖͨÓÃÓïÑÔ£¬ËüÊôÓÚµÚËÄ´úÓïÑÔ£¨4GL£©£¬ÆäÖ´ÐÐÌØµãÊǷǹý³Ì»¯£¬¼´²»ÓÃÖ¸Ã÷Ö´ÐеľßÌå·½·¨ºÍ;
¾¶£¬¶øÊǼòµ¥µÄµ÷ÓÃÏàÓ¦Óï¾äÀ´Ö±½ÓÈ¡µÃ½á¹û¼´¿É¡£ÏÔÈ»£¬ÕâÖÖ²»¹Ø×¢ÈκÎʵÏÖϸ½ÚµÄÓïÑÔ¶ÔÓÚ¿ª·¢ÕßÀ´ËµÓÐ׿«´óµÄ ......

Oracleѧϰ±Ê¼Çժ¼6


  declare
  begin
   --SQLÓï¾ä
   --Ö±½ÓдµÄSQLÓï¾ä(DML/TCL)
   --¼ä½Óдexecute immediate <DDL/DCLÃüÁî×Ö·û´®>
   --select Óï¾ä
        <1>±ØÐë´øÓÐinto×Ó¾ä
      &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ