ÔÚhibernateÖÐʵÏÖoracleµÄÖ÷¼ü×ÔÔö²ßÂÔ
ת×Ô£ºhttp://blog.csdn.net/scorpio3k/archive/2009/05/09/4162079.aspx
ÔںܶàÇé¿öÏ£¬ÎÒÃÇʹÓÃHibernateÔÚÒѾ½¨Á¢ºÃÊý¾Ý¿âµÄ»ù´¡ÉÏ¡£ÔÚoracleÖУ¬Èç¹ûÒѾ½¨Á¢ºÃµÄÊý¾Ý¿âÖÐʹÓÃÁËsequence
,Ôò¿ÉÒÔ°´ÕÕÏÂÃæµÄ²½Öè°ÑËüÒýÈëµ½HibernateÖУº
1¡¢ÔÚoracle Ê×ÏÈ´´½¨sequence
create sequence seq_id
minvalue 1
start with 1
increment by 1
cache 20;
2.ÔÚÄãµÄhbm.xmlÖеÄÅäÖÃ
<id column="ID0000" name="id" type="integer">
<generator class="sequence">
<param name="sequence">seq_id</param>
</generator>
</id>
ÕâÑùÔÙ²åÈëÊý¾ÝµÄʱºò£¬Hibernate»Ø×Ô¶¯Éú³ÉÈçÏÂÓï¾ä£º
hibernate
: select seq_id.nextval from dual
hibernate
: insert into YXJK.T_YXJK_WHRYTXL (XM0000, ZW0000, LXDH00, SJHM00, DZYJ00,
IP0000, ID0000) values (?, ?, ?, ?, ?, ?, ?)
×Ô¶¯Éú³ÉÏÂÒ»¸öÐòÁÐÖµ£¬È»ºó½«¶ÔÏó²åÈë±íÖС£
ÔÚʹÓõÄʱºòÐèҪעÒ⣬Hibernate¶ÔÓÚsequenceµÄÖ÷¼üµÄÒªÇóÊÇÒ»¶¨ÒªÊÇshor,long£¬»òÕßinteger
¸ù¾ÝhibernateµÄÎĵµ£¬ÓÐÁ½ÖÖ·½Ê½ÊµÏÖʵÌå¶ÔÏóµÄÖ÷¼ü×Ô¶¯Ôö³¤¡£
µÚÒ»ÖÖ£ºÉèÖÃIDµÄÔö³¤²ßÂÔÊÇsequence£¬Í¬Ê±Ö¸¶¨sequenceµÄÃû×Ö£¬×îºÃÿ¸ö±í½¨Ò»¸ösequence£¬´ËÖÖ×ö·¨¾ÍÈçͬMS-SQL,MY-SQLÖеÄ×Ô¶¯Ôö³¤Ò»Ñù£¬²»ÐèÒª´´½¨´¥·¢Æ÷£¬¾ßÌåµÄoracleÊý¾Ý¿â½Å±¾¼°hibernateÅäÖÃÎļþÈçÏ£º
[1]or
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
¾¹ýÁ½ÌìµÄµ¹ÌÚÖÕÓÚÔÚmacÉÏ×°ºÃoracle10g ÁË¡£ÕâÏÂÍêÃÀÁË++
½Ì³ÌÍøÉÏÓкܺã¬×Ô¼ºÒ²²»¼ÇµÃ²ÎÕÕ¹ý¶àÉÙÆªÁË¡£
Ö»¼ÇÏÂ×Ô¼ºÅöµ½µÄÎÊÌâµã¡£
1,×éÎÊÌâ¡£
ÍêÈ«ÊǸöÈËʹÓã¬ËùÒÔÎÒûÓл¨ÄǸöÏй¤·òȥн¨Ò»´ó¶Ñ×éºÍÓû§£¬
Ïà·´£¬ÎÒ¾ÍÊÇÄõ±Ç°Óû§×°µÄ£¬Ö»²»¹ý£¬°Ñµ±Ç°Óû§Ò²¼ÓÈëÁËROOT×飬Õâ¸ö±È½ÏºÝ¡£
2£¬ÓеĽ ......
µÍ³É±¾»ñÈ¡OracleÏà¹ØÈÏÖ¤£¬È«Ãæ¿ìËÙÕÆÎÕOracle¼¼Êõ
ÔÚÆóҵȺÌåÖУ¬È«Çò500Ç¿£¬ÓÐ98%ÔÚʹÓÃOracle¼¼Êõ£»È«ÇòÊ®´óÒøÐоù²ÉÓÃÁËOracleÓ¦ÓÃϵͳ£¬ÔÚÖйú£¬ÅÅÃûǰ20λµÄÒøÐж¼ÔÚʹÓÃOracle¼¼Êõ£»ÔÚͨÐÅÁìÓò£¬È«Çò20¼Ò¶¥¼¶Í¨ÐŹ«Ë¾È«²¿¶¼ÔÚʹÓÃOracleÓ¦ÓòúÆ·¡£ÔÚÖйú£¬ËùÓеĵçÐÅÓªÔËÉ ......
½ñÌ칫˾ÒòΪҵÎñÐèÒª,ÐÞÒªÐÞ¸Äij¸ö×Ö¶ÎÊý¾ÝÀàÐÍÓÐnumber(5),±äΪnumber(5,2)ÐÍ
ÒªÊÇûÓÐÊý¾ÝµÄ»°Ö±½ÓÓÃÒÔÏÂÓï¾ä¼´¿É
alter table tb_test modify permile number(5,2);
µ«ÊÇÓÐÊý¾ÝµÄ»° ¾Í²»ÄÜÓÃÉÏÃæ·½·¨ÁË,
alter table tb_test add permile_temp number(5,2)
update tb_test set  ......
1 ²éѯsqlÓÅ»¯
1.1 Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò£¨Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧORACLE£©
½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí¡£ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí ......