How Can Add ArrayList into a SQLite Database?

Question

I have array list of integer that i want to add in one column of sqlite database,

I do this by contentValues like this:

contentValues.put(Tag.REPORT_LATITUDE_LIST, report.getLatitudes());

first! what is the type of this column in database table?

and

how can I get these arrayList data from sqlite?

TomH · Accepted Answer · 2018-07-09 22:45:15Z

3

You could serialize your object to JSON, store it in this format as a string and just deserialize it when you read it.

 contentValues.put(Tag.REPORT_LATITUDE_LIST, new Gson().toJson(report.getLatitudes()));

You would need to add Gson to your gradle dependencies.

dependencies {
implementation 'com.google.code.gson:gson:2.8.5'

}

answered Jul 9, 2018 at 22:45

TomH

2,7592 gold badges20 silver badges34 bronze badges

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

1 Comment

It'll be stored as a string