Insert values into SQLite Database

Question

Is there an easier way I can insert data in a table in SQLite? What I need is to insert State_ID and State_Name in Table tblState. Since there are a lot of State in US, is there another way I can use instead of this:

String ROW1 = "INSERT INTO tblState VALUES (1,'Alabama')";
String ROW2 = "INSERT INTO tblState VALUES (2,'Alaska')";
String ROW3 = "INSERT INTO tblState VALUES (3,'California')";
db.execSQL(ROW1);
db.execSQL(ROW2);
db.execSQL(ROW3);

Thanks!

You can try like this ...Have state in an array. Execute a single insert statement inside for loop until this state array finish.. — Subburaj
– Subburaj, Commented May 15, 2013 at 9:40
You can concatenate all the INSERT in one string, then execute one db.execSQL — Marcos
– Marcos, Commented May 15, 2013 at 9:42
Subburaj how will i do that? sorry i'm just new in doing this. thanks! — dolphinately
– dolphinately, Commented May 15, 2013 at 9:52

Subburaj · Accepted Answer · 2013-05-15 10:16:03Z

1

Try for this..

String state[] = { "state1" , "state2",.............};
    int id=1;
    for(int i=0;i<state.length;i++)
    {
    db.execSQL("INSERT INTO tblState VALUES (id,state[i])");
    id++;
    }

answered May 15, 2013 at 10:16

Subburaj

5,21211 gold badges48 silver badges95 bronze badges

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

1 Comment

dolphinately Over a year ago

Thanks Subburaj!Great help. :)

Mathew Thompson · Accepted Answer · 2013-05-15 09:41:14Z

0

You can do the following:

String ALLROWS = "INSERT INTO tblState"
    + "SELECT 1 AS 'State_ID', 'Alabama' AS 'State_Name'"
    + "UNION SELECT 2 AS 'State_ID', 'Alaska' AS 'State_Name'"
    + "UNION SELECT 3 AS 'State_ID', 'California' AS 'State_Name'";

db.execSQL(ALLROWS);

answered May 15, 2013 at 9:41

Mathew Thompson

56.5k15 gold badges131 silver badges151 bronze badges

Comments

eternay · Accepted Answer · 2013-05-15 09:57:01Z

0

You should use ContentValues for each of the rows you want to insert:

ContentValues values = new ContentValues();
values.put('State_ID', 1);
values.put('State_Name', "Alabama");

and then use db.insert("tblState", null, values) to insert the row. You can write a method to construct your ContentValues:

public ContentValues method(int id, String name) {
    ContentValues values = new ContentValues();
    values.put('State_ID', id);
    values.put('State_Name', name);
}

Your code will be:

db.insert("tblState", null, method(1, "Alabama"));
db.insert("tblState", null, method(2, "Alaska"));
db.insert("tblState", null, method(3, "California"));

Or just loop through all the states...

answered May 15, 2013 at 9:57

eternay

3,8142 gold badges32 silver badges28 bronze badges

Collectives™ on Stack Overflow

Insert values into SQLite Database

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related