aardio 范例: 虚表

//虚表
//相关范例：范例 / Windows 窗口 / 列表视图控件 / 虚表
//下面listview 控件的类名（cls属性）请改为 "vlistview"
import win.ui;
/*DSG{{*/
winform = win.form(text="虚表";right=805;bottom=610)
winform.add(
listview={cls="vlistview";left=27;top=17;right=778;bottom=564;db=1;dl=1;dr=1;dt=1;edge=1;z=1}
)
/*}}*/

winform.listview.insertColumn("网址", 200);
winform.listview.insertColumn("评论", 200);

//创建测试数据
import access;
var db = access("/test.mdb");
if (!db.existsTable("homepage2")) {
        db.exec("CREATE TABLE homepage2 (url char(30), comment char(20))");

        db.connection.BeginTrans();
        for (i = 1; 1000) {
                db.exec("INSERT INTO homepage2(url, comment) VALUES(@url,@comment)", {
                        url = "http://www.aardio.com";
                        comment = "字符串包含'单引号' " ++ i;
                });
        }
        db.connection.CommitTrans();
}

//查询数据
var rs = db.openRecordSet("SELECT * FROM homepage2", db.adOpenStatic);

//指定虚表行数
winform.listview.count =  rs.recordCount;

//数据库缓存表
var cacheTable = table.cache(
    function(row) {
        rs.Move(row - 1, 1/*_adBookmarkFirst*/); 

        //注意返回的数组是先列后行
        return rs.getRows(1,0/*_adBookmarkCurrent*/)
        //return rs.getRows(1,0/*_adBookmarkCurrent*/,{"url","comment"})
    }
);

//获取虚表项
winform.listview.onGetDispItem = function(item,row,col){
    return  {text=cacheTable[row][col][[1]]}; 
} 

winform.listview.onDestroy = function(){
    db.close();
}

winform.show();
win.loopMessage();

Markdown 格式