unit1.pas

Delphi数据库编程

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    DataSource1: TDataSource;
    Query1: TQuery;
    DBGrid1: TDBGrid;
    Button1: TButton;
    Table1: TTable;
    Button2: TButton;
    Button3: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
 begin
    Query1.close;
    Query1.SQL.Clear ;
    Query1.SQL.Add('Insert Into 学生表(学号,姓名,性别,年龄,班级)   Values(''0301011'',''李小华'',''女'',21,''03信息管理'')') ;
    Query1.ExecSQL  ;
    Button2.Enabled :=True;
    button1.Enabled :=False;
    table1.Refresh ;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
    Query1.close;
    Query1.SQL.Clear ;
    Query1.SQL.Add('Delete From 学生表  Where 姓名=''赵小平''') ;
    Query1.ExecSQL  ;
    Button3.Enabled :=True;
    Button2.Enabled :=False;
    table1.Refresh ;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
    Query1.close;
    Query1.SQL.Clear ;
    Query1.SQL.Add('Update 学生表 SET 年龄=年龄+1 WHERE 性别=''男''' ) ;
    Query1.ExecSQL  ;
    Button3.Enabled :=False;
    Table1.Refresh ;
end;

end.