Multiple column insertion android sqlite

Question

I am using SQLLite Database supplied by Android.

I have a Table myTable with two coloumns: col_id and colName. The gettersetter class is as follows:

 public class MyTable{

        private long id;
    private String colName;

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public String getColName() {
        return colName;
    }

    public void setColName(String colName) {
        this.colName = colName;
    }

}

I have a method in database connector which inserts a single row :

 public void insertMyTable(String colName)
           {
              ContentValues newCon = new ContentValues();
              newCon.put("colName", colName);
              open();
              database.insert("myTable", null, newCon);
              close();
           }

Is there a way to insert a List of objects of type MyTable into the database, i have over 100 records to be inserted at once.

Thanks in advance

Hoan Nguyen · Accepted Answer · 2013-03-13 03:53:45Z

4

public void insertMyTable(List<MyTable> myTables)
{
    open();
    database.beginTransaction();
    for (MyTable myTable : myTables)
    {
        ContentValues insertValues = new ContentValues();
        insertValues.put("colName", myTable.getColName());
        database.insert("myTable", null, insertValues);
    }  
    database.setTransactionSuccessful();
    database.endTransaction();
    close();
}

edited Mar 13, 2013 at 3:53

answered Mar 13, 2013 at 3:30

Hoan Nguyen

18.2k3 gold badges52 silver badges56 bronze badges

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

1 Comment

amitsalyan Over a year ago

Thank you Nguyen for the response. However i was looking to use the gettersetter class to insert the value. Anyway to inser a single or multiple value?

Collectives™ on Stack Overflow

Multiple column insertion android sqlite

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related