Limit Results Number in javax.jdo.Query

2019-04-15 03:16发布

I would like to know how can I limit the results number with a javax.jdo.Query
I have tried with setRange function without success.
This is my current workaround

Object query_result = q.execute(locationId);
if(query_result!=null && ((List<BaseObject>) query_result).size()>0)
    return (PokerSession) ((List<BaseObject>) query_result).get(0);
return null; 

1条回答
狗以群分
2楼-- · 2019-04-15 03:49
    Query query = pm.newQuery(PokerSession.class);
    query.setFilter("locationId == plocationId"); // My asumption. need to change accoring to your field name.
    query.declareParameters("String plocationId"); //Again my asumption put here correct data type

    /* Here x is startIndex and y is end index
     * For example if you want to start from 10 and want to get 50 records 
     * you put x=9 (index are zero based) and  y = x + 50 
     */
    query.setRange(x, y); 

    List<PokerSession>) query_result = q.execute(locationId);
    if(!query_result.isEmpty())
        return query_result.get(0);
    return null
查看更多
登录 后发表回答