unit3.~pas

用delphi写的课堂作业

unit Unit3;

interface

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

type
  TFrame3 = class(TFrame)
    DBGrid1: TDBGrid;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    DBEdit4: TDBEdit;
    Label4: TLabel;
    Button5: TButton;
    Button1: TButton;
    Button6: TButton;
    Edit1: TEdit;
    Button7: TButton;
    Label5: TLabel;
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;


implementation

{$R *.dfm}

procedure TFrame3.Button2Click(Sender: TObject);
var
Qm:integer;
Pm:string;
begin
   adoquery1.Edit;
   Qm:=adoquery1.FieldByName('truancy').AsInteger;
   dbedit1.text:='';
   Qm:=Qm+1;
   Pm:=inttostr(Qm);
   dbedit1.Text:=Pm;
   adoquery1.Post;
   adoquery1.Next;
   //Qm:=ADOQuery1.FieldValues('truancy');
   //Qm:=Qm+1;
   //dbedit1.Text:=AdOQuery1.FieldValues('truancy');
   //ADOQuery1.Post;

   //Qm:=1;
   //Qm:=Qm+'truanry';
   //adoquery1.SQL.Add('updata from student set truanry=truanry+1 where condisions');


end;

procedure TFrame3.Button3Click(Sender: TObject);
var
Qm:integer;
Pm:string;
begin
   adoquery1.Edit;
   Qm:=adoquery1.FieldByName('late').AsInteger;
   dbedit2.text:='';
   Qm:=Qm+1;
   Pm:=inttostr(Qm);
   dbedit2.Text:=Pm;
   adoquery1.Post;
   adoquery1.Next;
end;

procedure TFrame3.Button4Click(Sender: TObject);
var
Qm:integer;
Pm:string;
begin
   adoquery1.Edit;
   Qm:=adoquery1.FieldByName('leave').AsInteger;
   dbedit3.text:='';
   Qm:=Qm+1;
   Pm:=inttostr(Qm);
   dbedit3.Text:=Pm;
   adoquery1.Post;
   adoquery1.Next;
end;

procedure TFrame3.Button5Click(Sender: TObject);
var
Qm:integer;
Pm:string;
begin
   adoquery1.Edit;
   Qm:=adoquery1.FieldByName('qingjia').AsInteger;
   dbedit4.text:='';
   Qm:=Qm+1;
   Pm:=inttostr(Qm);
   dbedit4.Text:=Pm;
   adoquery1.Post;
   adoquery1.Next;
end;

procedure TFrame3.BitBtn1Click(Sender: TObject);
begin
 adoquery1.Next;
end;

procedure TFrame3.Button1Click(Sender: TObject);
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('select * from student');
  ADOQuery1.Open;
end;

procedure TFrame3.Button6Click(Sender: TObject);
begin
  adoquery1.Next;
end;

procedure TFrame3.Button7Click(Sender: TObject);
var
tiaojian:string;
begin
  if Edit1.Text<>'' then
  begin
    adoquery1.Edit;
    tiaojian := 'select * from student where grade like "%' + Edit1.Text + '%"';
    ADOQuery1.Close;
    ADOQuery1.SQL.Clear;
    ADOQuery1.SQL.Add(tiaojian);
    ADOQuery1.Open;
  end
  else
    messagebox(handle,'请输入查询条件！','检查输入',mb_iconwarning+mb_ok)

end;

end.