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

Hibernate3²Ù×÷OracleµÄBlob×Ö¶Î

hibernate×÷Ϊһ¸öÓÅÐãµÄOR£­Mapping¹¹¼Ü£¬¶ÔÊý¾Ý¿âµÄ»ù±¾²Ù×÷½øÐÐÁ˱ȽϺõķâ×°£¬Õë¶ÔBlobÀàÐÍ×ֶεIJÙ×÷Ò²²»ÀýÍâ¡£µ«ÍøÉϴ󲿷ÖÄÜÕÒµ½µÄhibernate²Ù×÷BlobµÄÀý³Ì¶¼ÊÇ»ùÓÚhibernate2°æ±¾µÄ£¬Í¬Ê±ÔÚʵ¼Ê²Ù×÷ÖÐÎÒ·¢ÏÖÕë¶Ô²»Í¬µÄÊý¾Ý¿â£¬¿ÉÒÔÓв»Í¬µÄ²Ù×÷·½·¨¡£ÏÂÃæ½«hibernate3²Ù×÷oracleµÄBlob×ֶνøÐÐÒ»¸ö½éÉÜ¡£
         ÓÃJDBC²Ù×÷Blob×î»ù±¾µÄ˼·ÊÇ£ºÏȲåÈëÒ»Ìõ°üº¬¿ÕBlobµÄ¼Ç¼£¬È»ºóÁ¢¼´½«¸ÃÌõ¼Ç¼ÓÃÐÐËø¶¨µÄ·½Ê½´ò¿ª£¬µÃµ½¸ÄBlob×ֶεÄÒýÓ㬴ÓÖеõ½Ò»¸öÊä³öÁ÷£¬½«byte[]Êý¾ÝдÈëºóÌá½»¡£hibernate²Ù×÷µÄ»ù±¾Ë¼Â·Ò²ÊÇÒ»Öµġ£ÏÂÀýÖÐÓõ½±íimg£¬ÀïÃæÒ»¸öÖ÷¼üid£¬Ò»¸öBlob×Ö¶Îimg¡£Ëü¶ÔÓ¦µÄÓ³ÉäÎļþÈçÏ£º
  
      <class name="Img" table="IMG">
          <id name="id" column="ID" type="long">
              <generator class="increment"/>
          </id>
          <property name="img" column="IMG" type="java.sql.Blob" />        1
      </class>
         ÔÚ1´¦¿ÉÒÔ²»Ö¸¶¨×ֶεÄÀàÐÍ£¬ÈÃhibernate×Ô¶¯´¦Àí¡£¶ÔÓ¦µÄ³Ö¾Ã»¯ÀàÖУ¬imgÊôÐÔÒ²ÉùÃ÷Ϊjava.sql.BlobÀàÐÍ¡£²åÈëµÄ´úÂëÈçÏ£º
  
    Session s = Hsf.currentSession();
    Transaction t = s.beginTransaction();
    Img img = new Img();
  //µ÷ÓÃHibernateµÄ¾²Ì¬·½·¨£¬´´½¨Ò»¸ö³¤¶ÈΪ1µÄbyteÊý×飬Éú³ÉÒ»¸ö¿ÕBlob
    img.setImg(Hibernate.createBlob(new byte[1]));
    s.save(img);  //±£´æµ½Êý¾Ý¿âÖÐ
    s.flush();
    s.refresh(img,LockMode.UPGRADE);  //Ëø¶¨Îª¸üÐÂģʽ
    //System.out.println(img.getImg().getClass());
  //·µ»ØµÄÊÇSerializableBlobÀàÐ͵ĶÔÏó£¬ÕâÊǸöʵÏÖÁËBlob½Ó¿ÚµÄ¶Ô


Ïà¹ØÎĵµ£º

ÔÚOracleÖм¯³Éjava³ÌÐòµÄ¾­Ñé̸֮£¡

Õâ¶Îʱ¼äΪ¹«Ë¾ÄÚ²¿µÄÊý¾Ý´¦Àí¿ª·¢ÁËÒ»¸ö¹¤¾ß£¬Ç£Éæµ½ÔÚOracleÖм¯³ÉjavaÓ¦Óã¬×ܽáÁËһЩ¾­Ñ飬ÒÔ¹©´ó¼Ò²Î¿¼ÁË£¡
³ÌÐò·ÖÁ½²¿·Ö£¬Ç°¶Ë½çÃæÓÉVB/VC¿ª·¢£¬Ö÷ҪʵÏÖÊý¾Ý´¦ÀíÅäÖü°³£¹æ¼Ç¼ÔËË㣬Õⲿ·ÖûÓÐʲôºÃ˵µÄÁË¡£
ºǫ́ÒÔOracleΪÊý¾Ý»ù´¡´¦ÀíÍÐ¹ÜÆ½Ì¨£¬ÔÚÊý¾Ý´¦Àí¹ý³ÌÖУ¬ÐèÒª¶ÔһЩÃû³Æ¡¢µØÖ·Ê²Ã´µÄ½øÐÐÕªÒªÌáÈ¡¡¢² ......

oracleµ÷ÓÃjava

create or replace and compile java source named md5util as
import java.security.MessageDigest;
public class MD5Util
{
  public static String encrypt(String s)
  {
       char hexDigits[] = {'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', ......

oracleÓαê

drop table tmp_lzw_3283_tar;
create table tmp_lzw_3283_tar
(
    servnumber varchar2(11)
)
;
load data
infile 'tar_3283.txt'
insert into table tmp_lzw_3283_tar
fields terminated by '|'
(
servnumber
)
/*
select count(*),count(distinct servnumber) from tmp_lzw_3283_ta ......

Oracle Êý¾ÝÀàÐÍ·ÖÏí

¸øÍŶÓÄÚ²¿×öµÄÒ»¸öOracle Êý¾ÝÀàÐÍ·ÖÏí£¬Ö÷ÒªÊǹØÓÚOracleÊý¾ÝÀàÐÍһЩÄÚ²¿´æ´¢½á¹¹¼°ÐÔÄܽéÉÜ¡£
 http://www.slideshare.net/yzsind/oracle-4317768
ÒÔÏÂÊÇPPTÖÐunDumpNumberº¯ÊýµÄÈ«²¿´úÂ룺
 
create or replace function unDumpNumber(iDumpStr varchar2) return number is
 
  TYPE ByteAr ......

Oracle Trigger¼òµ¥Ó÷¨

1. trigger ÊÇ×Ô¶¯Ìá½»µÄ£¬²»ÓÃCOMMIT£¬ROLLBACK
2. trigger×î´óΪ32K£¬Èç¹ûÓи´ÔÓµÄÓ¦ÓÿÉÒÔͨ¹ýÔÚTRIGGERÀïµ÷ÓÃPROCEDURE»òFUNCTIONÀ´ÊµÏÖ¡£
3. Óï·¨
CREATE OR REPLACE TRIGGER <trigger_name>
<BEFORE | AFTER> <ACTION>
ON <table_name>
DECLARE
 <variable definitions> ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ