JDO分页问题

Question

我有一个用 26 个实体填充数据存储的单元测试。我有一个 DAO 试图检索这些实体并翻阅它们，但不知何故我无法让它完全工作。如果我执行query.setRange(0,10)，它会起作用，但不适用于query.setRange(10,20)。即使单元测试显示我有 26 个实体，查询也会返回 0 个结果。

public void testGetModulesWithPagination(){     
    String current_user="currentUser";
    String tags[] = {"football","soccer"};

    for (int i=0;i<=25;i++){
        Module m = new Module();
        m.setOwner("myName");
        m.setObjective("m"+i+" objective");
        m.setTitle("m"+i);
        m.setTags(tags);
        dao.insert(m);
    }
    Query query = new Query(Module.class.getSimpleName());
    List<Module> modules_page_one = dao.getModules(current_user,"football", "1");
    List<Module> modules_page_two = dao.getModules(current_user,"football","2");

    assertEquals(26, DatastoreServiceFactory.getDatastoreService().prepare(query).countEntities());
    assertNotNull(modules_page_one);
    assertEquals(10,modules_page_one.size());
    assertNotNull(modules_page_two);
    assertEquals(10,modules_page_two.size()); //FAILS here
    assertFalse(modules_page_one.equals(modules_page_two));
}       

这是我的 dao 实现

public List<Module> getModules(String owner,String tag,String page){
    getPm();
    String queryString = "select from "+Module.class.getName()+" where owner!='"+owner
        +"'";
    Query query = pm.newQuery(queryString);

    Long pageNumber = Long.parseLong(page);
    Long lower_bound = pageNumber*10-10;
    Long upper_bound = pageNumber*10;

    log.info("pageNumber "+pageNumber);
    log.info("lower_bound "+lower_bound);
    log.info("upper_bound "+upper_bound);

    query.setRange(lower_bound, upper_bound);
    List<Module> modules = (List<Module>) pm.detachCopyAll((List<Module>) query.execute());
    log.info("modules results size "+modules.size());
    log.info(modules+"");
    List<Module> search_results = new ArrayList<Module>();
    for (Module module:modules){
        String module_tags[] = module.getTags();
        for (int i=0;i<module_tags.length;i++){
            if (module_tags[i].equals(tag)){
                search_results.add(module);
                continue;
            }
        }
    }
    closePm();
    return search_results;
}

Answer 1

抱歉，但

String queryString = "select from "+Module.class.getName()+" where owner!='"+owner+"'";

不应该这样

String queryString = "select from "+Module.class.getName()+" where owner != '"+owner+"'";

？

只是检查。