accessÖУ¬ÈçºÎ°Ñȫȫ²¿µÄ¿Õ°×ɾ³ýÄØ
ºÃÏñÃüÁî²»¶ÔŶ£¬Ëû˵ִÐÐɾ³ýµÄÊÇ0ÐÐ
½¨ÒéÉÏ´«ÄãµÄÕâ¸ö²âÊÔÓÃMDBÎļþ¡£
Ëùν¡°¿Õ°×¡±ÊÇʲô£¿ NULL £¿ »¹ÊÇ¿Õ×Ö·û´®£¿»¹ÊÇʲô£¿
delete from table1 where ×Ö¶Î =''
¿ÉÒÔÉÏ´«µ½ http://www.access911.net/csdn
¾ÍÊÇÄ¿±êÇøÓòûÓÐÈÎÎñ×Ö·û
ÉÏ´«Äã ......
Óöµ½¸úhttp://topic.csdn.net/t/20040629/18/3132308.htmlÕâ¸öÌû×ÓÒ»ÑùµÄÎÊÌâ
ÄÄλ¸ßÊÖ°ïæ½â¾öÏ£¿¡«
¶¼ÊÇÔÚ´´½¨µÚ65¸öÁ¬½ÓµÄʱºò³ö´í¡£
ÄãµÄÁ¬½Ó×Ö·û´®ÊÇʲô£¿
ACCESS±¾ÉíµÄÏÞÖÆÊÇ
²¢·¢Óû§µÄ¸öÊý 255
¸úÕâÒ»¾äÊÇÀàËÆµÄ
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data&nb ......
access½¨Á¢µÄmdbÊý¾Ý¿â£¬½¨Á¢Ò»¸öÎı¾×ֶΣ¬µ«ÊǸÃ×ֶι涨Îı¾Ö»ÔÊÐí255¸ö×Ö·û£¬ÌÈÈôÎÒÓÐ1KµÄÎı¾»òÕ߸ü´óµÄÎı¾×Ö·û£¬ÈçºÎʵÏÖдÈë½ø¸Ã×ֶβ¢±£´æÄØ£¿Ð»Ð»
text?
×Ö¶ÎÓÃÎı¾ÀàÐÍÊDz»Ðеģ¬Óñ¸×¢ÀàÐ;ÍÐÐ
ÒýÓÃ
×Ö¶ÎÓÃÎı¾ÀàÐÍÊDz»Ðеģ¬Óñ¸×¢ÀàÐ;ÍÐÐ
àÞ£¬ÄÇÇëÎʱ¸×¢ÄÚÐеĹؼü´ÊÊÇÔõô¶¨Ò壿ÎÒÓÃvb£¬ÐèÔÚ´ ......
ÓÐÒ»¸öÎı¾user.txtÈçÏÂ
baidu,123456,baidu@163.com
hao123,666666,haohao@163.com
-----------------------------------------------------
ÿ¸ö×Ö¶ÎÓöººÅ¸ô¿ª ·Ö±ð´ú±íusername£¬password£¬Email
ÎÒÏ뽫D:\user.tetÀïµÄÄÚÈݵ¼Èëµ½ C:\game.mdb ÖÐµÄ userdataÕâ¸ö±íÀ±íÖÐÒѾ½¨ ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý¾Ý¿âÈ¥²éѯ
sql="SELECT * from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=c:\test.xl ......
select * from logininfo where loginname=¡®³ÂÄþ' and password='123'
ÇëÎÊÕâÌõÓï¾äÄÄÓдí
passwordÊÇintµÄÂðÓÃ""
passwordÊÇ΢Èí±£Áô×ֶΣ¬¸ÄΪ£º
select * from logininfo where loginname=¡®³ÂÄþ' and [password]='123'
Ô¤ÆÚ½á¹ûÊÇʲô£¿Êµ¼Ê½á¹û ......