unit12.~pas

学生管理系统(delphi7.0+sql2000) 对学生基本信息,学生成绩,课程进行插,删,改功能

unit Unit12;

interface

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

type
  TForm12 = class(TForm)
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    Panel1: TPanel;
    Panel2: TPanel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form12: TForm12;

implementation

{$R *.dfm}

procedure TForm12.Button1Click(Sender: TObject);
var
sqlstr:string;
begin
  sqlstr:='select * from 课程表';
  ADOquery1.Close;
  ADOquery1.SQL.Clear;
  ADOquery1.SQL.Add(sqlstr);
  ADOquery1.Open;
  dbgrid1.Font.Color:=clgreen;
end;

procedure TForm12.Button2Click(Sender: TObject);
var
abc:string;
begin

 abc:='select count(*) from 课程表';
  ADOquery1.Close;
  ADOquery1.SQL.Clear;
  ADOquery1.SQL.Add(abc);
  ADOquery1.Open;
  dbgrid1.Font.Color:=clgreen;

end;

procedure TForm12.BitBtn1Click(Sender: TObject);
begin
close;
end;

procedure TForm12.SpeedButton1Click(Sender: TObject);
begin
close;
end;

procedure TForm12.SpeedButton2Click(Sender: TObject);
var
sqlstr:string;
begin
  sqlstr:='select * from 课程表';
  ADOquery1.Close;
  ADOquery1.SQL.Clear;
  ADOquery1.SQL.Add(sqlstr);
  ADOquery1.Open;
  dbgrid1.Font.Color:=clgreen;
end;

procedure TForm12.SpeedButton3Click(Sender: TObject);
var
abc:string;
begin

 abc:='select count(*) from 课程表';
  ADOquery1.Close;
  ADOquery1.SQL.Clear;
  ADOquery1.SQL.Add(abc);
  ADOquery1.Open;
  dbgrid1.Font.Color:=clgreen;

end;
end.