|
看了access的分页,没明白连着3个order by id什么意思?
谢谢!
import access;
import console;
//创建数据库
var db = access("/test.mdb")
//创建表
if(!db.existsTable("tbl") ){
db.exec("CREATE TABLE tbl (id AUTOINCREMENT PRIMARY KEY, comment char(20))")
}
import console
//插入测试数据
for(i=1;100;1){
db.exec("INSERT INTO tbl(comment) VALUES('%d')",i);
}
//分页大小
var pagesize = 10;
for( page=1;10 ){
for(rs,fields in db.each("select * from (
select top " + pagesize + " * from (select top " + pagesize * page + " * from tbl order by id desc) order by id
) order by id desc") ){
console.log( rs("id").value,rs("comment").value )
console.more( 10 ) //分页显示
}
}
//删除表
db.exec("DROP TABLE tbl")
//关闭数据库连接
db.close();
|
|