ÐÂѧ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
DatabaseName=testÕâ¸öÊÇÖ¸Êý¾Ý¿âÃû³Æ£¿
»¹ÓÐЩϸ½Ú£¬±ÈÈç˵exceptionµÈʲôµÄ£¬Ã»ÓÐдÉÏ£¬Äã×Ô¼º²éÒÔÏÂapi°É
²éAPIÊÇ×î·½±ã×î׼ȷµÄ,Èç¹ûÖ»ÊÇ×öÒ»¸öÊý¾Ý¿âµÄÁ¬½Ó,¼òµ¥µÄ»°¿ÉÒÔÓÃJDBC
×Ô¼ºÐ´¸öconnect¾ÍÐÐÁË
²»Í¬µÄÊý
Ïà¹ØÎÊ´ð£º
µ±ÖªµÀÒ»¸öÈÕÆÚ£¬ÈçºÎ°ÑÕâ¸öÈÕÆÚËùÔÚÑ®µÄǰºóÁ½¸öÈÕÆÚÈ¡³ö
±ÈÈçÊäÈë20090905£¬¾ÍÊäÈë20090901 20090910
Êä³ö20090901 20090910
È¡µÃÌìÊýºó×÷Ò»ÏÂÅжÏÔÙ°ÑÕâ¸ö·½·¨ÓÃÏÂvoid set(int field, int value)
......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
±¾ÈËÕýÔÚÓÃJava×öÒ»¸öC/S¼Ü¹¹µÄÏîÄ¿£¬
¿ÉÊÇÓÉÓÚÏîÄ¿±È½Ï´ó£¬Ç°ÆÚ¶Ô¼Ü¹¹µÄÉè¼ÆÓÈÆäÖØÒª£¬ÒòΪºóÆÚ¿ÉÄÜËæÊ±»á¼Ó¸ö¹¦ÄÜ»òÕßÈ¥µôijЩ¹¦ÄÜ¡£
ËùÒÔÌØµØÑ°ÇóÈçºÎÉè¼ÆC/SµÄ¼Ü¹¹Ê¹³ÌÐò¸ü¼ÓÃæÏò¶ÔÏó¸ü¼ÓÒ×ÓÚά ......