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

ͨ¹ýJDBC£­ODBCÇÅÁ¬½ÓaccessÊý¾Ý¿â

Ò»°ãÇé¿öÏÂÎÒÃǶ¼ÊÇͨ¹ýodbcÀ´Á¬½ÓaccessÊý¾Ý¿â£¬µ«ÊÇÔÚj2eeµÄ·þÎñÆ÷ÉÏÔËË㱨±íÐèҪͨ¹ýÊý¾Ý¿âurlÀ´Á¬½ÓaccessÊý¾Ý¿â¡£

½â¾ö·½°¸£º

¿ÉÒÔͨ¹ýjdbc-odbcÇÅÀ´ÊµÏÖ¡£Á¬½Ó·½·¨ÈçÏ£º

Çý¶¯³ÌÐò: sun.jdbc.odbc.JdbcOdbcDriver

Êý¾Ý¿âurl: jdbc:odbc: Access

ÆäÖÐsun.jdbc.odbc.JdbcOdbcDriverÀàÊÇÀ´×Ôrt.jar£¬ËüÔÚ»·¾³±äÁ¿java_homeĿ¼µÄjre\libÏ¡£accessÊÇͨ¹ýodbc¹ÜÀí¹¤¾ß×¢²áµÄÊý¾ÝÔ´¡£

Òý×Ô£ºÈóǬ±¨±í֪ʶ¿â
Ô­ÎÄÁ´½Ó£ºÍ¨¹ýJDBC£­ODBCÇÅÁ¬½ÓaccessÊý¾Ý¿â


up


Ïà¹ØÎÊ´ð£º

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

¹ØÓÚaccessÊý¾Ý¿âÁ¬½Ó¾ø¶Ô·¾¶µÄÎÊÌâÇó½â

Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ


Microsoft O ......

´íÎóÐÅÏ¢Access violation....

ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

ADOÏòACCESSÊý¾Ý¿â²åÈëÊý¾ÝÎÊÌ⣬¾È¼±

m_PriceÊÇfloatÐÍ
m_MonthÊÇctimeÐÍ
ÆäËüÊÇcstringÐÍ
´íÎóÌáʾ£ºµ¯³ö´íÎó¶Ô»°¿ò£¬×××.exe£­Ó¦ÓóÌÐò´íÎ󣬡­¡­¡­¡­¡­¡­¸ÃÄÚ´æ²»ÄÜΪ"read"
¸ßÊÖ¼±¾È¡«¡«¡«¡«µ½µ×Ó¦¸ÃÈçºÎд
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ