ÇóÒ»¸ö Ô¶³ÌÁ¬½Ó 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·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É
SQL> select name from v$database;
NAME
---------
ORCL
......
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Êý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......