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

Á¬½ÓOracleÊý¾Ý¿âµÄHibernateÅäÖÃÎļþ

Á¬½ÓOracleÊý¾Ý¿âµÄHibernateÅäÖÃÎļþ
Á¬½ÓOracleµÄHibernateÅäÖÃÎļþÓÐÁ½ÖÖ¸ñʽ£¬Ò»ÖÖÊÇxml¸ñʽµÄ£¬ÁíÒ»ÖÖÊÇJavaÊôÐÔÎļþ¸ñʽµÄ¡£ÏÂÃæ·Ö±ð¸ø³öÕâÁ½ÖÖ¸ñʽÅäÖÃÎļþµÄ´úÂë¡£
1£®xml¸ñʽµÄÅäÖÃÎļþ
ÏÂÃæ½«¸ø³öÁ¬½Ó±¾µØOracle·þÎñÆ÷ÉϵÄdb_database02Êý¾Ý¿âʱHibernateÅäÖÃÎļþhibernate.cfg.xmlµÄ´úÂë¡£
Àý³Ì2-5£º¹âÅÌ\mr\02\sl\05\hibernate.cfg.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!--Ö¸¶¨Á¬½ÓÊý¾Ý¿âÓõÄÇý¶¯-->
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<!--Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄ·¾¶-->
<property name="connection.url">
jdbc:oracle:thin:@localhost:1521:db_database02
</property>
<!--Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄÓû§Ãû-->
<property name="connection.username">SYSTEM</property>
<property name="connection.password">SYSTEM</property><!--Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄÃÜÂë-->
<!--Ö¸¶¨Êý¾Ý¿âʹÓõÄSQL·½ÑÔ-->
<property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
<!--µ±show_sqlÊôÐÔΪtrueʱ±íʾÔÚ³ÌÐòÔËÐÐʱÔÚ¿ØÖÆÌ¨Êä³öSQLÓï¾ä£¬Ä¬ÈÏΪfalse£¬½¨ÒéÔÚµ÷ÊÔ³ÌÐòʱÉèΪtrue£¬·¢²¼³ÌÐò֮ǰÔÙ¸ÄΪfalse,ÒòΪÊä³öSQLÓï¾ä»áÓ°Ïì³ÌÐòµÄÔËÐÐËÙ¶È-->
<property name="show_sql">true</property>
<mapping resource="UserForm.hbm.xml"/><!--Ö¸¶¨³Ö¾Ã»¯ÀàÓ³ÉäÎļþ-->
</session-factory>
</hibernate-configuration>
ÔÚÉÏÃæµÄ´úÂëÖУ¬“localhost”´ú±í±¾µØOracle·þÎñÆ÷£¬Èç¹ûÏëÁ¬½ÓÆäËû·þÎñÆ÷¿ÉÒÔÐÞ¸ÄΪҪÁ¬½ÓµÄOracle·þÎñÆ÷µÄÃû³Æ£» “db_database02”ΪҪÁ¬½ÓµÄÊý¾Ý¿âÃû³Æ£»“SYSTEM”ΪµÇ¼Óû§Ãû£»“SYSTEM”±íʾÓû§ÃÜÂ룻 “UserForm.hbm.xml”Ϊ³Ö¾Ã»¯Àà¶ÔÓ¦µÄÓ³ÉäÎļþÃû³Æ¡£
2£®JavaÊôÐÔÎļþ¸ñʽµÄÅäÖÃÎļþ
ÏÂÃæ½«¸ø³öÁ¬½Ó±¾µØOracle·þÎñÆ÷ÉϵÄdb_database02Êý¾Ý¿âʱHibernateÅäÖÃÎļþhibernate.propertiesµÄ´


Ïà¹ØÎĵµ£º

oracle ¼Ç¼³¬¹ý1000Ìõ£¬Ê¹ÓÃin·½·¨

  ÔÚoracleÖУ¬ÎÒÃÇʹÓÃin·½·¨²éѯ¼Ç¼µÄʱºò£¬Èç¹ûinºóÃæµÄ²ÎÊý¸öÊý³¬¹ý1000¸ö£¬ÄÇô»á·¢Éú´íÎó£¬ÏÂÃæµÄÕâ¸ö·½·¨¾ÍÊǽâ¾öÕâ¸öÎÊÌâµÄ£¬Ëü½«ÎÒÃǵÄÉÏǧ¸ö²ÎÊý·Ö³É¼¸×飬±£Ö¤Ã¿×éµÄ²ÎÊý¸öÊý²»³¬¹ý1000
/**
  * Éú³É·ûºÏÌõ¼þµÄsqlÓï¾ä,½â¾öinÎÊÌâ
  * @param sqlParam£ºÎÒÃÇÐèÒª´¦ÀíµÄ²ÎÊýµÄ×Ö·û´®¸ñʽ£¬ÀýÈ ......

Oracleɾ³ý´ó±í²¢»ØÊÕ¿Õ¼äµÄ¹ý³Ì

½üÈÕÔÚ²éѯijÏîÈÕÖ¾µÄʱºò£¬·¢ÏÖ²éѯ·Ç³£»ºÂý£¬¸ù¾ÝÒÔÍùµÄ¾­ÑéÕâÊÇÓÉÓÚij¸öÈÕÖ¾±í¹ý´óÒýÆðµÄ£¬ÎªÁ˼ӿì²éѯ£¬¾ö¶¨½«´ó²¿·ÖµÄÀúÊ·Êý¾ÝÇ¨ÒÆµ½ÁíÍâÒ»¸ö±íÖУ¬±¾ÎÄÖ÷Òª¼Ç¼ɾ³ýÕâ¸ö´ó±íµÄ¹ý³Ì£¬¾Í½â¾öÎÊÌâ¶øÑÔ»¹Óкܶ෽·¨£¬µ«ÊDZ¾ÎIJàÖØµãÔÚÓÚÈçºÎ´¦Àí´óÊý¾ÝÁ¿É¾³ýµÄ²Ù×÷£¬¼°ÆäÉÆºó¹¤×÷¡£
Ê×ÏÈ¿´¿´ÎÒÃÇÒª×öÊý¾ÝÇ¨ÒÆµÄ±íËùÕ¼µÄ ......

²»Óð²×°Oracle ClientÈçºÎʹÓÃPLSQL Developer

²»Óð²×°Oracle ClientÈçºÎʹÓÃPLSQL Developer
1. ÏÂÔØoracleµÄ¿Í»§¶Ë³ÌÐò°ü£¨30M£©
      Ö»ÐèÒªÔÚOracleÏÂÔØÒ»¸ö½ÐInstant Client PackageµÄÈí¼þ¾Í¿ÉÒÔÁË£¬Õâ¸öÈí¼þ²»ÐèÒª°²×°£¬Ö»Òª½âѹ¾Í¿ÉÒÔÓÃÁË£¬ºÜ·½±ã£¬¾ÍËã֨װÁËϵͳ»¹ÊÇ¿ÉÒÔÓõġ£
      ÏÂÔØµ ......

oracleÖÐtruncate,delete,dropµÄÒìͬµã

truncate,delete,dropµÄÒìͬµã
×¢Òâ:ÕâÀï˵µÄdeleteÊÇÖ¸²»´øwhere×Ó¾äµÄdeleteÓï¾ä
Ïàͬµã:truncateºÍ²»´øwhere×Ó¾äµÄdelete, ÒÔ¼°drop¶¼»áɾ³ý±íÄÚµÄÊý¾Ý
²»Í¬µã:
1. truncateºÍ deleteֻɾ³ýÊý¾Ý²»É¾³ý±íµÄ½á¹¹(¶¨Òå)
dropÓï¾ä½«É¾³ý±íµÄ½á¹¹±»ÒÀÀµµÄÔ¼Êø(constrain),´¥·¢Æ÷(trigger),Ë÷Òý(index); ÒÀÀµÓÚ¸Ã±íµ ......

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
    Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ