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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Ìí¼Ó¼Ç¼µ½ds±£´æµ½xml
DataSet ds = new DataSet("myDs");
//´ÓXMLÖжÁÈ¡Êý¾Ý
ds.ReadXml(Serve ......
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 ת»»ºó ......
Ò». Àí½âʲôÊÇÊý¾Ý¿â»Ö¸´
µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊǿɿ¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨Ó²¼þ¹ÊÕÏ¡¢Èí¼þ¹ÊÕÏ¡¢ÍøÂç¹ÊÕÏ¡¢½ø³Ì¹ÊÕϺÍϵͳ¹ÊÕÏ£©Ó°ÏìÊý¾Ý¿âϵͳµÄ²Ù×÷£¬Ó°ÏìÊý¾Ý¿âÖÐÊý¾ÝµÄÕýÈ·ÐÔ£¬ÉõÖÁÆÆ»µÊý¾Ý¿â£¬Ê¹Êý¾Ý¿âÖÐÈ«²¿»ò²¿·ÖÊý¾Ý¶ªÊ§¡£Òò´Ëµ±·¢ÉúÉÏÊö¹ÊÕϺó£¬Ï£ÍûÄÜÖØ¹¹Õâ¸öÍêÕ ......