access²ËÄñÓöµ½Ð¡ÎÊÌâ
¸Õ½Ó´¥accessÊý¾Ý¿â ²»ÖªµÀÔõô´ò¿ª²éѯÊÓͼ ÔβËÁË ÏëÊÖдsqlÓï¾ä ÏòÊý¾Ý¿â²åÈëÒ»ÌõÓï¾ä Ñо¿Á˰ëÌìûŪ³öÀ´ ÓôÃÆ°¡ ˰ïæ½â´ðһ϶î
ºÇºÇ£¬ÓÃÏòµ¼»òÖ±½Óн¨Ò»¸ö¡£
ACCESSÖ÷²Ëµ¥£¬²åÈ룬²éѯ£¬Éè¼ÆÊÓͼ£¬È»ºóʲô±í¶¼²»Ñ¡Ö±½Ó£Ï£Ë¡£
£Á£Ã£Ã£Å£Ó£ÓÖ÷²Ëµ¥£¬ÊÓͼ£¬£Ó£Ñ£ÌÊÓͼ
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......