public PaginationRsp<Node> pageSelect(NodePaginationReq request) {
        PaginationRsp<Node> response = new PaginationRsp<Node>();

        Long results = new SelectSql(getSqlTemplate())
                .select()
                .columns("count(1)")
                .from()
                .table(getTableName())
                .whereSql(buildWhereSql(request))
                .single();
        response.setResults(results.intValue());

        if (results > 0) {
            List<Node> nodes = search(request);
            response.setRows(nodes);
        }
        return response;
    }
@author Robert HG (254963746@qq.com) on 6/6/15.
lts-admin/src/main/java/com/github/ltsopensource/admin/access/memory/NodeMemCacheAccess.java