database - Import .csv file to Sqlite in Android -

i have .csv file , want import file putting database in android.

example, .csv file:

| id | name  | dt1 | dt2 | dt3 |  | 1  | paul  | 21  | 98  | 91  | | 2  | john  | 22  | 44  | 11  | | 3  | george| 21  | 31  | 22  | | 4  | ringo | 20  | 10  | 15  |  

to thing that:

cursor cursor = getwritabledatabase(). rawquery("insert table1(_id, name, dt1, dt2, dt3) values ( 1, paul, 21, 98, 91) values ( 2, john, 22, 44, 11) values ( 3, george, 21,31,22) values ( 4, ringo, 20, 10,15);"); 

so please, how can that?

try following code,

filereader file = new filereader(filename); bufferedreader buffer = new bufferedreader(file); string line = ""; string tablename ="table_name"; string columns = "_id, name, dt1, dt2, dt3"; string str1 = "insert " + tablename + " (" + columns + ") values("; string str2 = ");";  db.begintransaction(); while ((line = buffer.readline()) != null) {     stringbuilder sb = new stringbuilder(str1);     string[] str = line.split(",");     sb.append("'" + str[0] + "',");     sb.append(str[1] + "',");     sb.append(str[2] + "',");     sb.append(str[3] + "'");     sb.append(str[4] + "'");     sb.append(str2);     db.execsql(sb.tostring()); } db.settransactionsuccessful(); db.endtransaction();