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

ÐÂѧJAVA¡£¡£²»ÖªµÀÔõôÁ¬½ÓORACLE¡£¡£Ë­Äܸø¸ö´úÂë

¸ø¸öÁ¬½ÓJAVAµÄ´úÂë°É£¿Á¬½ÓÉÏÁËÊÇÓÃSELECTÓï¾äÈ¡Êý¾Ýô£¿
sqlserverµÄ£¬¸Ä³ÉoracleµÄ¾ÍÊÇÁË¡£
oracleÐèÒªclass12.jar°ü
Java code:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://172.16.90.20:1433;DatabaseName=test";
String user = "sa";
String password = "sa";
con = DriverManager.getConnection(url, user, password);
System.out.println("con ok!");

return con;


sqlÓï¾äûÓÐʲô±ä»¯£¬×îÖ÷ÒªµÄÊÇÒª°Ñ»·¾³´î½¨ºÃÁË£¡

µ¼Èëojdbc14.jar

ÒýÓÃ
sqlserverµÄ£¬¸Ä³ÉoracleµÄ¾ÍÊÇÁË¡£
oracleÐèÒªclass12.jar°ü
Java codeClass.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://172.16.90.20:1433;DatabaseName=test";
String user="sa";
String password="sa";
con= DriverManager.getConnection(url, user, password);
System.out.println("con ok!");return con;


DatabaseName=testÕâ¸öÊÇÖ¸Êý¾Ý¿âÃû³Æ£¿



»¹ÓÐЩϸ½Ú£¬±ÈÈç˵exceptionµÈʲôµÄ£¬Ã»ÓÐдÉÏ£¬Äã×Ô¼º²éÒÔÏÂapi°É

²éAPIÊÇ×î·½±ã×î׼ȷµÄ,Èç¹ûÖ»ÊÇ×öÒ»¸öÊý¾Ý¿âµÄÁ¬½Ó,¼òµ¥µÄ»°¿ÉÒÔÓÃJDBC
×Ô¼ºÐ´¸öconnect¾ÍÐÐÁË
²»Í¬µÄÊý


Ïà¹ØÎÊ´ð£º

javaÈÕÆÚ´¦Àí - Java / Java SE

µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910

È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)  
......

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

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

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

C/SÏîÄ¿¼Ü¹¹Éè¼Æ----ÇóÖú - Java / Java SE

±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬ 
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£ 
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ