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
Ïà¹ØÎĵµ£º
ͨ³£Çé¿öÏ£¬Äã¿ÉÒÔ´Ó·þÎñÆ÷ÉÏΪtree¿Ø¼þÈ¡µÃXMLÊý¾Ý £¬ÄãÒ²¿ÉÒÔÔÚ<mx:Tree>TagÀïÖ±½Ó¶¨Òå¸ñʽÁ¼ºÃµÄXMLÊý¾Ý¡£
Äã¿ÉÒÔʹÓÃ<mx:XML>»òÕß<mx:XMLList>TagÔÚmxmlÀﶨÒåXMLÊý¾Ý¡£
Äã¿ÉÒÔ½«XML objectÖ±½Ó×÷Ϊһ¸ö²ã¼¶Êý¾Ý¿Ø¼þµÄdataProvider,however,if the object changes dynamically,ÄãÓ¦¸Ã×öÈçÏ´¦Àí£º ......
import java.io.File;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.Iterator;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;
public class ReadSetting {
......
import java.awt.Image;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import javax.imageio.ImageIO;
public class createXml
{
public static boolean writeXml(String path,String dir,String wpath,String wname)
{
File[] files = ReaderListFiles(path);
boo ......
µÚÒ»ÖÖ£º
select * from SOME_TABLE sample(1) where rownum <= 10;
µÚ¶þÖÖ£º
select * from (select * from SOME_TABLE order by dbms_random.value) where rownum<=10;
µÚÈýÖÖ£º
select * from (select * from SOME_TABLE order by sys_guid()) where rownum <= 10; ......
º¯ÊýË÷ÒýµÄ¸ÅÄ
»ùÓÚº¯ÊýµÄË÷ÒýÒ²ÊÇ8iÒÔÀ´µÄвúÎËüÓÐË÷Òý¼ÆËãÁеÄÄÜÁ¦£¬ËüÒ×ÓÚʹÓò¢ÇÒÌṩ¼ÆËãºÃµÄÖµ£¬ÔÚ²»ÐÞ¸ÄÓ¦ÓóÌÐòµÄÂß¼ÉÏÌá¸ßÁ˲éѯÐÔÄÜ¡£Ê¹ÓûùÓÚº¯ÊýµÄË÷ÒýÓм¸¸öÏȾöÌõ¼þ£º
(1)
±ØÐëÓµÓÐQUERY REWRITE£¨±¾Ä£Ê½Ï£©»òGLOBAL QUERY REWRITE£¨ÆäËûģʽÏ£©È¨ÏÞ¡£
(2)
±ØÐëʹÓûùÓڳɱ¾µÄÓÅ»¯Æ÷£¬»ùÓÚ¹æÔ ......