最快,也最灵活的实现,
你可以使用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 语句,但灵活性没有上面的方法好