Access²éѯЧÂÊÎÊÌâ
ĿǰÎÒÓÐÒ»¸ö´ó¸Å16ÍòÊý¾ÝµÄaccess±í£¬ÀïÃæµÄÊý¾ÝÊÇÊ÷ÐνṹµÄ£»
ÿ´ÎÒª²éѯ¶¼ÊDzéѯij¸ö½ÚµãÏÂÃæËùÓеĽڵ㣨¾ÍÊÇÕâ¸ö½ÚµãÏÂËùÓеÄ×ӽڵ㣩£»
µ±³õ²»µ½5ÍòµÂÊý¾Ý»¹ÊǺܿìµÄ£»¿ÉÊÇÏÖÔÚÊý¾ÝÔö¼ÓÁË£¬²éѯÆðÀ´¾Í±È½ÏÂýÁË£¬ÓÐûÓÐÒ»¸öºÃµÄ°ì·¨À´½â¾ö²éѯЧÂÊÎÊÌ⣿
ÁíÍâÎҵijÌÐòʱwinform£¬¶Ôi/oµÄÊéдÊDz»ÊǺÜÏûºÄʱ¼äºÍÄÚ´æÄØ£¿
¶ÔÊý¾Ý¿âµÄ²Ù×÷×îºÃ¾¡Á¿¼õÉÙ¶ÔÊý¾Ý¿â´ò¿ª¼°¹Ø±ÕµÄ²Ù×÷£¬ÕâÑù»áºÜÀË·Ñʱ¼ä£¬¿ÉÒÔ²ÉÓÃÓÿռä(ÄÚ´æ)È¥»»Ê±¼ä¡£
˼·£º
°ÑËùÐèÒªµÄÊý¾ÝÒ»´ÎÐÔ²éѯ³öÀ´±£´æµ½Êý¾Ý¼¯(»òÆäËû)ÖУ¬ÒªÏÔʾ½Úµãʱ¾Í´Ó¸ÃÊý¾Ý¼¯ÖвéѯÔÙ²Ù×÷¡£¡£ÕâÑù¾ÍÖ»²Ù×÷ÁËÒ»´ÎÊý¾Ý¿â¡£¡£Ê±¼äÓ¦¸Ã»á¿ìЩ£¡£¡
·Ö±í°É
Ïà¹ØÎÊ´ð£º
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
´ó¼Ò°ïÏÂæÁË
Çë½ÌÒ»¸öSQL²éѯµÄÎÊÌâ
±ÈÈçÎÒÏÖÔÚ²éѯ
SELECT * from XS WHERE רҵÃû='¼ÆËã»ú'
²éѯÍê³ÉÖ®ºóÎҿɲ»¿ÉÒÔÔÚÉϴβéѯµÄ»ù´¡Ö®ÉÏÔÚ½øÐÐÏà¹Ø²éÑ¯ÄØ£¿
±ÈÈçÎÒÔÚ²éÍê¼ÆËã»úרҵµÄËùÓÐѧÉúÖ®ºó£¬Ïë²é³ö¼ ......
±¾ÈËÊǸÕѧϰDelphi×Å£¬ÏÖÓöµ½ÈçÏÂÒ»¸öÎÊÌ⣺
ÎÒÏëÔÚListBoxÖÐÏÔʾAccessÊý¾Ý¿âTB±íµÄPeople×Ö¶ÎÀïÃæµÄ¼Ç¼¡£
ÀýÈ磺
TB±íÖеÄ×Ö¶ÎPeopleÀïÃæ¼Ç¼£ºA,B,C,D......
ÔÚListBoxÖÐÏÔʾ£¬ListBox.Item[0]:=A
......