unit8.pas

用DELPHI做的一个歌手评分系统

unit Unit8;

interface

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

type
  TForm8 = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    ADOQuery1: TADOQuery;
    ADOConnection1: TADOConnection;
    XPManifest1: TXPManifest;
    procedure Button3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form8: TForm8;

implementation

{$R *.dfm}

procedure TForm8.Button3Click(Sender: TObject);
begin
form8.Close;
end;

procedure TForm8.Button2Click(Sender: TObject);
begin
if edit1.text='' then
begin
showmessage('用户名不能为空！');
edit1.SetFocus;
exit;
end;
if edit2.text='' then
begin
showmessage('密码不能为空！');
edit2.setfocus;
exit;
end
else
if edit2.text<>edit3.Text then
begin
showmessage('输入密码不匹配，请重新输入！');
edit2.Clear;
edit3.Clear;
edit2.SetFocus;
exit;
end;
if (edit2.text<>'') and (edit2.text=edit3.Text) then
begin
 if edit1.text<>'' then
 begin
 with adoquery1 do
 begin
 adoquery1.Close;
 adoquery1.SQL.Clear;
 adoquery1.SQL.Add('insert into 系统登录(passname,password,Email,sex,QQ) values(:a,:b,:c,:d,:e)');
 parameters.parambyname('a').value:=trim(edit1.text);
 parameters.parambyname('b').value:=trim(edit2.text);
 parameters.parambyname('c').value:=trim(edit4.text);
 parameters.parambyname('d').value:=trim(edit5.text);
 parameters.parambyname('e').value:=trim(edit6.text);
 adoquery1.execsql;
 showmessage('注册成功！');
 end;
 end;
end;
end;
procedure TForm8.Button1Click(Sender: TObject);
begin
if edit1.text<>'' then
begin
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.sql.Add('select * from 系统登录 where passname='''+trim(edit1.text)+'''');
adoquery1.Open;
if adoquery1.recordcount=0 then
begin
showmessage('该用户名可用！');
edit2.SetFocus;
exit;
end
else
showmessage('该用户名已被占用！');
edit1.SetFocus;
end
else
showmessage('用户名不能为空！');
edit1.SetFocus;
end;
end.