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

accessÖÐlikeд·¨

sqlÓï¾äÊÇÕâÑùдµÃ 
string sql = "select * from shophistory where username(stringÀàÐÍ)¡¡like '%"+ name +"%' ";
½á¹ûÔËÐб¨´í£º(²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ  ˵ºó°ë¶ÎÓдíÎó like '%"+ name +"%' ";

²é¹ýÍøÉÏ×ÊÁÏ ËµÊÇÓÃ* #»ò ?¶¼ÐÐ £¬µ«ÔÚvs2005ÖÐ ÈçÓõÄÊÇOleDbDataAdapter »¹ÊÇÓðٷֺţ¿²»ÖªµÀ¸ÃÈçºÎÐ޸ģ¿ÔÚÏߵȼ±£¡£¡
ÁíÍâÔÙÎÊÒ»ÏÂaccessÖÐ Îı¾ºÍ±¸×¢ 2¸öÊÇ·ñ¶¼ÄÜÓÃlikeÄ£ºý²éѯ£¿ÈçÊÇÓï·¨ÊÇ·ñ¾ÍÊÇÓëÎÒÉÏÃæÐ´µÄÒ»Ñù£¿

*

ºý²éѯÓëbetween and
AccessÓë SqlServer  ,Oracle  ²»Í¬µÄµØ·½
Select * from ±í where  ×Ö¶Î1  like '*aa*'      aaÊÇÄãÊäÈëµÄ×Ö·û  *ÊDZØÐëÊäÈëµÄ¸ñʽ
Select * from ±í where  ×Ö¶Î2  between #3#  and  #33#      ×Ö¶Î2  ÔÚ3ºÍ33Ö®¼ä  #ÊDZØÐëÊäÈëµÄ¸ñʽ

select * from ±íÃû where ×Ö¶ÎÃû like '*abc*'


C# code:

//ʹÓòÎÊý
sql = "SELECT * from tt where aa like '%'+@t1+'%'";



ÒýÓÃ
ºý²éѯÓëbetween and
AccessÓë SqlServer  ,Oracle  ²»Í¬µÄµØ·½
Select * from ±í where  ×Ö¶Î1  like '*aa*'      aaÊÇÄãÊäÈëµÄ×Ö·û  *ÊDZØÐëÊäÈëµÄ¸ñʽ
Select * from ±í where  ×Ö¶Î2  between #3#  and  #33#


Ïà¹ØÎÊ´ð£º

php ʹÓà ADODB Á¬½ÓAccess µÄÎÊÌâ

<?php

include("adodb/adodb.inc.php");

$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......

ÔÚÒ»ÕÅaccess±íÖÐǶÌײéѯ

strSQLCmd.Format(_T("select * from (select * from talk_info where %s ='%s') where %s ='%s'"),
strVar,strValue,strVar2,strValue2);
ÇëÎÊÕâÓï¾äÓÐÎÊÌâÂð
ûÓÐÎÊÌâ¡£
......

c# ÓÃadox´´½¨accessÊý¾Ý¿â,´ò²»¿ª,Ìáʾ²»¿Éʶ±ð

CatalogClass cat=new CatalogClass();
cat.Creat(@"provider=microsoft.jet.oledb.4.0;data source="+path+";");


ÓÃÒÔÉÏ´úÂë´´½¨Îļþ³É¹¦ÁË£¬ÕÒµ½Îļþºó´ò¿ª£¬Ìáʾ²»¿Éʶ±ðµÄÊý¾ ......

access±íÖÐʱ¼ä²îµÄÉú³É

access±íÖÐÓÐ3¸ö×ֶΣ¬starttime£¬endtime£¬timespan£¬
ÊäÈëǰÁ½¸öÖµºóÔõô×Ô¶¯Éú³ÉtimespanÄØ
´´½¨²éѯ¡£

select *, endtime-starttime from your table


»òÕßÔÚÄãµÄÊäÈë´°ÌåÖÐÓÃVBA´úÂëʵÏÖ¡ ......

accessÌå»ý

Ò»¸ö³ÌÐòÍùaccessÊý¾Ý¿âÀïÃæÐ´¼Ç¼£¬Ã¿Ììд5ÍòÌõ£¬µÚ¶þÌìɾ³ýǰһÌìµÄ5ÍòÌõ
µ«ÊÇaccessÎļþµÄÌå»ý»áÂýÂýÔö¼Ó¡£¡£¡£
ÎÒ²»Ñ¹ËõÊý¾Ý¿âµÄÇé¿öÏ£¬Ê²Ã´Ê±ºòÊý¾Ý¿âµÄÌå»ý²Å²»Ôö¼ÓÄØ£¿

ÎÒɾ³ý¼Ç¼µÄʱºò£¬Êý¾Ý¿âÌå ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ