unit2.pas

没什么特别的 用ASSECC数据库~——~

unit Unit2;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, Grids, DBGrids, StdCtrls, Mask, DBCtrls, ImgList,
  ComCtrls, ToolWin, Buttons;

type
  TForm2 = class(TForm)
    ADOConnection1: TADOConnection;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Label2: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    ImageList1: TImageList;
    ADOQuery1: TADOQuery;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    BitBtn5: TBitBtn;
    BitBtn6: TBitBtn;
    BitBtn7: TBitBtn;
    BitBtn8: TBitBtn;
    BitBtn9: TBitBtn;
    Edit1: TEdit;
    Label9: TLabel;
    Label10: TLabel;
    Button1: TButton;
    procedure FormCreate(Sender: TObject);

    procedure DataSource1DataChange(Sender: TObject; Field: TField);
    
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
    procedure BitBtn6Click(Sender: TObject);
    procedure BitBtn7Click(Sender: TObject);
    procedure BitBtn8Click(Sender: TObject);
    procedure BitBtn9Click(Sender: TObject);
  
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
      procedure Setbt(val:integer);
  end;

var
  Form2: TForm2;
   id:string;
implementation

{$R *.dfm}

procedure TForm2.FormCreate(Sender: TObject);
begin
dbgrid1.Columns[1].Width:=80;
dbgrid1.Columns[2].Width:=60;
dbgrid1.Columns[3].Width:=60;
dbgrid1.Columns[4].Width:=60;
dbgrid1.Columns[5].Width:=80;
end;


procedure TForm2.DataSource1DataChange(Sender: TObject; Field: TField);
begin
inherited;
    Label2.Caption:=inttostr(ADOQuery1.RecordCount);
    dbedit1.Text:=DBGrid1.DataSource.DataSet.FieldByName('学号').AsString;
   dbedit2.Text:=DBGrid1.DataSource.DataSet.FieldByName('姓名').AsString;
   dbedit3.Text:=DBGrid1.DataSource.DataSet.FieldByName('班级编号').AsString;
   dbedit4.Text:=DBGrid1.DataSource.DataSet.FieldByName('宿舍').AsString;
   dbedit5.Text:=DBGrid1.DataSource.DataSet.FieldByName('性别').AsString;
   dbedit6.Text:=DBGrid1.DataSource.DataSet.FieldByName('政治面貌').AsString;
end;





procedure TForm2.BitBtn2Click(Sender: TObject);
begin
    datasource1.DataSet.Prior;
end;

procedure TForm2.BitBtn1Click(Sender: TObject);
begin
    datasource1.DataSet.First; //首记录
end;

procedure TForm2.BitBtn3Click(Sender: TObject);
begin
datasource1.DataSet.Next;
end;

procedure TForm2.BitBtn4Click(Sender: TObject);
begin
datasource1.DataSet.Last;
end;

procedure TForm2.BitBtn5Click(Sender: TObject);
begin
datasource1.DataSet.Append; //新增
Setbt(0);
end;

procedure TForm2.BitBtn6Click(Sender: TObject);
begin
datasource1.DataSet.Edit; //修改
Setbt(0);
end;

procedure TForm2.BitBtn7Click(Sender: TObject);
begin
datasource1.DataSet.Post;  //提交
Setbt(1);
end;

procedure TForm2.BitBtn8Click(Sender: TObject);
begin
if application.MessageBox('是否删除记录？','确认',MB_OKCANCEl)=IDOK then
  datasource1.DataSet.Delete;
end;

procedure TForm2.BitBtn9Click(Sender: TObject);
begin
    datasource1.DataSet.Cancel;
    Setbt(1);
end;
procedure TForm2.Setbt(val: integer);
begin
    if val=0 then
    begin
    bitbtn1.Enabled:=false;
    bitbtn2.Enabled:=false;
    bitbtn3.Enabled:=false;
    bitbtn4.Enabled:=false;
    bitbtn5.Enabled:=false;
    bitbtn6.Enabled:=false;
    bitbtn7.Enabled:=true;
    bitbtn8.Enabled:=false;
    bitbtn9.Enabled:=true;
     end
     else
     begin
     bitbtn1.Enabled:=true;
    bitbtn2.Enabled:=true;
    bitbtn3.Enabled:=true;
    bitbtn4.Enabled:=true;
    bitbtn5.Enabled:=true;
    bitbtn6.Enabled:=true;
    bitbtn7.Enabled:=false;
    bitbtn8.Enabled:=true;
    bitbtn9.Enabled:=false;
   end
end;



procedure TForm2.Edit1KeyPress(Sender: TObject; var Key: Char);
begin

    if not (key in ['0'..'9',#8,#13])then
   begin
   key:=#0;
   exit;
   end;
   if key=#13 then
   begin
    id:=trim(edit1.Text);
    adoquery1.Close;
     adoquery1.SQL.Clear;
     adoquery1.SQL.Add('select * from 学生信息表 where 学号='''+id+'''');
      adoquery1.Open;
      dbgrid1.Columns[1].Width:=80;
    dbgrid1.Columns[2].Width:=60;
    dbgrid1.Columns[3].Width:=60;
    dbgrid1.Columns[4].Width:=60;
   dbgrid1.Columns[5].Width:=80;
      end;
end;

procedure TForm2.Button1Click(Sender: TObject);
begin
 close;
end;

end.