Databases
StackOverflow2013
Postsdbo
POCreating SQLite Table in Android
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreating SQLite Table in Android
    primarykey
    data
    text
    <p>I'm trying to load values into a SQLite table on android. My application keeps breaking but it doesnt throw me a specific error besides NullPointerException which has be believing the table is not being created correctly.</p> <pre><code>public class MySQLiteHelper{ private static final String DATABASE_NAME = "breadcrumbs.db"; private static final int DATABASE_VERSION = 1; public static final String TABLE_BREADCRUMBS = "breadcrumbs"; private static Context context; static SQLiteDatabase db; private static SQLiteStatement insertStmt; private static final String INSERT ="insert into " + TABLE_BREADCRUMBS + " (time,lat,lon) values (?,?,?)"; public MySQLiteHelper(Context context) { MySQLiteHelper.context = context; OpenHelper openHelper = new OpenHelper(MySQLiteHelper.context); MySQLiteHelper.db = openHelper.getWritableDatabase(); MySQLiteHelper.insertStmt = MySQLiteHelper.db.compileStatement(INSERT); } public static long insert(long time,int lat,int lon) { insertStmt.bindLong(1, time); insertStmt.bindLong(2, lat); insertStmt.bindLong(3, lon); return insertStmt.executeInsert(); } public void deleteAll() { db.delete(TABLE_BREADCRUMBS, null, null); } public List&lt;String[]&gt; selectAll() { List&lt;String[]&gt; list = new ArrayList&lt;String[]&gt;(); Cursor cursor = db.query(TABLE_BREADCRUMBS, new String[] { "id","time","lat","lon"}, null, null, null, null, null); int x=0; if (cursor.moveToFirst()) { do { String[] b1=new String[]{cursor.getString(0),cursor.getString(1),cursor.getString(2), cursor.getString(3)}; list.add(b1); x=x+1; } while (cursor.moveToNext()); } if (cursor != null &amp;&amp; !cursor.isClosed()) { cursor.close(); } cursor.close(); return list; } public void delete(int rowId) { db.delete(TABLE_BREADCRUMBS, null, null); } private static class OpenHelper extends SQLiteOpenHelper { OpenHelper(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE " + TABLE_BREADCRUMBS + " (id INTEGER PRIMARY KEY, tim REAL, lat REAL, long REAL);"); //db.execSQL("CREATE TABLE " + TABLE_BREADCRUMBS + " (id INTEGER PRIMARY KEY AUTOINCREMENT, time REAL, lat REAL, long REAL);"); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { db.execSQL("DROP TABLE IF EXISTS " + TABLE_BREADCRUMBS); onCreate(db); } } </code></pre> <p>And I'm calling the method in another class with:</p> <pre><code> @Override public void onLocationChanged(Location location) { int lat = (int) (location.getLatitude() * 1E6); int lng = (int) (location.getLongitude() * 1E6); long time = (int)(location.getTime() * 1E6); GeoPoint point = new GeoPoint(lat, lng); createMarker(); MySQLiteHelper.insert(time,lat,lng); mapController.animateTo(point); // mapController.setCenter(point); } } </code></pre> <p>Perhaps I need to call OpenHelper somehow?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USZeroSkittles
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCreating SQLite Table in Android
      1. This table or related slice is empty.
      1. VTUpMod
    1. COyou should also put the logcat
      singulars
      1. POCreating SQLite Table in Android
      1. USAvi Kumar Manku
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload