mongoDB使用复杂查询写法

package com.leave.mos.controller.simple;

import com.leave.mos.constant.TablenameConstant;
import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.data.mongodb.core.query.Criteria;
import org.springframework.data.mongodb.core.query.Query;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.util.List;
import java.util.Map;
import java.util.regex.Pattern;


@RestController
@RequestMapping("logica")
public class LogicalQueryOperatorsController {

    @Resource
    private MongoTemplate mongoTemplate;

    
    @RequestMapping("and")
    public List and(){

        //{ "orderCode" : "order_10002", "$and" : [{ "orderCode" : { "$exists" : true}}]}
        Criteria c = new Criteria(TablenameConstant.goods_order.orderCode);
        c.is("order_10002");
        c.andOperator(Criteria.where(TablenameConstant.goods_order.orderCode).exists(true));
        Query query = new Query(c);

        List maps = mongoTemplate.find(query,Map.class, TablenameConstant.goods_order.TableName);
        return maps;
    }

    @RequestMapping("and1")
    public List and1(){

        //{ "orderCode" : "order_10002", "$and" : [{ "orderCode" : { "$exists" : true}}]}
        Criteria c = new Criteria(TablenameConstant.goods_order.orderCode);
        c.is("order_10002");
        Criteria c1 = Criteria.where(TablenameConstant.goods_order.orderCode).exists(true);
        Query query = new Query();
        query.addCriteria(c);
        query.addCriteria(c1);

        List maps = mongoTemplate.find(query,Map.class, TablenameConstant.goods_order.TableName);
        return maps;
    }

    @RequestMapping("and2")
    public List and2(){

        //{ "status" : { "$lt" : 2}, "$and" : [{ "boxUnitPrice" : 209}]}
        Criteria criteria = Criteria.where(TablenameConstant.goods_order.status).lt(2);
        criteria.andOperator(Criteria.where(TablenameConstant.goods_order.boxUnitPrice).is(209));

        Query query = new Query();
        query.addCriteria(criteria);//.addCriteria(criteria1);

        List maps = mongoTemplate.find(query,Map.class, TablenameConstant.goods_order.TableName);
        return maps;
    }


    
    @RequestMapping("not")
    public List not(){

        // Criteria criteria = Criteria.where(TablenameConstant.goods_order.status).lt(2).not();
        //not 要放到操作符的前面
        Criteria criteria = Criteria.where(TablenameConstant.goods_order.status).not().lt(2);

        Query query = new Query();
        query.addCriteria(criteria);

        List maps = mongoTemplate.find(query,Map.class, TablenameConstant.goods_order.TableName);
        return maps;
    }

    static final String pa = Pattern.compile("^order.*").pattern();

    @RequestMapping("not1")
    public List not1(){
        //正则表达式
        Criteria criteria = Criteria.where(TablenameConstant.goods_order.orderCode).regex(pa).not();

        Query query = new Query();
        query.addCriteria(criteria);

        List maps = mongoTemplate.find(query,Map.class, TablenameConstant.goods_order.TableName);
        return maps;
    }


    //$norNOR对一个或多个查询表达式的数组执行逻辑运算，并选择 数组中所有查询表达式失败的文档
    @RequestMapping("nor")
    public List nor(){
        // { "orderCode" : "order_100011", "$nor" : [{ "status" : 2}]}
        Criteria criteria = Criteria.where(TablenameConstant.goods_order.orderCode).is("order_100011")
                .norOperator(Criteria.where(TablenameConstant.goods_order.status).is(2));

        Query query = new Query();
        query.addCriteria(criteria);

        List maps = mongoTemplate.find(query,Map.class, TablenameConstant.goods_order.TableName);
        return maps;
    }

    @RequestMapping("nor1")
    public List nor1(){
        // orderCode 存在 并且 等于 order_100011
        Criteria criteria = Criteria.where(TablenameConstant.goods_order.orderCode).is("order_100011")
                .norOperator(Criteria.where(TablenameConstant.goods_order.orderCode).exists(false));

        Query query = new Query();
        query.addCriteria(criteria);

        List maps = mongoTemplate.find(query,Map.class, TablenameConstant.goods_order.TableName);
        return maps;
    }


    
    @RequestMapping("or")
    public List or(){

        //{ "$or" : [{ "orderName" : "新订单3"}, { "status" : { "$gte" : 2}}]}
        Criteria criteria1 = new Criteria().orOperator(
                Criteria.where(TablenameConstant.goods_order.orderName).is("新订单3"),
                Criteria.where(TablenameConstant.goods_order.status).gte(2)
        );
        Query query = new Query();
        query.addCriteria(criteria1);

        List maps = mongoTemplate.find(query,Map.class, TablenameConstant.goods_order.TableName);
        return maps;
    }
}
mongoDB使用复杂查询写法

Java相关栏目本月热门文章
