Creating SQLite Table in Android

Question

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.

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<String[]> selectAll()
        {
            List<String[]> list = new ArrayList<String[]>();
            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 && !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);


           }    
     }

And I'm calling the method in another class with:

    @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);

            }
}

Perhaps I need to call OpenHelper somehow?

you should also put the logcat

Avi Kumar
– Avi Kumar

2012-04-03 04:05:51 +00:00
Commented Apr 3, 2012 at 4:05 — Avi Kumar
– Avi Kumar, Commented Apr 3, 2012 at 4:05

Joost · Accepted Answer · 2013-12-22 20:10:43Z

5

Extend SQLiteOpenHelper & override two methods onCreate() and onUpgrade()

You can follow this really helpful tutorial

edited Dec 22, 2013 at 20:10

Joost

10.4k4 gold badges59 silver badges62 bronze badges

answered Apr 3, 2012 at 3:21

Yaqub Ahmad

27.7k24 gold badges105 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Maha Over a year ago

did you try to use this tutorial to save huge text?like SMS?

Lucifer · Accepted Answer · 2012-04-03 03:50:04Z

3

You need to make your class extend SQLiteOpenHelper I believe.

edited Apr 3, 2012 at 3:50

Lucifer

29.7k25 gold badges93 silver badges144 bronze badges

answered Apr 3, 2012 at 2:17

JakeWilson801

1,0367 silver badges20 bronze badges

Comments

ZeroSkittles · Accepted Answer · 2012-04-03 21:51:15Z

3

Fixed by changing insert statement to match column name "tim" instead of "time".

answered Apr 3, 2012 at 21:51

ZeroSkittles

1641 gold badge3 silver badges16 bronze badges

Collectives™ on Stack Overflow

Creating SQLite Table in Android

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related