/*** ContentValues方式** @param sum* @return*/ long insert1( sum) {long before = System.nanoTime();MysqLiteOpenHelper dbHelper = new MysqLiteOpenHelper(MainActivity.);// 得到@R_301_6948@对象sqliteDatabase db = dbHelper.getWritableDatabase();for ( i = 0; i < sum; i++) {ContentValues cv = ContentValues();cv.put("name""zhangsan");"age""23");"height"1.78);"remark""无");db.insert("user"}db.close(); after = System.nanoTime();return after - before;}
@H_419_326@ 2。使用基本slq语句插入。完成时间:3734808485(纳秒) 13
insert2( sum) { before = System.nanoTime(););// 得到@R_301_6948@对象sqliteDatabase db = dbHelper.getWritableDatabase();; i < sum; i++) {"insert into user(name,remark) values('zhangsan',23,1.78,'无')";db.execsql(sql);}db.close(); after = System.nanoTime(); after - before;}
insert3( sqliteDatabase db = dbHelper.getWritableDatabase();;sqliteStatement stmt = db.compileStatement(sql);; i < sum; i++) {stmt.clearBindings();stmt.bindString();stmt.bindLong(223);3178);4);stmt.execute();}db.close(); after = System.nanoTime(); after - before;}
@H_419_326@ 4。使用一次插入多条的方式。完成时间:245414315(纳秒) 22
insert4( ; i < sum / 10; i++) {"('zhangsan',";db.execsql(sql);}db.close(); after = System.nanoTime(); after - before;}
@H_419_326@ 5.使用事务处理插入方式。完成时间:229787881(纳秒) 16
insert5( db.beginTransaction();; i < sum; i++) {;db.execsql(sql);}db.setTransactionSuccessful();db.endTransaction();db.close(); after = System.nanoTime(); after - before;}
评论列表(0条)