我惯用的是在funtion上加两个参数Begin_No and End_No,比如10个记录分一页的话想要第3页的记录,这两个参数值就是Begin_No=21 and End_No=30,当然这要判断数据库的记录数,下面是简单例子。public Vector List(.....,int Begin_No, int End_No) { SQL = "select * from table"; Vector lRtnVtr = new Vector();
try { ......sql execute...
for(i=Begin_No;i<End_No;i++) {
Item lItem = new Item(db.sql.element(i)); lRtnVtr.addElement(lItem);
{
SQL = "select * from table";
Vector lRtnVtr = new Vector();
try
{
......sql execute...
for(i=Begin_No;i<End_No;i++)
{
Item lItem = new Item(db.sql.element(i));
lRtnVtr.addElement(lItem);
}
return lRtnVtr;
.....db.colse.....
}
catch (SysExcpt e)
{
....
}
}