ÈçºÎ½«accessÊý¾Ý¿âÎļþµ¼Èësqlserver2005
ÈçºÎ½«accessÊý¾Ý¿âÎļþµ¼Èësqlserver2005
µ¼Èëµ¼³ö¼´¿É
ѧϰ ÎÒÒ²ÊÇÐÂÊÖ
Óõ¼Èëµ¼³ö ×ֶμǼ »á¶ªÊ§Âð
²»»á
ÎÒ½«accessµ¼ÈësqlserverÁË µ«²»ÖªµÀÊý¾Ý¿â·ÅÔÚÄÄ
ÓÃSQL SERVER ÖÐ×Ô´øµÄDTS (Êý¾Ýµ¼Èëµ¼³ö¹¤¾ß) °´²½Öè²Ù×÷¼´¿É,Ö÷ÒªÊÇÑ¡ÔñÒªµ¼ÈëµÄÊý¾ÝÔ´Óëµ¼³öµÄÊý¾ÝÔ´.......×ÔÒÑÊÔÊÔ.
ÊÔÊÔ2005´øµÄµ¼Èëµ¼³öÏòµ¼°É.
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
СµÜÏÖÔÚSwingÔÚÁ¬½ÓÊý¾Ý¿âÉÏÓöµ½Ò»µãÎÊÌ⣬ÇëÎÊSwingÀïÃæµÄʼþºÍSQLserverÊý¾Ý¿âµÄÁ¬½ÓÓÐʲôºÃµÄ×ÊÁÏÊéÍÆ¼öÂð£¿
Õâ¸öÓ¦µ±Ã»ÓÐÊ²Ã´ÌØ±ð,ÓëÆäËûµÄ±à³ÌÒ»Ñù.
JDBC
ÇëÎÊÔÚSwingÖмÓÔØ±³¾°Í¼Æ¬ÊÇÔõô¼ÓµÄ£¿
......
¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......