mongodb 查询

最新推荐文章于 2024-07-15 03:29:12 发布

rzrenyu

最新推荐文章于 2024-07-15 03:29:12 发布

阅读量171

点赞数

文章标签： mongodb

本文链接：https://blog.csdn.net/rzrenyu/article/details/79871518

版权

1、等于

final UnionDao db = getDb();
		final Query<UnionEntity> query = db.createQuery();
		if(unionId!=0L){
			query.filter("unionId = ", unionId);
		}

2、不等于

final HallUserDao db = getDb();
        final Query<HallUserEntity> query = db.createQuery().filter("id_card != ", "")

.filter("id_card != ", null).offset(entity.getPageNow()).limit(entity.getPageSize());
        return query.asList();

3、in和大于小于

    public static long queryUnionTradeLogsCount(AoBoUnionTradeLogModel model) {
        final UnionTradeLogDao db = getDb();
        Query<UnionTradeLogEntity> query = db.createQuery();
        if (null != model.getUnion_id()) {
            query.filter("unionId = ", model.getUnion_id());
        }
        if (null != model.getSend_rid()) {
            query.filter("send_rid = ", model.getSend_rid());
        }
        if (null != model.getReceive_rid()) {
            query.filter("receive_rid = ", model.getReceive_rid());
        }
        if (null != model.getBegindate()) {
            query.filter("send_time > ", model.getBegindate());
        }
        if (null != model.getEnddate()) {
            query.filter("send_time < ", model.getEnddate());
        }
        String many_rid = model.getMany_rid();
        if (!StringUtils.isEmpty(many_rid)) {
            BasicDBList values = new BasicDBList();
            many_rid = many_rid.replaceAll(",", "#");
            if (!many_rid.contains("#")) {
                many_rid = many_rid + "#";
            }
            String[] int_array = many_rid.split("#");
            for (String str : int_array) {
                if (!StringUtils.isEmpty(str)) {
                    values.add(Integer.valueOf(str));
                }
            }
            BasicDBObject in = new BasicDBObject("$in", values);
            query.filter("send_rid", in);
        }

        return query.countAll();
    }