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


1¡¢ 
Á¬½ÓÊý¾Ý¿â
connect uuu/ooo
connect 
sys/ok as sysdba
2¡¢ 
´´½¨±í¿Õ¼ä
create tablespace stu(±í¿Õ¼äÃû
) datafile 

e:\stu.dbf

 size 100m autoextend on next 5m maxsize 500m;
3¡¢& ......

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

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

Oracle ±íɾ³ý´óÁ¿Êý¾Ýºó²éѯ±äÂýÎÊÌâ


Oracle ±íɾ³ý´óÁ¿Êý¾Ýºó£¬¼´Ê¹±íÖÐÖ»Óм¸ÐмǼ£¬µ«ÓÃselect count(*) from table À´²éѯ·¢¾õ¶¼²»»áÂíÉϳöÀ´£¬Ô­ÒòÊǸñíµÄ¿Õ¼ä´óÁË£¬²éѯÆðÀ´ºÜÂý¡£½â¾öµÄ·½·¨ÊǰѸñíËùÕ¼Óõıí¿Õ¼äËõС£¬»òÕß˵Êͷűí¿Õ¼ä¡£
alter table XXXX move; ÕâÑù´¦Àíºó¾ÍÊÍ·ÅÁ˱í¿Õ¼äÁË¡£µ«ÊÇÊͷűí¿Õ¼äºó£¬±íµÄÐкÅrowid»á·¢Éú±ä»¯£¬¶ø»ùÓÚ ......

oracle²»Óð²×°¿Í»§¶ËÒ²¿ÉÒÔÓÃplsqlÔ¶³ÌÁ¬½Ó

oracle²»Óð²×°¿Í»§¶ËÒ²¿ÉÒÔÓÃplsqlÔ¶³ÌÁ¬½Ó(ת£©
oracle²»Óð²×°¿Í»§¶ËÒ²¿ÉÒÔÓÃplsqlÔ¶³ÌÁ¬½Ó pl sqlÔ¶³ÌÁ¬½Ó
2008-01-14 14:33
oracle²»Óð²×°¿Í»§¶ËÒ²¿ÉÒÔÓÃplsqlÔ¶³ÌÁ¬½Ó
          ÿ´ÎÎÊÈ˼ң¬plsql ¿É²»¿ÉÒÔÖ±½ÓÔ¶³ÌÁ¬½Ó·þÎñÆ÷£¬ËûÃǶ¼ËµÒª°²×°¿Í»§¶Ë£¬¼ÇµÃÒÔÇ°Ó ......

oracle, stored procedure, cursor

CREATE OR REPLACE PROCEDURE kevin_proc(x varchar) IS
a VARCHAR(20);
b VARCHAR(20);
CURSOR mycur(rn NUMBER) IS SELECT * from t_kevin_test WHERE ROWNUM<rn;
BEGIN
OPEN mycur(10);
LOOP FETCH mycur INTO a,b;
EXIT WHEN mycur%NOTFOUND;
Dbms_Output.put_line('a: '||a);
Dbms_Output.put_line('b: '| ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ