¼±Çó½Ì£¬accessתoracleÊý¾Ý¿âµÄÎÊÌ⣿
aspÔ¤ÑÔ£¬accessÊý¾Ý¿â£¬Ôõôת»»³ÉoracleÊý¾Ý¿âµÄ£¬¾ßÌåÒªÔõô²Ù×÷£¬ÎÒ²»ÊÇoracle·½ÃæµÄ£¬ËùÒÔÇó½Ì¶®µÄÈË!лл£¡
½¨±í,µ¼ÈëÊý¾Ý!²»ÊÇÒ»Ñù,¾ÍÊÇÀàÐ͵Äת»»!
»¹ÓÐÎÊÌâ¾ÍÊÇaspºÍoracleÁ¬½ÓµÄÎÊÌ⣬Õâ¸öºÃÏñÓõIJ»¶à
Òì¹¹Êý¾Ýµ¼ÈëÖ»ÓÐ
SQLLDR,¸öÈ˾õµÃÄǸö¸ñʽ¹æÔòдÆðÀ´»áºÜÀÛµÄ
¶Ôoracle²»ÊǺÜÁ˽⣬ֻ֪µÀaccessתsql£¬ËüÃÇÓ¦¸ÃÓÐÏàͨµÄµØ·½¡£
MSSQLµÄDTS¿ÉÒÔ×ö°É¡£¡£¡£¡£
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
Ï뿼¸öocpÈÏÖ¤£¬µ±È»£¬Ò²ÏëºÃºÃѧµã¶«Î÷¡£
¿ÉÒÔ×ÔѧµÄ£¡
¸öÈ˾õµÃÖ»ÒªÕÆÎÕÁËÊý¾Ý¿âµÄ»ù±¾ÀíÂÛ£¬Âò²Î¿¼Êé×Ôѧ±È½Ïʵ¼Êµã£¬
ÌØ±ðÊÇÅàѵ̫¹ó²¢ÇÒ²»¿ÉÄÜѧµ½ºÜ¶à¶«Î÷£¡
Êý¾Ý¿âÊǸö³¤ÆÚµÄѧϰ¹ý³Ì£¬Â¥Ö÷¿ÉÒÔÂý ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......