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


    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();


    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++) {
        Column column = mapping.getColumn(requestFields[i]);


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


      if(query.getLimit() > 0) {
        select.setLimit(query.getLimit());
      }


      statement = getConnection().prepareStatement(select.toString());


      setParametersForPreparedStatement(statement, query);


      resultSet = statement.executeQuery();

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

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