Storing an ArrayList of Arrays in SQLite Database

Question

My question has to do with storing arrays and ArrayLists in SQLite. I have an Object Course as follows:

public class Course {
    private String name;
    private ArrayList<Tee> tees;

which contains the ArrayList of Tee where Tee looks like this:

public class Tee {
    private String Name;
    private int Slope;
    private double Rating;
    private int[] Par={0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};
    private int[] HCP={0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};

Each Course has a number of Tees associated with it and each Tee contains 2 integer arrays. I want to store a list of Courses in a SQLite database. Each row of the database will represent a Course and contain the Course object data. I have researched this and I find either too little or too much information to be helpful.

I think I need to use a JSON object or a BLOB to convert the ArrayLists to something that can be stored in SQLite, but I can't seem to find the way to convert an int array into such a thing (BLOB or JSON Object or JSON Array?) and then the subsequent list of Tees into another thing (BLOB, etc.)

please don't create blob column in sqlite database because if you insert big image means it will create problem.. do one thing store the image in sdcard save the path in sqlite .. search sqlite curd operation you will get lot of tutorial — prakash
– prakash, Commented Dec 3, 2013 at 12:33

mazurovEV · Accepted Answer · 2013-12-03 16:52:43Z

1

Create several tables.

One table ('Cource') contains field 'name' and field with reference('id' field) to row in table 'Tee'.

Table 'Tee' contains fields 'id', 'name', 'slop', 'rating', 'par' and 'hcp'.

Since it is impossible to store an array in a table row you can:

convert array to string
create a field for each item in array

StringBuilder b = new StringBuilder(); for(int i = 0; i < array.length - 1; i++) { if(i != 0) { b.append(","); } b.append(array[i]); } String stringArr = b.toString();

edited Dec 3, 2013 at 16:52

answered Dec 3, 2013 at 12:50

mazurovEV

3512 silver badges4 bronze badges

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

1 Comment

ddk Over a year ago

It is the process of converting the array to a string that I was asking about. More specifically, to a JSON object or a BLOB or something that already handles the conversion and packaging. I could write something that would do the conversion, but I thought that is what these JSONs and BLOBs were for.

Rajith Rajan · Accepted Answer · 2013-12-03 12:51:35Z

0

You have to create the framework for retrieving data.

Each course you should treat like one object.

  public class Tee {

    private String Name;
    private int Slope;

    private double Rating;
    private int[] Par={0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};
    private int[] HCP={0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0};

    public Tee(String name,int slope,double Rating,int[] par,int[] hcp)
    {

     this.name=name;
     this.slope=slope;
     this.Rating=rating;
     this.PAR=par;
     this.HCP=hcp;
   }

public String GetName()
{
return this.name;
}
....

public int[] GetHCP()
{
return this.HCP;
}
}

And Use for loop for inserting data into the database

for(int i=0;i<size();i++)
    {
        ContentValues values=new ContentValues();

        values.put("name", "data");



        long l=sdb.insert(TAble name, null, values);



    }

For PAR and HCP data storing, please do the table indexing for good way manage your data flow

answered Dec 3, 2013 at 12:51

Rajith Rajan

1217 bronze badges

2 Comments

ddk Over a year ago

You are showing me how to put string data into a database. I'm okay with that. I want to know how to convert the int array into something that can be stored in the database.

Rajith Rajan Over a year ago

For that you have to create the new sub table name like PAR and HCP add the column according to your requirements, do the indexing from the main table.I think there is no way to store array-list directly into the table in sq lite.

Collectives™ on Stack Overflow

Storing an ArrayList of Arrays in SQLite Database

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related