unit11.pas

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

unit unit11;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExtCtrls, DB, ADODB, jpeg, Buttons;

type
  TForm11 = class(TForm)
    Panel1: TPanel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    ADOQuery1: TADOQuery;
    Image1: TImage;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form11: TForm11;

implementation

{$R *.dfm}

procedure TForm11.BitBtn1Click(Sender: TObject);
begin
  if(edit1.Text='')or(edit2.Text='')or(edit3.Text='')then
  begin
   application.MessageBox('请输入完整的信息','提示',mb_ok);
   exit;
   end;
   ADOquery1.close;
   ADOquery1.sql.clear;
   ADOquery1.sql.add('select * from 登陆 where 用户名='''+edit1.text+'''');
   ADOquery1.open;
   if ADOquery1.recordcount>0 then
   begin
      showmessage('该用户名已经存在');
      edit1.selectall;
      exit;
    end;
    if(edit2.Text)<>(edit3.Text)then
    showmessage('两次输入的密码不一致');
    with ADOquery1 do
begin
  append;
  fieldvalues['用户名']:=edit1.Text;
  fieldvalues['密码']:=edit2.Text;
  post;
  showmessage('用户创建成功');
  self.Close;
end;
end;

procedure TForm11.BitBtn2Click(Sender: TObject);
begin
  close;
end;

end.