Examples of org.apache.gora.sql.statement.Where

org.apache.gora.sql.statement.Where
A WHERE clause in an SQL statement

    requestFields = getFieldsToQuery(requestFields);


    ResultSet resultSet = null;
    PreparedStatement statement = null;
    try {
      Where where = new Where();
      SelectStatement select = new SelectStatement(mapping.getTableName());
      select.setWhere(where);


//      boolean isPrimarySelected = false;
//      for (int i = 0; i < requestFields.length; i++) {
//        if(primaryColumn.getName().equals(primaryColumn)) {
//          isPrimarySelected = true;
//          break;
//        }
//      }
//      if(!isPrimarySelected) {
//        requestFields = StringUtils.append(requestFields, primaryColumn.getName());
//      }


      for (int i = 0; i < requestFields.length; i++) {
        Column column = mapping.getColumn(requestFields[i]);


        select.addToSelectList(column.getName());
      }


      where.equals(primaryColumn.getName(), "?");
      statement = getConnection().prepareStatement(select.toString());


      setObject(statement, 1, key, keySqlType, primaryColumn);


      resultSet = statement.executeQuery();

View Full Code Here

    String[] requestFields = query.getFields();


    ResultSet resultSet = null;
    PreparedStatement statement = null;
    try {
      Where where = constructWhereClause(query);
      SelectStatement select = new SelectStatement(mapping.getTableName());
      select.setWhere(where);


      select.addToSelectList(primaryColumn.getName());
      for (int i = 0; i < requestFields.length; i++) {

View Full Code Here

      throw new IOException(ex);
    }
  }


  private Where constructWhereClause(Query<K,T> query) {
    Where where = new Where();
    if (query.getKey() != null) {
      where.equals(primaryColumn.getName(), "?");
    } else {
      if (query.getStartKey() != null) {
        where.greaterThanEq(primaryColumn.getName(), "?");
      }
      if(query.getEndKey() != null) {
        where.lessThanEq(primaryColumn.getName(), "?");
      }
    }
    return where;
  }

View Full Code Here

TOP

Related Classes of org.apache.gora.sql.statement.Where

org.apache.gora.sql.store.SqlStore

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.