hibernate.cfg.xml¹ØÁªOracleÊý¾Ý¿âµÄÅäÖÃ
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE hibernate-configuration (View Source for full doctype...)>
- <!-- Generated by MyEclipse Hibernate Tools.
--> - <!-- ÒÔÉϼ¸ÐÐËùÓеÄhibernate.cfg.xml¶¼Ïàͬ
--> [url=file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/hibernate.cfg.xml#]-[/url] <hibernate-configuration>
[url=file:///C:/Documents%20and%20Settings/Administrator/×ÀÃæ/hibernate.cfg.xml#]-[/url] <session-factory>
- <!-- Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄURLÒÔ¼°ÒªÁ¬½ÓµÄÊý¾Ý¿â
--> <property name="connection.url">jdbc:oracle:thin:@127.0.0.1:1521:sryx</property>
- <!-- Á¬½ÓÊý¾Ý¿âµÄÓû§Ãû
--> <property name="connection.username">yf</property>
- <!-- Á¬½ÓÊý¾Ý¿âµÄÃÜÂë
--> <property name="connection.password">yf</property>
- <!-- Ö¸¶¨Á¬½ÓÊý¾Ý¿âµÄÇý¶¯
--> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
- <!-- Ö¸¶¨Á¬½ÓµÄÊý¾Ý¿âÀàÐÍ
--> <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property>
- <!-- JDBC´ÓÊý¾Ý¿âÿ´Î¶ÁÈ¡µÄ¼Ç¼Êý 100»¹½«ÓÅ»¯
--> <property name="jdbc.fetch_size">50</property>
- <!-- JDBCÖ´ÐÐÅúÁ¿É¾³ý£¬¸üУ¬²åÈëʱÿ´Î²Ù×÷µÄ¼Ç¼Êý 30µ½50°É
--> <property name="jdbc.batch_size">50</property>
- <!-- connectionÊÇ·ñ¹ö¶¯½á¹û¼¯
--> <property name="jdbc.use_scrollable_resultset">true</property>
- <!-- ÔÚÉú³ÉµÄSQLÓï¾äÖвúÉú×¢ÊÍ
--> <property name="use_sql_comments">true</property>
- <!-- Á¬½ÓSQLSERVER2000ÓÃ
<session-factory name="java:/hibernate/HibernateFactory"> <property name="show_sql">true</property> <property name="connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property> <property name="connection.url">jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=hibernate_test</property> <property name="c
Ïà¹ØÎĵµ£º
ORACLE SQLÐÔÄÜÓÅ»¯
ÎÒÒª½²µÄÌâÄ¿ÊÇOracle SQLÐÔÄÜÓÅ»¯£¬Ö»ÊÇOracleÐÔÄÜÓÅ»¯ÖеÄÒ»Ïî¡£OracleµÄÐÔÄÜÓÅ»¯°üº¬ºÜ¶à·½Ã棬±ÈÈçµ÷ÕûÎïÀí´æÈ¡£¬µ÷ÕûÂß¼´æÈ¡£¬µ÷ÕûÄÚ´æÊ¹Ó㬼õÉÙÍøÂçÁ÷Á¿µÈ¡£ÕâÀïÑ¡ÔñSQLÐÔÄÜÓÅ»¯ÊÇÒòΪÕⲿ·ÖÄÚÈÝÎÒÃDzâÊÔÈËÔ±×îÈÝÒ×½Ó´¥µ½£¬ÁíÍ⿪·¢ÈËԱдSQL½Å±¾Ê±ÓÐʱºÜËæÒ⣬²»Öª²»¾õ¾Í»áÔì³É³ÌÐòÐÔÄÜÉϵÄÏ ......
1.»ñÈ¡µÇ½Óû§µÄÖ÷»úÃû
select sys_context('userenv','host') from dual;
2.»ñÈ¡µÇ½Óû§µÄIPµØÖ·
select sys_context('userenv','ip_address') from dual; ......
OracleµÄµ¼ÈëʵÓóÌÐò(Import utility)ÔÊÐí´ÓÊý¾Ý¿âÌáÈ¡Êý¾Ý£¬²¢ÇÒ½«Êý¾ÝдÈë²Ù×÷ϵͳÎļþ¡£impʹÓõĻù±¾¸ñʽ£ºimp[username[/password[@service]]]£¬ÒÔÏÂÀý¾Ùimp³£ÓÃÓ÷¨¡£
1. »ñÈ¡°ïÖú
imp help=y
2. µ¼ÈëÒ»¸öÍêÕûÊý¾Ý¿â
imp system/manager file=bible_db log=dible_db full=y ignore=y
3. µ¼ÈëÒ»¸ö»òÒ»×éÖ¸¶¨ ......
Oracle»¥»»×ܽá
1. ¶àÐл»³ÉÒ»ÐÐ
col1 col2 col1 col2
a 1
a 2 ת»»ºó ......
×ܵÄÀ´ËµwindowsÏÂÔØ°²×°oracleÈí¼þ±ÈlinuxÏÂÒª¼òµ¥µÄ¶à¡£
Ò».°²×°oracle ·þÎñ¶Ë
1.oracle·þÎñÆ÷µÄÏÂÔØÍøÖ·ÈçÏ£º
http://www.oracle.com/technology/software/products/database/index.html
È»ºóÎÒÑ¡ÔñÁËÏÂÃæÕâ¸ö°²×°°ü£º
Oracle Database 10g Release 2 ( ......