unit11.pas

用Delphi写的学生信息管理系统的源代码

unit Unit11;

interface

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

type
  Tbyxxxg = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    DBGrid1: TDBGrid;
    Label2: TLabel;
    Edit2: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Button1: TButton;
    Button2: TButton;
    Button4: TButton;
    StatusBar1: TStatusBar;
    Label4: TLabel;
    Label5: TLabel;
    Edit4: TEdit;
    Label6: TLabel;
    Edit5: TEdit;
    Edit6: TEdit;
    GroupBox2: TGroupBox;
    Label7: TLabel;
    Edit7: TEdit;
    Label8: TLabel;
    Label9: TLabel;
    Edit8: TEdit;
    Edit9: TEdit;
    ComboBox1: TComboBox;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure Button4Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Button1Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure ADOQuery1AfterScroll(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  byxxxg: Tbyxxxg;

implementation
 uses unit1;
{$R *.dfm}

procedure Tbyxxxg.Button4Click(Sender: TObject);
begin
close;

end;

procedure Tbyxxxg.Button2Click(Sender: TObject);
 var
 i:integer;
begin
i:=application.MessageBox('你确定要删除吗？','删除提示',mb_YesNO);
if i=7 then
exit;
ADOquery1.Delete;
end;


procedure Tbyxxxg.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 Tbyxxxg.Button1Click(Sender: TObject);
begin
if(edit1.Text='')or(edit2.Text='')or(edit3.Text='')or(edit4.Text='')or(edit5.Text='')
or(edit6.Text='')or(edit7.Text='')or(edit8.Text='')or(edit9.Text='')then
begin
application.MessageBox('请输入要修改的内容','提示',0+64);
exit;
end
else
  ADOquery1.Edit;
  ADOquery1.FieldValues['学号']:=edit1.Text;
  ADOquery1.FieldValues['学制']:=edit2.Text;
  ADOquery1.FieldValues['毕业证号']:=edit3.Text;
  ADOquery1.FieldValues['就业单位']:=edit4.Text;
  ADOquery1.FieldValues['联系地址']:=edit5.Text;
  ADOquery1.FieldValues['学位证号']:=edit6.Text;
  ADOquery1.FieldValues['是否获毕业证']:=combobox1.Text;
  ADOquery1.FieldValues['毕业论文']:=edit7.Text;
  ADOquery1.FieldValues['发证日期']:=edit8.Text;
  ADOquery1.FieldValues['未获毕业证原因']:=edit9.Text;
  ADOquery1.Post;
  application.MessageBox('信息已经修改完成！','修改提示',mb_ok);
end;

procedure Tbyxxxg.FormActivate(Sender: TObject);
 var
 sqlstr:string;
begin
 sqlstr:='select *from t_biye';
  Adoquery1.Close;
  ADOquery1.SQL.Clear;
  ADOquery1.SQL.Add(sqlstr);
  ADOquery1.Open;
end;

procedure Tbyxxxg.ADOQuery1AfterScroll(DataSet: TDataSet);
begin
edit1.Text:=ADOquery1.FieldValues['学号'];
edit2.Text:=ADOquery1.FieldValues['学制'];
edit3.Text:=ADOquery1.FieldValues['毕业证号'];
edit4.Text:=ADOquery1.FieldValues['就业单位'];
edit5.Text:=ADOquery1.FieldValues['联系地址'];
edit6.Text:=ADOquery1.FieldValues['学位证号'];
combobox1.Text:=ADOquery1.FieldValues['是否获毕业证'];
edit7.Text:=ADOquery1.FieldValues['毕业论文'];
edit8.Text:=ADOquery1.FieldValues['发证日期'];
edit9.Text:=ADOquery1.FieldValues['未获毕业证原因'];
end;

end.