unit1.pas

老师随机点到

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    BitBtn1: TBitBtn;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    Button1: TButton;
    Button2: TButton;
    DBGrid2: TDBGrid;
    DataSource2: TDataSource;
    BitBtn2: TBitBtn;
    Button3: TButton;
    procedure BitBtn1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

uses Unit2, Unit3, Math, Unit4;

{$R *.dfm}

procedure TForm1.BitBtn1Click(Sender: TObject);
begin
  if not DM.DBSvrReadyTest then
  begin
    Form3 := TForm3.Create(Self);
    if Form3.ShowModal <> mrOK then
    begin
      Application.MessageBox('数据库连接失败,请检查网络连接','系统退出',MB_OK+MB_ICONINFORMATION);
      Application.Terminate;
    end;
    Form3.Free;
  end;
  DM.tblSQLStus.Open;
  DM.tblSQLStus.Fields[0].DisplayWidth := 10;
  DM.tblSQLStus.Fields[1].DisplayWidth := 10;
  DM.tblSQLStus.Fields[2].DisplayWidth := 10;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  if DM.tblSQLStus.Active then
  begin
    DM.tblSQLStus.Edit;
    DM.tblSQLStus.FieldByName('学号').AsString := '123';
    if DM.tblSQLStus.State in [dsEdit, dsInsert] then
      DM.tblSQLStus.Post;
      //DM.tblSQLStus.Cancel;
    if Application.MessageBox('', '', MB_YESNO) = mrYes then
      DM.tblSQLStus.Delete;
  end;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
  DM.tblExelStus.Open;
end;

procedure TForm1.BitBtn2Click(Sender: TObject);
var
  strCmd : String;
  strFieldsList : string;
begin
  If not DM.tblExelStus.Active then Exit;
  if not DM.GlobalCommandExcute('Delete From Students') then Exit;

  DM.tblExelStus.First;
  strFieldsList := '(' + DM.tblSQLStus.Fields[0].FieldName + ','
                       + DM.tblSQLStus.Fields[1].FieldName + ','
                       + DM.tblSQLStus.Fields[2].FieldName + ') ';
  while not DM.tblExelStus.Eof do
  begin
    //insert
    strCmd := 'insert into Students ' + strFieldsList
            + 'Values('
            + QuotedStr(DM.tblExelStus.FieldByName('学号').AsString) + ','
            + QuotedStr(DM.tblExelStus.FieldByName('姓名').AsString) + ','
            + QuotedStr(DM.tblExelStus.FieldByName('班级').AsString) + ')';
    if not DM.GlobalCommandExcute(strCmd) then
    begin
      Break;
    end;
    DM.tblExelStus.Next;
  end;
  DM.tblSQLStus.Requery;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
  Form4 := TForm4.Create(Self);
  Form4.ShowModal;
  Form4.Free;
end;

end.