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

£¨¼±£©ÅжÏAccessÊý¾Ý¿âÖÐÊÇ·ñ¼ÇÂ¼ÖØ¸´

ÎÒÏÖÔÚÏëʵÏÖÒ»ÏÂÕâÑùµÄ¹¦ÄÜ£º
ÔÚÎÒ±£´æ¼Ç¼֮ǰ£¬Ïȼì²éÒ»ÏÂÊý¾Ý¿âÖÐÊÇ·ñÒѾ­´æÔÚͬÑùµÄ¼Ç¼£¬SQLÓïÑÔÓ¦¸ÃÔõôÑùд£¿£¨ADOQuery£©Á¬½ÓÊý¾Ý¿â¡£
ʹÓÃgroup by ij¼¸¸ö×Ö¶Î having count(*)>1 ¼´¿É


ÒýÓÃ
ʹÓÃgroup by ij¼¸¸ö×Ö¶Î having count(*)>1 ¼´¿É

count(*)>1µÄ»°,±íÖÐÒѾ­ÓÐÖØ¸´µÄ¼Ç¼ÁË


Ò»°ãµÄ±íÖж¼»áÓÐÒ»¸öÖ÷¼ü£¬±£Ö¤Êý¾ÝµÄÍêÕûÐÔºÍΨһÐÔ

ÒýÓÃ

Ò»°ã,Êý¾Ý±íÖж¼ÓÐÒ»¸ö×Ö¶Î×÷Ϊ¹Ø¼ü×Ö,Äã¿ÉÒÔÒÔÕâ¸ö¹Ø¼ü×ÖÀ´ÅÐÊÇ·ñÖØ¸´(Èç¸öÈËÐÅÏ¢ÖеÄÉí·ÝÖ¤ºÅ),µ±È»Èç¹ûÄãµÄ±íÖÐ×ֶβ»ÊǺܶàµÄ»°,¿ÉÒÔÕâÑùÅÐ:
ADOQuery1.SQL.Text='select * from ±í where ×Ö¶Î1=ÄãÒª¼ÓÈëµÄ×Ö¶Î1 and ×Ö¶Î2=ÄãÒª¼ÓÈëµÄ×Ö¶Î2 and ..."
ADOQuery1.Open;
if not ADOQuery1.Eof then
¡­¡­


Ö»ÄÜ˵Ã÷ÄãûÓÐÀí½âÂ¥Ö÷µÄÒâ˼¡£


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

ÈçºÎ½«accessÀïÃæµÄ¸½¼þ±£´æµ½´ÅÅÌÉÏÄØ

Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit

ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......

dwr Illegal access to default constructor´íÎó

dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
  <param name="formBean" value="prisonerForm"/>
  < ......

linux²»ÄÜ·ÃÎÊaccess - Java / Java EE

rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬Ë­ÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿

AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿

Java code:

static String DBDRIVER = "sun.jd ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ