List of usage examples for com.badlogic.gdx.sql SQLiteGdxDatabaseCursor getShort
public short getShort(int columnIndex);
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; }