在ADOTAble中进行查询，删除操作

最新推荐文章于 2021-02-23 08:13:23 发布

luhouren

最新推荐文章于 2021-02-23 08:13:23 发布

阅读量450

点赞数

分类专栏： DELPHI学习文章标签： Windows

本文链接：https://blog.csdn.net/luhouren/article/details/83262275

版权

DELPHI学习专栏收录该内容

2 篇文章 0 订阅

订阅专栏

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Mask, DBCtrls, Grids, DBGrids, DB, ADODB;

type
  TForm1 = class(TForm)
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    DataSource1: TDataSource;
    DBEdit1: TDBEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button5: TButton;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
var
  newstring:string;
begin
  inputQuery('输入查询条件','姓名为',newstring);
  self.ADOTable1.Locate('Sname',newstring,[loCaseInsensitive]) //精确查询
end;

procedure TForm1.Button2Click(Sender: TObject);
var
  newstring:string;
begin
  inputQuery('输入查询条件','姓名为',newstring);
  self.ADOTable1.Locate('Sname',newstring,[loPartialKey]) //模糊查询
end;

procedure TForm1.Button3Click(Sender: TObject);
var
  newstring:string;
begin
  inputQuery('输入查询条件','姓名为',newstring);
  self.ADOTable1.Filter:='Sname='+''''+newstring+'''';
  self.ADOTable1.Filtered:=true;
end;

procedure TForm1.Button4Click(Sender: TObject);
var
  newstring:string;
begin
  inputQuery('输入查询条件','姓名为',newstring);
  self.ADOTable1.Filter:='Sname like ' + ''''+'%'+newstring+'%'+'''';
  self.ADOTable1.Filtered:=true;
end;

procedure TForm1.Button5Click(Sender: TObject);
begin
  self.ADOTable1.DisableControls;
  if
    messageDlg('确实要删除这条记录吗？',mtinformation,[mbok,mbcancel],0)=mrOk
  then
    self.ADOTable1.Delete;
    self.ADOTable1.EnableControls;
end;

end.