Android Open Source - GeoNFC Database

From Project

Back to project page GeoNFC.

License

The source code is released under:

GNU General Public License

If you think the Android project GeoNFC listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

package com.nfc.geo.geonfc.database;
//from w  ww. j av  a 2  s .c o m
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class Database extends SQLiteOpenHelper{

  private static final int DATABASE_VERSION = 1;
    private static final String DATABASE_TABLE_NAME = "Stats";
    public static final String TABLE_STATS = "infostats";
    public static final String COLUMN_TAGID = "tag_id";
    public static final String COLUMN_TIMESTAMP = "timestamp";
    public static final String COLUMN_NUMSATT = "num_sat";
    public static final String COLUMN_LAT = "latitude";
    public static final String COLUMN_LONG = "longitude";
    public static final String COLUMN_HDOP = "hdop";
    public static final String COLUMN_SPEED = "speed";
    public static final String COLUMN_TYPE = "type";
    public static final String COLUMN_GPS_FIJO = "gps_fijo";
    
  public Database(Context context) {
    super(context, DATABASE_TABLE_NAME, null, DATABASE_VERSION);
  }

  @Override
  public void onCreate(SQLiteDatabase db) {
    String build_table = "CREATE TABLE " + TABLE_STATS + "("
                +"id INTEGER PRIMARY KEY autoincrement, tag_id TEXT, timestamp TEXT, num_sat INTEGER, latitude DOUBLE, " +
                "longitude DOUBLE, hdop FLOAT, speed FLOAT, type TEXT, gps_fijo TEXT)";
    
    db.execSQL(build_table);
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  }

}

Java Source Code List