使用SQLiteStatement提高sqlite的插入速度

创建数据库

SQLiteDbHelper dbHelper= new SQLiteDbHelper(this, "mydb", null, 1);
SQLiteDatabase database = dbHelper.getWritableDatabase();
dbHelper.createTable();

利用SQLiteStatement插入数据，可大幅度提高效率

SQLiteDatabase db = dbHelper.getWritableDatabase();
String sql = "insert into user (name) values (?)";
db.beginTransaction();
SQLiteStatement sqLiteStatement = db.compileStatement(sql);
for (int j = 0; j < 100000; j++) {
     sqLiteStatement.bindString(1, j + "");
     sqLiteStatement.execute();
     sqLiteStatement.clearBindings();
}
db.setTransactionSuccessful();
db.endTransaction();