public List<Node> search(NodePaginationReq request) {

        SelectSql selectSql = new SelectSql(getSqlTemplate())
                .select()
                .all()
                .from()
                .table(getTableName())
                .whereSql(buildWhereSql(request));
        if (StringUtils.isNotEmpty(request.getField())) {
            selectSql.orderBy()
                    .column(CharacterUtils.camelCase2Underscore(request.getField()), OrderByType.convert(request.getDirection()));
        }
        return selectSql.limit(request.getStart(), request.getLimit())
                .list(RshHandler.NODE_LIST_RSH);
    }
@author Robert HG (254963746@qq.com) on 6/6/15.
lts-admin/src/main/java/com/github/ltsopensource/admin/access/memory/NodeMemCacheAccess.java