Example usage for com.badlogic.gdx.sql SQLiteGdxDatabaseCursor getShort

List of usage examples for com.badlogic.gdx.sql SQLiteGdxDatabaseCursor getShort

Introduction

In this page you can find the example usage for com.badlogic.gdx.sql SQLiteGdxDatabaseCursor getShort.

Prototype

public short getShort(int columnIndex);

Source Link

Document

Returns the value of the requested column as a short.

Usage

From source file:de.longri.cachebox3.sqlite.dao.CacheDAO.java

License:Open Source License

Cache ReadFromCursor(SQLiteGdxDatabaseCursor reader, boolean fullDetails, boolean withDescription) {

    try {/*from w w  w.  ja  v  a2  s .c  o m*/
        Cache cache = new Cache(reader.getDouble(2), reader.getDouble(3), fullDetails);

        cache.Id = reader.getLong(0);
        cache.setGcCode(reader.getString(1).trim());
        cache.setName(reader.getString(4).trim());
        cache.Size = CacheSizes.parseInt(reader.getInt(5));
        cache.setDifficulty(((float) reader.getShort(6)) / 2);
        cache.setTerrain(((float) reader.getShort(7)) / 2);
        cache.setArchived(reader.getInt(8) != 0);
        cache.setAvailable(reader.getInt(9) != 0);
        cache.setFound(reader.getInt(10) != 0);
        cache.Type = CacheTypes.values()[reader.getShort(11)];
        cache.setOwner(reader.getString(12).trim());

        cache.NumTravelbugs = reader.getInt(13);
        cache.setGcId(reader.getString(14));
        cache.Rating = (reader.getShort(15)) / 100.0f;
        if (reader.getInt(16) > 0)
            cache.setFavorite(true);
        else
            cache.setFavorite(false);

        if (reader.getInt(17) > 0)
            cache.setHasUserData(true);
        else
            cache.setHasUserData(false);

        if (reader.getInt(18) > 0)
            cache.setListingChanged(true);
        else
            cache.setListingChanged(false);

        if (reader.getInt(19) > 0)
            cache.setCorrectedCoordinates(true);
        else
            cache.setCorrectedCoordinates(false);

        if (fullDetails) {
            readDetailFromCursor(reader, cache.detail, fullDetails, withDescription);
        }

        return cache;
    } catch (Exception exc) {
        log.error("Read Cache", exc);
        return null;
    }
}

From source file:de.longri.cachebox3.sqlite.dao.WaypointDAO.java

License:Open Source License

/**
 * Create Waypoint Object from Reader.//from w  w  w.j ava 2  s.  c om
 *
 * @param reader
 * @param full   Waypoints as FullWaypoints (true) or Waypoint (false)
 * @return
 */
public Waypoint getWaypoint(SQLiteGdxDatabaseCursor reader, boolean full) {
    Waypoint WP = null;

    WP = new Waypoint(reader.getDouble(2), reader.getDouble(3), full);

    WP.setGcCode(reader.getString(0));
    WP.CacheId = reader.getLong(1);
    WP.Type = CacheTypes.values()[reader.getShort(4)];
    WP.IsSyncExcluded = reader.getInt(5) == 1;
    WP.IsUserWaypoint = reader.getInt(6) == 1;
    WP.setTitle(reader.getString(7).trim());
    WP.IsStart = reader.getInt(8) == 1;

    if (full) {
        WP.setClue(reader.getString(10));
        WP.setDescription(reader.getString(9));
        WP.setCheckSum(createCheckSum(WP));
    }
    return WP;
}