unit5.pas

这是本人网络数据库实习的程序,编程语言选择DELPHI7.0,完全个人编写.本程序一些界面还不够完善,功能不大,还有很多地方需要改进,望有兴趣的朋友一起探讨或通过电子邮箱与我联系!

unit Unit5;

interface

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

type
  Tusers = class(TForm)
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Edit1: TEdit;
    ComboBox1: TComboBox;
    Button1: TButton;
    DataSource1: TDataSource;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    ADOQuery1: TADOQuery;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBComboBox1: TDBComboBox;
    DBComboBox2: TDBComboBox;
    Label10: TLabel;
    DBEdit7: TDBEdit;
    procedure Button1Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  users: Tusers;

implementation
  uses unit1,unit2;
{$R *.dfm}

procedure Tusers.Button1Click(Sender: TObject);
begin
  with adoquery1 do
    begin
    sql.Clear;
    sql.Add('select * from 用户信息');
    sql.Add(format(' where (%s',[trim(combobox1.Text)]));
    if combobox1.Text='用户编号' then
      begin
      sql.Add(format(' = %d)',[strtoint(edit1.Text)]));
      end
    else
      sql.Add(format(' = ''%s'')',[trim(edit1.Text)]));
    open;
    end;
  if ADOQuery1.RecordCount<1 then
    showmessage('该用户不存在!请确认是否输入正确!');
end;

procedure Tusers.Button3Click(Sender: TObject);
begin
  if qx=false then
    begin
    showmessage('您没有权限修改此用户!');
    end
  else if application.MessageBox('确定删除吗此用户吗?','警告',1)=1 then
    adoquery1.Delete;
  adoquery1.Close;
  adoquery1.Open;  
end;

procedure Tusers.Button2Click(Sender: TObject);
begin
  if qx=false then
    begin
    showmessage('您没有权限修改此用户!');
    end
  else if application.MessageBox('确定修改此用户吗?','警告',1)=1 then
    adoquery1.Post;
  adoquery1.Close;
  adoquery1.Open;
end;

procedure Tusers.Button4Click(Sender: TObject);
begin
  users.Close;
  main.Show;
end;



end.