• mongodb spring anno 查询


    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();
            }
  • 相关阅读:
    div嵌套出现的样式问题
    知乎最多支持答案的黄色渐隐效果
    对话框图形的css实现方式
    排序算法的相关问题
    数据库优化
    常用的Java基本代码汇总
    浅谈getStackTrace()方法(一)
    ECharts学习总结(三)-----基本概念分析
    ECharts学习总结(二)-----图表组件漏斗图(funnel)
    Echarts学习总结(一)-----柱状图
  • 原文地址:https://www.cnblogs.com/solq/p/2742390.html
Copyright © 2020-2023  润新知