cw_kc.pas

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

unit cw_kc;

interface

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

type
  TForm22 = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    splb: TComboBox;
    Button1: TButton;
    GroupBox2: TGroupBox;
    Label4: TLabel;
    spmc: TComboBox;
    Button2: TButton;
    GroupBox3: TGroupBox;
    DBGrid1: TDBGrid;
    Button3: TButton;
    Button5: TButton;
    Q_splb: TQuery;
    DataSource1: TDataSource;
    Q_lb: TQuery;
    Q_spmc: TQuery;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form22: TForm22;

implementation

{$R *.dfm}

procedure TForm22.Button1Click(Sender: TObject);
 var splba:string;
begin
  splba:=splb.text;
  Q_splb.Close;
  Q_splb.SQL.Clear;
  Q_splb.SQL.Add('select * from kucun where TypeName='''+splba+'''');
  Q_splb.SQL.Add('order by MenuName,Intime');
  Q_splb.Open;
  Q_splb.Active:=True;

end;

procedure TForm22.Button2Click(Sender: TObject);
    var MenuName:string;
begin
  MenuName:=spmc.Text;
  Q_splb.Close;
  Q_splb.SQL.Clear;
  Q_splb.SQL.Add('select * from kucun where MenuName='''+MenuName+'''');
  Q_splb.SQL.Add('order by MenuName');
  Q_splb.Open;
  Q_splb.Active:=True;

end;

procedure TForm22.Button3Click(Sender: TObject);
begin
  Q_splb.Close;
  Q_splb.SQL.Clear;
  Q_splb.SQL.Add('select * from kucun order by MenuNo');
  Q_splb.Open;
end;

procedure TForm22.Button5Click(Sender: TObject);
begin
 close;
end;

procedure TForm22.FormShow(Sender: TObject);
begin
  Q_lb.Open;
  Q_lb.Active:=True;
  while not Q_lb.Eof do
        begin
          splb.Items.Add(Q_lb.FieldByName('TypeName').AsString);
          Q_lb.Next;
        end;

  Q_spmc.Active:=False;
  Q_spmc.Close;
  Q_spmc.Open;
  Q_spmc.Active:=True;
while not Q_spmc.Eof do
        begin
          spmc.Items.Add(Q_spmc.FieldByName('MenuName').AsString);
          Q_spmc.Next;
        end;

end;

end.