Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÒ»¸ö Ô¶³ÌÁ¬½Ó oracle ×Ö·û´®

ÎÒ×öµÄÊÇ×ÀÃæ³ÌÐòexe,Ò²¾ÍÊÇC/SµÄ£¬Ä¿Ç°ÄÜÁ¬±¾µØÊý¾Ý¿â£¬×î½üÒªÁ¬Ô¶³ÌÊý¾Ý¿â£¬²»ÖªµÀ¸Ã°ÑIPÕâ¸ö×ֶμӵ½ÄÄÀï¡£

ÎÒÒÔǰµÄÁ¬½Ó×Ö·û´®ÊÇ£º
Persist Security Info=False;User ID=Óû§Ãû;Password=ÃÜÂë;Data Source=Êý¾Ý¿âÃû

ÉÏÃæÕâ¸öÄÜÁ¬Í¨£¬µ«ÊÇÖ»ÄÜÁ¬±¾µØµÄ£¬×î½üÎÒÒªÁ¬Ô¶³ÌIPµÄij¸öÊý¾Ý¿âÁË¡£

ºóÀ´ÎÒÓÖʵÑéµÄºÃ¼¸ÖÖ£¬¶¼²»ÐУ¬ÈçÏ£º
server=Êý¾Ý¿âµÄIPµØÖ·;database=Êý¾Ý¿âÃû;uid=Óû§Ãû;pwd=ÃÜÂë

ÉÏÃæÕâ¸ö£¬³ÌÐò±¨´í£¬Ëµ²»Ö§³Ö"database"

Data Source=Êý¾Ý¿âµÄIPµØÖ·;Initial Catalog=Êý¾Ý¿âÃû;User ID=Óû§Ãû;Password=ÃÜÂë

ÉÏÃæÕâ¸ö£¬Ò²±¨´í£¬Ëµ²»Ö§³Ö"Initial Catalog"

ÉÏwww.connectstrings.comÄǸöÍø£¬¶¼ÊÇÓ¢Îĵģ¬¿´²»¶®

Ë­ÄܸæËßÎÒÁ¬½ÓÔ¶³ÌoracleµÄÁ¬½Ó×Ö·û´®ÊÇʲôѽ

ÎÒ.netÀïÓõÄÊÇOracleConnectionÀàÁ¬µÄ


Ҫʹһ̨»úÆ÷ÄÜÁ¬½ÓOracleÊý¾Ý¿â£¬ÐèÒªÔÚ»úÆ÷Éϰ²×°oracleµÄ¿Í»§¶ËÈí¼þ
Êý¾Ý¿âÒªÏëÔ¶³ÌÁ¬½ÓÊÇÒª¶ÔÊý¾Ý¿â½øÐÐÉèÖõġ£ÄãÏÈ¿´¿´ÄãÉèÁËû


µÃÓпͻ§¶ËµÄ°É
Ö±½ÓÁ¬½ÓÓ¦¸Ã²»¿ÉÒÔ°É


¸Ðл2Â¥µÄÀºÇòÑ¡ÊÖ£¬°ÑOracleConnection»»³ÉÄãÄǸöOleDbConnection¾ÍÐÐÁË£¬ÄÇЩ¸ö¹Ø¼ü×Ö¾ÍÖ§³ÖÁË¡£


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 

SQL> select name from v$database;
NAME
---------
ORCL ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ