database.pas

一套DELPHI北京公交车查询系统源码

unit database;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  DBCtrls, Grids, DBGrids, Db, DBTables, StdCtrls, ExtCtrls, Buttons;

type
  TForm1 = class(TForm)
    Panel1: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Button1: TButton;
    Button2: TButton;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    Query1: TQuery;
    BitBtn1: TBitBtn;
    Label3: TLabel;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.DFM}

procedure TForm1.Button1Click(Sender: TObject);
var
  sqlstr:string;
  s1,s2:string;
begin
  if (Edit1.Text<>'') and (Edit2.Text<>'') then
   begin
    s1:=Edit1.Text;
    s2:=Edit2.Text;
    sqlstr:='SELECT * FROM bus WHERE Router LIKE ''%'+s1+'%'' AND Router LIKE ''%'+s2+'%'';';
    query1.Close;
    query1.SQL.Clear;
    query1.SQL.Add(sqlstr);
    try
     query1.open;
    except
     query1.ExecSQL;
    end;
   end
  else
    showmessage('请同时输入开站和到站！');
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  edit1.Text:='';
  edit2.Text:='';
end;

procedure TForm1.FormCreate(Sender: TObject);
var
  sqlstr:string;
begin
  Application.Title :='data';
  sqlstr:='SELECT * FROM bus;';
  query1.Close;
  query1.SQL.Clear;
  query1.SQL.Add(sqlstr);
  try
   query1.open;
  except
   query1.ExecSQL;
  end;
end;

procedure TForm1.BitBtn1Click(Sender: TObject);
var
  sqlstr:string;
begin
  Application.Title :='data';
  sqlstr:='SELECT * FROM bus;';
  query1.Close;
  query1.SQL.Clear;
  query1.SQL.Add(sqlstr);
  try
   query1.open;
  except
   query1.ExecSQL;
  end;
end;

end.