xiu2.pas

相当不错 最新的

unit xiu2;

interface

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

type
  TForm6 = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    DBText1: TDBText;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    Button4: TButton;
    Button5: TButton;
    Button6: TButton;
    TabSheet2: TTabSheet;
    Label6: TLabel;
    Label7: TLabel;
    DBEdit4: TDBEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    DBLookupComboBox1: TDBLookupComboBox;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    DataSource1: TDataSource;
    ADOTable2: TADOTable;
    DataSource2: TDataSource;
    DataSource3: TDataSource;
    ADOTable3: TADOTable;
    DBEdit5: TDBEdit;
    Button7: TButton;
    Button8: TButton;
    procedure DBLookupComboBox1Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form6: TForm6;

implementation

{$R *.dfm}

procedure TForm6.DBLookupComboBox1Click(Sender: TObject);
begin
adotable2.Open;
adotable3.Open;
end;

procedure TForm6.Button4Click(Sender: TObject);
begin
dbedit1.Text:='';
dbedit2.Text:='';
dbedit3.Text:='';
end;

procedure TForm6.Button5Click(Sender: TObject);
begin
adotable2.Edit;
adotable2['成绩1']:=dbedit1.Text;
adotable2['成绩2']:=dbedit2.Text;
adotable2['成绩3']:=dbedit3.Text;
adotable2.Post;
dbedit1.Enabled:=false;
dbedit2.Enabled:=false;
dbedit3.Enabled:=false;
end;

procedure TForm6.Button6Click(Sender: TObject);
begin
adotable2.Cancel;
adotable2.Active:=false;
adotable2.Active:=true;
end;

procedure TForm6.Button8Click(Sender: TObject);
begin
if not adotable3.Eof then
adotable3.Next
else
adotable3.Last;
end;

procedure TForm6.Button7Click(Sender: TObject);
begin
if not adotable3.Bof then
adotable3.Prior
else
adotable3.First;
end;

procedure TForm6.Button1Click(Sender: TObject);
begin
dbedit4.Text:='';
end;

procedure TForm6.Button2Click(Sender: TObject);
begin
adotable3.Post;
dbedit4.Enabled:=false;
end;

procedure TForm6.Button3Click(Sender: TObject);
begin
adotable3.Cancel;
dbedit4.Text:=adotable3['成绩'];
end;

end.