passql.pas

舉例姓名管理系統

unit pasSQL;

interface

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

type
  TfrmSQL = class(TForm)
    DBGrid1: TDBGrid;
    Memo1: TMemo;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    XPManifest1: TXPManifest;
    Query1: TQuery;
    DataSource1: TDataSource;
    Label2: TLabel;
    dxBarManager1: TdxBarManager;
    dxBarRun: TdxBarButton;
    dxBarFirst: TdxBarButton;
    dxBarPre: TdxBarButton;
    dxBarNext: TdxBarButton;
    dxBarLast: TdxBarButton;
    dxBarClear: TdxBarButton;
    procedure DBGrid1DblClick(Sender: TObject);
    procedure dxBarRunClick(Sender: TObject);

    procedure dxBarClearClick(Sender: TObject);


  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmSQL: TfrmSQL;

implementation

{$R *.dfm}
uses pasMain, frmDetail;

procedure TfrmSQL.DBGrid1DblClick(Sender: TObject);
begin
Form1.Caption:= DBEdit1.Text +' 的属性';
Form1.Refresh;
Form1.ShowModal;
end;

procedure TfrmSQL.dxBarRunClick(Sender: TObject);
begin
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('Select * from dvdm');
Query1.SQL.Add('where 中文名称 like '''+ Label2.Caption + Label1.Caption + Label2.Caption+''''); 
Query1.Open;
end;
procedure TfrmSQL.dxBarClearClick(Sender: TObject);
begin
Query1.Close;
end;
end.