mongodb spring anno 查询

最新推荐文章于 2025-09-07 20:32:33 发布

转载最新推荐文章于 2025-09-07 20:32:33 发布 · 64 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/solq/archive/2012/10/27/2742390.html

文章标签：

#java #数据库

本文介绍了一个基于MongoDB的LogTaskBuilderRepository接口实现多种查询的方法，包括使用@Query注解进行复杂查询、正则表达式匹配及日期筛选等，并展示了如何通过findBy{字段}

public interface LogTaskBuilderRepository extends MongoRepository<LogTaskBuilder, String>  {

    @Query(value="{ 'type': {'$in' : ?0} }",fields="{ 'type' : 1}")
    public List<LogTaskBuilder> findTest(String[] name);
        
    @Query(value="{?0:?1}")  
    public List<LogTaskBuilder> findTest2(Object field,Object Value);
    
    //正则测试
    @Query(value="{ 'type' :{'$regex' :?0, '$options': 'i'} }")    
    public List<LogTaskBuilder> findTest3(String name); 
    
    //日期查询

    @Query(value="{ 'executeDate' :{'$gt' : ?0 } }")    
    public List<LogTaskBuilder> findTest4(Date date);  
    
    //内部查询 findBy{字段}{条件}
    public List<LogTaskBuilder> findByTypeLike(String name); 
    public List<LogTaskBuilder> findByTypeLike(String name, Sort sort); 
    public List<LogTaskBuilder> findByTypeLike(String name, Pageable pageable); 
    
}

public class LogTaskBuilder {

@Id
private String name;

private RecordType type; 
private Date executeDate;

}

test

System.out.println(logTaskBuilderRepository.findByTypeLike("SoulRecord").size());
        System.out.println(logTaskBuilderRepository.findTest3("Record").size());
        System.out.println(logTaskBuilderRepository.findByTypeLike("Record",new Sort("type", Order.DESCENDING)).size());
        
        System.out.println(logTaskBuilderRepository.findTest(new String[]{"SoulRecord","ItemRecord"}).size());
        System.out.println(logTaskBuilderRepository.findTest2("name","SoulRecord").size());
        
        DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
        
        try {
            System.out.println(logTaskBuilderRepository.findTest4(dateFormat.parse("2012-10-26")).size());
        } catch (ParseException e) {
            e.printStackTrace();
        }