u_set.pas

sqllite3数据库基本应用(打开,关闭表,及更新数据表)

unit u_set;

interface

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

type
  TForm1 = class(TForm)
    Edit1: TEdit;
    DBGrid1: TDBGrid;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Edit2: TEdit;
    Button4: TButton;
    procedure FormShow(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

uses u_data1;

{$R *.dfm}

procedure TForm1.FormShow(Sender: TObject);
begin
with data.qmain do
begin
close;
sql.Clear;
sql.Add('select * from department order by departmentid');
open;
end;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
with data.qmain do
begin
close;
sql.Clear;
sql.Add('select * from department order by departmentid');
open;
end;
if trim(edit1.Text)='' then
begin
application.MessageBox('请输入初始化密码!','提示',0+64);
edit1.SetFocus;
end
else
begin
data.qmain.close;
data.qmain.sql.Clear;
data.qmain.sql.Add('update department set departmentpwd='''+edit1.Text+'''');
data.qmain.ExecSQL;

data.qmain.close;
data.qmain.sql.Clear;
data.qmain.sql.Add('select * from department order by departmentid');
data.qmain.Open;

application.MessageBox('初始化密码成功!','提示',0+64);
edit1.Clear;
end;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
with data.qmain do
begin
close;
sql.Clear;
sql.Add('delete from task');
execsql;

close;
sql.Clear;
sql.Add('delete from users');
execsql;

close;
sql.Clear;
sql.Add('delete from requestlist');
execsql;

close;
sql.Clear;
sql.Add('select * from department order by departmentid');
open;

application.MessageBox('初始化数据库成功!','提示',0+64)
end;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
dbgrid1.DataSource.DataSet.Delete;
end;

procedure TForm1.Button4Click(Sender: TObject);
begin
with data.qmain do
begin
close;
sql.Clear;
sql.Add('select * from department');
open;
end;
if trim(edit2.Text)='' then
begin
application.MessageBox('请输入车间名称!','提示',0+64);
edit2.SetFocus;
end
else
if data.qmain.Locate('departmentname',edit2.Text,[]) then
begin
application.MessageBox('此车间已经存在!','提示',0+64);
edit2.SetFocus;
end
else
with data.qmain do
begin
close;
sql.Clear;
sql.Add('insert into department(departmentname)');
sql.Add('values('''+edit2.Text+''')');
execsql;

close;
sql.Clear;
sql.Add('select * from department order by departmentid');
execsql;

end;
end;

end.