pass an arraylist into SQLite database

Question

I have the below code:

    ArrayList NumList = getIntent().getParcelableArrayListExtra ("name");
    ArrayList<String> results = new ArrayList<String>();
    SQLiteDatabase sampleDB = null;

    try {
        sampleDB =  this.openOrCreateDatabase(SAMPLE_DB_NAME, MODE_PRIVATE, null);

        sampleDB.execSQL("CREATE TABLE IF NOT EXISTS " +
                SAMPLE_TABLE_NAME +
                " (FirstName VARCHAR);");

        sampleDB.execSQL("INSERT INTO " +
                SAMPLE_TABLE_NAME +
                " Values (NumList);");

What I am trying to do is to pass the NumList into the table. The above code shows an error saying "no such column: NumList)" How would I pass this information through?

sampleDB.execSQL("CREATE TABLE IF NOT EXISTS " + SAMPLE_TABLE_NAME + " (FirstName VARCHAR);"); You have only one column in your table which is FirstName. Try to add NumList too. — Lazy Ninja
– Lazy Ninja, Commented Aug 14, 2012 at 8:41
sampleDB.execSQL("INSERT INTO " + SAMPLE_TABLE_NAME + " Values (" + NumList[i] + ");"); You have to take NumList variable out. — Lazy Ninja
– Lazy Ninja, Commented Aug 14, 2012 at 8:47
I get the error: The type of the expression must be an array type but it resolved to ArrayList — fasheikh
– fasheikh, Commented Aug 14, 2012 at 8:52

Lazy Ninja · Accepted Answer · 2012-08-14 09:12:42Z

2

Try this:

for(String str: NumList){
sampleDB.execSQL("INSERT INTO " +
            SAMPLE_TABLE_NAME +
            " ( FirstName ) Values ('"+str+"');");
}

answered Aug 14, 2012 at 9:12

Lazy Ninja

22.6k9 gold badges86 silver badges104 bronze badges

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

4 Comments

fasheikh Over a year ago

thanks that works, sorry to be a pain but any idea how I could retain the state of checkboxes after the app closes?

Lazy Ninja Over a year ago

Use SharedPreferences to save the states.

fasheikh Over a year ago

how would I do this? I have tried but I can't seem to get it working

Lazy Ninja Over a year ago

You save the states as boolean. If checked you save as true, if unchecked you save false. On launching the application you read them. if true you check if false you uncheck.

Shawn Chin · Accepted Answer · 2012-08-14 09:59:19Z

2

Try this one:

sampleDB.execSQL("INSERT INTO " +
            SAMPLE_TABLE_NAME +
            " ( FirstName ) Values ('"+NumList+"');");

edited Aug 14, 2012 at 9:59

Shawn Chin

87.4k20 gold badges168 silver badges193 bronze badges

answered Aug 14, 2012 at 8:54

user1567667

4 Comments

fasheikh Over a year ago

thank you, that works :) is there anyway to display it as a list again or maybe automatically add a row for each value in the list?

fasheikh Over a year ago

my question is not fully answered, I would like to show the information as a list or add a new row for each value in the list

user1567667 Over a year ago

u have to put arraylist NumList in for loop

user1567667 Over a year ago

i answered again to ur question check my new answer

Collectives™ on Stack Overflow

pass an arraylist into SQLite database

2 Answers 2

4 Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related