带有with语句的分页

sql = "with xxx as (sql) select * from xxx";

Page<Record> page = Db.(pageNumberpageSizeselect count(*) from"sql)

报错:java.sql.SQLSyntaxErrorException: Unknown table 'xxx'


评论区

Freak

2019-11-15 16:30

Db.paginateByFullSql(pageNumber,pageSize,countsql,sql);

JFinal

2019-11-17 15:55

@Freak 有关分页的问题,一定要先看文档,了解了原理,再解决就很容易:
https://www.jfinal.com/doc/5-6

热门反馈

扫码入社