ÈçºÎ¶ÁÈ¡ÕâÖÖÊý¾Ý£¬ÔÚaccessÀïÃæ¡£Çó½Ì¸ßÊÖ
ÎÒµÄÒ»¸öaccessÊý¾Ý¿âÖеÄphoto×Ö¶ÎÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
|/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg||||/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg||||/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg||||/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg
˵Ã÷һϸñʽ£º|Сͼ|´óͼ||||Сͼ|´óͼ
ÒòΪÕâ¸öÒ»¸öÉÌÆ·ÀïÃæÓжàÕÅͼƬ¡£
ÎÒÕâÀïÇëÎÊ£¬Èç¹ûÎÒÒªÒ»Ò»°ÑËû¶ÁÈ¡³öÀ´£¬ÇëÎÊsql²éѯÓï¾äÔõôд£¿£¿£¿
ÎÒÒª°ÑÿÕŵĴóͼСͼ¶¼Òª¶ÁÈ¡³öÀ´¡£¡£¡£¡£
Çó¸ßÊÖ½â´ð~~£¡£¬Ð»Ð»~£¡
Ö±½ÓÓÃSQL·Ö½âÓеãÂé·³£¬¿ÉÒÔÏȲéѯ³öÀ´ÔÙÓóÌÐòsplit·Ö½â
¡£¡£¡£¡££¬ÎÒ¿´µ½Â¥Ö÷Ìû×ÓµÚÒ»·´Ó¦¾¹È»ÊÇÓÃÕýÔò¡£¡£¡£¡£
Éá±¾ÖðÄ©ÁË£¬º¹ÑÕ¡£
ÔõôÕâÑù´æÈëÊý¾Ý¿âÄØ¡£º¹¡£ÓÃÁ½¸ö×ֶξÍÐÐÁË¡£º¹¡£ÎÞÓï
Ïà¹ØÎÊ´ð£º
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖظ´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖظ´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
Òª×éºÏ4ÕűíµÄ²éѯ£¬·Ö±ðÊÇA±í£¬B±í£¬C±í£¬D±í£»
A±í
Game_id Game_Name
1 abc
B±í
Category_ID Category_Name Game_id
& ......
ÈçºÎ½«oracle±íת»»³ÉAccess±í»òÎı¾Îļþ
´ó¸ç¼±°¡¡£¡£
¿´ÄãÓÃʲô¹¤¾ß¡£ÓÃtoadÖ®ÀàµÄµ¼³ö¿ÉÒÔÑ¡Ôñµ¼³ö¸ñʽ¡£
ÓÃsqlplus¿ÉÒÔspool
·½·¨ºÜ¶à.
¿ÉÒÔÓÃpl/sql developer°Ñ±í±£´æΪexcel,ÔÙ°Ñexcelµ¼Èëµ½ac ......