advancequeryunit.pas

一个功能完美的学生成绩管理系统 使用ACCESS数据库在DATA文件夹中 功能强大

unit advancequeryUnit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, Grids, DBGrids, ExtCtrls, DBCtrls;

type
  Tadvancequeryform = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    Panel3: TPanel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Label1: TLabel;
    GroupBox1: TGroupBox;
    Memo1: TMemo;
    BitBtn3: TBitBtn;
    Panel4: TPanel;
    DBNavigator1: TDBNavigator;
    Splitter1: TSplitter;
    Splitter3: TSplitter;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  advancequeryform: Tadvancequeryform;

implementation

uses datamoduleUnit;

{$R *.dfm}

procedure Tadvancequeryform.BitBtn1Click(Sender: TObject);
begin

if memo1.Lines.Count<>0 then
with datamodule1.queryall do
   begin
     close;
     SQL.Clear;
     datamodule1.queryall.SQL:=memo1.Lines;
     prepared;
     open;
    end

else
 messagebox (Handle,'SQL 语句为空！','错误',mb_ok) ;

end;

procedure Tadvancequeryform.BitBtn2Click(Sender: TObject);
begin
memo1.Clear;
end;

procedure Tadvancequeryform.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
datamodule1.queryall.Close;
end;

end.