Oracle 10g ´©Ô½XP·À»ðǽ·ÃÎÊÎÊÌ⣡
ΪÁË¿ª·¢·½±ã£¬ÔÚ×Ô¼ºµÄWindows XP»úÆ÷ÉÏ×°ÉÏÁËOracle10g Êý¾Ý¿â×÷Ϊ¿ª·¢¿â£¬Êý¾Ý¿âÅäÖÃÍêºÃ£¬±¾µØ·ÃÎÊÒ²ºÜÕý³££¬µ«Í¬ÊµĻúÆ÷(´ò¿ªxp·À»ðǽ£¬²¢½«1521¶Ë¿Ú¼ÓÈëÀýÍâÖÐ)È´ÔõôҲ²»ÄÜÁ¬½Ó¡£
Ï£Íû¸÷λÄܰï°ï棬¸ø¸ö½â¾ö·½°¸£¿
°Ñ·À»ðǽ£¬É±¶¾£¬Ê²Ã´·ÀÓù ¶¼¹ØÁË
ÏÖÔÚÎÊÌâ¾ÍÊÇÒª°Ñ·À»ðǽ´ò¿ª°¡£¬¶øÇÒÒÔºóoracle»áÅäÖÃÔÚ¹«ÍøipµÄ»úÆ÷ÉÏ£¬×ܲ¿ÄÜÒ²°Ñ·À»ðǽºÍÆäËû·ÀÓù¶¼¹Ø±Õ¶î £¿
ÕâÓÐÆªÎÄÕÂÂ¥Ö÷¿´Ò»ÏÂÊÇ·ñÄܽâ¾öÕâ¸öÎÊÌâ
http://www.etiersoft.com/blog/article.asp?id=34
¿ØÖÆÃæ°å->Windows·À»ðǽ->ÀýÍâ->Ìí¼Ó¶Ë¿Ú
ΪʲôҪ°ÑORACLEµÄ¹«ÍøIP¹«¿ª
×î¶àÄã°ÑÄãµÄAPPµÄ¹«Ë¾¹«¿ª°¡¡£
windowÏÂÐèÒª¹²ÏísocketµÄ·½Ê½£¬¿ÉÒÔÔÚÍøÉÏÕÒÕÒ¿´£¬ºÜ¼òµ¥¾Í¿ÉÒԸ㶨
ÎÒÃǵijÌÐò°²×°ÔÚ
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......