unit4.~pas

学生信息管理系统

unit Unit4;

interface

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

type
  TForm4 = class(TForm)
    GroupBox1: TGroupBox;
    DBNavigator1: TDBNavigator;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit5: TDBEdit;
    DBComboBox1: TDBComboBox;
    DBComboBox2: TDBComboBox;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    DataSource1: TDataSource;
    DBMemo1: TDBMemo;
    StatusBar1: TStatusBar;
    procedure DataSource1DataChange(Sender: TObject; Field: TField);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form4: TForm4;

implementation

{$R *.dfm}

procedure TForm4.DataSource1DataChange(Sender: TObject; Field: TField);
var i,j:integer;
begin
    i:=ADOTable1.RecNo;
    j:=ADOTable1.RecordCount;
        statusbar1.Panels[0].Text:='第'+inttostr(i)+'条记录，总共'+inttostr(ADOTable1.RecordCount)+'条记录';
end;

procedure TForm4.FormCreate(Sender: TObject);
var mypath:string;
begin
    mypath:=ExtractFilePath(ParamStr(0));
    ADOConnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Password="";Data Source='+MyPath+'data1.mdb;Persist Security Info=True';
    try
        ADOConnection1.Open;
        ADOtable1.Active:=true;
    except
        application.MessageBox('找不到数据库，引起该问题的原因是数据库文件可能被人为删除或改名。','无法打开数据库',0);
        application.Terminate;
    end;
end;

procedure TForm4.FormClose(Sender: TObject; var Action: TCloseAction);
begin
    action:=cafree;
end;

end.