Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄ´


Ïà¹ØÎĵµ£º

solarisÏÂoracle×ÔÆô¶¯

SolarisÉÏOracle×Ô¶¯Æô¶¯ÉèÖÃ
===========================================================
×÷Õß: tianying(http://tianying.itpub.net)
·¢±íÓÚ: 2005.04.03 21:51
·ÖÀà: ³õʼ·ÖÀà
³ö´¦: http://tianying.itpub.net/post/2852/24823
---------------------------------------------------------------
¸ÕÔ ......

ÒÆÖ²SQL serverÊý¾Ý¿â¶ÔÏóµ½OracleµÄ²Ù×÷˵Ã÷

ÒÔÏÂÊÇÕª×ÔOracle¹ÙÍø:
¢ñ Oracle SQL Developer ÊÇÒ»¸öÃâ·ÑµÄͼÐλ¯Êý¾Ý¿â¿ª·¢¹¤¾ß¡£Ê¹Óà SQL Developer£¬Äú¿ÉÒÔä¯ÀÀÊý¾Ý¿â¶ÔÏó¡¢ÔËÐÐ SQL Óï¾äºÍ SQL ½Å±¾£¬²¢ÇÒ»¹¿ÉÒԱ༭ºÍµ÷ÊÔ PL/SQL Óï¾ä¡£Äú»¹¿ÉÒÔÔËÐÐËùÌṩµÄÈκÎÊýÁ¿µÄ±¨±í£¬ÒÔ¼°´´½¨ºÍ±£´æÄú×Ô¼ºµÄ±¨±í¡£SQL Developer ¿ÉÒÔÌá¸ß¹¤×÷ЧÂʲ¢¼ò»¯Êý¾Ý¿â¿ª·¢ÈÎÎñ¡£ ......

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

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

oracle µ¼Èë/³öÃüÁî

µ¼Èë IMP
Oracle µÄµ¼ÈëʵÓóÌÐò (Import utility) ÔÊÐí´ÓÊý¾Ý¿âÌáÈ¡Êý¾Ý£¬²¢ÇÒ½«Êý¾ÝдÈë²Ù×÷ϵͳÎļþ¡£ imp ʹÓõĻù±¾¸ñʽ£º imp[username[/password[@service]]] £¬ÒÔÏÂÀý¾Ù imp ³£ÓÃÓ÷¨¡£
 
1. »ñÈ¡°ïÖú
  imp help=y
2. µ¼ÈëÒ»¸öÍêÕûÊý¾Ý¿â
  imp system/manager file=bible_db log=dibl ......

OracleµÄÈÕÆÚº¯Êý

 
OracleµÄÈÕÆÚº¯Êý
 
 ³£ÓÃÈÕÆÚÐͺ¯Êý 
1¡£Sysdate µ±Ç°ÈÕÆÚºÍʱ¼ä
SQL> Select sysdate from dual;
SYSDATE
----------
21-6Ô -05
2¡£Last_day ±¾ÔÂ×îºóÒ»Ìì 
SQL> Select last_day(sysdate) from dual;
LAST_DAY(S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ