例用AdoQuery分页

王朝delphi·作者佚名  2006-01-08
窄屏简体版  字體: |||超大  

今晚在CSDN论坛上看到一个网友在问分页,就随便写了一段代码,如有不当之处,还请见谅。

首先在窗体上放个listview,两个button,一个label,一个adoquery,一个adoconnection

然后用adoconnection建立一个连接

unit Unit1;

interface

uses

Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,

Dialogs, DB, ADODB,Grids, DBGrids, StdCtrls, ComCtrls;

type

TForm1 = class(TForm)

Button1: TButton;

ADOConnection1: TADOConnection;

ADOQuery1: TADOQuery;

ListView1: TListView;

Label1: TLabel;

Button2: TButton;

procedure FormCreate(Sender: TObject);

procedure Button1Click(Sender: TObject);

procedure Button2Click(Sender: TObject);

private

{ Private declarations }

procedure Page_Count;

public

{ Public declarations }

end;

var

Form1: TForm1;

page: integer;

implementation

{$R *.dfm}

procedure TForm1.FormCreate(Sender: TObject);

var

ListItem:TListItem;

i:integer;

begin

with AdoConnection1 do

begin

ConnectionString := '连接串';

open();

end;

Page := 0;

end;

procedure TForm1.Page_Count;

var

i:integer;

ListItem:TListItem;

begin

ListView1.Clear;

with AdoQuery1 do

begin

Connection := AdoConnection1;

sql.Clear;

sql.Add('select a,b from tmplive');

open;

if Page = 0 then Page := 1;

if Page > RecordSet.RecordCount then page := RecordSet.RecordCount;

Recordset.PageSize := 10;

RecordSet.AbsolutePage := Page;

for i:= 1 to Recordset.PageSize do

begin

ListItem := ListView1.Items.Add;

ListItem.SubItems.Add(RecordSet.Fields.Item[0].value);

ListItem.SubItems.Add(RecordSet.Fields.Item[1].Value);

Next;

if RecordSet.EOF then exit;

end;

end;

end;

procedure TForm1.Button1Click(Sender: TObject);

begin

Page := Page+1;

Page_Count;

Label1.Caption := IntToStr(Page);

end;

procedure TForm1.Button2Click(Sender: TObject);

begin

Page := Page -1;

Page_Count;

Label1.Caption := IntToStr(Page);

end;

end.

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有  導航