Bu mesaj ekinde kabaca bir taslak ekledim, üzerine kat çıkarsınız.
İndirmeden incelemek isterseniz burada da açık halini paylaşayım.
Pratik örnek olsun diye SQLite veritabanı kullanıldı.
Forma sadece 1 adet Button 1 adet TListView bırakmanız kafi. Ayarlamaları kod içerisinden yapılır. İlave işleme lüzum yok.
Bir adet event örneği de ilave ettim, veritabanı hareketlerinden ana proje ile haberleşmek için kullanmaya örnek.
Kayıt seçimi yapıldığında projenin formunun caption'unda ilk field değeri belirir.
Bunu testlerinizde işlem süresince tetiklenmeyecek şekilde evrimleştirmelisiniz.
DBListViewU (sınıf içeren unit)
unit DBListViewU;
interface
Uses
Vcl.ComCtrls, Data.DB,
System.SysUtils, System.Classes, System.Types;
type
TBizimEvent = procedure(Sender: TObject; Text: String) of object;
TDBListView = class (TObject)
private
FListView : Vcl.ComCtrls. TListView;
FDataSet : Data.DB. TDataset;
FBizimEvent : TBizimEvent;
procedure DoOnSelectItem(Sender: TObject; Item: TListItem;
Selected: Boolean);
public
constructor Create( aListView: TListView );
destructor Destroy; override;
property DataSet : TDataSet read FDataSet write FDataSet;
procedure FetchData;
property OnBizimEvent: TBizimEvent read FBizimEvent write FBizimEvent;
end;
implementation
{ TDBListView }
constructor TDBListView.Create(aListView: TListView);
begin
inherited Create;
FListView := aListview;
FListView.ViewStyle := TViewStyle.vsReport;
end;
destructor TDBListView.Destroy;
begin
inherited;
end;
procedure TDBListView.DoOnSelectItem(Sender: TObject; Item: TListItem;
Selected: Boolean);
begin
if assigned(FBizimEvent)
then
FBizimEvent( self, Item.SubItems[0] );
end;
procedure TDBListView.FetchData;
var
i : Integer;
begin
if ( FDataSet = nil ) or (NOT FDataSet.Active)
then
exit;
FListView.Items.Clear;
FListView.Columns.Clear;
FListView.RowSelect := true;
FListView.ReadOnly := true;
FListView.OnSelectItem := DoOnSelectItem;
FListView.Columns.BeginUpdate;
with FListView.Columns.Add do
begin
Caption := '*';
Width := 80;
end;
for i := 0 to FDataSet.FieldDefList.Count-1
do
begin
with FListView.Columns.Add do
begin
Caption := FDataSet.FieldDefList[i].Name;
Width := 100;
end;
end;
FListView.Columns.EndUpdate;
FListView.Items.BeginUpdate;
FDataSet.First;
while NOT FDataSet.EOF do
begin
With FListView.Items.Add do
begin
Caption := '*';
for i := 0 to FDataSet.FieldDefList.Count-1
do
begin
SubItems.Add( FDataSet.Fields[i].Value );
end;
end;
FDataSet.Next;
end;
FListView.Items.EndUpdate;
end;
end.
Unit1
uses
DBListViewU,
Data.DB,
FireDAC.Stan.Intf,
FireDAC.UI.Intf,
FireDAC.VCLUI.Wait, {FDGUIxWaitCursor.Provider := 'VCL'}
FireDAC.Comp.UI,
FireDAC.Comp.Client,
FireDAC.DApt,
FireDAC.Stan.Param,
FireDAC.Stan.Def,
FireDAC.Stan.Async,
FireDAC.Phys.Intf,
FireDAC.Phys.SQLiteWrapper.Stat,
FireDAC.Phys.SQLite;
Var
FDBListView : TDBListView;
FDPhysSQLiteDriverLink : TFDPhysSQLiteDriverLink;
FDGUIxAsyncExecuteDialog : TFDGUIxAsyncExecuteDialog;
FDBFileName : String;
FFDConnection : TFDConnection;
FFDQuery : TFDQuery;
FDataSource : TDatasource;
procedure TForm1.DB_Prepare( dbName: String = '.\dbSqlite.db' );
var
LSQL : string;
i : Integer;
begin
FDBFileName := dbName;
if NOT DirectoryExists ( ExtractFilePath(FDBFileName))
then ForceDirectories( ExtractFilePath(FDBFileName) );
if NOT Assigned(FFDConnection) then
begin
FDPhysSQLiteDriverLink := TFDPhysSQLiteDriverLink.Create(nil);
FDPhysSQLiteDriverLink.DriverID := 'SQLite';
FDGUIxAsyncExecuteDialog := TFDGUIxAsyncExecuteDialog.Create(nil);
FFDConnection := TFDConnection.Create( nil );
FFDConnection.Params.Values['DriverID'] := 'SQLite';
FFDConnection.Params.Values['database'] := FDBFileName;
FFDQuery := TFDQuery.Create( nil );
FFDQuery.Connection := FFDConnection;
FDataSource := TDataSource.Create(nil);
FDataSource.DataSet := FFDQuery;
end;
if NOT FileExists( FDBFileName ) then
begin
try
FFDQuery.SQL.Text := ''
+ sLineBreak + 'CREATE TABLE [kisiler] ( '
+ sLineBreak + ' id INTEGER PRIMARY KEY, '
+ sLineBreak + ' Field_00 VARCHAR(64), '
+ sLineBreak + ' Field_01 INTEGER, '
+ sLineBreak + ' Field_02 INTEGER, '
+ sLineBreak + ' Field_03 INTEGER, '
+ sLineBreak + ' Field_04 INTEGER, '
+ sLineBreak + ' Field_05 INTEGER, '
+ sLineBreak + ' Field_06 INTEGER, '
+ sLineBreak + ' Field_07 INTEGER, '
+ sLineBreak + ' Field_08 INTEGER, '
+ sLineBreak + ' Field_09 INTEGER, '
+ sLineBreak + ' Field_10 INTEGER, '
+ sLineBreak + ' Field_11 INTEGER, '
+ sLineBreak + ' Field_12 INTEGER, '
+ sLineBreak + ' Field_13 INTEGER, '
+ sLineBreak + ' Field_14 INTEGER '
+ sLineBreak + '); '
;
try
FFDQuery.ExecSQL;
except
Showmessage('CREATE Edilemedi...' );
Exit;
end;
// SQL INSERT(s)
LSQL := ''
+ sLineBreak + 'INSERT INTO kisiler '
+ sLineBreak + ' ( '
+ sLineBreak + ' Field_00, Field_01, Field_02, Field_03, Field_04, '
+ sLineBreak + ' Field_05, Field_06, Field_07, Field_08, Field_09, '
+ sLineBreak + ' Field_10, Field_11, Field_12, Field_13, Field_14 '
+ sLineBreak + ' ) '
+ sLineBreak + ' VALUES ';
for i := 1 to 1000 do
begin // 1000 adet kayıt girilecek...
LSQL := LSQL
+ sLineBreak + '(''Karataş'',01,02,03,04,05,06,07,08,09,10,11,12,13,14),'
;
end;
System.Delete(LSQL, Length(LSQL), 1); // sondaki virgülü sil...
FFDQuery.SQL.Text := LSQL;
try
FFDQuery.ExecSQL;
except
Showmessage('INSERT Edilemedi...' );
Exit;
end;
FFDConnection.Commit;
except
Showmessage('Veritabanı sorunu...' );
Exit;
end;
end;
end;
procedure TForm1.FreeResources;
begin
if Assigned(FFDConnection) then
begin
FFDQuery.Active := false;
FFDConnection.Connected := false;
FreeAndNil(FDataSource);
FreeAndNil(FFDConnection);
FreeAndNil(FFDQuery);
FreeAndNil(FDPhysSQLiteDriverLink);
FreeAndNil(FDGUIxAsyncExecuteDialog);
end;
end;
procedure TForm1.FormCreate(Sender: TObject);
begin
ReportMemoryLeaksOnShutdown := true;
end;
procedure TForm1.FormClose(Sender: TObject; var Action: TCloseAction);
begin
FreeResources();
if Assigned(FDBListView)
then
FreeAndNil(FDBListView);
end;
procedure TForm1.DoBizimEvent(Sender: TObject; Text: String);
begin
Form1.Caption := Text;
end;
procedure TForm1.BitBtn1Click(Sender: TObject);
begin
DB_Prepare();
if NOT Assigned(FDBListView) then
begin
FDBListView := TDBListView.Create(ListView1);
FDBListView.OnBizimEvent := DoBizimEvent;
end;
FFDQuery.SQL.Text := 'SELECT * from kisiler';
FFDQuery.Active := true;
FDBListView.DataSet := FFDQuery;
FDBListView.FetchData();
end;