Java Row.getDouble方法代碼示例

import com.datastax.driver.core.Row; //導入方法依賴的package包/類
public Object getColValue(Row row, String colName, DataType colType){	
	switch(colType.getName()){
	case VARCHAR: 
		return row.getString(colName);
	case UUID: 
		return row.getUUID(colName);
	case VARINT: 
		return row.getVarint(colName);
	case BIGINT: 
		return row.getLong(colName);
	case INT: 
		return row.getInt(colName);
	case FLOAT: 
		return row.getFloat(colName);	
	case DOUBLE: 
		return row.getDouble(colName);
	case BOOLEAN: 
		return row.getBool(colName);
	case MAP: 
		return row.getMap(colName, String.class, String.class);
	default: 
		return null;
	}
}
 

import com.datastax.driver.core.Row; //導入方法依賴的package包/類
/**
 * getUserLastGeoCoordinates
 * @param userId
 * @return user's last geo coordinates and null if it doesn't exist
 * @throws Exception
 */
public static GeoCoordinates getUserLastGeoCoordinates (
  UUID userId) throws Exception {
  
  ResultSet resultSet =
    UsersInfo.i().executeSyncSelectLastLocation(userId);
  
  if (resultSet.isExhausted() == false) {
    
    Row row = resultSet.one();
    
    double latitude =
      row.getDouble(UsersInfo.kLastLatitudeColumnName);
    double longitude =
      row.getDouble(UsersInfo.kLastLongitudeColumnName);
    
    return new GeoCoordinates(latitude, longitude);
  } else {
    
    return null;
  }
}
 

import com.datastax.driver.core.Row; //導入方法依賴的package包/類
private Object getValue(Row musicRow, String colname) {
	ColumnDefinitions cdef = musicRow.getColumnDefinitions();
	String type = cdef.getType(colname).getName().toString().toUpperCase();
	switch (type) {
	case "BIGINT":
		return musicRow.getLong(colname);
	case "BOOLEAN":
		return musicRow.getBool(colname);
	case "BLOB":
		return musicRow.getBytes(colname);
	case "DOUBLE":
		return musicRow.getDouble(colname);
	case "INT":
		return musicRow.getInt(colname);
	case "TIMESTAMP":
		return musicRow.getTimestamp(colname);
	default:
		logger.error("UNEXPECTED COLUMN TYPE: columname="+colname+", columntype="+type);
		// fall thru
	case "VARCHAR":
		return musicRow.getString(colname);
	}
}
 

import com.datastax.driver.core.Row; //導入方法依賴的package包/類
private Object readRow(final Row row, final String name, final DataType colType) {
		switch (colType.getName()) {
		case BIGINT:
			return row.getLong(name);
		case BOOLEAN:
			return row.getBool(name);
		case DOUBLE:
			return row.getDouble(name);
		case FLOAT:
			return row.getFloat(name);
		case INT:
			return row.getInt(name);
		case MAP:
			return row.getMap(name, String.class, String.class);
		case UUID:
			return row.getUUID(name);
		case TEXT:
		case VARCHAR:
			return row.getString(name);
		case VARINT:
			return row.getVarint(name);
// These are not supported right now....
// ASCII
// BLOB
// COUNTER
// CUSTOM
// DECIMAL
// INET
// LIST
// SET
// TIMESTAMP
// TIMEUUID
// TUPLE
// UDT
		default:
			return null;
		}
	}
 

import com.datastax.driver.core.Row; //導入方法依賴的package包/類
private Double getDoubleValue(Row row) {
    if (aggregation == Aggregation.MIN || aggregation == Aggregation.MAX
            || aggregation == Aggregation.SUM || aggregation == Aggregation.AVG) {
        return row.getDouble(DOUBLE_POS);
    } else {
        return null;
    }
}
 

import com.datastax.driver.core.Row; //導入方法依賴的package包/類
@Override
protected void processRequest (final Request request) throws Exception {

  // use the following request Object to process the request and set
  //   the response to be returned
  RequestUpdateLocation requestUpdateLocation =
    (RequestUpdateLocation)request.getRequestJsonBody();
  
  // get last user's location
  ResultSet resultSet =
    UsersInfo.i().executeSyncSelectLastLocation(
      requestUpdateLocation.getUserId() );
    
  Row row = resultSet.one();
  
  // extract location's coordinates
  double lastLatitude = row.getDouble(UsersInfo.kLastLatitudeColumnName);
  double lastLongitude = row.getDouble(UsersInfo.kLastLongitudeColumnName);
  
  // first time to update location?
  if (lastLatitude == 0.0 && lastLongitude == 0.0) {
    
    // get location's continent code
    ReverseGeoCode reverseGeoCode =
      ReverseGeoCoding.i().getReverseGeoCode(lastLatitude, lastLongitude);
    
    // get user's registration time
    
    resultSet =
      UsersInfo.i().executeSyncSelectRegistrationTime(
        requestUpdateLocation.getUserId() );
    
    long registrationTime =
      resultSet.one().getLong(UsersInfo.kRegistrationTimeColumnName);
    
    Calendar registrationCalendar =
      CalendarAndDateOperationsInl.getCalendarFromUnixTime(
        registrationTime);
    
    // dispatch analytics
    
    // ig_analytics.annual_regional_counters.increment_new_users
    request.getDispatcher().addDispatchMessage(
      AnnualRegionalCounters.i().getQueryDispatchableIncrementNewUsers(
        CalendarFormatterInl.concatCalendarFields(
          registrationCalendar,
          Calendar.YEAR)
          + Constants.kCassandraIdConcat
          + reverseGeoCode.getContinentCode() ) );
    
    // ig_analytics.daily_regional_counters.increment_new_users
    request.getDispatcher().addDispatchMessage(
      DailyRegionalCounters.i().getQueryDispatchableIncrementNewUsers(
        CalendarFormatterInl.concatCalendarFields(
          registrationCalendar,
          Calendar.YEAR,
          Calendar.MONTH,
          Calendar.DAY_OF_MONTH)
          + Constants.kCassandraIdConcat
          + reverseGeoCode.getContinentCode() ) );
  }
  
  // update last_latitude and last_longitude
  UsersInfo.i().executeSyncSetLastLocation(
    requestUpdateLocation.latitude,
    requestUpdateLocation.longitude,
    requestUpdateLocation.getUserId() );
  
  // set response
  ((ResponseUpdateLocation)request.getResponseBody() ).set(
    requestUpdateLocation.request_tracking_id,
    request.getStartTime() );
}