unit3.~pas

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

unit Unit3;

interface

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

type
  Tjbxxxg = class(TForm)
    GroupBox1: TGroupBox;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Label2: TLabel;
    Edit1: TEdit;
    Label3: TLabel;
    Edit2: TEdit;
    Label4: TLabel;
    ToolBar1: TToolBar;
    Edit3: TEdit;
    Label5: TLabel;
    Label6: TLabel;
    Edit5: TEdit;
    Label7: TLabel;
    Edit6: TEdit;
    Label8: TLabel;
    Edit7: TEdit;
    Label9: TLabel;
    Edit8: TEdit;
    Label10: TLabel;
    Edit9: TEdit;
    Label11: TLabel;
    Edit10: TEdit;
    Label12: TLabel;
    Edit11: TEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Label13: TLabel;
    Edit12: TEdit;
    Label14: TLabel;
    Edit13: TEdit;
    Edit14: TEdit;
    Button4: TButton;
    StatusBar1: TStatusBar;
    ADOQuery1: TADOQuery;
    ADOConnection1: TADOConnection;
    DataSource1: TDataSource;
    Label15: TLabel;
    Label16: TLabel;
    ComboBox1: TComboBox;
    Image1: TImage;
    DateTimePicker1: TDateTimePicker;
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    
    procedure Button1Click(Sender: TObject);
    procedure DataSource1DataChange(Sender: TObject; Field: TField);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit13KeyPress(Sender: TObject; var Key: Char);
    procedure Button2Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure ADOQuery1AfterScroll(DataSet: TDataSet);
  
    
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  jbxxxg: Tjbxxxg;

implementation
uses unit1;
{$R *.dfm}



procedure Tjbxxxg.Button3Click(Sender: TObject);
begin
self.Close;
end;

procedure Tjbxxxg.Button4Click(Sender: TObject);
begin

dbgrid1.Refresh;
dbgrid1.Font.Color:=clgreen; 
end;


procedure Tjbxxxg.Button1Click(Sender: TObject);
begin
if(edit1.Text='')or(edit2.Text='')or(edit3.Text='')or(edit5.Text='')
or(edit6.Text='')or(edit7.Text='')or(edit8.Text='')or(edit9.Text='')or(edit10.Text='')
or(edit11.Text='')or(edit12.Text='')or(edit13.Text='')or(edit14.Text='')
then
 begin
   application.MessageBox('请输入要修改的内容','提示',0+64);
   exit;
 end
else
 begin
   ADOquery1.Edit;
   ADOquery1.FieldValues['学号']:=edit1.Text;
   ADOquery1.FieldValues['姓名']:=edit2.Text;
   ADOquery1.FieldValues['性别']:=ComboBox1.Text;
   ADOquery1.FieldValues['学制']:=edit3.Text;
   ADOquery1.FieldValues['出生年月']:=datetimepicker1.Time;
   ADOquery1.FieldValues['民族']:=edit5.Text;
   ADOquery1.FieldValues['籍贯']:=edit6.Text;
   ADOquery1.FieldValues['所在系别']:=edit7.Text;
   ADOquery1.FieldValues['所在班级']:=edit8.Text;
   ADOquery1.FieldValues['所学专业']:=edit9.Text;
   ADOquery1.FieldValues['政治面貌']:=edit10.Text;
   ADOquery1.FieldValues['入学时间']:=edit11.Text;
   ADOquery1.FieldValues['家庭住址']:=edit12.Text;
   ADOquery1.FieldValues['邮政编码']:=edit13.Text;
   ADOquery1.FieldValues['联系电话']:=edit14.Text;
   ADoquery1.Post;
{   edit2.Clear;
   edit3.Clear;
   edit4.Clear;
   edit5.Clear;
   edit6.Clear;
   edit7.Clear;
   edit8.Clear;
   edit9.Clear;
   edit10.Clear;
   edit11.Clear;
   edit12.Clear;
   edit13.Clear;
   edit14.Clear;
   edit1.SetFocus;
   edit1.SelectAll;
}
   application.MessageBox('信息已经修改完成！','修改提示',mb_ok);
 end;
end;

procedure Tjbxxxg.DataSource1DataChange(Sender: TObject; Field: TField);
begin
{
edit1.Text:=ADOquery1.FieldValues['学号'];
edit2.Text:=ADOquery1.FieldValues['姓名'];
checkbox1.Checked:=ADOquery1.FieldValues['性别'];
edit3.Text:=ADOquery1.FieldValues['学制'];
edit4.Text:=ADOquery1.FieldValues['出生年月'];
edit5.Text:=ADOquery1.FieldValues['民族'];
edit6.Text:=ADOquery1.FieldValues['籍贯'];
edit7.Text:=ADOquery1.FieldValues['所在系别'];
edit8.Text:=ADOquery1.FieldValues['所在班级'];
edit9.Text:=ADOquery1.FieldValues['所学专业'];
edit10.Text:=ADOquery1.FieldValues['政治面貌'];
edit11.Text:=ADOquery1.FieldValues['入学时间'];
edit12.Text:=ADOquery1.FieldValues['家庭住址'];
edit13.Text:=ADOquery1.FieldValues['邮政编码'];
edit14.Text:=ADOquery1.FieldValues['联系电话'];
}
end;

procedure Tjbxxxg.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 Tjbxxxg.Edit13KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in['0'..'9',#8])then
   begin
   key:=#0;
   Application.MessageBox('邮政编码只能填写数字','警告',0+64)
   end;
end;
procedure Tjbxxxg.Button2Click(Sender: TObject);
var
i:integer;
begin
 i:=application.MessageBox('你确定要删除吗？','删除提示',mb_YesNO);
 if i=6 then
   begin
      if  not ADOquery1.Eof then
       ADOquery1.Delete;
   end;
 //exit;
 //ADOquery1.Delete;

end;

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


end;

procedure Tjbxxxg.ADOQuery1AfterScroll(DataSet: TDataSet);
begin
edit1.Text:=ADOquery1.FieldValues['学号'];
edit2.Text:=ADOquery1.FieldValues['姓名'];
ComboBox1.Text:=ADOquery1.FieldValues['性别'];
edit3.Text:=ADOquery1.FieldValues['学制'];
datetimepicker1.Time:=ADOquery1.FieldValues['出生年月'];
edit5.Text:=ADOquery1.FieldValues['民族'];
edit6.Text:=ADOquery1.FieldValues['籍贯'];
edit7.Text:=ADOquery1.FieldValues['所在系别'];
edit8.Text:=ADOquery1.FieldValues['所在班级'];
edit9.Text:=ADOquery1.FieldValues['所学专业'];
edit10.Text:=ADOquery1.FieldValues['政治面貌'];
edit11.Text:=ADOquery1.FieldValues['入学时间'];
edit12.Text:=ADOquery1.FieldValues['家庭住址'];
edit13.Text:=ADOquery1.FieldValues['邮政编码'];
edit14.Text:=ADOquery1.FieldValues['联系电话'];
end;

end.