maxthin.pas

一个很简单的三层数据库程序,包括毕业论文, 因为简单,所以容易供参考学习!

unit maxthin;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Grids, DBGrids;

type
  TFm_maxindex = class(TForm)
    Edit2: TEdit;
    Edit3: TEdit;
    Label3: TLabel;
    Label2: TLabel;
    Label1: TLabel;
    Edit1: TEdit;
    DBGrid1: TDBGrid;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    procedure Edit3Click(Sender: TObject);
    procedure Edit2Click(Sender: TObject);
    procedure Edit1Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Fm_maxindex: TFm_maxindex;
  sql:string;
implementation

uses data;

{$R *.dfm}

procedure TFm_maxindex.Edit3Click(Sender: TObject);
begin
  edit1.Text:='';
  edit2.Text:='';
  edit1.Color:=clGray;
  edit2.Color:=clGray;
  edit3.Color:=clAqua;
  button1.Enabled:=false;
  button2.Enabled:=false;
  button3.Enabled:=true;
end;

procedure TFm_maxindex.Edit2Click(Sender: TObject);
begin
  edit1.Text:='';
  edit3.Text:='';
  edit1.Color:=clGray;
  edit2.Color:=clAqua;
  edit3.Color:=clGray;
  button1.Enabled:=false;
  button2.Enabled:=true;
  button3.Enabled:=false;
end;

procedure TFm_maxindex.Edit1Click(Sender: TObject);
begin
  edit2.Text:='';
  edit3.Text:='';
  edit1.Color:=clAqua;
  edit2.Color:=clGray;
  edit3.Color:=clGray;
  button1.Enabled:=true;
  button2.Enabled:=false;
  button3.Enabled:=false;
end;

procedure TFm_maxindex.Button1Click(Sender: TObject);
begin
   sql:='select * from book where bookname like '+'''%'+edit1.Text+'%''';
   fm_data.Cd_book.Close;
   fm_data.Cd_book.CommandText:=sql;
   fm_data.Cd_book.Execute;
   fm_data.Cd_book.Open;
end;

procedure TFm_maxindex.Button2Click(Sender: TObject);
begin
   sql:='select * from mag where auther like '+'''%'+edit1.Text+'%''';
   fm_data.Cd_book.Close;
   fm_data.Cd_book.CommandText:=sql;
   fm_data.Cd_book.Execute;
   fm_data.Cd_book.Open;
end;

procedure TFm_maxindex.Button3Click(Sender: TObject);
begin
   sql:='select * from mag where publish like '+'''%'+edit1.Text+'%''';
   fm_data.Cd_book.Close;
   fm_data.Cd_book.CommandText:=sql;
   fm_data.Cd_book.Execute;
   fm_data.Cd_book.Open;
end;

end.


//此源码由程序太平洋收集整理发布,任何人都可自由转载,但需保留本站信息
//╭⌒╮┅~ ¤　欢迎光临程序太平洋╭⌒╮
//╭⌒╭⌒╮╭⌒╮～╭⌒╮  ︶  ,︶︶
//,︶︶︶︶,''︶~~ ,''~︶︶　 ,''
//╔　╱◥███◣═╬╬╬╬╬╬╬╬╬╗
//╬ ︱田︱田 田 ︱　　　　　　　　　 ╬
//╬　　　　　　　http://www.5ivb.net ╬
//╬　 ╭○╮●　                   　╬
//╬　　/■\/■\　　                  ╬
//╬　　 <|　||　   有希望,就有成功！ ╬
//╬　　　　　　　　　　　　　　　　　╬
//╚╬╬╬╬╬╬╬╬╬╬╗  ╔╬╬╬╬╝
//
//说明：
//专业提供VB、．NET、Delphi、ASP、PB源码下载
//包括:程序源码,控件,商业源码,系统方案，开发工具，书籍教程，技术文档