VC ADO ACCESS sql ²éѯ - VC/MFC / Êý¾Ý¿â
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éѯÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ÆËã»úרҵËùÓеÄÄÐͬѧ
²»Ê¹ÓÃ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú' AND ÐÔ±ð='ÄÐ'
Ö±½ÓÔÚÉϴβéѯµÄ»ù´¡ÉÏÔÙ²éÑ°£¬¸ÃÔõôŪÄØ£¿
лл¸÷λÀÏ´óÁË£¡
ÎÒÏÖÔÚ×öµÄ³ÌÐòÓÐÎåÁù¸ö²éѯѡÏÊÂÇ°²¢²»ÖªµÀÄÇÒ»ÏîÑ¡ÔñÄÇÒ»ÏѡÔñ£¬ÒªÅÅÁÐ×éºÏд²éѯÓï¾äµÄ»°Ì«¶àÁË£¬ÎÒÏë·Ö¿ª²éѯ£¬¾ÍÊÇÔÚÉϴβéѯµÄ»ù´¡Ö®ÉϽøÐÐÖð²½²éѯ£¡
´ó¼Ò°ï°ïæÁË£¡£¡£¡£¡£¡£¡£¡£¡£¡
ÕâÖÖÏë·¨ÊÇ´íÎóµÄ¡£
ÕýÈ·µÄ×ö·¨£º
±ÈÈçÄãÓÐÁ½¸öÌõ¼þ£ºÒ»¸öרҵ£¬Ò»¸öÐÔ±ð£¬
дÓï¾äµÄʱºò£º
CString sql = "SELECT * from XS WHERE 1=1 ";
if(Ñ¡ÁËרҵÌõ¼þ)
{
sql = sql + "AND רҵ = '¼ÆËã»ú'";
}
if(Ñ¡ÁËÐÔ±ð)
{
sql = sql + "AND ÐÔ±ð = 'ÄÐ'"
}
con.execute(sql);
ºÃÏñÓиöʲôFilterÖ®ÀàµÄ¶«Î÷......
ÓÐÒ»ÖÖÏë·¨²»ÖªµÀ¿É²»¿ÉÐС£Äã¿ÉÒÔ½«ÉϴβéѯµÄÊý¾Ý±£´æÆðÀ´¡£
±£´æ£ºCSTring szTest = ¡°SELECT * from XS WHERE רҵÃû='¼ÆËã»ú' ¡±£»
µÚ¶þ´Î²éѯµÄʱºò½«±£´æµÄÊý¾Ý×Ô¼ºÌîÉÏ¡£¾ÍÐÐÁË¡£
CSTring szTest2 = ¡°AND ÐÔ±ð='ÄÐ'¡± £»
ÄÇôSELECT * from XS WHERE רҵÃû='¼ÆËã»ú' AND ÐÔ±ð='ÄÐ' ¾ÍµÈÓÚ
szTest + szTest2 ÐÔ±ð='ÄÐ' ÕâÑù¾ÍÐÐÁË¡£
¿´ÄãÔõôÉè¼ÆÁË¡£Ïë·¨¶øÒÑ~~±ðÅÄÎÒש~
ÊÇsqlÓïÑÔµ
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖظ´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖظ´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÎÊÌ⣱
ÎÒÓÃADOÁ¬½ÓÉèÁËÓû§ÃûÃÜÂëµÄÊý¾Ý¿â
µ«ÊÇÎÒ·¢ÏÖÎÒ²»ÊäÈë Óû§ÃûºÍÃÜÂë ¶¼¿ÉÒÔÁ¬½Ó³É¹¦ ¶øÇÒ»¹ÄÜ°ÑÊý¾Ý¶Á³öÀ´
¼ôÁËÒ»¸öÃûΪtestÊý¾Ý¿â ½¨ÁËÒ»¸öÃûΪpeopleµÄ±í
¼ûÁËÒ»¸ö Óû§Ãû1234 ÃÜÂë1234 µÄ ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊÇ°ÑEXCELµ±³ÉÊý ......