最快,也最灵活的实现,
你可以使用insert or fail 或 insert or ignore 来替换简单的insert
代码:
String[] sCheeseNames = {"a","b","a","b","a","b","a","b"}; String[] sCheeseOrigins = {"aa","bb","aa","bb","aa","bb","aa","bb"}; SQLiteDatabase db = SQLiteDatabase.create(null); ContentValues values = new ContentValues(); int i = 0; for (String name:sCheeseNames){ String origin = sCheeseOrigins[i++]; values.clear(); values.put("name", name); values.put("origin", origin); db.insert("cheese", null, values); }
也可以使用DatabaseUtils.InsertHelper 执行多行插入,这样只需要编译一次insert 语句,但灵活性没有上面的方法好