unit1.~pas

来自「delphi数据库的程序代码」· ~PAS 代码 · 共 91 行

unit Unit1;

interface

uses
  Windows, Messages, Classes, SysUtils, Graphics, Controls, StdCtrls, Forms,
  Dialogs, DBCtrls, DB, DBTables, Mask, ExtCtrls;

type
  TForm1 = class(TForm)
    Query1StringField: TStringField;
    Query1StringField2: TStringField;
    Query1StringField3: TStringField;
    Query1FloatField: TFloatField;
    Query1StringField4: TStringField;
    Query1StringField5: TStringField;
    Query1StringField6: TStringField;
    Query1FloatField2: TFloatField;
    Query1StringField7: TStringField;
    Query1StringField8: TStringField;
    ScrollBox: TScrollBox;
    Label1: TLabel;
    EditDBEdit: TDBEdit;
    Label2: TLabel;
    EditDBEdit2: TDBEdit;
    Label3: TLabel;
    EditDBEdit3: TDBEdit;
    Label4: TLabel;
    EditDBEdit4: TDBEdit;
    Label5: TLabel;
    EditDBEdit5: TDBEdit;
    Label6: TLabel;
    EditDBEdit6: TDBEdit;
    Label7: TLabel;
    EditDBEdit7: TDBEdit;
    Label8: TLabel;
    EditDBEdit8: TDBEdit;
    Label9: TLabel;
    EditDBEdit9: TDBEdit;
    Label10: TLabel;
    EditDBEdit10: TDBEdit;
    DBNavigator: TDBNavigator;
    Panel1: TPanel;
    DataSource1: TDataSource;
    Panel2: TPanel;
    Query1: TQuery;
    Label11: TLabel;
    Label12: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    RadioGroup1: TRadioGroup;
    procedure FormCreate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure RadioGroup1Click(Sender: TObject);
  private
    { private declarations }
  public
        state: integer;
    { public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.DFM}

procedure TForm1.FormCreate(Sender: TObject);
begin
  Query1.Open;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
        Query1.SQL.Clear;
        Query1.SQL.Add('select * from "C:\TEMP\student1.DB" as s where s."姓名"=:Name');
        Query1.Prepare;
        Query1.Params[0].AsString:=edit1.Text;
        Query1.Open;
end;

procedure TForm1.RadioGroup1Click(Sender: TObject);
begin
        case  RadioGroup1.ItemIndex of
        0:    state:=0;
        1:    state:=1;
        end;
end;

end.