unit10.pas

能够动态的实现数据库表的创建

unit Unit10;

interface

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

type
  TForm10 = class(TForm)
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    DBLookupComboBox1: TDBLookupComboBox;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form10: TForm10;

implementation

{$R *.dfm}


procedure TForm10.BitBtn1Click(Sender: TObject);
var
sql:string;
begin
  if(dblookupcombobox1.keyvalue=null)and(edit1.text='')then
   begin
   application.MessageBox('请输入查询条件','提示',mb_ok);
   exit;
  end;
sql:='select * from 课程 where 1=1';
   if(dblookupcombobox1.keyvalue<>null)then
    sql:=sql+' and 系名称='''+dblookupcombobox1.keyvalue+'''';
    if edit1.text<>'' then sql:=sql+' and 任课教师='''+edit1.text+'''';
  ADOquery1.Close;
 ADOquery1.SQL.Clear;
 ADOquery1.SQL.Add(sql);
 ADoquery1.Open;
 if ADOquery1.RecordCount=0 then
    begin
    application.MessageBox('没有您要查找的信息','提示',0+64);
    dblookupcombobox1.keyvalue:=null;
    edit1.text:='';
    exit;
    end;
 dblookupcombobox1.keyvalue:=null;
 edit1.text:='';
 sql:='';

end;
procedure TForm10.BitBtn2Click(Sender: TObject);
begin
  self.Close;
end;

procedure TForm10.BitBtn3Click(Sender: TObject);
begin
  ADOquery1.Close;
  ADOquery1.SQL.Clear;
  ADOquery1.SQL.Add('select * from 课程');
  ADoquery1.Open;
end;

end.