unit1.pas

来自「这是delphi 的入门代码是我们为了一次考试而准备的」· PAS 代码 · 共 55 行

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    ComboBox1: TComboBox;
    Edit1: TEdit;
    Button1: TButton;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    ADOConnection1: TADOConnection;
    ADODataSet1: TADODataSet;
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
  self.ADODataSet1.Close;
  self.ADODataSet1.CommandText:='select * from student where sdept='+#39+combobox1.Text+#39+' and sna='+#39+edit1.Text+#39;
  self.ADODataSet1.Open;
  
end;
procedure TForm1.FormCreate(Sender: TObject);
begin
  self.ADODataSet1.Close;
  self.ADODataSet1.CommandText:='select distinct sdept from student';
  self.ADODataSet1.Open;

  combobox1.Clear;
  while not self.ADODataSet1.Eof do
  begin
    combobox1.Items.Add(self.ADODataSet1.FieldByName('sdept').AsString);
    self.ADODataSet1.Next;
  end;
end;

end.