unit6.pas

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

unit Unit6;

interface

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

type
  Tform6 = class(TForm)
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    DBGrid1: TDBGrid;
    SpeedButton1: TSpeedButton;
    GroupBox3: TGroupBox;
    SpeedButton2: TSpeedButton;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    SpeedButton3: TSpeedButton;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    ADOConnection1: TADOConnection;
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure SpeedButton2Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  form6: Tform6;

implementation
  uses unit1;
{$R *.dfm}

procedure Tform6.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
if not (key in['0'..'9',#8])then
   begin
   key:=#0;
   Application.MessageBox('学号只能填写数字','警告',0+64)
   end;
end;

procedure Tform6.SpeedButton2Click(Sender: TObject);
begin
self.Close;
end;

procedure Tform6.FormActivate(Sender: TObject);
var sqlstr:string;
begin
sqlstr:='select *from 成绩表';
ADOquery1.Close;
ADOquery1.SQL.Clear;
ADOquery1.SQL.Add(sqlstr);
ADOquery1.Open;
end;

procedure Tform6.SpeedButton1Click(Sender: TObject);
begin
if(edit1.Text='')then
begin
 application.MessageBox('请输入学号','提示',0+64);
 exit;
end;
 ADOquery1.SQL.Clear;
 ADOquery1.Close;
 ADOquery1.SQL.Add('select * from 成绩表 where 学号='''+edit1.text+'''');
 dbgrid1.Font.Color:=clteal;
 ADOquery1.Open;
 edit1.SetFocus;
 edit1.SelectAll;
 
   if ADOquery1.RecordCount=0 then
    begin
    application.MessageBox('你输入的数据不存在请重新输入','提示',0+64);
    exit;
    end;
end;
procedure Tform6.SpeedButton3Click(Sender: TObject);
 var
sql:string;
begin

 sql:='where(授课教师 like '''+'%'+edit2.text+'%'')and(课程名称 like '''+'%'+edit3.text+'%'')and(学期 like '''+'%'+edit4.Text+'%'')and(成绩 like '''+'%'+edit5.Text+'%'' )';
 ADOquery1.SQL.Clear;
 ADOquery1.Close;
 ADOquery1.SQL.Add('select * from 成绩表');
 ADOquery1.SQL.Add(sql);
 ADoquery1.Open;
 
 end;

end.