Play frame RawSql how can I getTotalPage

Question

我使用Play 2.2.6。我想用RawSql得到'getTotalPageCount‘，但我总是得到一页记录。代码如下：

   String sql = "select "
            + "a.id as id ,"
            + "b.name as computerType ,"
            + "a.buy_time as buyTime ,"
            + "a.user_name as userName, "
            + "a.if_use as ifUse from computer a left join computer_type b on a.computer_type = b.code where 1=1 ";

    if(StringUtil.StringNoEmpty(vo.userName)){
        sql += " and a.user_name like '%"+vo.userName+"%'";
    }

    if(StringUtil.StringNoEmpty(vo.computerType)){
        sql += " and a.computer_type = '"+vo.computerType+"'";
    }
    if(null!=vo.startTime){         
        String startTime = DateUtil.formate.format(vo.startTime);
        sql += " and a.buy_time >= '"+startTime+"'";
    }

    if(null!=vo.endTime){
        String endTime = DateUtil.formate.format(vo.endTime);
        sql += " and a.buy_time <= '"+endTime+"'";
    }

    if(StringUtil.StringNoEmpty(vo.ifUse)){
        if("on".equals(vo.ifUse)){
            sql += " and a.if_use ='1' ";
        }else if("off".equals(vo.ifUse)){
            sql += " and a.if_use = '0'";
        }
    }

    RawSql rawSql = RawSqlBuilder.parse(sql).create();

    Query<ResultComputer> query = Ebean.find(ResultComputer.class).order("id");
    query.setRawSql(rawSql);

    Page<ResultComputer> page = query.findPagingList(10).setFetchAhead(false).getPage(0);
    Logger.debug(page.getTotalPageCount()+""); // result  1.

但是我的数据库有一千条记录。我认为"page.getTotalPageCount()“应该是100页的记录。我的错误在哪里？

Answer 1

public int getTotalPageCount();

返回给定页面位置(从0开始)的pages.Since总数getPage(0)，它返回1。getPage(0)-Return页面。如果您想要总页数:在获取的pagingList上执行getTotalPageCount();。