¼±Çó½Ì£¬accessתoracleÊý¾Ý¿âµÄÎÊÌ⣿
aspÔ¤ÑÔ£¬accessÊý¾Ý¿â£¬Ôõôת»»³ÉoracleÊý¾Ý¿âµÄ£¬¾ßÌåÒªÔõô²Ù×÷£¬ÎÒ²»ÊÇoracle·½ÃæµÄ£¬ËùÒÔÇó½Ì¶®µÄÈË!лл£¡
½¨±í,µ¼ÈëÊý¾Ý!²»ÊÇÒ»Ñù,¾ÍÊÇÀàÐ͵Äת»»!
»¹ÓÐÎÊÌâ¾ÍÊÇaspºÍoracleÁ¬½ÓµÄÎÊÌ⣬Õâ¸öºÃÏñÓõIJ»¶à
Òì¹¹Êý¾Ýµ¼ÈëÖ»ÓÐ
SQLLDR,¸öÈ˾õµÃÄǸö¸ñʽ¹æÔòдÆðÀ´»áºÜÀÛµÄ
¶Ôoracle²»ÊǺÜÁ˽⣬ֻ֪µÀaccessתsql£¬ËüÃÇÓ¦¸ÃÓÐÏàͨµÄµØ·½¡£
MSSQLµÄDTS¿ÉÒÔ×ö°É¡£¡£¡£¡£
Ïà¹ØÎÊ´ð£º
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
set A.flag=1
where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
set A.flag=1
where ......
Ï뿼¸öocpÈÏÖ¤£¬µ±È»£¬Ò²ÏëºÃºÃѧµã¶«Î÷¡£
¿ÉÒÔ×ÔѧµÄ£¡
¸öÈ˾õµÃÖ»ÒªÕÆÎÕÁËÊý¾Ý¿âµÄ»ù±¾ÀíÂÛ£¬Âò²Î¿¼Êé×Ôѧ±È½Ïʵ¼Êµã£¬
ÌØ±ðÊÇÅàѵ̫¹ó²¢ÇÒ²»¿ÉÄÜѧµ½ºÜ¶à¶«Î÷£¡
Êý¾Ý¿âÊǸö³¤ÆÚµÄѧϰ¹ý³Ì£¬Â¥Ö÷¿ÉÒÔÂý ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......