see_hiszd.pas

结于初学者来说这对数据库是一个很好的例子

unit see_Hiszd;

interface

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

type
  TForm17 = class(TForm)
    Q_zdcx: TQuery;
    DS_zdcx: TDataSource;
    Label1: TLabel;
    Q_zdxxcx: TQuery;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    AccountNo: TEdit;
    Button1: TButton;
    GroupBox3: TGroupBox;
    DB_zd: TDBGrid;
    Button4: TButton;
    Button2: TButton;
    procedure Button4Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
//    procedure Button5Click(Sender: TObject);
//    procedure Button5Click(Sender: TObject);
//    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form17: TForm17;

implementation

{$R *.dfm}

procedure TForm17.Button4Click(Sender: TObject);
begin
  q_zdcx.Active:=False;
  Q_zdcx.SQL.Clear;
  Q_zdcx.SQL.Add('select * from H_Sn_Account order by AccountNo');
  Q_zdcx.Active:=True;

end;

procedure TForm17.Button1Click(Sender: TObject);
begin
 if (length(AccountNo.Text)=0) then
  begin
   MessageDlg('输入不能为空，请重新输入！',mtError,[mbok],0);
   end
  else
   begin
  q_zdcx.Active:=False;
  Q_zdcx.SQL.Clear;
  Q_zdcx.SQL.Add('select * from H_Sn_Account where cstr(AccountNo)='''+AccountNo.Text+'''');
  Q_zdcx.Active:=True;
  end;
end;

procedure TForm17.Button2Click(Sender: TObject);
begin
 close;
end;

end.