Insert ArrayList in to Android SQLite database?

Question

HI,

I have array list of geopoints

List<GeoPoint> geoPointsArray = new ArrayList<GeoPoint>();

I want to put geoPointsArray array in to SQLite database and then fetch the data back as an array.

If anyone has a solution I would be greatly appreciated.

P.S.

Now I use ContentValues for insert into array as:

        ContentValues initialValues = new ContentValues();
        initialValues.put(KEY_TIME, time);
        db.insert(tableName, null, initialValues);

CommonsWare · Accepted Answer · 2010-09-15 18:14:56Z

3

I want to put geoPointsArray array in to SQLite database and then fetch the data back as an array.

Serialize the GeoPoint array to JSON and store it in a TEXT column.

answered Sep 15, 2010 at 18:14

CommonsWare

1.0m195 gold badges2.4k silver badges2.7k bronze badges

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

1 Comment

Jovan Over a year ago

Thanks , can you please give me simple code for converting in to JSON ?

mreichelt · Accepted Answer · 2010-09-15 19:47:48Z

1

Or different: Because a GeoPoint is build out of 2 integers, just store these integers in 2 columns called 'latitudeE6' and 'longitudeE6', which eliminates any overhead like JSON.

answered Sep 15, 2010 at 19:47

mreichelt

12.5k7 gold badges60 silver badges72 bronze badges

Collectives™ on Stack Overflow

Insert ArrayList in to Android SQLite database?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related