Oracle¿Í»§¶ËµÄÐ¶ÔØ
1.Á÷³ÌÈçÏÂ
Óû§¿ÉÒÔʹÓÃOracle°²×°³ÌÐò´ÓWindows NT¿òÖÐɾ³ýËùÐèÒªµÄ²úÆ·£¬µ«ÊÇÕâ¿ÉÄÜÓеã·Ñ¾¢¡£
Èô²»Ïë±£ÁôÈκÎN TµÄOracle²úÆ·£¬¿ÉÒÔ°´ÒÔÏÂÖ¸Áîɾ³ýËùÓеÄOracle²úÆ·£º
1) Ê×ÏÈ£¬ÓÿØÖÆÃæ°åÉ쵀 Services Ó¦ÓóÌÐòÍ£Ö¹ËùÓеÄOracle·þÎñ¡£
ËùÓеÄOracle·þÎñ¶¼Ó¦ÓÐÒ»¸ö°üº¬“O R C L”¡¢“Oracle”»ò“T N S”µÄÃû×Ö¡£Ã¿´Î·´ÏÔÒ»¸ö£¬µ¥»÷S t o p°´Å¥¡£
2) ½ÓÏÂÀ´£¬ÔËÐÐregedit¡¢Windows 2000 Registry Editor²¢Ñ¡ÔñHKEY_LOCAL_MACHINE→SOFTWARE→Oracle¡£Ê¹ÓÃD E L¼üɾ³ý¸ÃÏî¡£
3) ÏÖÔÚ£¬Ñ¡ÔñKEY_LOCAL_MACHINE→SYSTEM →CurrentControlSet→Services ¡£ÏòϹö¶¯¸ÃÁÐ±í£¬²¢É¾³ýËùÓеÄOracleÏî¡£
4) ´Ó×ÀÃæÉÏɾ³ýOracle³ÌÐò×飬´ÓS t a r t u p×éÖÐɾ³ýOracle To o l b a rͼ±ê¡£
5) ɾ³ýÓëOracleÏà¹ØµÄËùÓÐÎļþ¡£Ê¹ÓÃNT Explorer£¬Ñ¡ÔñOracleËùÓеÄȱʡh o m eĿ¼£¬C£º\Oracle£¬É¾³ýÕû¸öĿ¼¼°ÆäËùÓеÄ×ÓĿ¼¡£ÁíÍ⣬ÔÙ´ÓWindows NTµÄhomeĿ¼(ͨ³£ÎªC£º\ winnt )ÖÐɾ³ýÏÂÁÐÎļþ£º
ORACLE.INI ,ORADIM.INI OTOOLBAR.INI*,OTEMP.INI VS20.INI*
6) ÈôÓû§ÓÐOracle µÄ1 6λWindows 3.1 Ó¦ÓóÌÐò(ͨ³£ÔÚC£º\OrawinÎļþ¼ÐÖÐ)£¬Ò²¿ÉÒÔɾ³ý´ËÎļþ¼Ð¡£
7) ×îºó£¬ÈôÓû§ÔÚw i n . i n iÎļþÖÐÓÐ( Oracle )±ê¼Ç¶Î£¬Ôòɾ³ý¸Ã¶Î¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
µÚÒ»¸öÀࣺ
/**
*
* ´æ·ÅoracleÊý¾Ý¿âµÄÁ´½ÓÐÅÏ¢¡£
*
* @author ZhongHuiQiang
*
*/
public interface IOracleDAOInfor {
String DB_SERVER_HOSET = "localhost";
String DB_SERVER_NAME = "ppoo";
String DB_USER_NAME = "system";
String DB ......
²éѯʱ¿ÉÒÔÖ¸¶¨Ê¹ÓÃË÷ÒýµÄд·¨¡£
SELECT /*+ index(TB_ALIAS IX_G_COST3) */
TB_ALIAS.*
from g_Cost TB_ALIAS
WHERE Item_Two = 0
AND Flight_Date >= To_Date('20061201', 'YYYYMMDD')
AND Flight_D ......