com.j256.ormlite.stmt.QueryBuilder.setWhere()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(11.7k)|赞(0)|评价(0)|浏览(118)

本文整理了Java中com.j256.ormlite.stmt.QueryBuilder.setWhere方法的一些代码示例，展示了QueryBuilder.setWhere的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。QueryBuilder.setWhere方法的具体详情如下：
包路径：com.j256.ormlite.stmt.QueryBuilder
类名称：QueryBuilder
方法名：setWhere

QueryBuilder.setWhere介绍

暂无

代码示例

代码示例来源：origin: stackoverflow.com

dao = getHelper().getUsuarioDao();
QueryBuilder queryBuilder = dao.queryBuilder();
queryBuilder.setCountOf(true);
queryBuilder.setWhere(queryBuilder.where().eq("name", "Joe Smith" ));
Long usuarios = dao.countOf(queryBuilder.prepare());
Log.d(TAG, "How much name by "Joe Smith" are:" + usuarios);

代码示例来源：origin: mycontroller-org/mycontroller

@Override
public List<SensorVariable> getAll(List<Integer> ids) {
  try {
    if (ids != null && !ids.isEmpty()) {
      QueryBuilder<SensorVariable, Integer> queryBuilder = this.getDao().queryBuilder();
      Where<SensorVariable, Integer> where = queryBuilder.where();
      where.in(SensorVariable.KEY_ID, ids);
      queryBuilder.setWhere(where);
      queryBuilder.orderBy(SensorVariable.KEY_PRIORITY, true);
      return queryBuilder.query();
    }
    return new ArrayList<SensorVariable>();
  } catch (SQLException ex) {
    _logger.error("unable to get all items ids:{}", ids, ex);
    throw new McDatabaseException(ex);
  }
}

代码示例来源：origin: org.mycontroller.standalone/mycontroller-core

@Override
public List<SensorVariable> getAll(List<Integer> ids) {
  try {
    if (ids != null && !ids.isEmpty()) {
      QueryBuilder<SensorVariable, Integer> queryBuilder = this.getDao().queryBuilder();
      Where<SensorVariable, Integer> where = queryBuilder.where();
      where.in(SensorVariable.KEY_ID, ids);
      queryBuilder.setWhere(where);
      queryBuilder.orderBy(SensorVariable.KEY_PRIORITY, true);
      return queryBuilder.query();
    }
    return new ArrayList<SensorVariable>();
  } catch (SQLException ex) {
    _logger.error("unable to get all items ids:{}", ids, ex);
    return null;
  }
}

代码示例来源：origin: org.mycontroller.standalone/mycontroller-core

public long countOf(HashMap<String, Object> columnValues) {
  try {
    QueryBuilder<Tdao, Tid> queryBuilder = this.getDao().queryBuilder();
    Where<Tdao, Tid> where = queryBuilder.where();
    int andCount = 0;
    for (String key : columnValues.keySet()) {
      if (columnValues.get(key) instanceof List<?>) {
        where.in(key, columnValues.get(key));
      } else {
        where.eq(key, columnValues.get(key));
      }
      andCount++;
    }
    if (andCount > 1) {
      where.and(andCount);
    }
    queryBuilder.setWhere(where);
    return queryBuilder.countOf();
  } catch (SQLException ex) {
    _logger.error("unable to get count for query, input[{}]", columnValues, ex);
  }
  return 0;
}

代码示例来源：origin: mycontroller-org/mycontroller

public long countOf(HashMap<String, Object> columnValues) {
  try {
    QueryBuilder<Tdao, Tid> queryBuilder = this.getDao().queryBuilder();
    Where<Tdao, Tid> where = queryBuilder.where();
    int andCount = 0;
    for (String key : columnValues.keySet()) {
      if (columnValues.get(key) instanceof List<?>) {
        where.in(key, columnValues.get(key));
      } else {
        where.eq(key, columnValues.get(key));
      }
      andCount++;
    }
    if (andCount > 1) {
      where.and(andCount);
    }
    queryBuilder.setWhere(where);
    return queryBuilder.countOf();
  } catch (SQLException ex) {
    _logger.error("unable to get count for query, input[{}]", columnValues, ex);
    throw new McDatabaseException(ex);
  }
}

代码示例来源：origin: org.mycontroller.standalone/mycontroller-core

@Override
public Room getByNameAndParentId(String name, Integer parentId) {
  try {
    QueryBuilder<Room, Integer> queryBuilder = this.getDao().queryBuilder();
    Where<Room, Integer> where = queryBuilder.where();
    int whereCount = 0;
    where.eq(Room.KEY_NAME, name);
    whereCount++;
    if (parentId == null) {
      where.isNull(Room.KEY_PARENT_ID);
    } else {
      where.eq(Room.KEY_PARENT_ID, parentId);
    }
    whereCount++;
    where.and(whereCount);
    queryBuilder.setWhere(where);
    List<Room> rooms = queryBuilder.query();
    if (rooms != null && !rooms.isEmpty()) {
      return rooms.get(0);
    }
  } catch (SQLException ex) {
    _logger.error("unable to get room", ex);
  }
  return null;
}

代码示例来源：origin: mycontroller-org/mycontroller

@Override
public Room getByNameAndParentId(String name, Integer parentId) {
  try {
    QueryBuilder<Room, Integer> queryBuilder = this.getDao().queryBuilder();
    Where<Room, Integer> where = queryBuilder.where();
    int whereCount = 0;
    where.eq(Room.KEY_NAME, name);
    whereCount++;
    if (parentId == null) {
      where.isNull(Room.KEY_PARENT_ID);
    } else {
      where.eq(Room.KEY_PARENT_ID, parentId);
    }
    whereCount++;
    where.and(whereCount);
    queryBuilder.setWhere(where);
    List<Room> rooms = queryBuilder.query();
    if (rooms != null && !rooms.isEmpty()) {
      return rooms.get(0);
    }
  } catch (SQLException ex) {
    _logger.error("unable to get room", ex);
    throw new McDatabaseException(ex);
  }
  return null;
}

代码示例来源：origin: org.mycontroller.standalone/mycontroller-core

@Override
public List<Resource> getAll(RESOURCE_TYPE resourceType, Integer resourceId, Boolean enabled) {
  try {
    QueryBuilder<Resource, Integer> queryBuilder = getDao().queryBuilder();
    Where<Resource, Integer> where = queryBuilder.where();
    int whereCount = 0;
    where.eq(Resource.KEY_RESOURCE_TYPE, resourceType);
    whereCount++;
    where.eq(Resource.KEY_RESOURCE_ID, resourceId);
    whereCount++;
    if (enabled != null) {
      where.eq(Resource.KEY_ENABLED, resourceId);
      whereCount++;
    }
    where.and(whereCount);
    queryBuilder.setWhere(where);
    return queryBuilder.query();
  } catch (SQLException ex) {
    _logger.error("get resource failed! input:[resourceType:{}, resourceId:{}, enabled:{}], ",
        resourceType, resourceId, enabled, ex);
    return null;
  }
}

代码示例来源：origin: mycontroller-org/mycontroller

@Override
public List<Resource> getAll(RESOURCE_TYPE resourceType, Integer resourceId, Boolean enabled) {
  try {
    QueryBuilder<Resource, Integer> queryBuilder = getDao().queryBuilder();
    Where<Resource, Integer> where = queryBuilder.where();
    int whereCount = 0;
    where.eq(Resource.KEY_RESOURCE_TYPE, resourceType);
    whereCount++;
    where.eq(Resource.KEY_RESOURCE_ID, resourceId);
    whereCount++;
    if (enabled != null) {
      where.eq(Resource.KEY_ENABLED, resourceId);
      whereCount++;
    }
    where.and(whereCount);
    queryBuilder.setWhere(where);
    return queryBuilder.query();
  } catch (SQLException ex) {
    _logger.error("get resource failed! input:[resourceType:{}, resourceId:{}, enabled:{}], ",
        resourceType, resourceId, enabled, ex);
    throw new McDatabaseException(ex);
  }
}

代码示例来源：origin: j256/ormlite-core

@Test
public void testWhereSelectArg() throws Exception {
  QueryBuilder<Foo, Integer> qb = new QueryBuilder<Foo, Integer>(databaseType, baseFooTableInfo, null);
  Where<Foo, Integer> where = qb.where();
  SelectArg val = new SelectArg();
  where.eq(Foo.ID_COLUMN_NAME, val);
  StringBuilder sb = new StringBuilder();
  sb.append("SELECT * FROM ");
  databaseType.appendEscapedEntityName(sb, baseFooTableInfo.getTableName());
  sb.append(" WHERE ");
  databaseType.appendEscapedEntityName(sb, Foo.ID_COLUMN_NAME);
  sb.append(" = ? ");
  assertEquals(sb.toString(), qb.prepareStatementString());
  // set the where to the previous where
  qb.setWhere(where);
  assertEquals(sb.toString(), qb.prepareStatementString());
}

代码示例来源：origin: org.mycontroller.standalone/mycontroller-core

@Override
public Settings get(Integer userId, String key, String subKey) {
  try {
    Where<Settings, Integer> where = this.getDao().queryBuilder().where();
    int andCount = 0;
    if (userId == null) {
      where.isNull(Settings.KEY_USER_ID);
      andCount++;
    } else {
      where.eq(Settings.KEY_USER_ID, userId);
      andCount++;
    }
    where.eq(Settings.KEY_KEY, key);
    andCount++;
    where.eq(Settings.KEY_SUB_KEY, subKey);
    andCount++;
    where.and(andCount);
    QueryBuilder<Settings, Integer> queryBuilder = this.getDao().queryBuilder();
    queryBuilder.setWhere(where);
    return queryBuilder.queryForFirst();
  } catch (SQLException ex) {
    _logger.error("unable to get item for userId:{}, key:{}, subKey:{}", userId, key, subKey, ex);
    return null;
  }
}

代码示例来源：origin: mycontroller-org/mycontroller

@Override
public Settings get(Integer userId, String key, String subKey) {
  try {
    Where<Settings, Integer> where = this.getDao().queryBuilder().where();
    int andCount = 0;
    if (userId == null) {
      where.isNull(Settings.KEY_USER_ID);
      andCount++;
    } else {
      where.eq(Settings.KEY_USER_ID, userId);
      andCount++;
    }
    where.eq(Settings.KEY_KEY, key);
    andCount++;
    where.eq(Settings.KEY_SUB_KEY, subKey);
    andCount++;
    where.and(andCount);
    QueryBuilder<Settings, Integer> queryBuilder = this.getDao().queryBuilder();
    queryBuilder.setWhere(where);
    return queryBuilder.queryForFirst();
  } catch (SQLException ex) {
    _logger.error("unable to get item for userId:{}, key:{}, subKey:{}", userId, key, subKey, ex);
    throw new McDatabaseException(ex);
  }
}

代码示例来源：origin: com.j256.ormlite/ormlite-jdbc

@Test
public void testSetWhere() throws Exception {
  Dao<Foo, String> fooDao = createTestData();
  QueryBuilder<Foo, String> qb = fooDao.queryBuilder();
  Where<Foo, String> where = qb.where();
  where.eq(Foo.ID_COLUMN_NAME, foo1.id);
  List<Foo> list = fooDao.query(qb.prepare());
  assertEquals(1, list.size());
  assertEquals(foo1, list.get(0));
  qb = fooDao.queryBuilder();
  qb.setWhere(where);
  list = fooDao.query(qb.prepare());
  assertEquals(1, list.size());
  assertEquals(foo1, list.get(0));
}

代码示例来源：origin: org.mycontroller.standalone/mycontroller-core

queryBuilderFilteredCount.setWhere(whereMain);
queryBuilder.setWhere(whereMain);

代码示例来源：origin: mycontroller-org/mycontroller

queryBuilderFilteredCount.setWhere(whereMain);
queryBuilder.setWhere(whereMain);

代码示例来源：origin: org.mycontroller.standalone/mycontroller-core

@Override
public List<GatewayTable> getAll(GATEWAY_TYPE gatewayType, NETWORK_TYPE networkType, Boolean enabled) {
  try {
    if (gatewayType == null && networkType == null && enabled == null) {
      return this.getDao().queryForAll();
    }
    QueryBuilder<GatewayTable, Integer> queryBuilder = this.getDao().queryBuilder();
    Where<GatewayTable, Integer> where = queryBuilder.where();
    where.gt("id", 0);//This line is used to add and() for above inputs
    if (enabled != null) {
      where.and().eq(GatewayTable.KEY_ENABLED, enabled);
    }
    if (gatewayType != null) {
      where.and().eq(GatewayTable.KEY_TYPE, gatewayType);
    }
    if (networkType != null) {
      where.and().eq(GatewayTable.KEY_NETWORK_TYPE, networkType);
    }
    queryBuilder.setWhere(where);
    List<GatewayTable> gateways = this.getDao().query(queryBuilder.prepare());
    return gateways;
  } catch (SQLException ex) {
    _logger.error("unable to get all gateways:[type:{}, NetworkType:{}, Enabled:{}]",
        gatewayType != null ? gatewayType.getText() : null, networkType, enabled, ex);
    return null;
  }
}

代码示例来源：origin: mycontroller-org/mycontroller

@Override
public List<GatewayTable> getAll(GATEWAY_TYPE gatewayType, NETWORK_TYPE networkType, Boolean enabled) {
  try {
    if (gatewayType == null && networkType == null && enabled == null) {
      return this.getDao().queryForAll();
    }
    QueryBuilder<GatewayTable, Integer> queryBuilder = this.getDao().queryBuilder();
    Where<GatewayTable, Integer> where = queryBuilder.where();
    where.gt("id", 0);//This line is used to add and() for above inputs
    if (enabled != null) {
      where.and().eq(GatewayTable.KEY_ENABLED, enabled);
    }
    if (gatewayType != null) {
      where.and().eq(GatewayTable.KEY_TYPE, gatewayType);
    }
    if (networkType != null) {
      where.and().eq(GatewayTable.KEY_NETWORK_TYPE, networkType);
    }
    queryBuilder.setWhere(where);
    List<GatewayTable> gateways = this.getDao().query(queryBuilder.prepare());
    return gateways;
  } catch (SQLException ex) {
    _logger.error("unable to get all gateways:[type:{}, NetworkType:{}, Enabled:{}]",
        gatewayType != null ? gatewayType.getText() : null, networkType, enabled, ex);
    throw new McDatabaseException(ex);
  }
}

代码示例来源：origin: zulip/zulip-android

private void selectPointer() {
  if (filter != null) {
    Where<Message, Object> filteredWhere;
    try {
      filteredWhere = filter.modWhere(app.getDao(Message.class)
          .queryBuilder().where());
      filteredWhere.and().le(Message.ID_FIELD, app.getPointer());
      QueryBuilder<Message, Object> closestQuery = app.getDao(
          Message.class).queryBuilder();
      closestQuery.orderBy(Message.TIMESTAMP_FIELD, false).setWhere(
          filteredWhere);
      Message closestMessage = closestQuery.queryForFirst();
      // use anchor message id if message was narrowed
      if (anchorId != -1) {
        selectMessage(getMessageById(anchorId));
      } else {
        recyclerView.scrollToPosition(adapter.getItemIndex(closestMessage));
      }
    } catch (SQLException e) {
      throw new RuntimeException(e);
    }
  } else {
    int anc = app.getPointer();
    selectMessage(getMessageById(anc));
  }
}

内容来源于网络，如有侵权，请联系作者删除！

QueryBuilder

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com