unit10.pas

学生信息管理系统 学生信息管理系统 学生信息管理系统

unit Unit10;

interface

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

type
  Tbyxxlr = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    GroupBox2: TGroupBox;
    Label8: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label14: TLabel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    Label2: TLabel;
    StatusBar1: TStatusBar;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Image1: TImage;
    ComboBox1: TComboBox;
    ADOQuery1: TADOQuery;
    Image2: TImage;
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure SpeedButton1Click(Sender: TObject);
    
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  byxxlr: Tbyxxlr;

implementation
 uses unit1;
{$R *.dfm}


procedure Tbyxxlr.SpeedButton3Click(Sender: TObject);
begin
close;
end;

procedure Tbyxxlr.SpeedButton2Click(Sender: TObject);
begin
edit1.Clear;
edit2.Clear;
edit3.Clear;
edit4.Clear;
edit5.Clear;
edit6.Clear;
edit7.Clear;
edit8.Clear;
edit9.Clear;

end;

procedure Tbyxxlr.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 Tbyxxlr.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 Tbyxxlr.SpeedButton1Click(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('请输入数据','提示',mb_ok);
 exit;
end;
with ADOquery1 do
begin
append;
fieldvalues['学号']:=edit1.Text;
fieldvalues['学制']:=edit2.Text;
fieldvalues['毕业证号']:=edit3.Text;
fieldvalues['就业单位']:=edit4.Text;
fieldvalues['联系地址']:=edit5.Text;
fieldvalues['学位证号']:=edit6.Text;
fieldvalues['是否获毕业证']:=combobox1.Text;
fieldvalues['毕业论文']:=edit7.Text;
fieldvalues['发证日期']:=edit8.Text;
fieldvalues['未获毕业证原因']:=edit9.Text;
 try
 post;
   except
      Application.MessageBox('学号重复，请重新输入！','警告',0+64);
      delete;
      edit1.SetFocus;
      edit1.SelectAll;
      exit;
end;
end;
end;

end.